Do you already work with Excel and want to go beyond the basics?

This two-day Advanced Excel training will transform the way you analyse data, build reports and automate tasks.

You will learn how to create dynamic dashboards, use powerful formulas, master PivotTables and automate repetitive work. After this course, Excel will no longer be just a spreadsheet tool — it will become your strategic data partner.

Duration

2 days.

Why Follow this course ?

After this training, you will be able to:

• Build dynamic and interactive reports
• Use advanced formulas confidently and efficiently
• Analyse large datasets with powerful PivotTables
• Apply smart data validation techniques
• Perform scenario and what-if analyses
• Automate repetitive tasks with macros
• Work faster, smarter and more professionally in Excel

This course is hands-on, practical and immediately applicable to your daily work.

Course Outline

Day 1 - Advanced Data Handling & Powerful Formulas

Working with Tables Like a Pro

• Format data as structured tables
• Structured references
• Advanced sorting and filtering
  • AutoFilter
  • Advanced Filter
  • Filter by colour
• Subtotals and grouped data

Conditional Formatting

• Professional formatting techniques
• Custom rules and formula-based formatting
• Tips & tricks for clean reporting

Advanced Functions & Logical Formulas

• IF, nested IF and IFS
• IFERROR
• SUMIF(S) and COUNTIF(S)
• Lookup functions (HLOOKUP / VLOOKUP)
• Text functions
• Date & Time functions

Named Ranges & Data Validation

• Name Manager
• Creating dynamic named ranges
• Drop-down lists
• Data validation techniques

Day 2 – Analysis, Reporting & Automation

Mastering PivotTables

• Creating PivotTables
• Advanced calculations
• Grouping and filtering
• Calculated fields
• Slicers and timelines
• Layout and aesthetics
• Refreshing and updating data

What-If Analysis

• Scenario Manager
• Goal Seek
• Data Tables

Building Dynamic Reports

• Combining formulas and PivotTables
• Creating interactive reports
• Best practices for dashboards

Introduction to Macros

• Recording macros
• Absolute vs relative references
• Assigning macros to buttons
• Introduction to the VBA editor
• Macro security basics

Audience

This course is designed for professionals who:

• Already have a solid basic knowledge of Excel
• Regularly work with data, reports or calculations
• Want to improve efficiency and analytical skills
• Aim to create professional reports and dashboards

Typical participants include professionals from finance, HR, administration, sales, operations and project management.

Prerequisites

Participants should have successfully completed a Basic Excel course or possess equivalent knowledge, including:

• Basic formulas
• Simple formatting
• Basic charts
• Basic data sorting and filtering