MOS EXCEL 2016 ESSENTIALS ONLINE COURSE

The MOS Excel 2016 Essentials Online Course consists of the following modules:

Lesson 1 - Worksheets & Workbooks

• Introduction;
• The Excel 2016 Application;
• Managing Worksheets & Workbooks;
• Navigating Worksheets & Workbooks;
• Formatting Worksheets & Workbooks;
• Customisation Options;
• Configuration Options;
• Lesson Review & Quiz;
• Assignment 1 - Worksheet & Workbook Exercises.

Lesson 2 - Managing Cells & Ranges

• Introduction;
• Inserting Data;
• Formatting Data;
• Ordering & Grouping;
• Applying Formulas;
• Lesson Review & Quiz;
• Assignment 2 - Cell & Range Exercises.

Lesson 3 - Managing Tables

• Introduction;
• Creating Tables;
• Modifying A Table;
• Filter & Sort A Table;
• Pivot Tables & Charts;
• Lesson Review & Quiz;
• Assignment 3 - Table Exercises.

Lesson 4 - Excel Functions

• Introduction;
• Summarise Data With Functions;
• Use Conditional Logic In Functions;
• Format & Modify Text With Functions;
• Useful Maths Functions;
• Date & Time Functions;
• Lesson Review & Quiz;
• Assignment 4 - Function Exercises.

Lesson 5 - Inserting Charts & Objects

• Introduction;
• Creating A Chart;
• Formatting A Chart;
• Working With Objects;
• Lesson Review & Quiz;
• Assignment 5 - Charts & Object Exercises;
• The MOS Examination Explained.

Assessment:

You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, create and edit spreadsheet files. Your work can be sent back to your course tutor by email.