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.
Command Reference (2003 - 2007)
Creating a List with Validation
Tools Menu vs. Developer Toolbar
Absolute vs. Relative Reference
Creating a Template for Headers/Footers
Formulas from Other Worksheets
Tips for Working with V-Lookup
Creating an Add-In for a Custom
Using a Function with Goal Seek
Creating Pivots in Earlier Versions
Charts & Graphs in Prior Versions
Understanding the Add-In Tools
The Microsoft Interactive Tool
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.