Excel 2016 Advanced Level Training | Video Tutorials

Become an Excel 2016 expert

4.60 (56 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

How to use Pivot Tables, Input Tables and Charts. How to use Hyperlinks, Linking & Embedding. How to import Text Files and how to Sort and Filter Data. How to Track and Review changes. How to use Scenarios, Validation and Auditing techniques. Finally how to create recorded Macros and also learn about passwords & security issues

Why take this course?

Excel 2016 Advanced Training Course

This course is aimed at people with a good working knowledge of Excel, 2016 or people who have worked through the Foundation and Intermediate level Excel 2016 training courses.

The course starts by looking at Pivot Tables and then Input Tables.

We then move on to see how to make the most of Charts within Excel 2016.

Next we look at items such as Hyperlinks and then Linking & Embedding

The next chapter shows you how to import text files into Excel.

The next chapters guide you through Sorting and Filtering Data and then we look at Tracking and Reviewing Changes

Then use see the power of the Scenario Manager

Next it all about validating and auditing data.

Finally we look at Macros plus Passwords & Security Issues

Screenshots

Excel 2016 Advanced Level Training | Video Tutorials - Screenshot_01

Excel 2016 Advanced Level Training | Video Tutorials - Screenshot_02

Excel 2016 Advanced Level Training | Video Tutorials - Screenshot_03

Excel 2016 Advanced Level Training | Video Tutorials - Screenshot_04

Reviews

Idris

June 4, 2020

Thanks David. I learned so much. Very clear instruction. A super-advanced, deity-level course would be great. Things like, importing data, database functions, setting up macro procedure buttons - anything quirky but really useful to know.

Islandlake01@Comcast.Net

June 23, 2018

It is good for beginners and intermediate, but for Certified expect level with experience is only a refresher course, otherwise the presentation is ok. The title should read Intermediate, and not Advanced, otherwise it is misleading.

Bobbie

November 4, 2017

This is a great course as expected. I have learned a ton from all of Mr. Murray's courses. Thank you.

Osama

August 27, 2017

This is really a good course. But naming this course as advanced level is a bit doubtful. That's why 3.5.

Sarath

May 9, 2017

Appropriate for an intermediate level user; might even be a useful refresher. Not something I would describe as an advanced level of excel.

SHawn

January 17, 2017

This training is marked as advanced. i have never felt i was advanced and almost everything was a refresher versus and learning experience. Good training overall but the title was misleading to me and not worth the money.

Charts

Price

Rating

Enrollment distribution

Excel 2016 Advanced Level Training | Video Tutorials - Distribution chart