Microsoft Excel Advance
FREE Course Guide Download
On completion of this course, attendees will be able to create a variety of functions, present their data using PivotTables, analyse workbooks and data and record macros.
This short course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.
Attendees should have attended our Excel Intermediate course or have equivalent knowledge.
1. Working With Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
2. Using Lookup Formulas and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas
3. Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
4. Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
5. Creating Sparklines
Topic A: Create Sparklines