Microsoft Excel ® Templates, Training & Add-ins.
Personal & Business Software .
For Free 24/7 Microsoft Office® Support See:
Our Free Excel & VBA Help Forum. See Also our: Free Excel Newsletter

Excel Training & Excel VBA Training Resellers licence

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Current Special! Excel Training 1, 2, 3,  VBA Level 1 and Excel VBA UserForms (Complete Excel Training Course), only $145.00. $59.95 Instant Buy/Download. *Unlimited licence only $79.95!  **Reseller licence only $2000.00

*Unlimited licence allows an unlimited number of people to use, copy and print the lessons. Ideal for uploading to a companies Intranet!

*Unlimited licence allows an unlimited number of people to use, copy and print the lessons. Ideal for uploading to a companies Intranet!

Back to Excel Training All lessons applicable to Excel 97 through to Excel 2003

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 Downloadable  Workbook Examples

Excel Level 2 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 Utilised Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining. + 5 Downloadable  Workbook Examples

Excel Level 3 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 Downloadable  Workbook Examples

Lesson 10 has Time Saving Microsoft Excel Solutions

Excel VBA UserForms and their Controls 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 Downloadable  Workbook Examples

Lesson 10 has Time Saving Microsoft Excel Solutions

Time Saving Microsoft Excel Solutions

Is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

Back toExcel Training