Excel 2003 training courses - Excel - Microsoft Office Online

Click here to switch to other Office Online sites worldwide

United Kingdom (change) | All Microsoft Sites

	Microsoft Office Excel

Search

	Try Office for free Buy Office 2007
Get Office 2007

	Technical support Sign up to Office Insider newsletter
Help & support

	Check for free updates
Office updates

Microsoft Office Excel

» Excel Home

Product Information

» Overview

» Top 10 Benefits

» See it in Action

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Excel 2007 Help

» Excel 2003 Help

» Excel 2002 Help

» Excel 2000 Help

Choose your version

» Excel Web Access

Training

» Excel 2007 Training

» Excel 2003 Training

» Excel 2007 Demos

» Excel 2003 Demos

Templates

» Templates for Excel

A roadmap to Excel 2003 training:

1. A great place to start

Course	What you’ll learn
Get to know Excel: Create your first workbook	How to create a workbook, enter and edit text and numbers, and add rows or columns
Get to know Excel: Enter formulas	How to enter simple formulas into worksheets, and how to make formulas update their results automatically
Audio course: Get to know Excel: Enter formulas	What a sound value Excel offers you
Help secure and protect data in Excel	How passwords, encryption, security level settings, and digital signatures can help make you safer
So that's how! Great Excel features	How to keep column titles or row titles in view while you scroll, how to add numbers just by selecting them, how to make the formatting change automatically, and more
Audio course: So that's how! Great Excel features	How those same great features sound when you hear someone read the whole course aloud to you

2. Get it on paper

Course	What you’ll learn
So that's how! Printing options in Excel	How print preview helps with everything, how to fit your data onto a page, how to make row and column titles appear on every page, and how to use headers and footers

3. Make a list, make it available

Course	What you’ll learn
Lists I: How to use lists in Excel 2003	How to use the List command in Excel 2003 to sort, filter, and total data
Lists II: Publish Excel 2003 lists to a SharePoint site	How to publish an Excel 2003 list to a SharePoint site. How to synchronize the Excel list, so that when you make changes to it, the SharePoint list gets updated at the same time
All about AutoFilter	How to see only the text or numbers you want, and how to create filters for your particular needs

4. It's all about formulas

Course	What you’ll learn
Plan payments and savings by using financial formulas	How to use formulas to figure out payments, savings, and other financial numbers
Use formulas to edit, correct, and proofread text	How to save time by using formulas instead of retyping to work with text in Excel
Excel statistical functions	How to use statistical formulas, from the basics to making smart choices
Make time count by using formulas	How many hours did you work this week? What's the total if you deduct your lunchtimes?
Figure out dates by using formulas	How to find the number of days between dates, or the date after a number of workdays, or the date after a number of days, months, or years
Find functions and enter arguments	How to find and use a formula by telling Excel what you want to do

5. A picture is worth a thousand numbers

Course	What you’ll learn
Charts I: How to create a chart	How to use the Chart Wizard and what names chart parts have
Charts II: Choose the right chart type	How to pick a chart type that packs a punch for your point. How to combine charts, when two go better together
Charts III: Create a professional-looking chart	How to add visual interest to charts and make them more meaningful, using simple built-in formatting effects
Charts IV: Charts for the scientist	How to give your chart the look that a scientific audience expects, with trendlines, error bars, Greek letters, and symbols

6. Make the data dance: PivotTable reports

Course	What you’ll learn
PivotTable I: What's so great about PivotTable reports?	How PivotTable reports organize, summarize, and analyze your data to reveal its meanings. How to create a PivotTable report yourself — fast!
PivotTable II: Swing into action with PivotTable reports	How to organize data, how to plan your report, how to change your report, and how to run numbers inside the report
PivotTable III: Show off your PivotTable skills	Power tools: how to use more than one field in the same drop area, how to group data for quarterly summary instead of daily summary, how to use summary functions other than SUM, and how to use custom calculations and calculated fields

7. Import data

Course	What you’ll learn
Import external data into Excel	How to use a wizard to import data from a database, and how to update that data by using the connection you've made
Filter external data before importing it into Excel	How the Query Wizard helps you to filter and sort database data before you import it into Excel
Import text files into Excel	How simple it is to import text into Excel

8. XML the language, or XXL the extralarge worksheet?

Course	What you’ll learn
So that's how: Using XML in Excel 2003	How to create an XML list, how to create an XML map, how to import and export XML data to and from mapped worksheet cells, and how to use the XML Source task pane
So that's how! Working with really big worksheets	How to name cells so you can quickly return to those worksheet regions, how to group worksheets so you can enter common data in multiple worksheets simultaneously, how to print multiple worksheets at the same time, and more
Audio course: So that's how! Working with really big worksheets	How those same features sound when the whole course is read aloud to you

9. Macro hard? Not a bit

Course	What you’ll learn
Get in the loop with Excel macros	How to add a macro to a workbook, how to customize a macro, and to use a loop macro on a range of data

Note You can also download shorter PowerPoint versions of some courses, or you can download the Quick Reference Cards that summarize each course.

And that's not all – the whole schmeer

Online training isn't just for Excel. It's also available for the other programs in the Microsoft Office System. Because the more you know, the better you do.

Get Office 2007