Microsoft Excel 2016

Is the Microsoft Excel 2016 course suitable for me?

Consider studying the Microsoft Excel training course if:

•  You are self-employed or own a small business.
•  Work in Finance.
•  Use Excel regularly and want to improve skills.

Once completed, you will acquire all the necessary skills to complete this course.

How will the Microsoft Excel 2016 course benefit me? 

Students will be able to enhance their Microsoft Excel knowledge which can be used in all work environments where the software is used.

Your advanced knowledge of the software plus qualification will help with career progression.

Are you a business owner or manager and want to improve your employees’ skillset? This course is perfect to improve your employees to increase efficiency. Small businesses or self-employed individuals will greatly benefit from enhancing their knowledge of Excel that can help track their finances. You will increase your choice of career progression. If you are looking to fully complete the MOS Office Specialist qualification in all programmes, this would be a great starting point.

View our other Microsoft training courses.

What jobs can I apply for after my Microsoft Excel 2016 training? 

Microsoft training is excellent for a wide range of careers, with Excel suiting most jobs and industries.

If you are working towards a career in Finance, Bookkeeping, or Accounting, consider our range of AAT Accounting qualifications.

View our other Microsoft training courses.

Why choose to study the Microsoft Excel 2016 course with e-Careers?

We have developed an expert team over the last 10 years since our inception. In that time, we have trained over 590,000 delegates globally, which has helped offer the highest quality training, and we have earned a 5-star rating on Trustpilot, from over 9,000 students. 

By refining our processes, partner relationships, and course materials, we can offer high-quality training solutions for our delegates. 

Microsoft Excel 2016 Syllabus

MS Excel 2016: Introduction

•  Follow 34 lessons with approx. 17 study hours
•  Familiarise yourself with MS Excel 2016, its documents and controls
•  Learn to create tables step by step
•  Find out how to enter values correctly into the cells
•  Learn how to set up cell formatting, including conditional formatting
•  Study the manipulation of each cell and cell range
•  Learn to work with worksheets and entire files
•  Discover how to create a chart
•  Learn to create calculations using basic arithmetic formulas

MS Excel 2016: Intermediate

•  Follow 35 lessons with approx. 18 study hours
•  Follow interactive lessons focused mainly on performing calculations
•  Broaden your basic knowledge by the application of logical and text functions
•  Understand the principles of referencing to the values in other cells
•  Learn to fill cells with a series of data
•  Familiarise yourself with the advanced options of sorting and filtering data
•  Study searching for specific values in extensive tables
•  Examine how to split longer text entries in tables into individual data placed into several columns

MS Excel 2016: Advanced

•  Follow 29 lessons with approx. 15 study hours
•  Focus on the creation of charts and automation of the work in the program using macros
•  Examine the insertion of various graphical elements into worksheets i.e., shapes or SmartArt graphics
•  Learn to prepare a table or entire worksheet before printing
•  Familiarise yourself with the options of protecting and sharing the workbook content
•  Look at the usage of macros, including their creation, editing, and the options of macro security
•  What does the MS Excel 2016 course cover?
•  This official Microsoft exam could include questions based on the following topics:
•  Creation of worksheets and workbooks 
•  Navigating around worksheets and workbooks
•  Formatting topics 
•  Different customisation and view options
•  Configuration of worksheets and workbooks
•  Managing data cells and ranges
•  Formatting cells and organising data 
•  Creating tables  
•  Performing tasks using formulas and functions 
•  Creating charts and objects.