Excel Level 1 Lessons

10 Lessons and 5 Workbook examples on Excel level 1

Description of Excel Level 1 Lessons:

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.

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. FinExcelSoft Financial Templates
   Product title: FinTemplates Contains 56 Excel financial templates: 1. npv.xls - NPV & IRR for periodic cash flows templates 2. npvirrdate.xls - NPV & IRR for any cash flows templates 3. mirr.xls - MIRR template 4. sec.xls - 26 securities templates 5.
2. PerlXL Add-In Builder
   The PerlXL Add-In Builder lets you build custom, compiled XLL Excel Add-In files using nothing but Perl and the Add-In Builder. Generated XLL files can be redistributed and installed on machines that don't even have perl installed.
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. Ultimate Business Forms
   Ultimate Business Forms is a comprehensive collection of 85 different intelligent Excel templates designed by professionals.
5. Company Comparison
   Are you thinking of buying a stock and want to compare key values for up to 4 other securities? Tired of clicking thru multiple pages, printing or cutting and pasting to get all the information that you want in one spot? If so...
6. Loan Assistant for Microsoft Excel
   The Loan Assistant tells you in advance what your loan payments will be for any loan. It also generates amortization tables showing the amount of principal, unpaid balance and interest by week, month, or year.
7. OM-MULTIMON
   Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment
8. Backup Assistant for Excel
   The Backup Assistant is designed to help you make backup copies of your workbooks before you make changes to them.
9. Directory Lister for Microsoft Excel
   The Directory Lister is like having the Windows Explorer inside Excel! Create lists of all the files in your directories, and open any file by clicking on it. Or just print the lists!
10. DB for Outlook 2002
    DB for Outlook provides Microsoft. Excel and Outlook users to develop a database from select e-mails.
11. OM-FACILITY LOCATION
    Excel Spreadsheet Templates for locating distribution center.
12. TorniaiSansUT Regular PC
    TorniaiSansUT Regular PC
13. Excel-to-MySQL
    a program to convert MS Excel spreadsheet into MySQL
14. OzGrid excel Addins Collection
    Excel add-ins Collection
15. Random Sampler for Microsoft Excel
    Use the Random Sampler to randomly select your samples!
16. TorniaiSansOsfUT Light PC
    TorniaiSansOsfUT Light PC
17. Balloon Amortization - for Windows 3.1
    Balloon.EXE - A program that explores the use of this type mortgage to reduce initial payments.
18. VOShoppingList for Windows
    The #1 Pocket PC Shopping List comes to your Windows desktop! Easily manage, print and email your lists for any number of stores.
19. Advanced Stock Bar
    An advanced Internet Explorer plugin that makes stock market research easy
20. TrigleUT Family PC
    TrigleUT Family PC