Microsoft Excel 2016 (Online Course)

Microsoft Excel 2016 (Online Course)

  • R 950.00

Course Details

Microsoft Office Excel Course

This course covers all the content of Microsoft Office Excel 2016 needed to become internationally certified. This three-day course is designed to prepare you for everything you will need to know in order to write an official Microsoft Office Specialist (MOS) certification, and to be able to set yourself up for success in your work environment.

How does the training work?
You will need to commit to 3 full days worth of training. This can be spread across a few days by doing a few hours a day of can be fully completed ​in 3 full days (18h).
Course Objectives:
  1. Master everything you need to know about Microsoft Excel.
  2. Reach the top professional level of Microsoft Excel with no need for prior knowledge of the application.

    All you need to pass your Excel 2016 Microsoft Office Specialist (MOS) certification exam.

      Benefits & Prerequisites 


      1. Gain the skills and confidence required to successfully obtain your Microsoft Office Excel 2016 certification
      2. Test prep questions that meet all Excel 2016 exam objectives
      3. View your online courseware anytime, anywhere


        1. Basic computer and English literacy.
        2. You have access to a computer and the internet of the following specs:
        • - Windows Vista, Windows 7, Windows 8, Windows 8.1, or Windows 10
        • - Full installation of Excel 2016 (not compatible with Office Mobile or Office Online)
        • - GMetrix SMS current version 6.1 installed
        • - High-speed Internet connection


          Course Outline

          Excel 2016 Course Outline

          Session 1: Excel 1
          ​Introduction to Excel 2016
          Create Worksheets and Workbooks
          Navigate in Worksheets and Workbooks
          Format Worksheets and Workbooks
          Customize Options and Views
          Prepare Files for Distribution

          Session 2: Excel 2
          Manage Data
          Format Cells and Ranges
          Summarize and Organize Data
          Domain 2 Recap

          Session 2: Excel 3
          Create Tables
          Manage Table Styles and Options
          Filter and Sort a Table

          Session 3: Excel 4
          Calculations with Formulas and Functions
          Use Conditional Functions
          Use Text Functions

          Session 3: Excel 5
          Create Charts and Objects
          Format Charts
          Insert and Format Objects
          Domain 5 Recap
          Test Taking Tips


          Delivery Details

          You will receive you're online coursed registration and login details via email. Once purchased you will receive your email in less than 24 working hours. You will have all the instructions required to begin practicing.