Microsoft Office Specialist – Excel

Core Content

MOS Excel Associate courses typically focus on five key areas, mirroring the exam’s objective domains:

1. Manage Worksheets and Workbooks:

1. • Creating and managing multiple worksheets within a workbook.
   • Navigating, formatting, and customizing workbooks and worksheets.
   • Configuring settings for collaboration and different views.
2. Manage Data Cells and Ranges:
   • Inserting, manipulating, and formatting data in cells and ranges.
   • Applying formulas and performing data entry.
   • Using basic functions to perform calculations and transform data.
3. Manage Tables and Table Data:
4. • Creating and formatting structured tables from data ranges.
   • Sorting, filtering, and modifying table data.
   • Introducing concepts like PivotTables and PivotCharts.
5. Perform Operations Using Formulas and Functions:
   • Inserting references to cells and ranges.
   • Applying basic and advanced formulas and functions.
   • Performing calculations and transforming data using functions.
6. Manage Charts and Objects:
   • Creating and formatting various charts and sparklines to visualize data.
   • Inserting and manipulating other graphic elements to enhance data presentation.
   • • Creating and formatting structured tables from data ranges.
     • Sorting, filtering, and modifying table data.
     • Introducing concepts like PivotTables and PivotCharts.
   • Perform Operations Using Formulas and Functions:
     • Inserting references to cells and ranges.
     • Applying basic and advanced formulas and functions.
     • Performing calculations and transforming data using functions.
   • Manage Charts and Objects:
     • Creating and formatting various charts and sparklines to visualize data.
     • Inserting and manipulating other graphic elements to enhance data presentation.

It is recommended that you have achieved or are working at level 1 in Digital.
You must be aged 19+

This course is full funded for those living in the WMCA and earning less than £34,000 per year.