Microsoft Office 2016 Excel Beginner to Advanced

Description

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