Excel VBA Level 1 Lessons

Learn about Excel VBA in 10 HTML lessons with 5 Workbook examples

Description of Excel VBA Level 1 Lessons:

These lessons have been written by OzGrid Business Applications, who develop Excel spreadsheets on a professional basis. All information within these lessons are drawn from 'real world' experience and not fictitious class room scenarios. There are five Workbook examples with the 10 lessons. Each lessson is between 5 and 10 Word Document pages long.

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!

BASIC 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 WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.

WHY USE US FOR EXCEL TRAINING?

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer traini65.00

See Also: All products from OzGrid Business Applications

1. Excel VBA UserForm Lessons
   10 Lessons and 5 Workbook examples on Excel VBA UserForms
2. Filter Assistant for Microsoft Excel
   The Filter Assistant for Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature.
3. OM-LEARN
   Excel Spreadsheet Template for Learning curves data.
4. Excel Assistant
   MS Excel add-in for accounting
5. ExcelExplorer 1.01
   ExcelExplorer is a new utility for quick and easy managing excel files. Using ExcelExplorer you can view, move, delete or rename excel files even without Excel on your pc. ExcelExplorer has transparent interface of two panels.
6. Excel Spreadsheet Auditor 1.0
   Excel Spreadsheet Auditor is a Jabsoft's Excel add-in which enables you to view formulas in a different, friendlier manner. Excel Spreadsheet Auditor shows all origin links which may exist between formulas of a selected range.
7. NeuroXL Predictor
   NeuroXL Predictor is a powerful, easy-to-use and affordable solution for advanced estimation and forecasting.
8. Time Sheet
   This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
9. Funding Plan Pro
   Funding Plan PRO for Excel provides the perfect financial planner for any 10 year projection.
10. ESQuotes 2.0.0
    Excel add-in for quoting stocks, options, mutual funds. Free real time quotes, historical data, alerts. Ideal to watch & research stocks, options & mutual funds your way. Uses simple & familiar =functions(). Works with all internet connections.
11. TrigleUT Family PC
    TrigleUT Family PC
12. TorniaiSansOsfUT Bold PC
    TorniaiSansOsfUT Bold PC
13. Chart Viewer for Microsoft Excel
    View Excel charts on a worksheet in a slide show fashion!
14. TorniaiSansOsfUT LightItalic PC
    TorniaiSansOsfUT LightItalic PC
15. Random Sampler for Microsoft Excel
    Use the Random Sampler to randomly select your samples!
16. Retirement Investment Req'd - Windows 95 or higher
    Retirinv.EXE - You can calculate the amount of money you need to be investing monthly to provide a monthly withdrawa supplemented by Social Security, pensions, annuities or other income sources.
17. TorniaiSansOsfUT BlackItalic PC
    TorniaiSansOsfUT BlackItalic PC
18. Excel Level 1, 2 and 3 Training
    Excel levels Basic to Advanced Training
19. Advanced Excel Select 1.4
    Save your time and nerves when selecting cells with formulas, comments, conditional formats, etc.
20. Excel Level 1, 2 and 3 Training
    MS Excel Training for newsletter members only