Microsoft Excel 2003
by Kate J. Chase
Start the free chapterExcel 2003 enables you to turn data into information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. Author Kate J. Chase's extensive knowledge of Excel 2003 will have you using it like a pro by the end of the tutorial. From simple spreadsheets to complex databases, it is all covered in VTC's Microsoft Excel 2003 tutorial. To begin learning today, simply click on the links below.
Course content
Introduction To Excel 20036 lessons
Installing Excel 20035 lessons
Getting Assistance With Excel 20034 lessons
Excel 2003 Basic Concepts20 lessons
- Worksheets and Workbooks2:521 credit or ad
- Organization2:031 credit or ad
- Differences Between Text & Data Values3:051 credit or ad
- Labels and Names3:211 credit or ad
- More About Labels2:281 credit or ad
- More about Cells and Cell Ranges2:341 credit or ad
- About Mathematical Operators & Operands3:031 credit or ad
- About Formulas & Calculations2:131 credit or ad
- The Role of Functions3:211 credit or ad
- Types of Charts2:051 credit or ad
- Forms/Including Data Forms2:481 credit or ad
- The Job of Queries2:251 credit or ad
- What are Workbook Audits2:471 credit or ad
- Importing and Exporting1:571 credit or ad
- Linking and Embedding1:351 credit or ad
- Absolute vs Relative Cell References3:111 credit or ad
- What About Smart Tags?2:141 credit or ad
- What is XML?2:291 credit or ad
- Locking/Freezing Cells/Splitting Work Area3:311 credit or ad
- About Excel Security2:531 credit or ad
First Hands On In Excel9 lessons
- Launching Excel 20033:191 credit or ad
- Planning Your Worksheet or Workbook1:541 credit or ad
- Labeling & Naming Worksheet/Workbook3:381 credit or ad
- A Look at Our Example Layout2:511 credit or ad
- Naming and Saving Your Workbook2:591 credit or ad
- Renaming and Deleting a Workbook2:581 credit or ad
- Printing Your Workbook2:001 credit or ad
- Double Check Workbook & Exit2:581 credit or ad
- Opening an Existing Workbook2:141 credit or ad
Customizing Excel 20037 lessons
- About Excel Customization1:391 credit or ad
- Customizing Excel Menu Bar2:011 credit or ad
- Customizing Excel Toolbars4:311 credit or ad
- Changing Page Setup2:321 credit or ad
- Modifying Default Location of Saved Work3:231 credit or ad
- Setting Up Options â Pt.12:201 credit or ad
- Setting Up Options â Pt.23:141 credit or ad
Entering Your Information9 lessons
- About Entering Your Information3:351 credit or ad
- Entering Labels and Values4:021 credit or ad
- More About Multiple Entries2:551 credit or ad
- Understanding Multiple Selections2:271 credit or ad
- Inserting/Deleting Rows & Columns3:071 credit or ad
- Copying & Pasting Columns/Rows & Cells4:061 credit or ad
- Moving Columns/Rows & Cells3:051 credit or ad
- Adding a Smart Tag3:591 credit or ad
- Editing Your Work3:531 credit or ad
Formatting Your Work13 lessons
- Introduction to Formatting2:451 credit or ad
- Formatting Text & Data Pt.13:581 credit or ad
- Formatting Text & Data Pt.24:461 credit or ad
- Using AutoFormat2:091 credit or ad
- Changing AutoFormat Options2:091 credit or ad
- Adding Colors and Patterns3:041 credit or ad
- Adding Borders3:171 credit or ad
- What is Conditional Formatting?2:301 credit or ad
- Applying Conditional Formatting3:111 credit or ad
- Copying Cell Formatting2:341 credit or ad
- About Styles2:001 credit or ad
- Creating a Style3:151 credit or ad
- Applying and Modifying a Style2:521 credit or ad
Adding Elements To A Workbook10 lessons
- Introduction to Adding Elements2:301 credit or ad
- Adding Images to a Workbook3:421 credit or ad
- Modifying Images Inserted in Workbook4:141 credit or ad
- Adding Clips2:371 credit or ad
- Diagramming in Excel4:151 credit or ad
- Adding an Organizational Chart2:151 credit or ad
- Changing an Organizational Chart2:081 credit or ad
- Adding WordArt3:101 credit or ad
- Adding a Hyperlink4:031 credit or ad
- Inserting Objects Such as AutoShapes5:041 credit or ad
Calculation With Formulas and Functions5 lessons
Managing Data With Excel17 lessons
- Use it or Lose it4:291 credit or ad
- Using Forms/Particularly Data Forms3:061 credit or ad
- Entering Data Using a Data Form3:381 credit or ad
- Managing Data from a Data Form2:211 credit or ad
- About Using Excel as a Database2:101 credit or ad
- What are Lists?3:471 credit or ad
- Creating a List5:221 credit or ad
- Entering Data into a List2:581 credit or ad
- Sorting Data in a List3:221 credit or ad
- Using Filters to Sort Lists4:431 credit or ad
- Auditing Excel Data3:501 credit or ad
- Other Validation and Error Checking4:261 credit or ad
- More About Validation for Data Entry2:551 credit or ad
- Performing Queries4:011 credit or ad
- Exporting Data from Excel1:561 credit or ad
- Linking Data Pt.15:371 credit or ad
- Linking Data Pt.23:471 credit or ad
Working With Charts4 lessons
Sharing & Collaborating With Excel 20037 lessons
- Sharing Your Worksheet or Workbook2:111 credit or ad
- Sending Your Workbook for Review2:391 credit or ad
- Using Online Collaboration2:321 credit or ad
- Protecting Your Workbook3:101 credit or ad
- Change Different Versions of a Workbook3:571 credit or ad
- Adding/Editing/Deleting Comments3:381 credit or ad
- Creating & Sharing a Workbook Template4:101 credit or ad