Logical and lookup functions
- Build conditions with IF
- Combine AND, OR and IFERROR
- Use XLOOKUP to connect tables
- Use INDEX and MATCH when appropriate
- Handle exact and approximate matches
- Test and validate results
Microsoft Excel — Intermediate
Microsoft Excel intermediate
Save time, correct fragile methods and complete more complex projects with confidence.
Course plan
Three-hour modules in a logical sequence
Modules can be delivered as a complete path, selected individually or combined with another level.
Data validation, cleaning and control
- Create drop-down lists and input rules
- Find duplicates, blanks and inconsistencies
- Clean text with the appropriate functions
- Convert and standardize dates and numbers
- Use conditional formatting as a control
- Establish a verification method
PivotTables and charts
- Prepare an analysis-ready data source
- Create and modify a PivotTable
- Group dates, categories and values
- Add slicers and timelines
- Choose a chart suited to the message
- Refresh and distribute the report
Excel collaboration in Microsoft 365
- Share a workbook with the right permissions
- Co-author and track changes
- Use comments and mentions
- Manage versions and restoration
- Protect sheets, cells and structure
- Avoid file and copy conflicts
By the end of training
Directly observable skills
✓
Build conditions with IF
Practised in an exercise or work case.
✓
Combine AND, OR and IFERROR
Practised in an exercise or work case.
✓
Create drop-down lists and input rules
Practised in an exercise or work case.
✓
Find duplicates, blanks and inconsistencies
Practised in an exercise or work case.
✓
Prepare an analysis-ready data source
Practised in an exercise or work case.
✓
Create and modify a PivotTable
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.