• No products in the basket.

What Will I Learn?

Custom Excel

Work with Range Names

Analyze Data with Common Lookup Functions

Analyze and Organize with Tables

Outline with Subtotals and Grouping

Work with Date and Time Functions

Link Workbooks and Worksheets

Analyze Data with Common Logical Functions

Sort and Filter Range Data

Use Conditional Formatting

Display Data Graphically

Work with Flash Fill

Work with Common Text Functions

Course Overview

You can increase your understanding of various tools in Excel 2016 by completing this Excel 2016 Intermediate course.

You will learn how to manage and view data in Excel. This skill will help you gain new career opportunities upon completion.

In this Excel 2016 Intermediate course, you will be able to confidently work with workbooks, worksheets and more. This course will teach you how to use specific features such as conditional formatting and graphs. Learn how to easily understand pivot tables, work with date and time functions by taking this course. You can also practice what you learn throughout the course.

Excel 2016 Intermediate is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector. 
This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Intermediate is packed with 76 modules and 4 hours, 3 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.
It doesn’t matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime. 
Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.



After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Introduction FREE 00:01:00
Customizing Excel
Customizing the Ribbon 00:06:00
Customizing the Quick Access Tool Bar 00:04:00
Customizing the General and Formula Options 00:02:00
Customzing the Auto Correct Options 00:04:00
Customizing the Save Default 00:02:00
Customizing Advanced Excel Options 00:03:00
Linking Workbooks and Worksheets
Linking Workbooks and Worksheets 00:05:00
Linking Worksheets with 3D References 00:03:00
Understanding the Consolidate Feature 00:05:00
Working with Range Names and Advanced Formulas
What are Range Names 00:03:00
Creating Range Names Using the Name Box and Define Name 00:07:00
Creating Range Names Using Create from Selection 00:03:00
Analyzing Data with Common Logical Functions
Working with the Most Common Logical Functions 00:03:00
Evaluate Data with the AND Function 00:03:00
Evaluate Data with the OR Function 00:03:00
Understanding IF Functions 00:04:00
Nesting AND and OR Inside and IF Function 00:06:00
Analyzing Data with Common Lookup Functions
What are Lookup Functions 00:02:00
Using VLookup 00:08:00
Using HLookup 00:02:00
Sorting and Filtering Range Data
Differences Between Sorting & Filtering 00:02:00
Sorting Lists 00:04:00
Filtering Lists 00:03:00
Analyzing and Organizing with Tables
Creation and Benefits of a Table 00:02:00
Elements of a Table 00:03:00
Formatting a Table 00:03:00
Sorting Tables 00:02:00
Filtering Tables 00:03:00
Filtering with Slicers 00:03:00
Calculating with Tables 00:04:00
Removing Erroneous Table Data 00:02:00
Exporting, Refreshing, Converting Tables 00:02:00
Using Conditional Formatting
What is Conditional Formatting 00:01:00
Conditional Formatting and Highlight Cells and Top Bottom Rules 00:04:00
Conditional Formatting Data Bars, Icon Sets, and Color Scales 00:04:00
Using Custom Fonts and Colors 00:02:00
Using Custom Conditional Formatting 00:03:00
Modify or Remove Conditional Formatting 00:02:00
Outlining with Subtotals and Grouping
What are Subtotals and Grouping 00:01:00
Creating Subtotals 00:03:00
Grouping and Ungrouping Data 00:02:00
Displaying Data Graphically
What are Charts 00:04:00
Creating Charts 00:04:00
Understanding Chart Elements 00:03:00
Modifying Chart Elements 00:07:00
Changing and Moving Charts 00:04:00
Filtering a Chart 00:02:00
Formatting Charts 00:07:00
Adjusting Numbering 00:03:00
Creating Dual Axis Charts 00:02:00
Forecasting with Trendlines 00:05:00
Creating a Chart Template 00:01:00
Displaying Trends with Sparklines 00:04:00
Understanding PivotTables and PivotCharts and Filtering with Slicers
What is a Pivot Table 00:04:00
Creating a Pivot Table 00:03:00
Working with the Pivot Table Fields Pane 00:07:00
Basic Data Organization and Analysis with Pivot Table 00:04:00
Formatting Pivot Tables 00:06:00
Creating a Pivot Chart 00:04:00
Modifying and Formatting a Pivot Chart 00:03:00
Adding Slicers and Timeline Slicers 00:03:00
Formatting Slicers 00:03:00
Working with Flash Fill
What is Flash Fill 00:01:00
Using Flash Fill and Autofill 00:03:00
Filling Various Series 00:04:00
Working with Date and Time Functions
What are Date and Time Functions- 00:02:00
Using TODAY, NOW, and DAY Functions 00:02:00
Using NETWORKDAYS and YEARFRAC Functions 00:02:00
Working with Common Text Functions
What are Text Functions 00:01:00
Using CONCATENATE 00:03:00
Using Text to Columns 00:02:00
Using LEFT, RIGHT, & MID Functions 00:02:00
Using UPPER, LOWER, & PROPER Functions 00:02:00
Course Recap 00:02:00
Resources – Excel 2016 Intermediate 00:00:00


Course Reviews


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

No Reviews found for this course.


  • 1 Coldbath Square, Farringdon, London, EC1R 5HL
  • 02037432362



Partnered with

Course Cloud is an online learning platform that provides one of the best e-learning experience. With a large variety of training courses to choose from, you are bound to find something to suit you.

© Copyright Course Cloud
Select your currency