Excel Skills and Tools Course

From Spreadsheet Setup to Advanced Functions

Excel Skills and Tools Course

The goal of the Excel Skills and Tools Course at MF Business School is to help participants gain full mastery of Excel, from setting up spreadsheets to using advanced functions. You will learn how to build solid formulas, manage structured datasets, create effective tables and pivot tables, design clear charts, and develop interactive dashboards.

The course also focuses on developing skills in using Power Query and Power Pivot to import, model, and analyze complex data, as well as automating processes through VBA Macros and AI-assisted tools. A complete learning path designed to transform Excel into a true professional environment for analysis, automation, and decision-making.

Course Contents

Basic Excel Level

Understanding the grid and relative, absolute, and mixed references
Writing basic formulas and functions to solve common cases
Designing double-entry tables and defining layout and formatting
Using date/time functions, time management, and dynamic calendar creation
Creating linear tables, applying filters, and simple conditional formatting
Using pivot tables to turn data into meaningful information
Data validation to reduce manual input errors
Text functions such as MID and CONCAT

Intermediate Excel Level

Managing tables with filters, automatic totals, and dynamic tools
Pivot table analysis: calculations, percentages, and grouping
Interactive pivot charts with filters and timelines
Lookup functions (VLOOKUP / XLOOKUP) and error handling
Conditional functions (IF, IF.S) for automation
Power Query to import, clean, and transform data from multiple sources and connect it to pivot tables

Advanced Excel Level

Advanced use of Power Query to import data from multiple sources, model using the M language, and reuse scripts
Importing entire folders and analyzing data through pivot tables
Advanced table features with internal and external column references
Power Pivot for dynamic data models, introduction to DAX language, and relationships between tables
Append and Merge queries
Building dashboards with advanced pivot tables, filters, and charts
Creating VBA macros through recording and assisted programming
Introduction to prompt engineering and the use of AI models (LLMs) to write VBA macros and M/DAX scripts

Duration and Format

The training methodology will be delivered through online learning with a strong experiential focus, enriched by practical activities such as:

group exercises
simulations based on real business cases
project work

The Excel training program is divided into Basic, Intermediate, and Advanced levels.
Each level includes 5 sessions of 5 hours each, with scheduling to be agreed upon with the company.

Are you interested in our Excel Skills and Tools Course at MF Business School?
Download the brochure below to find out more. You will discover further details about the course structure and learning methodology.

Download brochure