Microsoft Excel Automation Tutorials


Course Content


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.

To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie. «« Hide This
Introduction
	Course Objectives	(04:43)
	Command Reference (2003 - 2007)	(01:35)
Time Saving Techniques
	Shortcuts & Quick Tips	(04:44)
	Auto Correct Options	(03:30)
Validation & Protection
	Introducing Data Validation	(03:04)
	Creating a List with Validation	(02:16)
	Setting up Protection	(04:38)
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 Feedback

Tutorial Information / Pricing

Title:	Microsoft Excel Automation
Author:	Lauri Matson
SKU:	33964
ISBN:	1-935320-28-9
Duration:	5 hrs / 71 Lessons
Compatibility:	Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30

The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP	LEARN MORE »


Get this title on CD


Single User: US$ 99.95 - Purchase CD / Add to Cart


Select Bandwidth


Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming. Select:


Select Category


Animation & 3D Audio Business Applications Databases Graphics & Page Layout Multimedia & Video Networking & Security Operating Systems Programming Internet & Web Design Special Groups New Releases All Titles Publisher or Products Adobe Tutorials Apple Tutorials Cakewalk Tutorials Corel Tutorials Dreamweaver Tutorials Macromedia Tutorials Microsoft Tutorials Oracle Tutorials Photoshop Tutorials Sony Tutorials

Microsoft Excel Automation Tutorials

Introduction

Time Saving Techniques

Validation & Protection

Named Ranges

Security

Introduction to Macros

Macros

Practice with Macros

Understanding Macro Code

Buttons vs. Command Buttons

The VBA Screen

Creating a Routine

Adding Controls

Designing a Pop-Up Calendar

Writing Code

Formulas & Functions

Three Dimensional Formulas

Popular Functions

VBA & Functions

Using an Add-In

Pivot Tables

Automating Pivot Tables

Advanced Charts & Graphs

Automating Charts & Graphs

Pivots & Charts in Legacy Versions

Working with Other Programs

Importing/Exporting Data

Analysis Tools

Looking for Help

Wrap Up