Excel 2016 Advanced Level Training | Video Tutorials
4.0 (30 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,330 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Advanced Level Training | Video Tutorials to your Wishlist.

Add to Wishlist

Excel 2016 Advanced Level Training | Video Tutorials

Become an Excel 2016 expert
4.0 (30 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,330 students enrolled
Created by Mr David Murray
Last updated 7/2016
English
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You will need a PC with Microsoft Windows and Excel 2016 installed on it. Remember that this is a foundation course for people new to Excel 2016
Description

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

 

Who is the target audience?
  • This is the third of three Excel 2016 training courses and builds on the materials covered in the first two levels. This advanced Excel tutorial is designed for people with solid previous Excel experience or people who have completed the other courses in this series.
Curriculum For This Course
17 Lectures
01:27:44
+
Introduction
1 Lecture 02:13
+
e-Book and sample files
1 Lecture 00:21
251-page e-Book edition of this course, plus sample files
00:21
+
Excel 2016 Advanced - Pivot Tables
1 Lecture 06:11
+
Excel 2016 Advanced - Input Tables
1 Lecture 03:22
Input Tables
03:22
+
Excel 2016 Advanced - Charts
1 Lecture 09:02
+
Excel 2016 Advanced - Hyperlinks
1 Lecture 02:25
Hyperlinks
02:25
+
Excel 2016 Advanced - Importing Text
1 Lecture 06:26
Importing Text
06:26
+
Excel 2016 Advanced - Sorting Data
1 Lecture 06:09
+
Excel 2016 Advanced - Filtering Data
1 Lecture 06:29
Filtering Data
06:29
+
Excel 2016 Advanced - Subtotalling Data
1 Lecture 03:19
Subtotalling Data
03:19
7 More Sections
About the Instructor
Mr David Murray
4.3 Average rating
1,471 Reviews
52,611 Students
9 Courses
20 years SEO Experience | Almost 50,000 Students

David Murray | An SEO (Search Engine Optimization)  training expert with over 20 years’ experience delivering training courses all over Europe from Dublin to Moscow.  First website went live in April 1996 and I have never needed any salespeople or advertising, I just use organic SEO to get sales. Lean how to do SEO the right way and promote your website within Google.