Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 27 Minute(s)
Language
English
Taught by
David Murray
Rating
1 views
Course Overview
Become an Excel 2016 expert
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
Course Content
- 10 section(s)
- 17 lecture(s)
- Section 1 Introduction
- Section 2 e-Book and sample files
- Section 3 Excel 2016 Advanced - Pivot Tables
- Section 4 Excel 2016 Advanced - Input Tables
- Section 5 Excel 2016 Advanced - Charts
- Section 6 Excel 2016 Advanced - Hyperlinks
- Section 7 Excel 2016 Advanced - Importing Text
- Section 8 Excel 2016 Advanced - Sorting Data
- Section 9 Excel 2016 Advanced - Filtering Data
- Section 10 Excel 2016 Advanced - Subtotalling Data
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
Skills covered in this course
Reviews
-
IIdris Thomas
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.
-
SSherry Breitkreutz
David is easy to follow and explains very well.
-
AAndrew Tran
GOOD COURSE
-
IIslandlake01@Comcast.Net
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.
