Excel 2016 Expert
Course
Online
Perfect your knowledge of Excel!
-
Type
Course
-
Methodology
Online
-
Class hours
120h
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
Now you can acquire advanced knowledge of Excel thanks to this course that Emagister added to its catalog.
The Excel 2016 online expert course is designed to cover the advanced features of Microsoft Excel, for students who have already completed the Excel Essentials course, or who have extensive knowledge of the Excel software package. The course follows the expert program of Microsoft Office Specialist (MOS) and is the perfect study guide for those who want to obtain the MOS Expert certification recognized in the industry.
The Excel 2016 Expert course is presented in an updated online multimedia format, with the constant support and guidance of your tutor of the designated course, which is available to you at each step of the course of the program. You will be evaluated in the tasks that are detailed in the course materials. These assignments will require you to do work, create and edit spreadsheet files. Your work can be sent to your course tutor by email.
The course contains valuable tips to prepare for the MOS exam and includes free access to the number of GMetrix MOS practice practice questions, which have the same format as the MOS exam itself.
If you are interested in knowing more details about this course, do not hesitate to contact us and request more information in Emagister.
Facilities
Location
Start date
Start date
About this course
Students should have completed the Excel 2016 Essentials Course or covered all of the subjects taught within the Excel Essentials syllabus.
Please Note: The course covers the use of Microsoft Excel 2016 which is a PC version of the software. It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office which will differ from Mac versions.
On successful completion of this course students will receive our Excel 2016 Expert Certificate of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist Excel 2016 Expert 77-728 Exam.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- Options
- MS Excel
- Workbooks
- Settings
- Objects
- Advanced Charts
- Time functions
- Advanced Conditional Formatting
- Internationalisation
- Managing Pivot Tables
- Troubleshooting Formulas
- Workbook Options
- Protect Workbooks
- Applying Custom Data
- Pplying Advanced Date
- Creating Pivot Tables
- Defining Named Ranges
- He MOS Examination
- Restrict Editing
- Formula Options
- Workbook Elements
Course programme
Lesson 1 - Manage Workbook Options & Settings
- Introduction;
- Managing Workbooks;
- Restrict Editing & Protect Workbooks;
- Version Control & Formula Options;
- Lesson Review & Quiz;
- Assignment 1 - Workbook Options & Settings Exercises.
Lesson 2 - Apply Custom Data Formats & Layouts
- Introduction;
- Applying Custom Data Formats & Validation;
- Advanced Conditional Formatting & Filtering;
- Creating & Modifying Custom Workbook Elements;
- Preparing A Workbook For Internationalisation;
- Lesson Review & Quiz;
- Assignment 2 - Custom Data Formatting Exercises.
Lesson 3 - Creating Advanced Formulas
- Introduction;
- Applying Functions in Formulas;
- Lookup Data Using Functions;
- Applying Advanced Date & Time Functions;
- Importing & Analysing External Data;
- Business Intelligence Features;
- Troubleshooting Formulas;
- Defining Named Ranges & Objects;
- Lesson Review & Quiz;
- Assignment 3 - Advanced Formula Exercises.
Lesson 4 - Creating Advanced Charts & Tables
- Introduction;
- Creating Advanced Charts;
- Creating Pivot Tables;
- Managing Pivot Tables;
- Create & Managing Pivot Charts;
- Lesson Review & Quiz;
- Assignment 4 - Advanced Table & Chart Exercises;
- The MOS Examination.
Excel 2016 Expert