CURRENT SPECIAL Was $145.00 Now
$59.95
Reduced to $53.96
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
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.
