Go beyond basics — learn Excel functions and automation that save hours every week.
Stop struggling with manual data work — use advanced tools like PivotTables, Solver, and Macros.
Turn Excel into your daily decision-making engine with formulas that work smarter.
Course Overview
Most Excel users only scratch the surface — but real productivity comes from mastering the advanced tools that automate, analyze, and structure your work. Whether you're building dashboards, forecasting outcomes, or streamlining reports, advanced Excel skills give you the edge.
This 2-day instructor-led course takes you beyond intermediate use. You’ll work with nested functions, VLOOKUP, INDEX & MATCH, What-If Analysis tools (Goal Seek, Solver, Scenarios), PivotTables, Slicers, Advanced Charts, Macros, and Form Controls.
If you're already using Excel and want to maximize its capabilities, this course is the practical next step.
Learning Objectives
Creating advanced formulas (nested IFs, INDEX + MATCH)
Performing What-If Analysis using Goal Seek, Scenarios, Solver
Using VLOOKUP, HLOOKUP, and Array formulas
Linking, consolidating, and combining multiple datasets
Designing PivotTables, PivotCharts, and applying Slicers
Building advanced charts like dual axis visualizations
Recording and assigning macros using Form Controls
Protecting workbooks and publishing to PDF
Who Should Attend
Admin and finance professionals managing large datasets
Analysts and managers needing deeper control over Excel models
Office users looking to automate reports and analysis
Anyone who has completed Excel Intermediate/Foundation and wants more
Prerequisites
Completion of Excel Foundation & Intermediate training OR
Ability to build formulas (e.g., IF, COUNTIFS, SUMIFS)
Comfortable with filters, data validation, and duplicate removal
Course Modules
Module 1: Getting the Most from Your Data
Outlining, grouping, and subtotaling data for clearer reporting.
Module 2: What-If Analysis
Using Data Tables, Goal Seek, Scenarios, and Solver for modeling outcomes.
Module 3: Advanced Excel Tasks
Writing Array formulas, using VLOOKUP, INDEX, MATCH, and combining data across sheets and workbooks.
Module 4: Advanced Charting
Creating dual-axis charts and custom templates.
Module 5: PivotTables, Slicers & PivotCharts
Creating and customizing PivotTables, filtering with Slicers, and visualizing insights with PivotCharts.
Module 6: Workbook Enhancement
Inserting and formatting hyperlinks, customizing workbooks.
Module 7: Macros & Form Controls
Recording Macros, assigning them to buttons, and using Form Controls for interactive workbooks.
Module 8: Publishing & Protection
Saving to PDF, protecting worksheets and full workbooks, file-level security.
Public Class Details
Professional Outcomes
This course supports Excel users transitioning into roles such as Data Analyst, Reporting Specialist, or Excel Automation Power User — building reports and tools that drive business value.
Certification Details
No specific exam for this course
Frequently Asked Questions
Is this course suitable for beginners?
No. It is designed for users who already understand Excel basics and intermediate functions.
Will I learn automation?
Yes. You’ll use Macros and Form Controls to automate tasks.
Are financial or statistical formulas covered?
The course includes logical, lookup, array, and forecasting tools like Solver and Scenarios.
Is this course mostly formulas or visual tools?
It’s both — formulas, PivotTables, charting, and workbook automation are all covered.
Do I need to know VBA?
No. Macros are recorded using Excel’s built-in recorder — no coding required.
Is this course HRDC claimable?
Yes. Fully claimable under HRD Corp for eligible Malaysian employers.
Can I schedule this as a private group training?
Yes. GemRain offers both in-house and virtual team sessions.
Will I receive a certificate?
Yes. GemRain provides a certificate of completion for all participants.