| |
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 as well as Time Saving Microsoft Excel Solutions.
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 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
<P>
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.
|
|
