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

CODE VBA / EXCEL DASHBOARD REPORTS

Excel Training Outline- All Levels

 

Learn Excel VBA With FREE Question Support and Instant Download

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
     

VBA FOR EXCEL - LEVEL 1

   
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

VBA FOR EXCEL - LEVEL 2

   
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

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.

You get instant download of your Excel training & FREE Excel question support for LIFE! Ask all/any Excel/VBA questions in our 24/7 Excel Help Forum. All Lessons Applicable to Excel 97-Excel 2007+.  All Excel/VB 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!

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
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
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

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

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