| |
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!<P>
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 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! |
|