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 2 is for Excel users familiar with the basics of Excel VBA who want to build fully automated trading and analysis models with user forms, data import/export, automated controls, and other "software like" features. The course covers:
Filling UserForm Controls
Putting Data into your Controls
When to put Data into our Control
Filling a ListBox and/or ComboBox using Loops
Creating a wizard using the Multi-Page Control
Validating the User Inputs
Some Useful Methods and Functions
When to apply Validation
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
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!