Booking options
£9.99
£9.99
On-Demand course
4 weeks
All levels
Learning Outcomes
Familiarise yourself with the basic to advanced level excel tools
Learn the process of managing and modifying Workbooks
Enrich your knowledge of Pivot Tables and Pivot Charts
Develop your skills in data analysis
Learn about lookup functions and formula editing
Grasp the principles of data mapping and forecasting
Microsoft Office 2016 Excel Beginner to Advanced Course Description
At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time.
In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping.
At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now!
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.
CPD Accredited Certificate
After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.
Method of Assessment
At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately.
Career path
This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as
Data Analyst
Receptionist
Office Admin
Data entry Officer
Course Contents
Microsoft Excel Beginners
Getting Started with Microsoft Office Excel 2016
Performing Calculations
Modifying a Worksheet
Formatting a Worksheet
Printing Workbooks
Managing Workbooks
Microsoft Excel Intermediate
Working with Functions
Working with Lists
Analyzing Data
Visualizing Data with Charts
Using PivotTables and PivotCharts
Microsoft Excel Advanced
Working with Multiple Worksheets and Workbooks
Using Lookup Functions and Formula Auditing
Sharing and Protecting Workbooks
Automating Workbook Functionality
Creating Sparklines and Mapping Data
Forecasting Data
Resources