Microsoft Excel Advanced - Level 2
Training
In Norwich
Description
-
Type
Training
-
Location
Norwich
-
Duration
1 Day
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. Suitable for: Those who wish to continue advancing their knowledge of Excel
Facilities
Location
Start date
Start date
Reviews
Course programme
Microsoft Excel Advanced - Level 2
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
Microsoft Excel Advanced - Level 2