Microsoft Excel

Office Training Home Page

Get to know Excel: Create your first workbook: Length: 40 min
Learn how to create a Microsoft Office Excel workbook, how to enter and edit text and numbers, and how to add and delete columns and rows.

So that's how! Great Excel features: Length: 50 min
Learn five great Microsoft® Excel® features that will help you to work faster and easier.

Printing options in Excel Length: 40 min
See how to get the results you want when you print in Microsoft Office Excel.

Get to know Excel: Enter formulas Length: 50 min
Get to know Microsoft® Excel by learning how to perform simple calculations. Get started by learning to enter simple formulas into worksheets.

Charts I: How to create a chart Length: 30 min
Charts transform data into pictures. Take this course to learn how to create charts in Microsoft Excel.

Charts II: Choose the right chart type Length: 30 min
Selecting the most effective chart type will make your data clearer, stronger, and more informative. Microsoft Office Excel offers a wide variety of chart types and simple methods for selecting and previewing them.

Charts III: Create a professional-looking chart Length: 40 min
You know how to create a chart in Microsoft® Office Excel 2003 and choose the most effective chart type. Now learn how to customize it, enhance its appearance, and change any of the information on the chart.

Charts IV: Charts for the scientist Length: 45 min
Learn how to use the chart features in Excel to accomplish scientific tasks such as adding a trendline to data or using error bars.

Import data: Import text files into Excel Length: 30 min
Learn how to import text files into Microsoft Office Excel so that you can work on the data in Excel, and how to update the imported data if the external data changes.

Import data: Import external data into Excel Length: 20 min
Learn to import data that is stored in a database into Microsoft Office Excel by using the Data Connection Wizard.

Import data: Filter external data before importing it into Excel Length: 30 min
Learn to filter and sort data that is stored in a database by using Microsoft Query before importing into Microsoft Office Excel.

Lists I: How to use lists in Excel 2003 Length: 20 min
There's a new List command in Microsoft Excel 2003 that makes it easy to sort and filter data and to total up values.

Lists II: Publish Excel 2003 lists to a SharePoint site Length: 20 min
In Microsoft Office Excel 2003, you can share list data with others by publishing the list to a Web site based on Microsoft Windows® SharePoint® Services. Once the list is published, you can update it from Excel, and others who have the permissions can add or revise list data from the SharePoint site. Take this course to learn how.

PivotTable I: What's so great about PivotTable reports? Length: 30 min
Learn about the little-known, yet powerful, Microsoft Office Excel PivotTable feature, which organizes, summarizes, and analyzes your data to reveal its meanings.

PivotTable II: Swing into action with PivotTable reports Length: 40 min
Learn even more about the ins and outs of working with Microsoft® Excel PivotTable® reports.

PivotTable III: Show off your PivotTable skills Length: 50 min
Learn even more advanced ways to use Microsoft® Excel PivotTable® reports, including how to use formulas with report data.

Work with the keyboard Length: 40 min
Learn how to find a complete list of keyboard shortcuts for each Microsoft® Office program and to use them in menus, in toolbars, and in the document itself.

Help secure and protect data in Excel Length: 40 min
Learn what you can do to help keep data secure in Microsoft Excel. Use passwords so that only you, or a select few, can open a workbook. See how to help protect data from being changed by others. And learn some basic information about computer viruses, macros, and digital signatures.

So that's how! Working with really big worksheets Length: 40 min
Learn how to work with ease in really big Microsoft Excel worksheets. Keep column and row names in sight no matter where you are on a worksheet, navigate to the far end of the largest worksheet by using a keyboard shortcut, move and copy sheets, and filter and sort data by using the AutoFilter arrows.

All about AutoFilter Length: 30 min
AutoFilter selects and shows you only the data you want to see in Microsoft Excel.

Use formulas to edit, correct, and proofread text Length: 50 min
Learn how to save time by using formulas instead of retyping to work with text in Microsoft® Excel.

Plan payments and savings by using financial formulas Length: 50 min
Learn how to use Microsoft® Excel formulas to figure out payments, savings, and other financial numbers.

Find functions and enter arguments Length: 30 min
Learn how to find Microsoft® Excel functions by using the Insert Function dialog box. Get to know function arguments and the ways to learn more about them.

Make time count by using formulas Length: 30 min
Learn how to calculate times by using formulas in Microsoft® Excel.

Figure out dates by using formulas Length: 40 min
Learn how to figure out dates by using formulas in Microsoft® Excel.

Excel statistical functions Length: 50 min
Learn about using statistical functions and formulas in Microsoft Office Excel 2003, from the very basics to choosing the right function for you. Learn also how to troubleshoot common problems.

Customize your toolbars and menus Length: 50 min
Learn how to change existing toolbars and menus, including the shortcut menu, and how to create your own toolbars and menus in Microsoft® Office programs.

See what you can do with the Research service Length: 30 min
Need a definition, a synonym, facts about a company's finances, an encyclopedia article, or other types of information from the Web? Then the new Research service in Microsoft Office 2003 is for you.

Organize your clip art and other media Length: 20 min
Microsoft Clip Organizer is a Microsoft Office tool that arranges and catalogs clip art and other media files stored on your hard disk. Learn how to make Clip Organizer work for you and to quickly find the clips you need.