Save on this all-in-one course package! Excel Levels 1,2 and 3 PLUS VBA Levels 1 and 2 all in one low price!
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 50 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples.
Course Outlines:
Excel Level 1 Basic is for students and professionals new to Microsoft ExcelŽ. Level 1 focuses on core Excel skills you will need to perform everyday functions in finance, marketing, analysis, and administration. The course covers:
The Fundamentals of Excel
Cut, Copy, Insert, Delete, Paste Special
Custom Formatting
Undo, Redo
Excel Formulas - Basic
Useful functions and Paste Function
Calc
Comments
Drawing toolbar
Edit, Replace, Delete, Clear
Essential Printing
Data Sorting, Hiding
AutoFormats
Protection
Basic Charts
Basic Formatting
If Function
Excel Level 2 Intermediate is for students and professionals with 1-3 years of Microsoft ExcelŽ experience. Level 2 advances your core Excel skills, dramatically enabling you to perform advanced analysis, formulas, data capture, charts, graphs, and presentations necessary for today's complex business and academic environment. The course covers:
Worksheet Formulas
Specific Worksheet Formulas
Extract Data and Decision Making
Data Validation and External References
Advanced Filters and AutoFilters
Range Names
Charts
Under-Utilised Features
Protection
Shared Workbooks and Merging Shared Workbooks
Track Changes
Custom Views
Report Manager
Hyperlinks
Outlining
Excel Level 3 Advanced 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!
