NEW! EXCEL 2016: Excel from beginner to professional

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

4.20 (50 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

Use Excel in a professional environment

Create and manage complicated spreadsheets

Manage constantly changing data

Understand what Excel is and how it really works

Create a 3D heat map to plot sales geographically

Set up and manage Excel Pivot Tables

Why take this course?

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!

Screenshots

NEW! EXCEL 2016: Excel from beginner to professional - Screenshot_01

NEW! EXCEL 2016: Excel from beginner to professional - Screenshot_02

NEW! EXCEL 2016: Excel from beginner to professional - Screenshot_03

NEW! EXCEL 2016: Excel from beginner to professional - Screenshot_04

Reviews

Katrina

April 5, 2017

The course is fun and informative! I feel more and more capable as we go along. I like that the classes are short and that I am able to log out after each course and practice what I am learning. I am enjoying the options to play back 15 seconds if I need to. Also it has been super helpful to be able to pause the class, go to my example spreadsheet and practice what I am learning. If I lose my way around classes by going in and out, it's easy for me to locate the class I am currently taking and get back to learning.

Christy

October 13, 2016

Might be a little too advanced for the extreme novice. Perhaps demonstrate all of the features in the ribbon? Add as optional video. For me, an advanced beginner, it was great, and I learned a few new tricks.

Collins

June 1, 2016

Gradual build up of excel fundamentals ......Ideal progression Downside.... Absolutely no regards for student progression. No attempt to respond or even acknowledge receipt of queries. Sad...

Palmira

May 25, 2016

Clearly and simply explained. Short lessons that can be easily fitted during office hours and that facilitate learning at your own pace, great!

Charts

Price

Rating

Enrollment distribution

NEW! EXCEL 2016: Excel from beginner to professional - Distribution chart