VTC Legacy
Home / Project Management

Advanced Excel 2016

by Lauri Sowa
77 lessons18 chapters7.3 hReleased 201612 free
Start the free chapter

Microsoft Excel is one of the most popular programs to use for analyzing and visualizing the tremendous amounts of data that we have collected.rnrnLearn how Microsoft Excel can manage and summarize your data. Explore the features and wizards of Excel, learning how to master the new graphic and visualization tools to place you on the leading edge of new design. Master data manipulation with PowerPivot and Pivot Tables, learn how to increase productivity with automation, macros and VBA.rnrnThis course goes well beyond the basics to help you get the most out of Microsoft Excel. It concentrates on proven concepts and includes an array of work files so you can follow along and master the techniques.rnrnUnleash the power of Excel to make accurate decisions based on your data, Excel's abundant features, and the power of visualization.rnrn

Course content

Introduction4 lessons
The New Look of Spreadsheets4 lessons
Visualizing Worksheets4 lessons
Manipulating Data4 lessons
Adding Special Effects4 lessons
Validation and Protection5 lessons
Manipulating Data5 lessons
Cell References5 lessons
Advance Formulas & Functions5 lessons
Tables and Scenarios5 lessons
Creating Dashboard4 lessons
Charts and Graphics5 lessons
Creating a Specialty Chart3 lessons
Working with Pivot Tables5 lessons
Understanding Power Pivot3 lessons
Automation & Macros5 lessons
The VBA Screen5 lessons
Conclusion2 lessons