VTC Legacy
Home / Business Applications

Microsoft Excel Automation

by Lauri Sowa
71 lessons30 chapters5 hReleased 20092 free
Start the free chapter

VTC's Microsoft Excel Automation course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and productivity. Students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this course will help students master the art of spreadsheet design and will provide comprehensive instruction in the automation and simplification of even the most complex data. Expanding upon our basic Excel courses, Lauri Matson explores the more advanced features of Excel such as VLookup functions, validation, pivot tables, analysis tools, charting, and more. To begin learning Excel Automation today, simply click on the movie links.

Course content

Introduction2 lessons
Time Saving Techniques2 lessons
Validation & Protection3 lessons
Named Ranges3 lessons
Security2 lessons
Introduction to Macros3 lessons
Macros2 lessons
Practice with Macros3 lessons
Understanding Macro Code2 lessons
Buttons vs. Command Buttons2 lessons
The VBA Screen2 lessons
Creating a Routine3 lessons
Adding Controls2 lessons
Designing a Pop-Up Calendar2 lessons
Writing Code2 lessons
Formulas & Functions2 lessons
Three Dimensional Formulas2 lessons
Popular Functions4 lessons
VBA & Functions2 lessons
Using an Add-In3 lessons
Pivot Tables3 lessons
Automating Pivot Tables2 lessons
Advanced Charts & Graphs3 lessons
Automating Charts & Graphs2 lessons
Pivots & Charts in Legacy Versions2 lessons
Working with Other Programs2 lessons
Importing/Exporting Data2 lessons
Analysis Tools3 lessons
Looking for Help2 lessons
Wrap Up2 lessons