Complete Excel & VBA Course

Text

COMPLETE EXCEL & VBA COURSE 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 25 Workbook examples. There is also an online Microsoft Pivot Table tutorial.

EXCEL LEVELS 1,2 AND 3 OUTLINE

The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, 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 Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilised Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining

Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2

VBA AND VBA USERFORMS 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.

UserForms Introduction, Filling UserForm Controls, Putting Data into our 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.

* 1 User License allows installation of the software on 2 Computers only.

* Unlimited license allows installation of the software on an unlimited number of Computers, and/or Networks. Ideal and VERY cost effective for corporate environments!

* Resellers License allows you do what ever you like with the software, re-brand and re-sell. No Restrictions At All! Email the support email given immdediantly after purchase for passwords.

Price: $59.95 USD Category: Spreadsheets Screenshot: Added: Oct 27th 2013 Publisher: Dave Hawley Homepage: http://www.ozgrid.com/?idhere