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. It 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. .
Excel Automation Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.
Problems Playing the Demos?
Benefits
- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac
Just Released This Week
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction
Time Saving Techniques
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
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
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 |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2009 |
| Work files | Yes |
| Price US / Canadian Sales | $99.95   |
768 In Stock
Purchase Orders from Schools, Colleges, Government and Military Accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $500
10 Multi User $500 Why use this method of video training?
- Learn Excel Automation from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's Cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
- This title also has Closed Captions, which add clarity and help with retention. It also benefits users who are deaf / hearing impaired.
Want to hear what our customers say about our products?
Associated Tutorials:
Microsoft Excel 2007 | Excel for Statistics | Visual Basic for Excel | Microsoft Project Tutorial | MCAS | MYOB Accounting
Excel Automation Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
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.
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, and no commitment on your part.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
