Advanced Excel

Duration: ONE DAY

Pre-requisites:

Delegates need to have attended the Introduction and Intermediate Excel courses or have similar knowledge 

Course Objectives:

After attending the course, delegates should have enhanced their use of Excel’s advanced features

Course Content:

What-if data analysis: 

Using Goal Seek to set a formula to the result you specify

Using Solver to analyse multiple variable problems 

Auditing the worksheet: 

Understanding the relationships between cells in your worksheet

Using comments

Finding circular references 

Pivot Tables:

Creating a simple Pivot Table

Formatting the Pivot Table data values

Pivoting the data

Sorting and hiding data

Working with totals

Using Pivot Table data in a formula outside the Pivot Table

Creating Pivot Charts 

Using shared workbooks: 

Creating a shared workbook

Editing a shared workbook

Setting updating options for shared workbooks

Reviewing changes

Distributing workbooks to other people

Merging workbooks 

Outlining: 

Creating an automatic outline

Outline symbols

Clearing an outline

Creating summary reports

Creating charts from outlines

Using styles with outlines 

Consolidating and totalling data: 

Sub totalling by category

Date consolidation 

Data mapping: 

Creating a data map

Using the Map Control panel

Creating place pins 

Recording macros: 

Recording and running a macro

Viewing the macro code

Local vs global macros