This class covers advanced skills in Excel 2013. Although not required, it is highly recommended that you attend the Introduction to Excel training class before you attend this one. If you attend this advanced class, you are expected to know all the basic skills covered in the Introduction to Excel class (please check the list of skills on the Introduction to Excel class page).
Like the Introductory class, this Advanced class takes place in one morning, spanning approximately 3 hours.
The following is a list of Microsoft Excel 2013 skills covered in this class, in no particular order:
- Conditional Formatting
- Custom Sorting
- Grouping
- Locking Cells & Protecting Sheets
- Consolidate & Sparklines
- V-Lookup
- Watch Window
- Trace Precedents & Trace Dependents
- Creating Tables with Features
- Creating PivotTables & PivotCharts
Advanced Excel Class Handbook Recently Updated with additional Topics & Features...