Duration: 1 Day
Course Overview
The Advanced Excel course is designed for those who are already comfortable with Excel fundamentals and seek to enhance their skills for more sophisticated data analysis, reporting, and automation.
Target Audience
This course is ideal for individuals who regularly use Excel in their roles and want to enhance their efficiency and analytical capabilities through more advanced techniques.
Array Formulas and Functions:
Working with Data: FILTER, SORT, UNIQUE, SEQUENCE.
Lookup and Reference: Adv XLOOKUP, GROUPBY & PIVOTBY
Spill Ranges in Excel
Introduction to Power Query:
Importing, transforming, and cleaning data from various sources.
What-If Analysis:
Using Goal Seek, Data Tables, and Scenario Manager
Advanced Pivot Table Techniques:
Using slicers and Timelines
Calculated fields, Calculated Items, and Grouping data.
Percentages and Aggregation
Additional Pivot Table Options
Introduction to Macros:
Naming Conventions
Recording and Editing Macros
Using the Visual Basic Editor
Assigning Macros to the QAT and Sheet Buttons
By the end of the course, participants will be equipped with powerful Excel techniques for improving productivity, data insights, and decision-making capabilities.
