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. Excel Level 3 Lessons
   10 Lessons and 5 Workbook examples on Excel level 3
2. Spreadsheet Assistant for Microsoft Excel
   Save time in Microsoft Excel with the Spreadsheet Assistant.
3. ESQuotes 2.0.0
   Excel add-in for quoting stocks, options, mutual funds. Free real time quotes, historical data, alerts. Ideal to watch & research stocks, options & mutual funds your way. Uses simple & familiar =functions(). Works with all internet connections.
4. Spreadsheet xlNavigator 2003 TM
   Intuitive display of Spreadsheet cell dependencies
5. XLChartPro & XLTradeLink Bundle
   An Excel addin to Create Point and Figure Charts from a variety of data sources
6. To Do List Assistant for Microsoft Excel
   Manage your to do lists within Microsoft Excel!
7. Consolidation Assistant for Microsoft Excel
   The Consolidation Assistant is designed to help you consolidate data from multiple workbooks or from multiple worksheets.
8. OM-SKED1A
   Excel Spreadsheet Template for Job sequencing a single work station.
9. Time Sheet Advanced
   This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
10. Complete Excel Course
    Excel Levels 1, 2, 3 VBA and UserForms Courses
11. Excel Download Package
    Over 33 Excel & VBA Workbook Examples
12. Home Buyers Calculator Suite 4.4.01
    Calculate the financial scenarios related to the purchase or sale of real estate
13. Excel Level 1, 2 and 3 Training
    MS Excel Training for newsletter members only
14. 15 vs 30 Year Mortgage - for Windows 95 or higher
    1530mtge.EXE - A program that displays and lists the advantages and pitfalls of using either type of financing.
15. Spreadsheet Assistant for Microsoft Excel
    Save time in Microsoft Excel with the Spreadsheet Assistant.
16. Excel Level 3 Lessons
    10 Lessons and 5 Workbook examples on Excel level 3
17. Employee Scheduler in Excel
    An Excel-based scheduler for hourly and salaried employees. Allows you to schedule hours as a percentage of your anticipated revenue.
18. OM-FACILITY LOCATION
    Excel Spreadsheet Templates for locating distribution center.
19. OM-ACCEPTSA
    Excel Spreadsheet Templates for Quality Control, Acceptance sampling.
20. Added Payment Amortization - for Windows 3.1
    Addedpmt.EXE - A program illustrating the effect of additional payments for reducing interest paid and the term of a loan.