Course goals
MEDIAplus elearning
This module offers interactive training consisting of 12 training videos, 12 exercises and 2 additional resources.
Excel 2021 – Data tables
- Database functionality with an Excel table – Theme
- You need to know: Flash Fill
- Creating and managing a data table
- Presenting and sorting data in a data table
- Adding calculations to a data table
- Automatic filtering
- Custom filters
- Blank cells and duplicates
- You need to know: The criteria range
- Criteria ranges
- Filtering and copying rows using a criteria range
- Statistics with a criteria range
- Data sorting and filtering functions
MEDIAplus elearning
This module offers interactive training consisting of 12 training videos, 12 exercises and 1 additional resource.
Excel 2021 – Pivot tables – v2
- Set your data from a different angle: pivot tables and charts – Theme v2
- You need to know: Pivot tables and charts
- Creating pivot tables
- Editing and adding calculations to pivot tables
- Changing a pivot table’s source
- Selecting, copying, moving or deleting in pivot tables
- Pivot table layout and printing
- Formatting pivot tables
- Filtering pivot tables
- Filtering with slicers
- Creating pivot tables based on several tables
- Adding calculated fields or elements
- Grouping data
- Pivot charts
Video
This module offers to view a video lasting 23 minutes.
Microsoft Office: use cases – Excel, Word or PowerPoint with a Microsoft 365 subscription
- The Office suite with or without an Microsoft 365 subscription: what are the differences?
- Creating and saving Office files in OneDrive, SharePoint Online or Teams
- Editing an Office file from OneDrive, SharePoint or Teams
- Sharing Office files with other contributors or people from outside your organisation
- Co-editing a file
Additional book
This module includes digital course material.
Excel 2021 and Office 365 versions – Reference book
Additional MEDIAplus elearning content
This module offers interactive training consisting of 27 training videos, 27 exercises and 6 additional Resources.
Excel 2021 – Table creation basics
