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. EE Import Contacts
   EE Import Contacts is a Microsoft Excel add-in that allows users to import Outlook contact folders directly into Excel. From userforms, users can determine which fields are imported, and also can edit the Outlook contacts prior to import.
2. FinancePro 2.9
   A Business budget and financial forecasting modeling to build a reliable forecasting reports more easily.
3. CZ Excel Converter
   CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more! The software supports batch conversion, command line and folder watcher.
4. Excel Shift Scheduler
   The Shift Schedules S2-10-50 Excel spreadsheet automatically assigns up to 50 people to up to 10 shifts per day in response to your scheduling needs and your employee's preferences and qualifications.
5. Xcelential Standard Edition
   Xcelential lets you view the key charts and data from the latest versions of all your Excel spreadsheet files on a dashboard you can easily build in 5 minutes. Xcelential automatically gets updated spreadsheets from emails and shared folders for you.
6. EziFiler Pro
   Do you have forms that staff fill in on a regular basis? Timesheets? Leave Applications? Travel Requests? Stationary Orders? etc.
7. Basic Balance Sheet Template
   The basic balance sheet template is an Excel spreadsheet for those who prefer to do their own valuation and/or analysis and would rather not spend the significant time needed to create the financial statements.
8. Visual Basic Collection for Microsoft Excel
   The Visual Basic collection contains two downloadable books on Excel macros: Visual Basic Macros Made Easy and Visual Basic Macro Examples.
9. Number Manager
   The number manager fills in the gaps in Excel when working with numbers. It allows you to add 15 different number formats that are not part of Excel's built in number formats.
10. SpreadCalc 1.01
    SpreadCalc - for those who use Excel seldom and don't need all its complicated features. A handy utility with most often used features of Excel but for less money - for you.
11. TorniaiSansUT Light PC
    TorniaiSansUT Light PC
12. TorniaiSansUT Heavy PC
    TorniaiSansUT Heavy PC
13. Auto Loan Calculators - for Windows 95 or higher
    Autoloan.EXE - These calculators may be used to compare loan types proposed and assist decision making.
14. Financial Statement - for Windows 3.1
    Finastmt.EXE - This is a standard personal financial statement that is widely accepted in by banking and mortgage lender institutions.
15. ExcelSmartTools Auditor
    ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models.
16. Excel Level 2 Lessons
    10 Lessons and 5 Workbook examples on Excel level 2
17. TorniaiSansUT Black PC
    TorniaiSansUT Black PC
18. Maxmortgage - for Windows 3.1
    Maxmtge.EXE - A mortgage qualifier for either a fixed- rate or variable-rate mortgage which shows how large a mortgage you qualify for.
19. Refinance It? -for Windows 95 or higher
    Refinanc.EXE - This program demonstrates the advantages of refinancing your existing mortgage as well as conditions under which you should consider refinancing.
20. Check2Check
    Check2Check is an innovative and easy-to-use budget program which will quickly show you where your money is going and allows you to plan your finances into the months ahead.