You are previewing Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours.
O'Reilly logo
Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Book Description

For readers who are new to Excel 11 and want to get up and running quickly, Sams Teach Yourself Microsoft Excel 2003 in 24 Hours will do the trick. This book includes shortcuts and ways to accomplish the most common tasks in Excel. Readers are able to work at their own pace through the easily digestible, one-hour lessons. After completing the lessons, the reader will have a solid foundation of the basics and know the most efficient way to utilize the new version of Excel.

Table of Contents

  1. Copyright
  2. About the Author
  3. Acknowledgments
  4. We Want to Hear from You!
  5. Introduction
  6. Excel Basics
    1. Getting Started
      1. What Is Excel?
      2. Planning Strategies for Excel Worksheets
      3. Starting Excel
      4. Looking at the Excel Screen
      5. Working with Toolbars
      6. Using Excel Menus and Dialog Boxes
      7. Working with Dialog Boxes
      8. Examining the Task Pane
      9. Getting the Most Out of Help
      10. Moving Within a Workbook
      11. Summary
      12. Q&A
    2. Entering Data
      1. Typing Data in a Cell
      2. Entering Labels
      3. Automating Your Work
      4. Creating a Simple Spreadsheet
      5. Entering Values
      6. Adding Dates and Times
      7. Copying from Cell to Cell
      8. Making Changes to the Worksheet
      9. Inserting and Deleting Cells
      10. Working with Rows and Columns
      11. Summary
      12. Q&A
    3. Organizing Your Files
      1. Saving Your Workbook
      2. Saving Your Work for the First Time
      3. Saving Your Work Later
      4. Understanding Excel Filenames
      5. Protecting Your Work with AutoRecover
      6. Saving an Existing Workbook with a New Name
      7. Other Save Options
      8. Rearranging Your Files
      9. Summary
      10. Q&A
    4. Managing Your Files and Workbooks
      1. Creating a Blank Workbook
      2. Opening an Existing Workbook
      3. Making Use of the Getting Started Task Pane
      4. Searching for the Right File
      5. Working with Workbooks and Worksheets
      6. Getting a View of the Workbook
      7. Using Ranges
      8. Changing Worksheet Views
      9. Workbook and Worksheet Navigation Tools
      10. Summary
      11. Q&A
    5. Letting Excel Do the Math
      1. Why Use Formulas?
      2. How Formulas Work
      3. Creating a Simple Formula
      4. Referencing Cells
      5. Using AutoSum
      6. Using Range Names in Formulas
      7. Using Relative and Absolute Addressing
      8. Copying Formulas
      9. Troubleshooting Formula Errors
      10. Summary
      11. Q&A
    6. Using Excel Templates
      1. What Is a Template?
      2. Exploring Excel Templates
      3. Creating Your Own Template
      4. Saving a Worksheet as a Template
      5. Summary
      6. Q&A
    7. Printing Your Workbook
      1. The Value of Hard Copy
      2. Checking Your Spelling Before You Print
      3. Setting Up Your Page
      4. Changing the Orientation and Paper Size
      5. Adding Headers and Footers
      6. Choosing What to Print
      7. Controlling Where Pages Break
      8. Printing What You Want
      9. Summary
      10. Q&A
  7. Dress Up Your Work
    1. Changing the Appearance of Text
      1. Formatting Your Text
      2. Treating Numbers Like Text
      3. Using Fonts
      4. Changing Cell Alignment
      5. Rotating Cell Entries
      6. Centering a Heading
      7. Controlling the Flow of Text
      8. Copying Formatting with the Format Painter
      9. Removing Formatting
      10. Adjusting Column Width
      11. Altering Row Height
      12. Finding Data
      13. Replacing Data
      14. Working with Comments
      15. Summary
      16. Q&A
    2. Changing the Look of Values
      1. What Formats Are Available?
      2. Choosing a Number Style
      3. Working with Decimal Places
      4. Designing Custom Numeric Formats
      5. Formatting Conditionally
      6. Hiding Zeros
      7. Working with Dates
      8. Summary
      9. Q&A
    3. Adding Borders, Colors, and Fills
      1. Have It Your Way
      2. Changing the Color of Cell Entries
      3. Adding Borders to Cells and Ranges
      4. Working with Fills, Shading, and Color
      5. Formatting with AutoFormat
      6. Summary
      7. Q&A
  8. Interactive Data Makes Your Worksheet Come Alive
    1. Working with Graphics Objects
      1. What Is a Graphics Object?
      2. Why Use Graphics?
      3. Using the Drawing Toolbar
      4. Adding Clip Art
      5. Adding Special Effects with WordArt
      6. Manipulating Graphics Objects
      7. Combining Multiple Objects
      8. Deleting Graphics Objects
      9. Summary
      10. Q&A
    2. Adding a Chart
      1. Why Use a Chart?
      2. Chart Elements
      3. Types of Charts
      4. Creating Charts with the Chart Wizard
      5. Working with Charts
      6. Chart Formatting Techniques
      7. Creating a Pie Chart
      8. Summary
      9. Q&A
    3. Other Types of Charts
      1. Creating Other Chart Types
      2. Creating an Excel Diagram
      3. Summary
      4. Q&A
  9. Advanced Excel Techniques
    1. Working Smarter
      1. Working with Multiple Workbooks
      2. Working with Formulas That Reference Other Workbooks and Worksheets
      3. Creating Links Between Worksheets and Workbooks
      4. Customizing Excel
      5. Protecting Your Data
      6. Protecting Your Files
      7. Saving Your Workspace
      8. Using Excel Add-ins
      9. Summary
      10. Q&A
    2. Using Functions
      1. Advantages of Excel Functions
      2. Using the Insert Function Dialog Box and Formula Palette
      3. Financial Functions
      4. Date and Time Functions
      5. DATEVALUE
      6. Logical Functions
      7. How to Use Lookup Functions
      8. Summary
      9. Q&A
    3. Auditing and Validating Your Work
      1. Auditing Workbooks
      2. Validating Input
      3. Using Named Constants and Formulas
      4. Defining Label Ranges
      5. Summary
      6. Q&A
    4. Analyzing Your Data
      1. Using the Scenario Manager
      2. Using the Goal Seek Tool
      3. Summary
      4. Q&A
    5. Working with Pivot Tables
      1. What Is a Pivot Table?
      2. Learning the PivotTable Lingo
      3. Building a Pivot Table
      4. Modifying a Pivot Table
      5. Working with Pivot Table Reports
      6. Building a PivotChart
      7. Creating a Chart from PivotTable Report Data
      8. Summary
      9. Q&A
    6. Integrating Excel with Other Office Applications
      1. Using Objects in Excel
      2. Inserting Objects
      3. Using Hyperlinks with Other Office Documents
      4. Sending Your Document Via Email with Outlook
      5. Summary
      6. Q&A
    7. Automating Tasks with Macros and Smart Tags
      1. What Is a Macro?
      2. Creating a Macro
      3. Running the Macro
      4. Fixing Macro Errors
      5. Attaching a Macro to a Toolbar
      6. Using a Macro in Other Workbooks
      7. Understanding Macro Viruses
      8. Working with Smart Tags
      9. Summary
      10. Q&A
  10. Creating and Using Databases in Excel
    1. Building an Excel Database
      1. Basic Database Concepts
      2. Starting with a Plan
      3. Creating a Database
      4. Entering and Adding Data
      5. Searching for Data
      6. Saving the Database
      7. Summary
      8. Q&A
    2. Working with Your Database
      1. Working with Subtotals
      2. Using Advanced AutoFilter Functions
      3. Setting a Criteria Range
      4. Retrieving Data with the Query Wizard
      5. Choosing a Data Source
      6. Saving Data Queries
      7. Summary
      8. Q&A
  11. At the Office and on the Internet/Intranet
    1. Sharing Your Work with Your Colleagues
      1. What Is a Network?
      2. Sharing Workbooks
      3. Setting Up a Shared Workbook
      4. Opening a Shared Workbook
      5. Tracking Changes in Your Worksheet
      6. Summary
      7. Q&A
    2. Worksheets and the Web
      1. What Is the Internet?
      2. Using Internet Explorer 6.0
      3. Searching on the Web
      4. Adding a Hyperlink to a Worksheet
      5. Saving Excel Documents to the Web
      6. Posting Your Worksheet to the Web
      7. Summary
      8. Q&A
  12. Index