Excel 2007 Level 2 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.

Description of Excel 2007 Level 2 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 10 lessons, each between 5 and 10 Word Document pages long, and 5 Workbook examples.

BASIC COURSE OUTLINE:

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.

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 also Excel developers!

See Also: All products from Dave Hawley

1. FastStart Necessary Forms Pack
   The FastStart Necessary Forms Pack contains fourteen Excel spreadsheet templates and forms for your business - Purchase Order, Purchase Order Log, Invoice, Service Invoice, Invoice Log, Shipping Order, Bill of Lading, Expense Statement, Cash Receipt...
2. Alyuda Forecaster XL
   Alyuda Forecaster XL is a forecasting tool for MS Excel based on neural networks. It is targeted for Excel users who need a quick-to-learn and reliable forecasting tool embedded into familiar Excel interface.
3. DigDB Excel Add-in Toolkit for Excel97 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.
4. Configuration Management Spreadsheet
   This impact zone includes all the controls required for hardware and software configuration. The price includes a subscription to a full year of updates.
5. Text Manager
   The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.
6. Excel VBA UserForm Lessons
   10 Lessons and 5 Workbook examples on Excel VBA UserForms
7. Multiple Seek Target 1.0
   The Multiple Seek Target is an Excel add-in, which allows you to get target seek solutions to many spreadsheet cells at one time by configuring the seek target wizard. It does multiple re-calculations automatically.
8. Portfolio Tracking & Monitoring 1.0
   An Excel template for the ongoing monitoring of your financial investment portfolio.
9. Analysis Collection for Microsoft Excel
   Get two downloadable books on Excel macos, another on time saving solutions, and 19 time saving add-ins, including the Spreadsheet Assistant.
10. Macro Button Assistant for Microsoft Excel
    The Macro Button Assistant for Microsoft Excel expands your choice of macro buttons from the smiley face button to over 1700 buttons.
11. AVI to GIF SWF Converter
    AVI to GIF SWF Converter is a software tool to convert any AVI files to GIF and SWF files. It can convert the video to GIF and SWF (and include audio or not for SWF). The GIF and SWF files can be set to auto start play when loading, can loop play or not.
12. PhoneBook
    Simple to use telephone book. Keeps track of people, phone numbers, addresses, emails, and additional information.
13. ValidInstaller
    Creates professional Setups for Pocket PC. The clear wizard guides you to a ready installation.
14. 4Videosoft iPod Manager for Mac
    4Videosoft iPod Manager for Mac also acts as Mac to iPod Manager and iPod to Mac Manager.
15. Only Truth in Science Counts
    Truth in Science Counts is a multimedia, interactive, Adventure in Science, exploring the Universe we live in.
16. BCG Matrix
    BCG Matrix for Excel. This application allows you to create BCG Charts in excel based on your data. The entire process is automated and you generate BCG Charts with a click of a button.
17. The Heirs to St.Pauli
    The Heirs to St.Pauli - The Reeperbahn Game Ready to dive directly into your new business as the boss of Hamburg?s world-famous Redlight District St.
18. GE Matrix
    GE / McKinsey Matrix for Excel. This application allows you to create your own GE/McKinsey Charts in excel based on your data. The entire process is automated and you can generate your charts with a click of a button.
19. QR Code Fontware and Writer SDK
    This package includes the following contents: One true type fonts targeting 600 dpi laser printers - mrvqrcode.ttf. The user manual, which you are reading on. QRCode Encoder GUI, a GUI program to create barcode strings based on data entered.
20. Music Making in MS Word
    Music Notation for MS Word makes it easy to enhance Microsoft Word documents with music notation.