Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)

   
  Table of Contents
  Index
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours
By Trudi Reisner
 
Publisher : Sams Publishing
Pub Date : September 15, 2003
ISBN : 0-672-32551-9
Pages : 480

                               

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

Категории