Microsoft Excel Advanced, 1-Day Online Training Course

* 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