Your cart is empty.
Keep shoppingExcel 2016 Advanced Level Training | Video Tutorials
4,100 students
Excel 2016 Advanced Level Training | Video Tutorials
Become an Excel 2016 expert
Created byDavid Murray
Last updated 7/2016
English
English [Auto],
What you'll 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
Explore related topics
Course content
17 sections • 17 lectures • 1h 27m total length
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 this course is for:
- 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.