Microsoft Excel 2016 (Online Course)

Microsoft Excel 2016 (Online Course)

  • R 950.00


Course Details

Microsoft Office Excel Course

Overview:
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 

      Benefits

      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

        Prerequisites

        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
          Conclusion

           

          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.