|
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 10 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!
Excel VBA Level 1 is for Microsoft ExcelŽ users who want to automate their repetitive spreadsheet and analysis tasks, increase productivity, and enhance their analysis capabilities. VBA Level 1 teaches you the basics of Excel VBA programming (macros), how the code and code modules function, code syntax, real-life examples, and much more! The course covers:
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
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 Worksheet Functions in VBA
Specific Examples
Excel's Built-In Features
User Defined Functions
Good vs Bad
Arguments
Calculation
Controls
ActiveX
Control Toolbox, Control Properties, Control Parent
5 Downloadable Workbook examples
What you Get
Instant download of your Excel training
FREE Excel question support for LIFE!
Ask all/any Excel/VBA questions free in OzGrid's 24/7 Excel Help Forum
All Lessons Applicable to Excel 97-Excel 2003 and Windows 95 and Above!
30 Day Money Back Guarantee on All Excel/VBA Training
3 LICENSE OPTIONS (SPECIFY IN THE ORDER FORM):
- 1 User License allows installation of the course on 2 Computers
- Unlimited license allows installation of the course on an unlimited number of Computers, and/or Networks.
- Resellers License allows you do what ever you like with the lessons, re-brand and re-sell. No Restrictions At All!
|
