Easy to follow Excel Automation Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Excel Automation tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.
Excel Automation Tutorial Video - Try for FREE
This Excel Automation Tutorial Video Online Training is an advanced course that helps high end users of Excel streamline repetitive and common tasks and free their time for more productive use. Office software expert Lauri Matson picks up where the introductory Excel courses leave off and shows users the advanced techniques and strategies that will truly make a difference in their everyday work. This course is not for beginners. Although some basic features are addressed, new users will benefit the most from taking one of the introductory Excel online training titles first. The emphasis of this tutorial is to increase productivity by reducing common errors and simplifying overall workflow. Lessons concentrate on automating common tasks, avoiding duplication and using advanced Excel tools to get more work done in less time. Working with formulas, reviewing functions and examining conditional formats is the first stage of the course, and special time is devoted to Using Macros, Named References, Advanced Charts, Pivot Tables and Lists. Free demos are available below, and the full contents of the training will be instantly accessible as soon as you've signed up. In addition, you can watch videos from any of the other tutorial video online training courses. This online course allows you to learn Excel from your own desk.
Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.
The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.
Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!
The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.
Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!
Benefits of Online Learning
- Unlimited viewing. No Hidden Costs
- Downloadable working files.
- Instant Access
- Expert instructors.
- Use at home / work or both.
- Works on PC or Mac.
- Telephone Tech support.
- Cancel at any time.
- 600+ courses for 1 low fee.
- New titles added monthly.
- 100% Guaranteed
Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Excel Automation training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.
If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.
Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.
Try a Free demo, Click on any of the links below
Topics covered on this tutorial video include:
Introduction
Time Saving Techniques
- Shortcuts & Quick Tips Demo
- Auto Correct Options Demo
Validation & Protection
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
Excel Automation Video Tutorial
Title Excel Automation Training Tutorial
5 hours
71
Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions
Own this Training Course on CD
Would you like to own this Excel Automation Training title on CD?
You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Excel Automation tutorial on CD.
Excel Automation tutorial on CD.
Free Certification - Prove Your Skills
After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.
Related Tutorials
Customer Comments
We have been customers of Apex Web Media for over 3 years and would have no hesitation in recommending their professional and efficient services to any company looking for professional, affordable training.
S.J Holt
Suwanee Georgia
S.J Holt
Suwanee Georgia