Video training course for the Microsoft 77-420 Office Specialist exam. The MOS exams are a must-have for any desktop support technician or if you regularly use Excel and want to sharpen your skills.
By the end of the course you will be able to:
- Create and Manage Worksheets and Workbooks
- Create Cells and Ranges
- Create Tables
- Apply Formulas and Functions
- Create Charts and Objects
The exam is entirely practical in nature so instead of exams we use case studies throughout the course to prepare you. The exam is very hard so please don’t take it lightly!
Your Instructor
Lawrence ‘Toby’ Rose
Is a graduate of the University of London, and has a background in project management, software development and user training. He is a Microsoft Certified Professional with extensive experience across the whole of the Microsoft Office product set and with many Adobe products.
Lawrence has worked in several countries and is a keen traveler.
Module 1 | Create and Manage Worksheets and Workbooks |
---|---|
Unit 1 | Introduction |
Unit 2 | Create Worksheets and Workbooks |
Unit 3 | Create Worksheets and Workbooks 2 |
Unit 4 | Navigate through Worksheets and Workbooks |
Unit 5 | Navigate through Worksheets and Workbooks 2 |
Unit 6 | Format Worksheets and Workbooks |
Unit 7 | Format Worksheets and Workbooks 2 |
Unit 8 | Format Worksheets and Workbooks 3 |
Unit 9 | Format Worksheets and Workbooks 4 |
Unit 10 | Format Worksheets and Workbooks 5 |
Unit 11 | Format Worksheets and Workbooks 6 |
Unit 12 | Format Worksheets and Workbooks 7 |
Unit 13 | Customize Options and Views for Worksheets and Workbooks |
Unit 14 | Customize Options and Views for Worksheets and Workbooks 2 |
Unit 15 | Customize Options and Views for Worksheets and Workbooks 3 |
Unit 16 | Customize Options and Views for Worksheets and Workbooks 4 |
Unit 17 | Customize Options and Views for Worksheets and Workbooks 5 |
Unit 18 | Configure Worksheets and Workbooks to Print or Save |
Unit 19 | Configure Worksheets and Workbooks to Print or Save 2 |
Module 2 | Create Cells and Ranges |
Unit 1 | Insert Data in Cells and Ranges |
Unit 2 | Insert Data in Cells and Ranges 2 |
Unit 3 | Insert Data in Cells and Ranges 3 |
Unit 4 | Format Cells and Ranges |
Unit 5 | Format Cells and Ranges 2 |
Unit 6 | Format Cells and Ranges 3 |
Unit 7 | Format Cells and Ranges 4 |
Unit 8 | Order and Group Cells and Ranges |
Unit 9 | Order and Group Cells and Ranges 2 |
Unit 10 | Order and Group Cells and Ranges 3 |
Unit 11 | Order and Group Cells and Ranges 4 |
Module 3 | Create Tables |
Unit 1 | Create a Table |
Unit 2 | Modify a Table |
Unit 3 | Filter and Sort a Table |
Module 4 | Apply Formulas and Functions |
Unit 1 | Utilize Cell Ranges and References in Formulas and Functions |
Unit 2 | Summarize Data with Functions |
Unit 3 | Utilize Conditional Logic in Functions |
Unit 4 | Format and Modify Text with Functions |
Module 5 | Create Charts and Objects |
Unit 1 | Create a Chart |
Unit 2 | Format a Chart |
Unit 3 | Insert and Format an Object |
Unit 4 | Insert and Format an Object 2 |
Module 6 | Case Study 3 |
Unit 1 | Introduction |
Unit 2 | Part 1 |
Unit 3 | Part 2 |
Unit 4 | Part 3 |
Unit 5 | Part 4 |
Unit 6 | Part 5 |
Module 7 | Case Study 4 |
Unit 1 | Introduction |
Unit 2 | Part 1 |
Unit 3 | Part 2 |
Unit 4 | Part 3 |
Unit 5 | Part 4 |
Unit 6 | Part 5 |
Module 8 | Case Study 5 |
Unit 1 | Introduction |
Unit 2 | Part 1 |
Unit 3 | Part 2 |
Unit 4 | Part 3 |
Unit 5 | Part 4 |
Unit 6 | Part 5 |
Unit 7 | Part 6 |