VTC - Microsoft Excel Automation

[Nguyen Trung Hoa]

Code:

Author(s):  Lauri Matson
Date    : 2009-01-30
Video Duration: 5 hrs / 71 tutorials
Format  : ISO
Language : English
ISBN-10  : 1935320289

[list=]Details of content covered:

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)
[/list]

Video Duration: 5 hrs / 71 tutorials bundled in an ISO format (7 parts), will require quicktime player for playing these files.

Thanks and all credits to the original uploader.

Enjoy!!!

Code:

http://rapidshare.com/files/297551989/Excel_Automation__Tutorial__.part01.rar
http://rapidshare.com/files/297559323/Excel_Automation__Tutorial__.part02.rar
http://rapidshare.com/files/297562540/Excel_Automation__Tutorial__.part03.rar
http://rapidshare.com/files/297569505/Excel_Automation__Tutorial__.part04.rar
http://rapidshare.com/files/297570126/Excel_Automation__Tutorial__.part05.rar
http://rapidshare.com/files/297576493/Excel_Automation__Tutorial__.part06.rar
http://rapidshare.com/files/297584864/Excel_Automation__Tutorial__.part07.rar