Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

This Microsoft Excel Automation Tutorial video is designed to take intermediate and advanced Excel users and show them how to use the program's most advanced features to increase their efficiency, accuracy, and productivity. If you've already gone through the Excel beginners tutorials or if your skill set is at the point that you're ready for the next level, this video course is for you. Long-time spreadsheet expert and professional computerized accounting consultant Lauri Matson brings you a course that uses practical examples to show you how to use macros, VLookup functions, validation, pivot tables, and charting, analysis, and security tools to get your work done more quickly. The unique video tutorial format of each lesson includes a real-time feed of Excel in use, so following along is especially easy. You're never left wondering if you're in the right menu or getting the correct results. Best of all, this video training system allows you to learn at your own pace. The short subject-specific videos make it easy to skip between lessons, and full controls within each video give you the ability to pause or go forward or back as you need to. Since the training is available online or on CD , you can learn from anywhere you have a computer.

Associated Tutorials: Microsoft Excel 2007 | Excel for Statistics | Visual Basic for Excel - VBA | MCAS | ACT! 2010 | Microsoft Excel 2010 | Learn Microsoft Project 2010

Excel Automation Tutorial CD / DVD

When you order this Excel Automation Video Tutorial CD You'll Receive...
Over 5 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Excel Automation from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" We use some of your introductory videos for the computers at our local Senior Center, and the results have been great...the quality audio is what seem to make the big difference. Thanks. "Kathy Gagnier, Ontario

Excel Automation Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 5 Hours in Duration and Covers 71 Lessons.
Welcome to VTC's Microsoft Excel Tutorial Tips and Techniques for Excel Efficiency Understanding Validation & Protection
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Working with Named Ranges
  • Establishing a Name
  • Utilizing and Modifying Names
  • Managing Names
Working with Security
  • Working with Security
  • Macros and Using Extensions
Utilizing Macros
  • Using the Tools Menu versus the Developer Toolbar
  • Saving Macros
  • Using a Startup Folder with Macros
Creating Macros
  • First Steps
  • Understanding Absolute versus Relative Reference
Macros in Action
  • Establishing a Routine
  • Macro Format Automation
  • Building Templates for Headers/Footers
Basics of Writing Macros
  • Modifying Macro Code with Visual Basic for Apps
  • Basics to Interpreting Code
Understanding Buttons versus Command Buttons
  • Making a Button
  • Making a Command Button
The Visual Basic for Apps Screen
  • Introductiong to Explorer
  • Working with Objects & Forms
Establishing a Routine
  • Making an Object Video One
  • Making an Object Video Two
  • Applying Code to an Object
Creating Controls
  • Building Dropdown Menus
  • The Command Line View
Constructing a Pop-Up Calendar
  • Making the Form
  • Applying Code
Basics of Writing Code
  • Coding with Visual Basic for Apps
  • Sample Commands
Working with Formulas & Functions
  • Understanding the Difference between Formulas and Functions
  • Basic Guide to Formulas
Understanding 3D Formulas
  • Working with Formulas from Outside Worksheets
  • Creating External Workbook Links
Working with Common Functions
  • Working with Conditional Statements
  • Working with Nested Statements
  • Basics of V-Lookup
  • Working with V-Lookup
Using Functions with Visual Basic for Apps
  • Understanding Functions
  • Building Custom Function
Working with an Add-In
  • Introduction to Add-In
  • Constructing an Add-In for a Custom Function
  • Working with Goal Seek and Functions
Understanding Pivot Tables
  • Working with Pivot Tables
  • Employing External Data
  • Understanding Pivot Formats and Properties
Working with Pivot Tables and Automation
  • Creating a Pivot Chart
  • Working wtih Automation Macros & Code
Further with Charts & Graphs
  • Working with Single Point Charts
  • Working with Specialty Charts
  • Working wtih Combination Charts
Utilizing Chart & Graph Automation
  • Building a Dynamic Chart
  • Understanding the Offset Command
Working with Pivots & Charts in Previous Versions
  • Constructing Pivots
  • Creating Charts & Graphs
Integration with Workflow
  • Working with PowerPoint
  • Configuring Spreadsheets
Data Migration
  • Utilizing External Data
  • How to Export Excel Data
Working with Excel Analysis Tools
  • Working with the Add-In Tools
  • Understanding Descriptive Statistics
  • Working with the Histogram
Getting Assistance
  • Using the Help Menu in Excel & Visual Basic for Apps
  • Using Microsoft's Interactive Tool
Course Summary
  • Content Revew and Look Ahead
  • Tutor Bio

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Excel Automation Training CD

Title Excel Automation
Tutor Lauri Matson
Other tutorials by Lauri Matson
Videos 71 Lessons- Video run time: 5 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2009
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available on this title
128 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Excel Automation from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos| Online Excel Automation Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.