Excel training
Excel in Microsoft 365
Analyse and automate efficiently
Target Audience:
Employees who already use Excel but want to expand their skills
Purpose:
Quickly structure, analyse and present data in a visually appealing way
Time investment per module:
8 hours
In-depth content:
- Using Smart Tables (structured data, automatic filters)
- Combining functions (IF, AND/OR, TEXT functions, date/time, search functions such as XLOOKUP)
- Conditional formatting: visual warning function for deviations
- Pivot tables & slicers: gain insights from large data sets
- Build graphs (column, line, combo, sparklines)
- Work with multiple worksheets (3D formulas, cell references, links)
- Collaboration: manage versions, track changes, provide comments
- Intro to Power Query: clean and combine data (e.g. importing CSV files)
- Tips: avoid common mistakes, troubleshooting, understand short formulas
Interested?
Contact our team. We are happy to listen to your situation and propose a tailor-made path.