MOS Excel 2019 and 365 Associate

If you’re looking to get to grips with the latest version of Microsoft Excel and perhaps need it for your job role to prove your competence, our Microsoft Excel 2019 365 Associate course can help you stand out! Learn how to manipulate data in worksheets, perform operations using tables and understand how to manage charts and objects. Become fully skilled in using Microsoft Excel and choose to sit an exam to receive the full certification. Study for this course online and study whenever, wherever you want.

Course Content

Unit 1 Managing worksheets and workbooks

• Introduction
• The Excel application
• Managing worksheets and workbooks
• Navigating worksheets and workbooks
• Formatting worksheets and workbooks
• Customisation option and views
• Configuring content for collaboration
• Lesson review and quiz
• Assignment 1 – worksheet and workbook exercises

Unit 2 Managing data cells and ranges

• Introduction
• Manipulating data in worksheets
• Formatting cells and ranges
• Summarising data visually
• Applying formulas
• Lesson review and quiz
• Assignment 2 – data cell and range exercises

Unit 3 Managing tables and table data

• Introduction
• Creating and formatting tables
• Modifying tables
• Filtering and sorting table data
• Introducing pivot tables and charts
• Lesson review and quiz
• Assignment 3 – table exercises

Unit 4 Perform operations using functions

• Introduction
• Inserting references
• Calculating and transforming data
• Using conditional logic In functions
• Formatting and modifying text with functions
• Introducing maths functions
• Introducing date and time functions
• Lesson review and quiz
• Assignment 4 – function exercises

Unit 5 Managing charts and objects

• Introduction
• Creating and modifying charts
• Formatting charts
• Working with objects
• Lesson review and quiz
• Assignment 5 – charts and object exercises
• The MOS examination explained