Excel beginner
Build solid foundations and produce clean, calculated and easy-to-share tables.
- Navigate workbooks efficiently
- Enter and structure data consistently
- Create reliable basic calculations
- Format, filter and print clearly
Microsoft 365
Microsoft Excel training for businesses
Structure, analyze and automate data with private Excel training built around the workbooks, reports and decisions your team handles every day.
Course plans
Choose the level that fits your team
Each level can be delivered alone, combined with another or adapted to your files. A mixed-level group can also be divided so everyone progresses at the right pace.
Excel intermediate
Save time, strengthen calculations and produce useful analysis from real data.
- Master relative and absolute references
- Combine logical and lookup functions
- Summarize data with PivotTables
- Build a repeatable management report
Excel advanced
Automate data preparation and build robust, fast and auditable models.
- Import and transform with Power Query
- Use advanced dynamic formulas
- Audit and optimize a model
- Refresh reports without rebuilding them
Not sure which level to choose?
Assess my team
A short discussion, questionnaire and a few sample files help us recommend the right path.
Target skills
Learn what is genuinely useful
Content is organized around the tasks participants must perform at work rather than a simple feature list.
Structure reliable tables
Create data ranges that are easy to maintain, filter and expand.
Write practical formulas
Choose functions and references that match real business situations.
Clean and consolidate data
Standardize imports, remove inconsistencies and prepare reusable sources.
Analyze quickly
Use PivotTables, charts and dashboards to answer business questions.
Automate recurring tasks
Reduce copy-and-paste work with Power Query and repeatable methods.
Present results clearly
Build reports that make indicators, assumptions and decisions understandable.
Collaborative training
Training built around your projects
After a short demonstration, participants practise, compare methods and receive immediate feedback. When real files cannot be shared, equivalent exercises reproduce the same constraints without exposing confidential information.
The content and pace are adjusted to the team’s roles, authorized tools and expected results.
✓
Repair a fragile budget workbookStandardize formulas, references and checks across worksheets.
✓
Turn monthly exports into a repeatable reportCreate a cleaning and refresh process instead of rebuilding the report.
✓
Build a sales, operations or HR dashboardSelect useful indicators and create a clear decision view.
Beyond the three levels
Targeted Excel workshops for Microsoft 365 needs
Your team may not need a complete course. We can build intensive workshops around a specific challenge or deliverable.
Power Query and data preparation
Import, clean, combine and refresh recurring sources.
Dashboards and recurring reporting
Create indicators, PivotTables, filters, charts and update routines.
Modern formulas
XLOOKUP, dynamic arrays, LET, logical functions and reusable calculations.
Workbook audit and repair
Trace formulas, identify risks, improve controls and document assumptions.
Excel in Microsoft 365
Collaboration, sharing, versions and functions available in the client environment.
Excel and artificial intelligence
Use authorized AI tools to explain formulas, explore data and document work with human validation.
Our solutions
A format for every need
From a single session to an annual program, the format is adapted to your organization’s pace, objectives and priorities.
Private collaborative training
Your team works live with a specialist who explains, demonstrates and answers questions.
- Flexible 3-hour blocks
- 1 to 15 participants
- Online or in person
Custom training
We review files, roles, processes and expected results before building the learning path.
- Needs assessment
- Customized exercises
- Learning validation
Managed training subscription
JFL Media coordinates several topics, instructors and teams throughout the year.
- Flexible annual calendar
- Session or credit bank
- Support for managers
Process
Your Excel training in three steps
A simple process from the first discussion to practical application.
Clarify the need
Objectives, level, Excel versions, authorized files, participants and constraints.
Build the learning path
Selection of the most relevant level, modules, instructor and exercises.
Your team puts it into practice
Short demonstrations, guided exercises, questions and next steps.
Let’s discuss your project
Training adapted to your team?
Describe the result you need, current level, number of participants, preferred delivery and any authorized files or processes.