 |
|
|
|
|
|
|
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!
Hi Dave
I have just finished VBA level 1, lesson 5 and would like to say that I have
learnt more in the short time that I have been working through your lessons,
than I have using any other text. Your course is extremely concise, relevant and
easy to follow. Simple tips like understanding why Select Case is more efficient
than If Else, and knowing about the DateSerial function will make my code far
more efficient. I did not have to dredge through pages and pages of jargon
filled text books, I just sat down for 15 minutes in front of your lesson and I
have learnt 2 essential techniques. Of course, it will take me years to perfect
them, but you are helping me build solid foundations.
Thank you Dave.
Daniel Houseman
Excel VBA Level 1 Course Outline: The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent. + 5 Downloadable Workbook Examples
Lesson 10 has Time Saving Microsoft Excel Solutions. It 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 freeware. Download and use 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 - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!
Instant Buy/Download or Save And Buy as part the
Complete
Excel & VBA Course |
Secure Payment Options |
30 Day Money Back Guarantee &
Big Discount for Unlimited License
and Resellers License |
Want This Course for
$0.00 (FREE)? Consider The
Code-VBA
Add-in To Ensure your code is efficient Code| Order Type: |
|
- 1 User License allows installation of the course on 2 Computers only.
- Unlimited license allows installation of the course on an unlimited number of Computers, and/or Networks. Ideal and VERY cost effective for corporate environments!
- Resellers License allows you do what ever you like with the lessons, re-brand and re-sell. No Restrictions At All!
| 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 | |||
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Why
No Excel 2007 Training?
Put simply, Ozgrid is not about getting the latest training modules out there for
the latest Excel version ASAP to cash in on training frenzies. We base our training
on experience, not generically written training manuals, which by the way
are often written while the latest version is still in BETA testing infancy. Excel
2007 is the 1st major change, from a end user perspective, since Excel 97. As such,
we are NOT going to pretend we have enough experience yet to offer
"experience based training". In addition, the latest version has bugs that have
not yet been addressed by Microsoft. We estimate about early/mid 2008 before we will have our Excel 2007 training based on experience.
See Also: All Software
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