Microsoft Excel 2016 (Online Course)
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.
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).
- Master everything you need to know about Microsoft Excel.
- 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
- Gain the skills and confidence required to successfully obtain your Microsoft Office Excel 2016 certification
- Test prep questions that meet all Excel 2016 exam objectives
- View your online courseware anytime, anywhere
- Basic computer and English literacy.
- 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
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
Format Cells and Ranges
Summarize and Organize Data
Domain 2 Recap
Session 2: Excel 3
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
Insert and Format Objects
Domain 5 Recap
Test Taking Tips
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.