Course Description: Understand the more advanced features of Excel 2003, the spreadsheet program widely used for financial and data management purposes. Learn how to use array formulas, special formatting, and VLOOKUP to make tasks easier.
| Lessons |
Time
(Min:Sec) |
|
|---|---|---|
| Introduction PREVIEW, CLICK HERE | 01:59 | |
| Array Formulas PREVIEW, CLICK HERE | 08:24 | |
| Cost Extension PREVIEW, CLICK HERE | 05:15 | |
| Sorting | 02:56 | |
| Functions | 03:56 | |
| Amortization Schedule | 05:44 | |
| Saving Files | 06:31 | |
| Show Formulas | 01:27 | |
| VLOOKUP | 06:53 | |
| Find Functions | 02:55 | |
| Protecting Cells | 04:53 | |
| Graphing Screen | 08:00 | |
| Drawing Toolbar | 02:25 | |
| Cell Orientation | 02:38 | |
| Special Formatting | 02:28 | |
| Conditional Formatting | 05:24 | |
| Specifications | 02:14 | |
| Summary | 00:29 |
Microsoft Excel Online Training Tutorial
Microsoft Excel is a spreadsheet program that is widely used for financial and other data management purposes. It features calculation, graphing tools, PivotTables, and a macro programming language called VBA (Visual Basic for Applications).
Microsoft Excel 2003 Advanced Course Objective
At the end of this course, you will be able to: use array formulas, sort personal data, use Excel functions, create an amortization schedule, use the VLOOKUP function, protect cell data, create graphs using Excel data, format data to your specific needs, and much more.
How can a Group Excel Training Program help my business?
Excel is one of the most used spreadsheet applications for business today. Imagine your entire staff using Microsoft Excel effectively and efficiently. Your business could save both time and money by understanding the capabilities and shortcuts of Microsoft Excel.
How does this Group Excel Training Program work?
With your group account, your entire company will have unlimited access to this course—and to every other course in our library—for one full year. Your staff can access this course from anywhere at anytime. They will also be able to receive a Certificate of Proficiency after reviewing the entire course and passing the test we have provided. All you have to do is log in, select, click, and watch.
To access this lesson, you need to log in to your account.
Enter your username and password in the boxes at the top right corner of this page.
