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. Multi-Cell Goal Seeker for Microsoft Excel
   The Multi-Cell Goal Seeker for Microsoft Excel allows you to get goal seek solutions to many spreadsheet cells at one time.
2. EldoS AutoSaveXL 1.5
   AutoSaveXL is Excel plugin that saves the files automatically.
3. 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.
4. Addintools Assist
   Convert data format between Date, Numeric, Text. Recognize more than ten formats of date: 12/31/2006, 2006-12-31, 2006.12.31... Recognize more than 36 formats and convert to numeric: '123.45, (1.23)E2, (1) 1/3 ...
5. Easy Hour Assignments for 25 People with Excel
   The Easy Hours Scheduler saves you scheduling headaches and time by letting you simply specify your daily staffing needs and then assign them to up to 25 people by inserting a number in the start time column.
6. Financial Advisor (English Version)
   Borrowing, business profitability, discounted cash flows, financial planning, investing, bonds, cost of capital, options...
7. Investment & Business Valuation 1.0
   The Investment Valuation model by Excel Business Tools
8. Categorizing Data for Excel
   If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.
9. Visual Basic Collection for Microsoft Excel
   The Visual Basic collection contains two downloadable books on Excel macros: Visual Basic Macros Made Easy and Visual Basic Macro Examples.
10. TradeMax Trade Manager
    TradeMax Trade Manager is an Excel spreadsheet that tracks open and historical long and short stock trades, calulates profit/loss, commissions and stops based on inputs...
11. Excel Duplication Manager Add-in
    Manage duplicate data in your Workbook with ease.
12. 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.
13. COMxL RS232C
    Link a measuring instrument to YOUR Excel worksheet via RS232 port
14. Excel Level 3 Lessons
    10 Lessons and 5 Workbook examples on Excel level 3
15. Retirement Investment Required - for Windows 3.1
    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.
16. To Do List Assistant for Microsoft Excel
    Manage your to do lists within Microsoft Excel!
17. 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.
18. TorniaiSansOsfUT Bold PC
    TorniaiSansOsfUT Bold PC
19. Loan Amortization - for Windows 95 or higher
    Loanamor.EXE - This program is a standard amortization schedule which displays annual interest paid for your use at tax time and it can also be used for any simple interest loan with multiple payment periods.
20. 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.