Live team training · Excel Foundations
Excel foundations for everyday work.
Build a stronger method for organizing data, using formulas and turning information into clear reports. For teams who already use Excel and want more reliable skills.
Training is available in English.
Marco Filocamo — Microsoft Excel MVP
Exercise · sample data
From table to summary
| Product | Amount |
|---|---|
| Product A | 40 |
| Product B | 18 |
Table → PivotTable → chart
Is this the right course for your team?
Starting level
Participants should already be able to open, edit and save a workbook and use Excel in everyday tasks.
Prerequisites
Basic computer operations are assumed.
Everyday work
The pathway starts from real work: recurring reports, source data and the questions your team needs to answer.
What your team will work on
Course pathway
01
Start with the question
Define the question, understand the source data and plan the analysis before choosing commands.
02
Work with Excel tables
Create and filter tables, use structured references and keep calculations consistent as data changes.
03
Analyze with PivotTables
Choose fields, aggregations and layouts; use slicers and timelines to explore the question.
04
Build clear charts and reports
Choose suitable charts, labels and conditional formatting so another person can read the result.
05
Use essential modern formulas
Work with XLOOKUP, IF, SUMIFS, COUNTIFS, UNIQUE and text functions where the installed version supports them.
Inside an exercise
Question
Which products contribute most to the total?
Work in Excel
Organize the source as a table, build a PivotTable and choose a chart that makes the comparison clear.
Result
Product totals
Excel exercise · sample data
Source data
| Product | Region | Quantity |
|---|---|---|
| Product A | North | 24 |
| Product B | South | 18 |
| Product A | South | 16 |
Product totals
| Product | Amount |
|---|---|
| Product A | 40 |
| Product B | 18 |
Illustrative exercise — sample data.
Compare the options
Excel Foundations
Your instructor
Marco Filocamo — Microsoft Excel MVP. I connect tools with the questions people face at work, using practical examples and exercises to explain the reasoning.
Planning the course
Software and format
The course is designed for live team training using Excel for Microsoft 365 installed on participants’ computers.
Platform
Windows is recommended.
Compatibility and planning
Mac compatibility and feature availability are checked against the selected topics; group size, timing and delivery arrangements are agreed separately.
Questions about the pathway
Can we adjust the content to the team?
The initial discussion covers current skills, everyday tasks and objectives so suitable adaptations can be assessed.
Does every participant need the same features?
The selected topics need a compatible Excel installation. Version, platform and feature availability should be checked before organizing the course.
Which other pathway should we consider?
Foundations consolidates tables, formulas, PivotTables and reports. Advanced builds on those skills with transformations and more complex analysis.
Build skills around the work your team does.
Describe the team’s current level, activities and training objectives.