Excel 2003

1. Working with Data. Task # 1: Enter Numbers and Fractions. Task #2: Enter Dates and Times. Task #3: Name Cells and Ranges. Task #4: Validate Data Entry Using a Pick List. Task #5: Extend a Series of Dates with AutoFill. Task #6: Add a Symbol or Special Character. Task #7: Compare Multiple Spreadsheets Using Freeze Panes. Task #8: Hide Rows to Compare Data with Outlining. Task #9: Access Excel by Keyboard. Task #10: Access Excel by Voice with Speech Recognition. Task # 11: Find and Replace Data. Task #12: Generate a Worksheet with InfoPath. 2. Working with Formulas and Functions. Task #13: Add Values in Different Ways. Task #14: Make Magic with the Function Wizard. Task #15: Document Formulas with Comments. Task #16: Document Worksheets with OneNote. Task #17: Define a Constant. Task #18: Apply Names in Functions. Task #19: Figure Out the Best Loan Terms. Task #20: Determine the Internal Rate of Return. Task #21: Determine the Nth Largest Value. Task #22: Create a Conditional Formula. Task #23: Calculate a Conditional Sum. Task #24: Discover Your Inner Calculator. Task #25: Find Products and Square Roots. Task #26: Calculate the Duration Between Two Times. Task #27: Calculate Days Between Two Dates. Task #28: Change Text to Numbers. 3. Copying Data, Formats, and More. Task #29: Copy a Range with the Office Clipboard. Task #30: Transpose a Row into a Column. Task #31: Copy Styles to Another Workbook. Task #32: Copy Chart Formatting into Another Chart. Task #33: Copy Formulas with Paste Special. Task #34: Track Changes while Editing. 4. Using Excel Lists. Task #35: Generate a List Automatically. Task #36: Enter List Data Using a Form. Task #37: Import a Word List into Excel. Task #38: Sort and Filter a List. Task #39: Sort by Multiple Criteria. Task #40: Find Averages in a Sorted Group. Task #41: Filter by Multiple Criteria. Task #42: Remove Duplicate Records from a List. Task #43: Count Filtered Records. Task #44: Filter by Multiple Criteria in the Same Column. Task #45: Chart a Filtered List. Task #46: Look Up Information in a List. 5. Exploring Patterns in Data. Task #47: Create a PivotTable. Task #48: Modify PivotTable Data and Layout. Task #49: Find the Average of a Field. Task #50: Create a Calculated Field. Task #51: Hide Rows or Columns in a PivotTable. Task #52: AutoFormat a PivotTable. Task #53: Create a PivotChart. Task #54: Describe Data with Statistics. Task #55: Discover Associations within Your Data. Task #56: Explore Outcomes with What--If Analysis. Task #57: Optimize a Result with Goal Seek. 6. Creating Charts. Task #58: Create a Chart. Task #59: Modify Chart Details. Task #60: Change the Chart Type. Task #61: Add a Trendline to a Chart. Task #62: Add and Remove Chart Data. Task #63: Visually Represent Missing Chart Data. Task #64: Use Error Bars in a Chart. Task #65: Pull a Slice from a Pie Chart. Task #66: Label the Slices of a Pie Chart. Task #67: Create a Histogram. Task #68: Paste a Chart into Word. Task #69: Paste--link a Chart into Word. 7. Presenting Worksheets. Task #70: Format Numbers as Percentages. Task #71: Format Currencies in Currency and Accounting Formats. Task #72: Format Column Headings. Task #73: Format Quickly with Format Painter. Task #74: Group Formats in a Style. Task #75: Insert a Background Image into Your Worksheet. Task #76: Create a Transparent Image. 8. Saving and Printing Worksheets. Task #77: Save a Workbook as a Template. Task #78: Save a Workbook as an XML Spreadsheet. Task #79: Print Multiple Cell Ranges on One Page. Task #80: Print Multiple Areas of a Workbook. Task #81: Print Multiple Worksheets of a Workbook. Task #82: Repeat Headings of a Row or Column. Task #83: Print Functions to Show Calculations. 9. Extending Excel. Task #84: Hyperlink a Worksheet to Another Office Document. Task #85: Embed a Chart within PowerPoint. Task #86: Publish an Interactive Workbook. Task #87: Import a Worksheet from the Web. Task #88: Query a Web Site. Task #89: Query an Access Database. Task #90: Reuse a Saved Query. Task #91: Import a Worksheet into Access. Task #92: Use Excel Data to Create Labels in Word. 10. Customizing Excel. Task #93: Add Features by Installing and Using Add--Ins. Task #94: Launch a Specific Workbook when Excel Opens. Task #95: Create a Custom Workspace. Task #96: Save Time by Creating a Custom View. Task #97: Create a Custom Number Format. Task #98: Create a Macro to Format Numbers. Task #99: Create a Button to Run a Macro. Task #100: Enlarge Screen Elements.