Microsoft Excel Automation Training - FREE Tutorials

Time Saving Techniques
Shortcuts & Quick Tips
Auto Correct Options

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

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month.

CLICK HERE TO BUY THIS TUTORIAL ON CD

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 - Tuition 1
Creating an Object - Tuition 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

CLICK HERE TO BUY THIS TUTORIAL ON CD