Software Search, Categories and Specials                                                                                     HOME
Course Outlines For Excel & Excel VBA Training

# Excel Training Outline- All Levels

Bundled Savings | other Excel Training | Complete Excel Training Course Special! NEW! Excel 2007+Training Level 1 & Excel 2007+Training Level 2

## Excel Training Course Outlines

 EXCEL - LEVEL 1 Lesson Title Workbook 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 Yes 5 Useful functions and Paste Function Yes 6 Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear 7 Essential Printing Yes 8 Data Sorting, Hiding, AutoFormats Yes 9 Protection, Basic Charts, Basic Formatting 10 If Function Yes EXCEL -  LEVEL 2 Lesson Title Workbook 1 Excel Fundamentals 2 Worksheet Formulas 3 Specific Worksheet Formulas Yes 4 Extract Data and Decision Making Yes 5 Data Validation and External References 6 Advanced Filters, AutoFilters, Names Yes 7 Charts 8 Under Utilised Features 9 Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks Yes (2) 10 Custom Views, Report Manager, Hyperlinks, Outlining Yes EXCEL - LEVEL 3 Lesson Title Workbook 1 Advanced Formulas Yes 2 Advanced Filters, Text To Columns, Importing Text Files Yes 3 Pivot Tables 1 Yes 4 Pivot Tables 2 Yes 5 Pivot Tables 3 Yes 6 Scenarios, Goal Seek Yes 7 Data Tables and Consolidation Yes 8 Excel on the Web Yes 9 Macros 1 10 Macros 2 Yes
 Lesson Title Workbook 1 The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties 2 Excel Objects - Workbook Included, Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars Yes 3 Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants Yes 4 Loops, Types of Loops, Loop Pitfalls Yes 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 Yes 8 Excel WorksheetFunctions 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 Yes Lesson Title Workbook 1 UserForms Introduction Yes 2 Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops 3 Multi-Page Control, Creating a wizard using the Multi-Page Control 4 Validating the User Inputs, Some Useful Methods and Functions Yes 5 When to apply Validation, Control Events Yes 6 Which Controls to use and When Yes 7 Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls 8 Option Buttons and Checkboxes in Detail, True or False 9 Creating Template Controls, Using the RefEdit Control 10 Finding the Active Control, Creating Controls at Runtime Yes

### Other Excel training

All Training Comes With Lifetime Free Question Support. Register Here Then Send Your Username & Order Number
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
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 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

Mathematics Aids With Demos
Speed Math for Mind: Speed Mind Maths-details/buy