Microsoft Excel Advanced - Level 2

Microsoft Excel Advanced - Level 2

Pivot Tables, Data Consolidation, Charting, Auditing and What if Analysis
 
One Day Course

Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Excel.
In particular, delegates will learn how to use what if analysis techniques, and perform formula auditing.  Additionally to manipulate, consolidate and chart data using the various techniques, functions and facilities available with Excel including Pivot Tables.

Assumed Knowledge:
Delegates must have a good working knowledge of Excel.  They must be regular users who are able to create, edit, format and print Excel spreadsheets.  They must be able to use basic calculations, functions and charts.  It is an advantage to have attended our Excel Advanced - Level 1 course.

Course Outline:
Macros
·         Revision of macros
Goal Seek
·         Changing a single cell
·         Applying a global change
Scenario Manager
·         Creating scenarios
·         Editing scenarios
·         Showing scenarios
·         Summarising scenarios
Custom Views
·       Creating custom views
·       Using custom views
Auditing
·       Auditing Features
·       Precedents and Dependants
·       Tracing Errors & Invalid Data
Consolidating Data
·         Working with multiple sheets
·         Linking files with formulas
·         Paste special
·         Data consolidation
Working With Text Files
·         Importing text files
·         Text to columns
·         Text functions
Data Manipulation
·         Sorting data
·         Using subtotals
·         AutoFilter
·         Advanced filter
Pivot Tables
·         Using the pivot table wizard
·         Editing the pivot table
·         Drilling down in a pivot table
Advanced Calculations
·         Lookup functions
·         Cross-multiplication
·         Conditional calculations
Advanced Charting
·         Creating combination charts
·         Adding & removing data
·         Adding trend lines
·         Forecasting forward
 
 
Follow on course:
Visual Basic for Excel