|
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 30 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples.
Excel Level 3 is for students and professionals with strong Microsoft ExcelŽ knowledge. Level 3 truly makes you a master of Excel, and provides you with the powerful knowledge and skills you need to do complex modeling, data management, advanced formulas, pivot tables, and much more! The course covers:
Advanced Formulas
Advanced Filters
Text To Columns
Importing Text Files
Pivot Tables (with online tutorial)
Scenarios
Goal Seek
Data Tables and Consolidation
Excel on the Web
VBA Macros 1 and 2
5 Downloadable Workbook examples
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
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:
UserForms Introduction
Filling UserForm Controls
Putting Data into your 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
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!
|
