Excel VBA Level 1 Lessons

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

TorniaiSansOsfUT LightItalic PC
TorniaiSansOsfUT LightItalic PC

TorniaiSansOsfUT Light PC
TorniaiSansOsfUT Light PC

TorniaiSansOsfUT Family PC
TorniaiSansOsfUT Family PC

TorniaiSansUT BlackItalic PC
TorniaiSansUT BlackItalic PC

TorniaiSansUT Black PC
TorniaiSansUT Black PC

TorniaiSansUT HeavyItalic PC
TorniaiSansUT HeavyItalic PC

TorniaiSansUT Heavy PC
TorniaiSansUT Heavy PC

TorniaiSansUT BoldItalic PC
TorniaiSansUT BoldItalic PC

TorniaiSansUT Bold PC
TorniaiSansUT Bold PC

TorniaiSansUT RegularItalic PC
TorniaiSansUT RegularItalic PC

TorniaiSansUT Regular PC
TorniaiSansUT Regular PC

TorniaiSansUT LightItalic PC
TorniaiSansUT LightItalic PC

TorniaiSansUT Light PC
TorniaiSansUT Light PC

TorniaiSansUT Family PC
TorniaiSansUT Family PC

FinancePro
A Business budget and financial forecasting modeling to build a reliable forecasting reports more easily.

ForecastingTools Graph
ForecastingTools Graph provides the most Known and commonly used Forecasting methods for Marketing, Economics, Accounting, Operations Management.

ExcelSmartTools Auditor
ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models.

ExcelSmartTools Premium Edition
This Add-In adds and enhances Microsoft Excel commands and functions. Many improvements are great time-savings features for tedious and repetitive tasks.

Investment & Business Valuation
The Investment Valuation model by Excel Business Tools

Regression Business Plan Forecasting
The Multiple Regression Forecasting model by Excel Business Tools