Microsoft Excel
Learn how to get the most out of Microsoft Excel
-
What this module covers
What this module covers
- Getting started
- What is Microsoft Excel?
- Entering data
- Entering data
- Activity: Creating a budget planner
- Data validation
- Activity: Alternative budget planner
- Formatting your spreadsheet
- Formatting your spreadsheet
- Activity: Formatting the budget planner
- Adding filters and sorting data
- Activity: Filtering and sorting the alternative budget planner
- Using basic formulas
- Introducing formulas
- Activity: Performing calculations on the budget planner
- Using formulas with text based data
- Activity: Analysing the budget planner using formulas
- Presenting data with graphs and charts
- Graphs and charts
- Activity: Adding charts to our budget planner
- Using pivot tables
- Activity: Further analysis of the budget planner
- Test your knowledge on Microsoft Excel
- Earn your Microsoft Excel badge