All Excel/VBA 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!
I have just finished VBA level 1, lesson 5 and would like to say that I have learnt more in the short time that I have been working through your lessons, than I have using any other text. Your course is extremely concise, relevant and easy to follow. Simple tips like understanding why Select Case is more efficient than If Else, and knowing about the DateSerial function will make my code far more efficient. I did not have to dredge through pages and pages of jargon filled text books, I just sat down for 15 minutes in front of your lesson and I have learnt 2 essential techniques. Of course, it will take me years to perfect them, but you are helping me build solid foundations.
Thank you Dave.
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.
Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL. Please email the support address and include your order number so we can send you the code password. Resellers user license ONLY.
|All Training Comes With Lifetime Free Question Support. Register Here Then Send Your Username & Order Number|
|Type/Level||Cost||Instant Download||Bundled Savings Option|
|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 (index of courses) 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. Download Demo||$99.00||YES||No|
|Smart VBA VBA Development Tool for VBA Programmers. Download Demo||$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|
|111+ POWER ACCESS/SQL QUERIES||$39.95||YES||N/A|
|Mathematics Aids With Demos|
|Speed Math for Mind: Speed Mind Maths-details/buy|
|DreamCalc Graphing Calculator-details/buy|
|DreamCalc Professional Calculator-details/buy|
|DreamCalc Scientific Calculator-details/buy|
|FindDec standard-details/buy | FindDec Professional-details/buy | FindDec Unlimited-details/buy|
|Aquarius Soft Pocket Binary Converter-details/buy|
|Aquarius Soft Pocket Currency Calculator-details/buy|
|Aquarius Soft Pocket Unit Converter-details/buy|
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