clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master Microsoft Excel Automation - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
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.
Microsoft Excel Automation Training
Access the complete Microsoft Excel Automation Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Excel Automation plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Excel Automation from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Excel Automation
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Excel Automation
Description: Click here to open / close full 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.

-Close-
Instructor: Lauri Matson (more by this author)
Instruction: 71 Tutorials - Duration: 5 hrs
First Release: 2009-02-25
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Excel Automation
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Excel Automation
 
Below is content list for all of the lessons included with the Microsoft Excel Automation Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction
movie image Course Objectives
movie image Command Reference (2003 - 2007)

Time Saving Techniques
movie image Shortcuts & Quick Tips
movie image Auto Correct Options

Validation & Protection
movie image Introducing Data Validation
movie image Creating a List with Validation
movie image Setting up Protection


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

Named Ranges
Defining a Name
Editing & Using Names
Name Manager

Security
Adjusting Security Levels
Using Macro Extension

Introduction to Macros
Tools Menu vs. Developer Toolbar
Storing Macros
Working with a Startup Folder

Macros
Getting Started
Absolute vs. Relative Reference

Practice with Macros
Creating a Routine
Automating Formats
Creating a Template for Headers/Footers

Understanding Macro Code
Editing Macros with VBA
Introduction to Reading Code

Buttons vs. Command Buttons
Creating a Button
Creating a Command Button

The VBA Screen
The Explorer & Properties
Objects & User Forms

Creating a Routine
Creating an Object pt. 1
Creating an Object pt. 2
Adding Code to an Object

Adding Controls
Creating Dropdown Lists
Viewing the Code

Designing a Pop-Up Calendar
Creating the Calendar Form
Writing the Code

Writing Code
Coding with VBA
Examples

Formulas & Functions
Formulas vs. Functions
Tips for Formulas

Three Dimensional Formulas
Formulas from Other Worksheets
Linking External Workbooks

Popular Functions
Conditional Statements
Nested Statements
Introduction to V-Lookup
Tips for Working with V-Lookup

VBA & Functions
Using Functions
Creating a Custom Function

Using an Add-In
Explaining Add-In
Creating an Add-In for a Custom
Using a Function with Goal Seek

Pivot Tables
Using Pivot Tables
Working with Outside Data
Formats & Features of Pivots

Automating Pivot Tables
Adding a Pivot Chart
Macros & Code for Automation

Advanced Charts & Graphs
Single Point Charts
Specialty Charts
Combination Charts

Automating Charts & Graphs
Creating a Dynamic Chart
The Offset Command

Pivots & Charts in Legacy Versions
Creating Pivots in Earlier Versions
Charts & Graphs in Prior Versions

Working with Other Programs
Linking to PowerPoint
Dressing up Your Spreadsheets

Importing/Exporting Data
Working with External Data
Exporting from Excel

Analysis Tools
Understanding the Add-In Tools
Descriptive Statistics
Histogram

Looking for Help
The Help Menu for Excel & VBA
The Microsoft Interactive Tool

Wrap Up
Conclusion
About the Author
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2010 VTC Canada All Rights Reserved.