Excel — Catalogue
Choose a course or a bundle to get started.
Excel Professional is designed in particular for controllers, accountants, business administrators, analysts, assistants, project managers and operational managers. Its goal is to help them make data reliable, perform calculations and reconciliations, build budgets, dashboards and recurring reports, and automate repetitive work.
The 15 courses progress from the fundamentals to a genuine expert level: modern functions, advanced lookups, PivotTables, visualization, Power Query, data models, Power Pivot, first DAX measures, macros/VBA, workbook protection and controlled use of Copilot. By the end of the pathway, you will be able to build, control, analyze, automate, document and hand over a complete professional workbook that is maintainable and usable in a real business environment.
🎓 15 courses • 📚 120 interactive lessons • ⏱️ 45 to 75 hours of conversational training
Best offer
Professional Excel — Complete Pack
143,10 € excl. VAT
Savings : 95,40 €
29,70 €
22,90 excl. VAT
Savings : 6,80 €
Discover Excel and create your first workbook
Understand the Excel environment and build a first usable table.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
No specific technical prerequisite. Everyday confidence with a computer and common office tools is sufficient.
- What Excel is used for
- Understanding workbooks, sheets, cells and ranges
- Entering and editing data
- Workshop: create a first tracking table
- Apply the methods and tools covered in the course to understand the Excel environment and build a first usable table.
- Complete a representative course task independently: create a first tracking table
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
9,90 € excl. VAT
Present a professional table
Produce a clear, readable and properly presented sheet.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
No specific technical prerequisite. Everyday confidence with a computer and common office tools is sufficient.
- Recognizing different data types
- Organizing rows, columns and cells
- Using conditional formatting
- Workshop: present a professional budget
- Apply the methods and tools covered in the course to produce a clear, readable and properly presented sheet.
- Complete a representative course task independently: present a professional budget
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
9,90 € excl. VAT
Perform your first calculations
Understand the logic behind Excel formulas.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
No specific technical prerequisite. Everyday confidence with a computer and common office tools is sufficient.
- Understanding the structure of a formula
- Using relative references
- Using SUM, AVERAGE, MIN and MAX
- Workshop: build a calculated expense table
- Apply the methods and tools covered in the course to understand the logic behind Excel formulas.
- Complete a representative course task independently: build a calculated expense table
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
9,90 € excl. VAT
38,70 €
28,90 excl. VAT
Savings : 9,80 €
Use the essential functions
Automate the most common calculations in business.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
A working knowledge of the pathway foundations and confidence with the operations introduced in the first courses are recommended.
- Using the IF function
- Counting with COUNT, COUNTA and COUNTIF
- Rounding results
- Workshop: create a goals and results tracker
- Apply the methods and tools covered in the course to automate the most common calculations in business.
- Complete a representative course task independently: create a goals and results tracker
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
12,90 € excl. VAT
Organize and control your data
Turn a simple list into a real Excel working base.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
A working knowledge of the pathway foundations and confidence with the operations introduced in the first courses are recommended.
- Turning a range into an Excel table
- Sorting data on one or more criteria
- Controlling entry with data validation
- Workshop: build a reliable tracking file
- Apply the methods and tools covered in the course to turn a simple list into a real Excel working base.
- Complete a representative course task independently: build a reliable tracking file
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
12,90 € excl. VAT
Work with text and dates
Clean and transform the information you receive.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
A working knowledge of the pathway foundations and confidence with the operations introduced in the first courses are recommended.
- Extracting text with LEFT, RIGHT and MID
- Cleaning up spaces and unwanted characters
- Calculating durations and deadlines
- Workshop: clean up an imported file
- Apply the methods and tools covered in the course to clean and transform the information you receive.
- Complete a representative course task independently: clean up an imported file
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
12,90 € excl. VAT
47,70 €
35,90 excl. VAT
Savings : 11,80 €
Search for and match information
Automatically retrieve information from another table.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
A working knowledge of the pathway foundations and confidence with the operations introduced in the first courses are recommended.
- Understanding the principle of a lookup
- Handling values not found
- Using INDEX and MATCH
- Workshop: match two professional files
- Apply the methods and tools covered in the course to automatically retrieve information from another table.
- Complete a representative course task independently: match two professional files
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
15,90 € excl. VAT
Master modern and advanced formulas
Build dynamic calculations that are easier to maintain.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Using dynamic arrays
- Sorting with SORT and SORTBY
- Simplifying a formula with LET
- Workshop: produce a dynamic analysis
- Apply the methods and tools covered in the course to build dynamic calculations that are easier to maintain.
- Complete a representative course task independently: produce a dynamic analysis
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
15,90 € excl. VAT
Create professional charts
Choose and build the right visualization.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Choosing a chart suited to your message
- Representing change over time
- Using a secondary axis
- Workshop: present results to management
- Apply the methods and tools covered in the course to choose and build the right visualization.
- Complete a representative course task independently: present results to management
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
15,90 € excl. VAT
56,70 €
42,90 excl. VAT
Savings : 13,80 €
Analyze with PivotTables
Quickly summarize a large volume of data.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Preparing a correct data source
- Organizing rows, columns, values and filters
- Using slicers and timelines
- Workshop: analyze the results of an activity
- Apply the methods and tools covered in the course to quickly summarize a large volume of data.
- Complete a representative course task independently: analyze the results of an activity
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
18,90 € excl. VAT
Build a dashboard
Bring together indicators, charts and filters in an interactive report.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Defining the dashboard's objectives
- Preparing the source data
- Adding interactive filters and slicers
- Workshop: create a complete dashboard
- Apply the methods and tools covered in the course to bring together indicators, charts and filters in an interactive report.
- Complete a representative course task independently: create a complete dashboard
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
18,90 € excl. VAT
Import and transform with Power Query
Automate the cleaning and consolidation of files.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Understanding the role of Power Query
- Discovering the Power Query editor
- Adding and merging several queries
- Workshop: consolidate several monthly files
- Apply the methods and tools covered in the course to automate the cleaning and consolidation of files.
- Complete a representative course task independently: consolidate several monthly files
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
18,90 € excl. VAT
65,70 €
48,90 excl. VAT
Savings : 16,80 €
Build a data model with Power Pivot
Analyze several tables without cramming everything into one sheet.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Understanding the Excel data model
- Creating relationships between tables
- Differentiating calculated columns and measures
- Workshop: analyze several linked tables
- Apply the methods and tools covered in the course to analyze several tables without cramming everything into one sheet.
- Complete a representative course task independently: analyze several linked tables
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
21,90 € excl. VAT
Secure, protect and automate Excel
Build robust workbooks and reduce repetitive tasks.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Auditing formulas and their dependencies
- Protecting cells, sheets and workbooks
- Recording a first macro
- Workshop: automate a recurring task
- Apply the methods and tools covered in the course to build robust workbooks and reduce repetitive tasks.
- Complete a representative course task independently: automate a recurring task
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
21,90 € excl. VAT
Work with Copilot and complete a full project
Bring together all the course's skills in a professional case.
Course information
Professionals who use Excel to organize, validate, calculate, analyze or present business data.
You should already master the pathway foundations or have equivalent practical experience. Advanced topics build on skills introduced earlier.
- Properly preparing data for Copilot
- Asking for a formula to be created or explained
- Checking Copilot's suggestions and results
- Presenting, documenting and handing over the workbook
- Apply the methods and tools covered in the course to bring together all the course's skills in a professional case.
- Complete a representative course task independently: Presenting, documenting and handing over the workbook
- Check the consistency of the result and correct identified errors or gaps
- Transfer the course skills to a comparable workplace situation
3 to 5 h
21,90 € excl. VAT