Excel 2016 Advanced Level Training | Video Tutorials

Course details

Excel 2016 Advanced Training Course

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

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

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

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

The next chapter shows you how to import text files intoExcel.

The next chapters guide you through Sorting and FilteringData 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 & SecurityIssues