Power Query and automated data preparation
- Import files, folders and common sources
- Clean and transform data
- Merge and append multiple queries
- Create reusable parameters and steps
- Manage types, errors and missing values
- Refresh a repeatable process
Microsoft Excel — Advanced
Microsoft Excel advanced
Automate, standardize and manage complex files, models or processes for team production.
Course plan
Three-hour modules in a logical sequence
Modules can be delivered as a complete path, selected individually or combined with another level.
Dynamic formulas and advanced models
- Use FILTER, UNIQUE, SORT and SEQUENCE
- Build formulas with LET
- Create reusable functions with LAMBDA
- Use SUMIFS and COUNTIFS efficiently
- Structure scalable models
- Optimize readability and performance
Dashboards, auditing and automation
- Define indicators and reading flow
- Build a dashboard layout
- Combine charts, slicers and formulas
- Audit dependencies and sensitive cells
- Introduce macros and Office Scripts safely
- Document, test and hand off the model
By the end of training
Directly observable skills
✓
Import files, folders and common sources
Practised in an exercise or work case.
✓
Clean and transform data
Practised in an exercise or work case.
✓
Use FILTER, UNIQUE, SORT and SEQUENCE
Practised in an exercise or work case.
✓
Build formulas with LET
Practised in an exercise or work case.
✓
Define indicators and reading flow
Practised in an exercise or work case.
✓
Build a dashboard layout
Practised in an exercise or work case.
Frequently asked questions
Prepare the right path
Can we choose only some modules?
Yes. The builder lets you select, remove and reorder modules according to the need.
How do we confirm this level is right?
Use the online assessment or share a few work examples with JFL Media.
Can the duration be adjusted?
Yes. The suggested duration is a starting point; the final plan considers the group, versions and objectives.
Can we work on real files?
Yes when files are authorized and prepared. Otherwise, equivalent examples are used.
JFL Media
Ready to build your plan?
Select the modules from this level, add other topics if needed and send your path to JFL Media.