CBT IT Certification Training

Unlimited IT Certification Courses via Streaming Video

MOS – Microsoft Office Excel 2013

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!

LawrenceR
SUBSCRIBE NOW

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.

  • Over 12  hours of video training
  • Instructor set case studies
  • End-of-course certificate
  • Captions available
  • Access to members only forum
  • Exam vendor – Certiport or Prometric
  • Prerequisites – None
  • Recommended – A+
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