Self Study, Tutorial Video on CD - DVD. Tutor Lauri Matson 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 course is ideal for Beginners and Advanced users
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. . Watch our free Excel Automation Tutorial Videos by clicking the blue lesson links below.
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
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.
Named Ranges
$149.95
- Defining a Name
- Editing & Using Names
- Name Manager
- Adjusting Security Levels
- Using Macro Extension
- Tools Menu vs. Developer Toolbar
- Storing Macros
- Working with a Startup Folder
- Getting Started
- Absolute vs. Relative Reference
- Creating a Routine
- Automating Formats
- Creating a Template for Headers/Footers
- Editing Macros with VBA
- Introduction to Reading Code
- Creating a Button
- Creating a Command Button
- The Explorer & Properties
- Objects & User Forms
- Creating an Object Lesson 1
- Creating an Object Lesson 2
- Adding Code to an Object
- Creating Dropdown Lists
- Viewing the Code
- Creating the Calendar Form
- Writing the Code
- Coding with VBA
- Examples
- Formulas vs. Functions
- Tips for Formulas
- Formulas from Other Worksheets
- Linking External Workbooks
- Conditional Statements
- Nested Statements
- Introduction to V-Lookup
- Tips for Working with V-Lookup
- Using Functions
- Creating a Custom Function
- Explaining Add-In
- Creating an Add-In for a Custom
- Using a Function with Goal Seek
- Using Pivot Tables
- Working with Outside Data
- Formats & Features of Pivots
- Adding a Pivot Chart
- Macros & Code for Automation
- Single Point Charts
- Specialty Charts
- Combination Charts
- Creating a Dynamic Chart
- The Offset Command
- Creating Pivots in Earlier Versions
- Charts & Graphs in Prior Versions
- Linking to PowerPoint
- Dressing up Your Spreadsheets
- Working with External Data
- Exporting from Excel
- Understanding the Add-In Tools
- Descriptive Statistics
- Histogram
- The Help Menu for Excel & VBA
- The Microsoft Interactive Tool
- 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 |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2009 |
| Work files | Yes |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
134 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 $695
10 Multi User $695 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 from basics to advanced 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 | ACT! 2010
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 free 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.
