| |
These lessons
have been written by OzGrid Business Applications who
develop Excel spreadsheets on a professional basis.
Each lesson is drawn from 'real world' experience and
not made up class room scenarios. There are 10 lessons,
each between 5 and 10 Word Document pages long, and
5 Workbook examples.
Lesson 2 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:
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! |
|