Supercharge your Excel skills with our “Advanced Excel on Steroids” course. Master complex formulas, Power Query, Pivot Tables, and macros. Create dynamic dashboards and automate tasks for enhanced productivity.
| Date | Venue | Duration | |
|---|---|---|---|
| 23 - 25 March 2026 | Pretoria | 3 Days | Register Now |
This advanced Excel training program is designed to equip participants with the skills to work efficiently with complex data sets, automate tasks, and leverage Excel’s latest features for enhanced decision-making. Participants will gain hands-on experience with advanced formulas, Power Query, Pivot Tables, Macros, and data visualization techniques to streamline their workflow and improve reporting capabilities.
Â
Key topics include:
Advanced formulas and functions (logical, lookup, text, and math functions).
Data cleaning and automation using Power Query.
Advanced sorting, filtering, and data validation techniques.
Goal Seeker, Solver, and advanced conditional formatting.
Pivot Tables, dynamic charting, and dashboard creation.
Excel macros for task automation.
Workbook and worksheet protection.
Exploration of new Excel features to improve productivity.
By the end of this Advanced Excel on Steroids course, participants will be able to:
Utilize advanced Excel formulas and functions to efficiently manipulate and analyse data.
Leverage Power Query to clean and transform large data sets.
Apply advanced sorting, filtering, and data validation techniques for structured data management.
Use Goal Seek and Solver to optimize data-driven decision-making.
Implement advanced conditional formatting for better visualization of key insights.
Create and manipulate Pivot Tables and Pivot Charts for in-depth data analysis.
Develop interactive dashboards to present data in a meaningful and dynamic way.
Automate repetitive tasks using Macros to enhance productivity.
Secure and protect Excel workbooks and worksheets to maintain data integrity.
Explore and integrate new Excel features to streamline workflows and improve efficiency.
This Advanced Excel on Steroids course is designed for:
Business professionals, analysts, and managers who need to analyse and manage large datasets.
Finance, accounting, and HR professionals who work extensively with data validation, formulas, and financial modelling.
Administrative personnel responsible for generating reports, dashboards, and automating repetitive tasks.
IT and data professionals who want to enhance their Excel proficiency with Power Query, Pivot Tables, and advanced charting.
Anyone looking to improve their Excel skills for better efficiency and productivity in the workplace.
Our diverse instructional approaches ensure effective learning:
– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.
Date Concepts – Refresher
Date functions include DATE, EDATE, EOMONTH, YEARFRAC
Formulas & Functions
Explore commonly used functions and new functions
Logical – IF, IFS, IFERROR, LET, AND, OR, XOR, NOT, SCAN & TRUE Â Â Â Â Â Â Â Â Â Â Â Â Â Â
Lookup & Reference – VLOOKUP, HLOOKUP, XLOOKUP, CHOOSE, SEQUENCE, SWITCH and INDEX & MATCH
Math & Trig – SEQUENCE, ROUNDUP & ROUNDDOWN
Text – SUBSTITUTE, TEXTBEFORE, TEXTAFTER, TEXTSPLIT, TEXTJOIN & VALUETOTEXT
New Dynamic Array functions – CHOOSECOL, CHOOSEROW, DROP, FILTER, HSTACK, SORT, SORTBY, UNIQUE, TOCOL, TOROW, VSTACK & XMATCH
Mixed Referencing – Understanding Absolute and Mixed Referencing
Formulas Miscellaneous.
Name Manager – functions of & defining names
Formula Auditing – Trace Precedents, Trace Dependents & Evaluate Formula
Introduction to Name Ranges
Understanding the importance of name ranges and when they must be used.
The Name Box
Naming ranges
The Name Manager
Apply a Name Range to a formula.
Editing and deleting a Name range
Data Cleaning using Power Query
Advanced data cleaning using Power Query
Format a table
Get Data
Capitalize each work and Trim
Split Column
Merge Columns
Applied Steps
Data Miscellaneous
Data Sorting – Basic and advanced sorting
Data Filtering – Basic and advanced filtering
Data Tools – Text to Column, Flash Fill & Remove Duplicates
Data Validation
Reason why data validate
Data validation options – Value, whole number, decimal, list, date
Data validation – messages and alerts
Data validation advanced – custom
Goal Seeker & Solver
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
Goal Seeking Components
Using Goal Seek
Understanding How Solver Works
Installing The Solver Add-In
Setting Solver Parameters
Adding Solver Constraints
Performing The Solver Operation
Running Solver Reports
Advanced Conditional Formatting
Standard Option – data bars, color scales & icon sets
Custom Formatting – format cells that contain, format cells based on their values & use a formula to determine which cell to format
Format a Table
Reasons to format a table
Dynamic tables – total rows, slicers
Pivot Tables
New Formulas – GETPIVOTDATA, PIVOTBY & GROUPBY
Pivot Tables Advanced
Pivot Charts
Pivot Table Pro Tips
Data Modelling in Pivot Tables
Advanced Charting
Dynamic charting using Forms Control
Scroll Bar
Check Box
Combo Box
Macros
Using macros to automate mundane and repetitive tasks
Understanding Excel Macros
Setting Macro Security
Saving A Document as Macro Enabled
Recording A Simple Macro
Running A Recorded Macro
Relative Cell References
Viewing A Macro
Editing A Macro
Assigning A Macro to The Toolbar
Running A Macro from The Toolbar
Assigning A Macro to The Ribbon
Assigning A Keyboard Shortcut To A
Macro
Deleting A Macro
Copying A Macro
Dashboard
Dashboard Principles
Developing a Dashboard User Interface
Protection
Workbook Protection
Worksheet Protection – specific cells, option, hide formulas
New Excel Features
Easy Search
Navigation Pane
New Keyboard Shortcuts
Automate Tab
Value Tool tip
Add-Ins
Analyze Data
Forecast
Insert from Picture
Searchable Drop-down box
Extract Data from Image
Check Box
Discover how our courses enhance professionals’ effectiveness in their workplaces.
