Excel Training
Excel like most software is best learnt by use. But trial and error is never efficient and at times we can all use some help, so have a look at some of the training options available.
This selection of Excel Training resources is provided by third party developers and covers training and courses to help you get the most out of Excel. Included descriptions are provided direct from the developers with links directly to the developer web site and the individual item page.
In conjunction with the developers we also offer an additional 5% discount for all third party orders placed through our web site. This offer only applies when an order is made by clicking a Discount Offer link like
To receive this additional discount make sure that when you are ready to order you return to this page and place your order using the Discount Offer link for the item you require.
Complete Excel Course
Complete Excel Course from OzGrid
comes with a
30 day money back guarantee.
In conjunction with the developers we offer an additional 5% discount for all third party orders placed through our web site. So make sure that when you are ready to order you return to this page and place your order using our Discount Offer link for the item you require.
Current developer special - was $145.00 now $59.95 - order using our Discount Offer and recive an additional 5% saving.
This Training package from OzGrid includes training packages for Excel Levels 1, 2 and 3 plus VBA and VBA Userforms plus a downloadable book Time Saving Microsoft Excel Solutions.
These lessons have been written by professional developers of Excel spreadsheets. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 50 lessons, each between 5 and 10 Word Document pages long, and 25 Workbook examples. There is also an online Microsoft Pivot Table tutorial as well as Time Saving Microsoft Excel Solutions.
TIME SAVING MICROSOFT EXCEL SOLUTIONS:
It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. 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!
EXCEL LEVELS 1,2 AND 3 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
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
Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2
VBA AND VBA USERFORMS OUTLINE:
The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, 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 WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.
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.
Complete Excel Course - More Details...
This link will take you directly to the developers web page for this software. Many software titles are available for download and free evaluation so you can give them a test run, then when you are ready to order simply use our Discount Offer link.
In conjunction with the developers we offer an additional 5% discount for all third party orders placed through our web site. So make sure that when you are ready to order you return to this page and place your order using our Discount Offer link for the item you require.
Excel Forum
Another useful tool if you have some Excel questions is the OzGrid Excel Forum. This is an open discussion forum where you can post questions and talk to others with an interest in Excel.
Third party software and services are the property of their respective holders and must be individually assessed. When available an online purchase facility is provided via RegNow.
