|
|
Bundled Savings | other Excel Training | Complete Excel Training Course Special! NEW! Excel 2007+Training Level 1 & Excel 2007+Training Level 2
| 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 |
|
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
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