Excel Level 1, 2 and 3 Training

MS Excel Training for newsletter members only

Description of Excel Level 1, 2 and 3 Training:

Buying the lessons in this bundle normally saves you over 45% off the normal price! Buying them by the 20th of Jan 2003 will save you a futher 50%! All you pay is $49.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 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples. There is also online Microsoft Pivot Table tutorial.

BASIC COURSE 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

Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheet99.95

See Also: All products from OzGrid Business Applications

1. DigDB Excel Add-in Toolkit for Excel2000 & Up 6.3
   Use this Excel add-in toolkit to empower yourself. It removes duplicates - you can dedupe by matching one table against another, or filter, count, purge duplicates by key fields. You can do Access-like query, aggregation, and join.
2. Number Manager
   The number manager fills in the gaps in Excel when working with numbers. It allows you to add 15 different number formats that are not part of Excel's built in number formats.
3. CZ-Xls2Txt COM
   CZ-Xls2Txt COM is a COM component/object designed to assist you, the developer, to quickly add a powerpoint document conversion utility to your application. It can be called from VB, VC, DELPHI.
4. Calc Audit 2.0
   Calc Audit is uses advanced modeling techniques to analyze and graphically present cause and effects in Excel derivations.
5. Excel VBA UserForm Lessons
   10 Lessons and 5 Workbook examples on Excel VBA UserForms
6. Rental Property Analysis Spreadsheet
   Rental Properties are great to own and can make you a lot of money, but you need to buy them right. Much of the money made in rental properties is made when you buy the property.
7. Backup Assistant for Excel
   The Backup Assistant is designed to help you make backup copies of your workbooks before you make changes to them.
8. Excel-to-MySQL
   a program to convert MS Excel spreadsheet into MySQL
9. Company Comparison
   Are you thinking of buying a stock and want to compare key values for up to 4 other securities? Tired of clicking thru multiple pages, printing or cutting and pasting to get all the information that you want in one spot? If so...
10. Worksheet Booster
    Improves the speed required to accomplish routine operations with Excel worksheets. Twenty essential commands accelerate routine worksheet operations, which usually require several steps to accomplish.
11. Savings/Pension Growth - for Windows 3.1
    Savpengr.EXE - This program will calculate a complete annuitization schedule for regular deposits over a duration of up to 40 years.
12. Portfolio Evaluator - for Windows 3.1
    Porteval.EXE - Track your investments in stocks, bonds, or mutual funds with this program.
13. Advanced Excel Find
    Easy and fast search through multiple worksheets and workbooks in Excel. Simultaneous search in values, formulas and comments, free moving around search results and more.
14. E-Secretary
    …schedules and reminds beautifully. A color full scheduler that reminds in a customized manner
15. Mortgage Advisor 1.26
    Mortgage Advisor which provides extensive mortgage calculations and analysis.
16. TorniaiSansUT Family PC
    TorniaiSansUT Family PC
17. Added Payment Amortizationfor Windows 95 or higher
    Addedpmt.EXE - A program illustrating the effect of additional payments for reducing interest paid and the term of a loan.
18. Advanced Excel Select 1.4
    Save your time and nerves when selecting cells with formulas, comments, conditional formats, etc.
19. Biweekly Amortization - for Windows 95 or higher
    Biweekly.EXE - This program calculates and displays the reduced loan period and total payment with this type mortgage.
20. Maxmortgage - for Windows 3.1
    Maxmtge.EXE - A mortgage qualifier for either a fixed- rate or variable-rate mortgage which shows how large a mortgage you qualify for.