United States Microsoft Excel Automation Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Excel Automation
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
Introduction
|
|||
| Course Objectives | (04:43) | T | |
| Command Reference (2003 - 2007) | (01:35) | T | |
|
Time Saving Techniques
|
|||
| Shortcuts & Quick Tips | (04:44) | T | |
| Auto Correct Options | (03:30) | T | |
|
Validation & Protection
|
|||
| Introducing Data Validation | (03:04) | T | |
| Creating a List with Validation | (02:16) | T | |
| Setting up Protection | (04:38) | T | |
|
Named Ranges
|
|||
| Defining a Name | (04:12) | ||
| Editing & Using Names | (02:58) | ||
| Name Manager | (04:11) | ||
|
Security
|
|||
| Adjusting Security Levels | (04:13) | ||
| Using Macro Extension | (04:18) | ||
|
Introduction to Macros
|
|||
| Tools Menu vs. Developer Toolbar | (02:49) | ||
| Storing Macros | (04:29) | ||
| Working with a Startup Folder | (03:40) | ||
|
Macros
|
|||
| Getting Started | (03:36) | ||
| Absolute vs. Relative Reference | (03:46) | ||
|
Practice with Macros
|
|||
| Creating a Routine | (03:29) | ||
| Automating Formats | (03:06) | ||
| Creating a Template for Headers/Footers | (03:13) | ||
|
Understanding Macro Code
|
|||
| Editing Macros with VBA | (04:06) | ||
| Introduction to Reading Code | (05:11) | ||
|
Buttons vs. Command Buttons
|
|||
| Creating a Button | (04:12) | ||
| Creating a Command Button | (05:44) | ||
|
The VBA Screen
|
|||
| The Explorer & Properties | (04:53) | ||
| Objects & User Forms | (05:46) | ||
|
Creating a Routine
|
|||
| Creating an Object pt. 1 | (03:04) | ||
| Creating an Object pt. 2 | (04:38) | ||
| Adding Code to an Object | (06:05) | ||
|
Adding Controls
|
|||
| Creating Dropdown Lists | (04:23) | ||
| Viewing the Code | (04:34) | ||
|
Designing a Pop-Up Calendar
|
|||
| Creating the Calendar Form | (05:13) | ||
| Writing the Code | (05:17) | ||
|
Writing Code
|
|||
| Coding with VBA | (03:37) | ||
| Examples | (05:14) | ||
|
Formulas & Functions
|
|||
| Formulas vs. Functions | (03:49) | ||
| Tips for Formulas | (04:47) | ||
|
Three Dimensional Formulas
|
|||
| Formulas from Other Worksheets | (03:48) | ||
| Linking External Workbooks | (05:18) | ||
|
Popular Functions
|
|||
| Conditional Statements | (02:43) | ||
| Nested Statements | (04:40) | ||
| Introduction to V-Lookup | (05:21) | ||
| Tips for Working with V-Lookup | (03:29) | ||
|
VBA & Functions
|
|||
| Using Functions | (05:00) | ||
| Creating a Custom Function | (04:44) | ||
|
Using an Add-In
|
|||
| Explaining Add-In | (03:59) | ||
| Creating an Add-In for a Custom | (02:37) | ||
| Using a Function with Goal Seek | (04:21) | ||
|
Pivot Tables
|
|||
| Using Pivot Tables | (05:01) | ||
| Working with Outside Data | (04:40) | ||
| Formats & Features of Pivots | (04:30) | ||
|
Automating Pivot Tables
|
|||
| Adding a Pivot Chart | (04:06) | ||
| Macros & Code for Automation | (05:54) | ||
|
Advanced Charts & Graphs
|
|||
| Single Point Charts | (05:39) | ||
| Specialty Charts | (05:44) | ||
| Combination Charts | (04:44) | ||
|
Automating Charts & Graphs
|
|||
| Creating a Dynamic Chart | (04:12) | ||
| The Offset Command | (04:51) | ||
|
Pivots & Charts in Legacy Versions
|
|||
| Creating Pivots in Earlier Versions | (04:13) | ||
| Charts & Graphs in Prior Versions | (05:39) | ||
|
Working with Other Programs
|
|||
| Linking to PowerPoint | (03:41) | ||
| Dressing up Your Spreadsheets | (05:40) | ||
|
Importing/Exporting Data
|
|||
| Working with External Data | (05:33) | ||
| Exporting from Excel | (03:56) | ||
|
Analysis Tools
|
|||
| Understanding the Add-In Tools | (02:18) | ||
| Descriptive Statistics | (03:36) | ||
| Histogram | (03:21) | ||
|
Looking for Help
|
|||
| The Help Menu for Excel & VBA | (05:16) | ||
| The Microsoft Interactive Tool | (02:32) | ||
|
Wrap Up
|
|||
| Conclusion | (03:01) | ||
| About the Author | (03:06) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | Microsoft Excel Automation |
| Author: | Lauri Matson |
| SKU: | 33964 |
| ISBN: | 1-935320-28-9 |
| Release Date: | 2009-01-30 |
| Duration: | 5 hrs / 71 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Updated Notes
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More