Microsoft Excel Automation

Microsoft Excel Automation Training

CD Contents For This Title

All the chapters and lesson contents of Microsoft Excel Automation are listed below.

To help you evaluate our training, we have made some of the tutorials for Microsoft Excel Automation freely available. Click on any of the linked lesson listings below to preview FREE!

Title 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:

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

Title Information / Pricing

Title:	Microsoft Excel Automation
Author:	Lauri Sowa
SKU:	33964
ISBN:	1-935320-28-9
Release Date:	2009-01-30
Price:
Duration:	5 hrs / 71 lessons
Work Files:	Yes
Captions:	Available on CD and Online University
Compatibility:	Vista/XP/2000, OS X, Linux QuickTime 7