• No products in the cart.

Complete Microsoft Excel 2016 Diploma - Beginner, Intermediate & Advanced

4.7( 8 REVIEWS )

Gain a complete mastery of spreadsheets with this online Microsoft Excel course, with every function of the industry-standard software covered through bitesize video tutorials. Enhance your CV and gain proof of your expertise with a professional qualification covering everything from creating workbooks to advanced features such as designing formulas, implementing macros, link data across different sheets and running detailed data analysis reports.


Certified by CPD Qualifications Standards and CiQ, this online distance learning course will give you a complete understanding of Microsoft Excel. Starting with basic spreadsheet skills before working through intermediary and then advanced workbook techniques, you benefit from video lessons which give real-world examples of how to apply your new knowledge. Upon successful completion, you will qualify for a professional certification as evidence of your skills.

Benefits of studying the Complete Microsoft Excel 2016 Diploma – Beginner, Intermediate & Advanced with Victoria Education include:

  • Easy-to-understand course materials designed by industry experts, accessible through your smartphone, laptop, desktop or tablet device
  • No hidden fees or costs — study a professional course and earn a professional e-certificate upon successful completion
  • Get instant feedback from automated assessments and mock exams to gauge your progress
  • No formal deadlines or teaching schedule, meaning you can learn at your own pace
  • 24/7 help and support from your online tutors, through email and via our live online chat
  • Qualify for an NUS Extra card and gain access to over 200 fantastic deals from high street brands and one free year of ISIC unlocking over 42,000 international discounts

How is this qualification is delivered?

Our courses are taught entirely online, meaning you can access the materials wherever, whenever, at a pace that suits you, without formal deadlines or teaching schedules.

The courses are delivered through

  • Video lessons
  • Mock exams
  • Online assessment

These can be accessed through any device with an internet connection. Our e-learning platform is optimised for use on mobile, tablet, laptops and desktop computers.

Mandatory units

The Complete Microsoft Excel 2016 Diploma – Beginner, Intermediate & Advanced consists of 17 mandatory modules, covering

  • Identifying the elements of the Excel interface
  • Developing formulas and inserting functions
  • Using subtotal and database functions to calculate data
  • Creating sparklines and mapping data
  • Determining potential outcomes using data tables
  • And more…


The assessment at the end of each course is a multiple-choice exam taken through our online platform. The system is fully automated so you will receive your results instantly upon completion.


Upon successful completion you will qualify for the UK and internationally-recognised professional qualification. You can order a PDF Certificate for £12.

Who is this course for?

Our Complete Microsoft Excel 2016 Diploma – Beginner, Intermediate & Advanced is aimed at anyone wishing to start working in a range of business and administration roles, or existing professionals wishing to boost their skills and employability.

Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT.

Career path

Studying this would benefit a range of careers, but would specifically boost employability in roles including

  • Payroll
  • Accounting
  • Finance
  • Business administration
  • Budgeting
  • Office administration
  • Other professional roles in IT or accounting and finance

Course Curriculum

Essentials of Mirosoft Excel 2016
Getting around the Excel Interface 00:28:00
Essentials: Commands 00:10:00
Basics: Create and Save 00:19:00
F1: Help function 00:12:00
Basics: Input Data 00:05:00
How to perform calculations
Essentials: Formulas 00:15:00
Essentials: Functions 00:17:00
Repeat the Formula or Function 00:17:00
How to amend a worksheet
Essentials: Insert, Delete, Adjust 00:10:00
Essentials: Search Function 00:09:00
Essentials: Proof Functions 00:07:00
How to format a worksheet
Essentials: Format for text 00:17:00
Essentials Format for numbers 00:08:00
Adjusting Contents 00:09:00
Essentials: Styles 00:12:00
Essentials: Conditional Formatting 00:11:00
Template Developer 00:07:00
Printing the entire workbook
Essentials: Print 00:10:00
Essentials: Page Layout 00:08:00
Essentials: Headers and Footers 00:07:00
Managing entire workbooks
Worksheet Management 00:05:00
Workbook and Worksheet Viewer 00:07:00
Essentials: Adjusting the settings of Workbook 00:05:00
Managing functions
Essentials: Ranges Function 00:18:00
Essentials: Specialized Functions 00:11:00
Logical Functions 00:23:00
Do you know the Date & Time functions? 00:08:00
Text Function Essentials 00:11:00
Managing lists
Data Sorting 00:10:00
Data Filtering 00:10:00
Essentials Query 00:09:00
Data Review 00:09:00
Data analysis
Table Creation 00:15:00
Intermediate Level: Conditional Formatting 00:07:00
Advanced Level: Conditional Fotmatting 00:05:00
Envisaging Data with Chart tools.
Chart Creation 00:13:00
Modification of Charts 00:12:00
AdvancedL Charts 00:12:00
Essentials of PivotTables and PivotCharts
PivotTable Essentials 00:13:00
Analysis of Data 00:12:00
Showing off your findings 00:07:00
Slicer and Timelines Tools 00:11:00
Management of several worksheets and workbooks
Connections to external source 00:12:00
Graphic References 00:06:00
Check Data 00:05:00
Utiising advanced functions: Lookup and formula auditing
Essentials: Lookup 00:12:00
Essentials: Tracing of cells 00:09:00
Review Formulas 00:08:00
How to share and protect workbooks
Share your workbook 00:19:00
Data Protection 00:08:00
Managing the automation of workbooks
Regulate the Data 00:13:00
Error Checking 00:04:00
Essentials Macros 00:18:00
Utilising advanced functions: Sparklines and Data Mapping
Sparklines Essentials 00:07:00
MapData 00:07:00
Estimation of Data
Predicting results with Data Tables 00:08:00
Predicting results with Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Essentials Goal Seek 00:05:00
Mock Exam
Final Exam

Course Reviews


8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • £379.00 £45.00
  • 1 year
  • , ,
  • Course Badge
  • Course Certificate
  • Number of Units59
  • Number of Quizzes0
  • 10 hours, 25 minutes


© Victoria Education Ltd.