Office Training Home Page
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
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
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.
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
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
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
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 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
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
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
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
Make time count by using formulas Length: 30 min
how to calculate times by using formulas in Microsoft® Excel.
Figure out dates by using formulas Length: 40 min
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
how to change existing toolbars and menus, including the shortcut menu, and
how to create your own toolbars and menus in Microsoft® Office
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.