Excel Level 2 Lessons

10 Lessons and 5 Workbook examples on Excel level 2

Description of Excel Level 2 Lessons:

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 OzGrid Business Applications

1. Spreadsheet Presenter
   Spreadsheet Presenter is an add-in for Microsoft Excel which will allow you to customise your charts and reports in Excel as you want.
2. Duplicate Finder forMicrosoft Excel
   Finds duplicates within a list or between two lists. The lists can be on different worksheets or in different workbooks
3. Waterfall Chart Creator
   Create waterfall charts quickly and easily with the Waterfall Chart Creator. Waterfall charts plot a set of rectangles representing the size of the X and Y values. For example, volume versus earnings by product.
4. Excel VBA Level 1 and Excel UserForms
   Excel VBA Training Level 1 and Excel UserForms and Controls
5. ExcelPipe Lite
   ExcelPipe is used by IT personnel to repair hyperlinks when a server gets renamed, by SMEs and large organisations when they change their contact details/name/etc, by translators to apply massive search/replace lists - the list of uses is endless.
6. Ultimate Business Forms
   Ultimate Business Forms is a comprehensive collection of 85 different intelligent Excel templates designed by professionals.
7. ABC Amber QuattroPro Converter 1.03
   ABC Amber QuattroPro Converter is an advanced tool to convert your QuattroPro spreadsheets into any format you wish (PDF, DBF, CSV, XML, XLS, CHM, HTML, RTF, HLP, DOC, TXT, etc.) easily and quickly.
8. ZRandom for Excel 1.2
   ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm : * Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
9. XLTradeLink
   An Excel addin to link data from a variety of data sources
10. Spreadsheet xlNavigator 2003 TM
    Intuitive display of Spreadsheet cell dependencies
11. Portfolio Fundamentals - for Windows 3.1
    Portfund.EXE - This program gives you a place to input the financial data for a given stock so that you might better forecast and track its performance.
12. TorniaiSansUT BlackItalic PC
    TorniaiSansUT BlackItalic PC
13. TorniaiSansOsfUT Light PC
    TorniaiSansOsfUT Light PC
14. TorniaiSansUT Bold PC
    TorniaiSansUT Bold PC
15. ASAP Euro Converter
    The ASAP Euro Converter is an easy to use, professional Euro conversion program, which automates the process of converting your financial data to Euro and vice versa.
16. Mortgages+ for Windows 3.1
    Mrtgages.EXE - A collection of 8 mortgage type programs
17. Richworks.Now
    Personal Finance Manager
18. TorniaiSansUT Heavy PC
    TorniaiSansUT Heavy PC
19. TimeAndWageBook
    Calculate employee time and wages in an Excel Workbook
20. TorniaiSansUT Black PC
    TorniaiSansUT Black PC