Booking options
£25
£25
On-Demand course
All levels
Become an Excel expert in a matter of hours and manage everyday office tasks faster and more efficiently with Mastering MS Excel. This course is ideal for experts in administrative and IT-based roles who want to improve their proficiency in Microsoft Office.
Throughout this Microsoft Excel training course, you will develop valuable administrative skills which will assist you in automating everyday work tasks, collaborating on spreadsheets, and data management. Taking you from beginner to advanced levels, you will learn how to create a basic spreadsheet, perform a financial analysis, insert tables, record macros and much more.
On successful completion, you will have a solid knowledge of how to utilise the world’s leading spreadsheet program for business administration and master basic and complex work tasks.
Learning Outcomes of The Mastering MS Excel
Master the functions and features of the world’s leading spreadsheet program
Develop fundamental career-boosting skills in office administration
Learn how to automate tasks and collaborate on worksheets
Go from a beginner to an expert in Excel in a matter of hours
Get step-by-step training on how to calculate sums, totals and averages
Understand how to create different types of graphs and charts
Learn how to record macros to automate everyday administrative tasks
Get to grips with intermediate Excel functions including VLOOKUP, COUNTIF and AVERAGIF
Be trained on how to create a custom autofill for your data & save time for other tasks
Why choose this course
Earn an e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
Online study materials
Mock exams
Multiple-choice assessment
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.
CPD Certificate of Achievement from Janets
Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
To ensure the Quality Licensing Scheme is endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on their performance. After passing the assessment, one can apply for a certificate.
Course Contents
Getting Started with Microsoft Office Excel 2016
Performing Calculations
Modifying a Worksheet
Formatting a Worksheet
Printing Workbooks
Managing Workbooks
Working with Functions
Working with Lists
Analyzing Data
Visualizing Data with Charts
Using PivotTables and PivotCharts
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