Advanced Level · Microsoft Excel

Advanced Excel: master analysis & automation

The advanced course is where teams stop being users of Excel and start being builders. Nested logic, INDEX/MATCH searches across huge datasets, SUMIFS reporting, scenario modelling, Goal Seek and dashboards designed for the people who make decisions.

Book this course Download brochure (PDF)

Format: Onsite or online
Duration: 1–2 full days
Group size: 1 – 20+

What you'll learn

Outcomes for your team

Every session is tailored around real workplace problems your team is trying to solve. These are the outcomes we usually design around.

Nest IF/AND/OR to model real business rules cleanly.
Use SUMIFS, COUNTIFS and AVERAGEIFS to summarise data with no macros.
Search huge datasets with INDEX and MATCH.
Build interactive dashboards with slicers, PivotTables and clean design.
Run Goal Seek and Scenarios to answer 'what if' questions on the fly.

Nested logic & advanced functions

Nesting functions using IF, AND, OR
Advanced Functions: SUMIF(S), COUNTIF(S) & AVERAGEIF(S)
IFERROR wrapping for cleaner reports
Text functions for cleaning messy data

Searching and referencing at scale

Searching databases using MATCH and INDEX
XLOOKUP for modern Excel
Dynamic ranges and structured references
Named Ranges in complex models

PivotTables, Slicers & dashboards

Using Slicers to work with PivotTable data
Advanced Conditional Formatting techniques
Creating a visual Dashboard in Excel
Layout and typography for readable dashboards

Modelling & analytical tools

Data Validation with dependent lists
Creating and working with Scenarios
Using Goal Seek to arrive at a known value
Documenting models so someone else can use them

Ideal for

Who this course is designed for

Analysts, controllers and management accountants.
Ops and supply-chain teams modelling scenarios weekly.
Anyone building dashboards leadership actually opens.
Long-time Excel users who suspect they're doing things the slow way.

Free download

The Excel training brochure

6-page PDF: beginner to advanced curriculum, real client testimonials and pricing guidance for teams.

Download PDF

What clients say

5.0 stars on Google

Read all reviews →

"I am glad I chose Deepak over the other teachers for my Excel course. I am amazed by the value provided by him. He is an excellent tutor, very patient and explains everything precisely step by step at your own pace. I would highly recommend him."

- Eleonora Sara Sedik

"I would definitely recommend Deepak if you're starting out with Excel, or even if you just want to brush up your skills! He's very patient, non-judgmental, and above everything very knowledgeable. He caters to both individuals and corporates. Highly recommended!"

- Neeraja Nair

"Great day of training with Deepak - excellently delivered, very patient, and somehow he made what could be considered a boring subject very interesting. I've used Excel for 20+ years and thought I was quite good but learnt so much on the day."

- Richard Appleton

"Deepak is an expert in the field and helped me out a lot. He is 100% a great tutor not only for students but for professionals in other fields who need to improve their Excel skills. Very patient and explains everything thoroughly."

- Mina Nozari

"Deepak's training was excellent. I'm completely new to Excel but, thanks to his clear and patient tuition, I've already built my own spreadsheet so I no longer have to do calculations by hand and have saved myself acres of time. Recommended 100%."

- Alexa Brummer

"Deepak is a great teacher: calm, professional with the ability to teach. His attitude is great and his advanced Excel knowledge is excellent. Highly recommended!"

- Dorota Mezykowska

"Deepak is an outstanding Excel tutor. His teaching style is clear, engaging and tailored to my needs. I highly recommend him to anyone looking to master Excel."

- CJ Okonkwo