Microsoft Excel Advanced
Pivot Tables are often the main focus of this Microsoft® Excel advanced course but there are many other useful forgotten features that can be discovered including shared workbooks and data validation.
The course is designed to be flexible and a discussion of the students' main points of interest will take place before the start of the day. Before attending this course students should be comfortable with the majority of the features on the introductory and intermediate courses.
Please note that Macro training on this advanced course is aimed at writing and running macros from the Excel interface. VBA programming and building custom dialog boxes is not covered. Courses are available in Excel VBA and please contact us for details.
Data Analysis with PivotTables
Dates, Custom Groups, Multiple Tables
What IF Analysis
Protecting Worksheets & Cells
Outline and the View Manager
Advanced Functions (if required)
Using Styles and Templates