Excel 2003 training courses

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


. 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 languag

e, 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.

Applies to:
Excel 2003