Bundled Savings | other Excel Training | Complete Excel Training Course Special! NEW! Excel 2007 Training Level 1 & Excel 2007 Training Level 2
NEW EXCEL VIDEO TRAINING-HALF PRICE FOR SHORT TIME!
| 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 |
| Excel Training Course Outlines - All Levels | |||
| 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 |
| eXCEL training VIDEOS 60 Day Money Back Guarantee | |||
| EXCEL VIDEO TRAINING $33.50 with coupon code: XLT-6Y1E-NITY | $67.00 | YES | N/A |
| Training bibles | |||
| Excel training bible | $119.95 | YES | N/A |
| 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 | $99.00 | YES | No |
| Smart VBA VBA Development Tool for VBA Programmers | $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 |
Instant Download and Money Back Guarantee on Most Software
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