All Excel/VB training is in full HTML format. No special software is needed, only your browser which you are reading this page with. They can be read, copied or printed, offline or online. Each course consists of 10 lessons and 5 downloadable Workbook examples. The lessons are delivered to you immediately after payment and are instantly downloadable. The lessons are then yours to keep....forever & use as many times as you like!
Excel Level 1 Training: Course Outline: The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function. + 5 Workbook Examples
Intermediate Excel Training: Course Outline: Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining. + 5 Workbook Examples
Advanced Excel Training: Course Outline: Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3 with online tutorial, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2 . + 5 Downloadable Workbook Examples
Excel VBA Level 1: Course Outline: The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent. + 5 Workbook Examples.
Excel VBA UserForms: Course Outline: UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime. + 5 Workbook Examples.
30 Day Money Back Guarantee
$59.95
Complete Excel Training Course Instant Buy/Download.
| Order Type: |
|
1-2 User License allows installation of the course on 2 Computers only. Free lifetime question support
Unlimited license allows installation of the course on an unlimited number of Computers, and/or Networks. Ideal and very cost effective for corporate environments. Free lifetime question support
Resellers License (No Restrictions) allows you do what ever you like with the lessons, re-brand and/or re-sell them at any price. Free lifetime question support
TIP! get any license at half price simply by registering here
| Type/Level | Cost | Instant Download | Bundled Savings Option |
| NEW! Excel 2007 Training Level 1, Excel 2007 Training Level 2, Excel Charting Lessons & Working With Excel Sheets In VBA | |||
| Excel Training 30 Day Money Back Guarantee | |||
| Complete Excel Course Special | $59.95 | YES | N/A |
| Excel Level 1 Basic | Free | N/a | N/A |
| Excel Level 2 Intermediate | $29.95 | YES | Yes |
| Excel Level 3 Advanced | $29.95 | YES | Yes |
| Excel Tips & Tricks Intermediate-Advanced | $19.95 | YES | No |
| Excel VBA Training 30 Day Money Back Guarantee | |||
| Excel VBA 1 Basic | $29.95 | YES | Yes |
| Excel VBA 2 (UserForms & ActiveX Controls) | $29.95 | YES | Yes |
| Working With Excel Sheets In VBA 30 Day Money Back Guarantee | |||
| EXCEL CHARTING 30 Day Money Back Guarantee | $9.95 | yes | yes |
| EXCEL TRAINING VIDEOS 60 Day Money Back Guarantee | |||
| EXCEL VIDEO TRAINING | $67.00 | YES | NO |
| VBA Coding Enhancement tools-basic to advanced vba experience | |||
| Code VBA Coding tools added to your Visual Basic editor (VBE) you create better VBA macros faster | $99.00 | YES | No |
| Smart VBA VBA Development Tool for VBA Programmers | $99.00 | YES | no |
| Print VBA Code Customizable printing of VBA source code in color with joining indicators | $59.95 | YES | No |
| Excel Dashboard Learning Kit | |||
| Excel Dashboard Reports/Charts 365 Day Money Back Guarantee | $49.95 | YES | Yes |
| Excel in the Stock Trading Market 30 Day Money Back Guarantee | |||
| Build an Automated Stock Trading System | $89.95 | YES | No |
| Build an Automated Sector Fund System | $89.95 | YES | No |
| Build an Automated Spread Trading System | $89.95 | YES | No |
| Build an Cash Flow Valuation Model With Excel with Yahoo! Finance | $49.95 | YES | No |
| Technical Indicators Library Open Source | $89.95 | YES | No |
| Excel Finance & Statistic | |||
| Finance and Statistics Models | $29.95 | YES | Yes |
| Random Numbers Generator and Statistics | $29.95 | YES | Yes |
| Numerical Searching and Option Pricing Models | $29.95 | YES | Yes |
| ACCESS/SQL | |||
| 111+ POWER ACCESS/SQL QUERIES | $39.95 | YES | N/A |
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft