|
|
|
Main
> Business
& Finance >
Spread Sheets
> Excel VBA Level 1 and Excel UserForms |
 CURRENT
SPECIAL Was $75.00 Now $39.95
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 20 lessons. Each
lessson is between 5 and 10 Word Document pages long. There are also 10
Excel 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!
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.
UserForms Introduction, Filling UserForm Controls, Putting Data into our
Controls, When to put Data into our Control, Filling a ListBox and/or
ComboBox using Loops, Multi-Page Control, Creating a wizard using the
Multi-Page Control, Validating the User Inputs, Some Useful Methods and
Functions, When to apply Validation, Control Events, Which Controls to use
and When, Parsing Control Values back to a Spreadsheet, Parsing range values
to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or
False, Creating Template Controls, Using the RefEdit Control, Finding the
Active Control, Creating Controls at Runtime.
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 training in many different Applications, and
while they may supply information from good trainers it is very unlikely the
trainers will know Excel to the extent we do! Remember we develop Excel
spreadsheets in our day-to-day business so we know what you will encounter
in your day-to-day use of Excel. We are not just Excel teachers, but also
Excel developers! |
|
Buy
Now |
| |
|
|
Product
Information
|
-
Version:-
-
Price:
$39.95
-
Size:
9MB
-
License:
Shareware
-
Developer:
Dave Hawley
-
OS:
Windows
-
Rating:
|
|
|
|