|
|
|
Main
> Business
& Finance >
Spread Sheets
> Complete Excel Course |
 CURRENT
SPECIAL Was $145.00 Now $59.95
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. |
|
Buy
Now |
|
|
|
|
Product
Information
|
-
Version: -
-
Price:
$59.95
-
Size:
MB
-
License:
Shareware
-
Developer:
Dave Hawley
-
OS:
Windows
-
Rating:
|
|
|
|
