Improve job skills - Become more efficient - Produce better results !

Learn Microsoft Excel Automation (in only 5 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: This Microsoft Excel Automation video course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and even productivity. First, students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this video course will help you 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 including; VLookup functions, validation, pivot tables, analysis tools, charting, and more.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 68 Free Video Video Time
(minutes)

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

 







Excel is used by businesses and organizations around the world largely for its ability to do complex operations that other programs simply cannot do. It is important to understand the basic functions and ways to use Excel, but for intermediate or advanced users of Excel, this course will help you understand some of the more challenging things in Excel and help you take your skills to the next level. Validation is a great tool in Excel and you will learn the basic of data validation, how to create a list with validation, and also setting up protection. Macro extensions are essentially external apps that can run in excel to help you run models, do estimates, and a variety of other things. Learning some of the more advanced Excel functions such as linking to external notebooks, coding with VPA, and creating dropdown lists can help you stand above your peers and truly be the Excel expert in your office.