* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course Code: EXLADV

Duration: 1 Day

Overview

This one-day course covers aspects of Microsoft Excel that goes well beyond building basic workbooks, including workbook automation and productivity features. Participants will learn advanced Excel techniques in a range of areas such as worksheet and workbook consolidation, data validation, PivotTables and Pivot Charts, Lookup and Reference Functions, Linking Data, Financial Functions, Recorded Macros and much more.

Audience

This course is intended for experienced Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks. Upon completion of the course, students will have learned the skills to able work with Excel’s advanced data analysis tools, automate workbook operations and effectively use complex functions.

Prerequisites

Participants should have already completed both the Excel for Beginners course and Excel Intermediate course before attending this course, or have Excel skills up to the intermediate level course.

Module List

Module 1: Setting Excel Options
Module 2: Lookup Functions in Excel
Module 3: Text Functions in Excel
Module 4: Financial Functions
Module 5: Information Functions
Module 6: Complex Formulas
Module 7: Goal Seeking
Module 8: Data Linking in Excel
Module 9: Data Consolidation
Module 10: Protecting Data
Module 11: Summarising and Subtotalling
Module 12: Grouping and Outlining
Module 13: Pivot Tables
Module 14: Pivot Charts
Module 15: Pivot Table Features
Module 16: Recorded Macros

Click here for the full 'Excel Advanced' course outline