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.
Description
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…
Assessment
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.
Certification
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
No Reviews found for this course.