Microsoft Excel Automation Training Video - Tutorial CD
This powerful Microsoft Excel Automation Training Video course will take users already familiar with the fundamentals and everyday operation of the program and teach them advanced skills that will help them get the most out of the application. Longtime Excel user and business software consultant Lauri Matson draws from years of hands-on Microsoft Excel experience to show you everything you need to know about macros, VLookup functions, pivot tables, validation, security and other advanced topics that affect the way you work. Each Training Video features a live view of Microsoft Excel in use, and combined with the provided work files, this training system makes it extremely intuitive to follow along. Don’t spend any more valuable time or money on cumbersome manuals or expensive corporate seminars. Our Training Video training is designed to fit your schedule and budget by offering you one competitive package that allows you to learn at your own pace. Available online or on CD. This tutorial is the ideal way to Learn Microsoft Excel Automation at your own pace.
Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.
try a free demo Below.
Benefits
- Works on PC or Mac
- Professional Tutition by Experts
- Self-Paced Learning Interface
- Builds Practical Skills Quickly
- Rapid Learning - High Retention
- Free Certificate with each Tutorial
Client Testimonials
-
I have been a member of the online university for over a year now, and still to this day I don't know how you offer so much training for only $25.00 per month, and if that's not enough you keep adding more titles each month.
F. Hatch
Ontario. Canada
Just Released Training
- Just Released this week.
Sony Vegas 10 Training Video
Topics covered on this Tutorial Video
are Listed Below:-
The purchased version of this Training contains all the movies listed below as well as all the featured Movies above.
US$ 99.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 pt. 1
- Creating an Object pt. 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
When you order this Microsoft Excel Automation Training CD you'll receive:-
An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.
A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels
A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.
A verifiable Certificate Proving your Skills
Microsoft Excel Automation Training - VIDEO INFO
Microsoft Excel Automation
Lauri Matson
5 hours - 71 Movies
US$ 99.95
Win 7 ,Vista, XP, 2000, 98. Mac OS X
Ground / 2 day / Next Day
33964
Multi User Version Available
Benefits of this Training Video
- Learn Microsoft Excel Automation in the shortest time possible
- Self paced tutorial, training on video, learn at your own pace
- Just sit back and watch, no books to read, just easy to follow lessons
- Training can be viewed from any location, on PC or Mac
- All training is self-contained; you dont even need the application you are learning loaded on your machine
- The most affordable way to learn, benefit from a world-leading expert
- High quality content for a fraction of the cost of a classroom training course
- The tutorials can be rewound, fast forwarded or stopped at any time
- Learn Microsoft Excel Automation from the comfort of your own desk.
Prove your Skills. Free Certification
- With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.
Related Tutorial Videos
Microsoft Excel Automation Related Videos
Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:
Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: