Intermediate Level · Microsoft Excel

Intermediate Excel: work smarter with data

This is the level most professionals actually need. We take the everyday things your team already does in Excel and speed them up dramatically - IF logic, VLOOKUP, PivotTables, protecting your data and building drop-downs that keep spreadsheets clean.

Book this course Download brochure (PDF)

Format: Onsite or online
Duration: 1 full day or 3 half-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.

Link data cleanly between worksheets and workbooks.
Use IF, VLOOKUP and Conditional Formatting to make spreadsheets self-explaining.
Build PivotTables and PivotCharts in minutes, not hours.
Protect workbooks, worksheets and cells so nobody breaks them.
Create drop-down lists and Named Ranges that make updates painless.

Working across sheets and workbooks

Linking data between worksheets & workbooks
Working with Named Ranges to speed data updates
Sensible workbook structure
Protecting workbooks, worksheets & individual cells

Dates, logic and lookups

Using the Date and Time functions
Conditional Logic: using IF statements
Finding data records using the VLookup function
When to use VLOOKUP vs XLOOKUP

Formatting and clean data

Highlighting data with Conditional Formatting
Data validation: creating drop-down lists
Sorting and filtering large tables
Removing duplicates safely

PivotTables and PivotCharts

Sorting information using PivotTables
Viewing data trends with PivotCharts
Grouping dates, values and categories
Refreshing pivots as data changes

Ideal for

Who this course is designed for

Finance, ops and marketing teams that live in Excel every week.
Analysts who inherited big workbooks and want to tame them.
PAs and coordinators managing budgets, trackers and rotas.
Anyone who's watched a YouTube video on VLOOKUP and wants the real thing.

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