Byron Employment

Byron Employment. Over 162,573 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $800.00

Course Overview

This course aims To provide a thorough understanding of the advanced concepts and skills that will enable the participant to effectively use Microsoft Excel 2007.

Methodology

Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Total Learning Time

2 days

Delivery Method

Classroom

Prerequisite

Attendance at an Excel Level 2 course or equivalent experience.

Objectives

Security and Protection

  • Password Protection
  • Attaching a Password
  • Modification Password
  • Saving with a Backup
  • Cell Protection
  • Protecting Cells

Circular References

  • Circular Error Messages
  • Error Checking

Functions

  • Function Overview
  • Functions Revision
  • Math & Trig Functions
  • The SUMPRODUCT Function
  • Rounding Functions
  • Financial Functions
  • The PMT Function
  • Logical Functions
  • The IF Function
  • Nested IF Functions
  • The AND Function
  • The OR Function
  • More Functions
  • Lookup Functions
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Concatenating Functions
  • Index & Match Functions
  • Naming Ranges
  • The MATCH Function
  • The INDEX Function
  • Using the Function Library

Goal Seek

  • Using Goal Seek

Solver

  • Target Cell & Value
  • Saving a Scenario
  • Solver Reports

Scenarios

  • Adding a Scenario
  • Showing Scenarios

Linking

  • Worksheet Linking
  • Workbook Linking

Data Consolidation

  • Using Statistical Functions

Importing Data

  • Importing CSV Files
  • Text Import Wizard

Exporting Data

  • Choosing a Specific Format
  • Exporting to Microsoft Word
  • Pasting Data with a Link
  • Copying a Graph as a Picture

PivotTable Reports

  • Rearranging Data
  • Filtering a Report
  • Adding Fields
  • Field Settings
  • Refreshing Data
  • Formatting a PivotTable
  • Expanding and Collapsing Detail

PivotChart Reports

  • Creating a PivotChart
  • PivotChart Reports from scratch
  • Adding Fields to a PivotChart

Macros

  • Recording a Macro
  • Editing a Macro
  • Relative/Absolute Recording
  • Stepping through a Macro

Macro Buttons

  • Customising the Quick Access
  • Toolbar
  • Deleting Macros
  • Macro Revision Exercise
  • Macro Security Level

Lunch

All Drake Publicly Scheduled Courses provide lunch to students.

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON 1300 362 262
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL 1300 362 262 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search