Explore

NEW! EXCEL 2016: Excel from beginner to professional

3 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Learn Excel 2016 and the most important and popular functions. Learn to use Excel like a pro with this Excel Course

Description

By Completing this course, you will receive a verifiable Certificate of Completion.

This course has cut down on the fluff and empty space to keep it shorter, but still cover a wide range of topics. Designed for people starting out with Excel, it also covers some of the more complicated and important areas like Pivot Tables.

This Excel course is recorded completely using Excel 2016, the latest version of Excel offered in the Microsoft Office 2016 suite.

Some of the topics include (but not limited to)

Creating your first workbook
Referencing from other sheets within a book
Quick Charts
Quick Sorting
Flash Fill
Named Ranges
Excel Sheet Management (moving, colouring, creating)
Creating 3D maps using address data in a list
Popular Excel Functions like SumIf, VLookUp, Left, Right, Mid, Len and more
Power Excel functionality like nested formulas
Using slicers to quickly sort and make spreadsheets look good
A complete set of Pivot Table videos

I aim to add 4 new lectures every month to the course, and would love to have your feedback. So once you have signed up and completed the training, let me know what you would like to learn next!

Requirements

Requirements
You will need to have a copy of Excel 2010 / 2013 or 2016. 2016 is recommended, but a lot of this is backwards compatible

Recommended for you

The Project Management Course: Beginner to PROject Manager

The Complete Course for becoming a Successful Project Manager Project Management is an exciting profession. This online course is unique, as it combines all critical lessons a PM should learn:...

Save Course

[2021] Tableau 2020: A-Z Hands-on Tableau For Data Science

Learn Tableau 2020 step by step from Basic to Advance: Data Visualization through Chat, Graphs and Maps | 4,00,000+ Do you want to have hands-on knowledge in Tableau?...

Save Course