Excel Level 1, 2 and 3 Training

Excel levels Basic to Advanced Training

Description of Excel Level 1, 2 and 3 Training:

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

WHY USE US FOR EXCEL TRAINING?

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 spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but al99.00

See Also: All products from OzGrid Business Applications

1. Name Splitter for Microsoft Excel
   quickly and easily split names that are in one cell into individual names in individual cells.
2. IBXL
   IBXL is real-time streaming quotes interface for Interactive Brokers Trader Workstation and Microsoft Excel.
3. Sales Leads 2008 for Excel 2007
   Our Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States.
4. Split-25 Shift Scheduler
   The Split-25 Excel spreadsheet creates schedules where each employee can be assigned to 1 or 2 categories (manager, cook, waiter, etc.), 1 or 2 locations (Store A, Store B, etc.
5. Quick Charts for Microsoft Excel
   Quick Charts for Excel is a menu driven Excel workbook that allows you to construct a graph of one row of data and then to easily change from one row of data to another using the Quick Charts tool bar.
6. NeuroXL Predictor
   NeuroXL Predictor is a powerful, easy-to-use and affordable solution for advanced estimation and forecasting.
7. Model Navigator 1.1
   Monitor and visualize your Microsoft® Excel models with accuracy, quickness and ease. Model Navigator is a useful tool built by Jabsoft, which will allow you, quickly, to make the often performed tasks in your Excel models development.
8. Excel Level 3 & Excel VBA & Excel UserForm Courses
   Excel Level 3 & Excel VBA & Excel UserForms Courses
9. Excel Level 2 Lessons
   10 Lessons and 5 Workbook examples on Excel level 2
10. EziFiler Pro
    Do you have forms that staff fill in on a regular basis? Timesheets? Leave Applications? Travel Requests? Stationary Orders? etc.
11. Financial Statement - for Windows 95 or higher
    Finastmt.EXE - This is a standard personal financial statement that is widely accepted in by banking and mortgage lender institutions.
12. Richworks.Now
    Personal Finance Manager
13. OzGrid excel Addins Collection
    Excel add-ins Collection
14. 15 vs 30 Year Mortgage - for Windows 3.1
    1530mtge.EXE - A program that displays and lists the advantages and pitfalls of using either type of financing.
15. TorniaiSansOsfUT Family PC
    TorniaiSansOsfUT Family PC
16. Annuity/Pension Payout - for Windows 95 or higher
    Anpenpay.EXE - This program demonstrates the length of time an annuity or a pension payout will last conditioned on the amount of monthly payments to you and the interest that will be earned on the balance.
17. Home Buyers Calculator Suite 4.4.01
    Calculate the financial scenarios related to the purchase or sale of real estate
18. Advanced Stock Bar
    An advanced Internet Explorer plugin that makes stock market research easy
19. Retirement Investment Req'd - Windows 95 or higher
    Retirinv.EXE - You can calculate the amount of money you need to be investing monthly to provide a monthly withdrawa supplemented by Social Security, pensions, annuities or other income sources.
20. TorniaiSansUT Light PC
    TorniaiSansUT Light PC