Home > Excel Business Solutions > Excel Productivity > Training and Tutorials > Training Courses Share

Training Courses

Excel training courses for training and tutorials


Excel Training Courses

(Recommended)
Rate this solution:
(4/5 from 2 votes)
The Excel Training courses have been written by professional business application developers who develop Excel spreadsheets on a professional basis. Each course is drawn from 'real world' experience and not made up class room scenarios. There are 50 Excel training courses, each between 5 and 10 Word Document pages long, and 25 Excel Workbook examples. There is also an online Microsoft Pivot Table tutorial as well as downloadable book of time saving Microsoft Excel solutions.

Time Saving Microsoft Excel Solutions:

This 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 free. Download and use it 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 this resource - just download, run, and open Excel. Access the contents from the Excel Tools menu by clicking on the new menu item.

Training Courses for Excel links are provided below for individual and combination of Excel training courses to find more information, purchase individually or with bundled discounts where available.

Excel Training Courses Levels 1,2 and 3: (* = Excel Workbook included)

Excel Training Courses - Level 1:
1. The Fundamentals of Excel
2. Cut, Copy, Insert, Delete, Paste Special
3. Custom Formatting, Undo, Redo
4. Excel Formulas - The least you should know *
5. Useful functions and Paste Function *
6. Calculate, Comments, Drawing toolbar, Edit Replace, Delete Clear
7. Essential Printing *
8. Data Sorting, Hiding, AutoFormats *
9. Protection, Basic Charts, Basic Formatting
10. If Function *

Excel Training Courses - Level 2:
1. Excel Fundamentals
2. Worksheet Formulas
3. Specific Worksheet Formulas *
4. Extract Data and Decision Making *
5. Data Validation and External References
6. Advanced Filters, Auto Filters, Names *
7. Charts
8. Under Utilized Features
9. Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks *
10. Custom Views, Report Manager, Hyperlinks, Outlining *

Excel Training Courses - Level 3:
1. Advanced Formulas *
2. Advanced Filters, Text To Columns, Importing Text Files *
3. Pivot Tables 1 *
4. Pivot Tables 2 *
5. Pivot Tables 3 *
6. Scenarios, Goal Seek *
7. Data Tables and Consolidation *
8. Excel on the Web *
9. VBA Macros 1
10. VBA Macros 2 *


Excel Training Courses for VBA and VBA User forms: (* = Excel Workbook included)

Excel VBA Training Courses - Level 1:
1. The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties
2. Excel Objects - Workbook Included, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars *
3. Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants *
4. Loops, Types of Loops, Loop Pitfalls *
5. Effective Decision Making, If/And/Or, Select Case, Dates and Times
6. Workbook and Worksheet Events
7. Debugging and Error Handling, Prevention, Good Habits, Runtime Errors *
8. Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features
9. User Defined Functions, Good vs Bad, Arguments, Calculation
10. Controls, ActiveX, Control Toolbox, Control Properties, Control Parents *

Excel VBA Training Courses - Level 2:
1. User Forms Introduction *
2. Filling User Form Controls, Putting Data into our Controls, When to put Data into our Control, Filling a List Box and/or Combo Box using Loops
3. Multi-Page Control, Creating a wizard using the Multi-Page Control
4. Validating the User Inputs, Some Useful Methods and Functions *
5. When to apply Validation, Control Events *
6. Which Controls to use and When *
7. Parsing Control Values back to a Spreadsheet, Parsing range values to the User Form Controls
8. Option Buttons and Check boxes in Detail, True or False
9. Creating Template Controls, Using the RefEdit Control
10. Finding the Active Control, Creating Controls at run time *

Try It  Get It

Price: USD 59.95
(Updated on 2012-02-06)

Related Excel Solutions for Training Courses

Workbook and VBA ExamplesTraining and Tutorials  Time Saving TipsTraining and Tutorials  Knowledge BaseTraining and Tutorials  Help GeneratorModel Building  Online TrainingTraining and Tutorials  Training TemplatesTraining and Tutorials  Project Manager TrainingTraining and Tutorials

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.