Byron Employment

Byron Employment. Over 113,194 Jobs Australia Wide.

Delivery Method

  • Classroom

Microsoft Excel 2007 Level 3 focuses on the more advanced features of Excel 2007. Advanced analysis tools, especially pivot tables, Solver, outlining and summarising are covered, as are some key automation features such as Macros.

It would be beneficial to have completed Excel 2007 Level 2 or have equivalent experience.

The course duration is 2 days.

Delivery Method

One on one training can be arranged.

Group bookings only - all states and territories.

Lookup Functions

Setting Excel Options

Understanding Data Lookup Functions
Using CHOOSE
Using VLOOKUP
Using VLOOKUP For Exact Matches
Using HLOOKUP
Using INDEX
Using MATCH
Understanding Reference Functions
Using ROW And ROWS
Using COLUMN And COLUMNS
Using ADDRESS
Using INDIRECT
Using OFFSET
Understanding Excel Options
Personalising Excel
Setting The Default Font
Setting Formula Options
Understanding Save Options
Setting Save Options
Setting The Default File Location
Setting Advanced Options

Chart Object Formatting

Labels And Names

Understanding Chart Object Formatting
Selecting Chart Elements
Using Shape Styles To Format Objects
Changing Column Colour
Changing Pie Slice Colour
Changing Bar Colours
Changing Chart Line Colours
Using Shape Effects
Filling The Chart Area And The Plot Area
Filling The Background
The Format Dialog Box
Using The Format Dialog Box
Using Themes
Understanding Labels And Names
Creating Names Using Text Labels
Using Names In New Formulas
Applying Names To Existing Formulas
Creating Names Using The Names Box
Using Names To Select Ranges
Pasting Names Into Formulas
Creating Names For Constants
Creating Names From A Selection
Scoping Names To The Worksheet
Using The Name Manager
Documenting Range Names

Protecting Data

Summarising And Subtotalling

Understanding Data Protection
Providing Total Access To Cells
Protecting A Worksheet
Working With A Protected Worksheet
Disabling Worksheet Protection
Providing Restricted Access To Cells
Password Protecting A Workbook
Opening A Password Protected Workbook
Removing A Password From A Workbook
Creating Subtotals
Using A Subtotalled Worksheet
Creating Nested Subtotals
Copying Subtotals
Using Subtotals With AutoFilter
Installing The Conditional Sum Wizard
Using The Conditional Sum Wizard
Creating Relative Names For Subtotals
Using Relative Names For Subtotals

Conditional Formatting

Data Linking

Understanding Conditional Formatting
Formatting Cells Containing Values
Clearing Conditional Formatting
More Cell Formatting Options
Top Ten Items
More Top And Bottom Formatting
Options
Working With Data Bars
Working With Colour Scales
Working With Icon Sets
Understanding Data Linking
Linking Between Worksheets
Linking Between Workbooks
Updating Links Between Workbooks
Data Consolidation
Understanding Data Consolidation
Consolidating With Identical Layouts
Creating An Outlined Consolidation
Consolidating With Different Layouts

PivotTables

PivotTable Techniques

Understanding Pivot Tables
Creating A PivotTable Shell
Dropping Fields Into A PivotTable
Filtering A PivotTable
Clearing A Report Filter
Switching PivotTable Labels
Formatting A PivotTable
Using Compound Fields
Counting In A PivotTable
Formatting PivotTable Values
Working With PivotTable Grand Totals
Working With PivotTable SubTotals
Finding The Percentage Of Total
Finding The Difference From
Grouping In PivotTables
Creating Running Totals
Creating Calculated Fields
Providing Custom Names
Creating Calculated Items
PivotTable Options
Sorting In A PivotTable

PivotCharts

Goal Seeking

Creating A PivotChart Shell
Dragging Fields For The PivotChart
Changing The PivotChart Type
Using The PivotChart Filter Pane
Moving PivotCharts To Chart Sheets
Goal Seek Components
Using Goal Seek
Grouping And Outlining
Understanding Grouping And Outlining
Creating An Automatic Outline
Working With An Outline
Creating A Manual Group
Grouping By Columns

Solver

Recorded Macros

Understanding How Solver Works
Setting Solver Parameters
Adding Solver Constraints
Performing The Solver Operation
Running Solver Reports
Refining Solver Answers
Understanding Excel Macros
Setting Macro Security
Saving A Document As Macro Enabled
Recording A Simple Macro
Running A Recorded Macro
Relative Cell References
Running A Macro With Relative References
Viewing and Editing A Macro
Assigning A Macro To The Toolbar
Running A Macro From The Toolbar
Assigning A Keyboard Shortcut To A Macro
Copying and Deleting A Macro

Recorder Workshop

Preparing Data For An Application
Recording A Summation Macro
Recording Consolidations
Recording Divisional Macros
Testing Macros
Creating Objects To Run Macros
Assigning A Macro To An Object
Concluding Remarks

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9699 4940
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9699 4940 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search