Excel 2003 Personal Trainer

About CustomGuide, Inc.; Introduction; CustomGuide Staff and Contributors; Introduction; About the Personal Trainer Series; About This Book; Conventions Used in This Book; Using the Interactive Environment; How to Contact Us; Chapter 1: The Fundamentals; 1.1 Starting Excel; 1.2 What's New in Excel 2003?; 1.3 Understanding the Excel Program Screen; 1.4 Using Menus; 1.5 Using Toolbars and Creating a New Workbook; 1.6 Filling Out Dialog Boxes; 1.7 Keystroke and Right Mouse Button Shortcuts; 1.8 Opening a Workbook; 1.9 Saving a Workbook; 1.10 Moving the Cell Pointer; 1.11 Navigating a Worksheet; 1.12 Entering Labels in a Worksheet; 1.13 Entering Values in a Worksheet and Selecting a Cell Range; 1.14 Calculating Value Totals with AutoSum; 1.15 Entering Formulas; 1.16 Using AutoFill; 1.17 Previewing and Printing a Worksheet; 1.18 Getting Help; 1.19 Changing the Office Assistant and Using the "What's This" Button; 1.20 Closing a Workbook and Exiting Excel; 1.21 Chapter One Review; Chapter 2: Editing a Worksheet; 2.1 Entering Date Values and Using AutoComplete; 2.2 Editing, Clearing, and Replacing Cell Contents; 2.3 Cutting, Copying, and Pasting Cells; 2.4 Moving and Copying Cells with Drag and Drop; 2.5 Collecting and Pasting Multiple Items; 2.6 Working with Absolute and Relative Cell References; 2.7 Using the Paste Special Command; 2.8 Inserting and Deleting Cells, Rows, and Columns; 2.9 Using Undo, Redo, and Repeat; 2.10 Checking Your Spelling; 2.11 Finding and Replacing Information; 2.12 Advanced Printing Options; 2.13 File Management; 2.14 Inserting Cell Comments; 2.15 Understanding Smart Tags; 2.16 Recovering Your Workbooks; 2.17 Chapter Two Review; Chapter 3: Formatting a Worksheet; 3.1 Formatting Fonts with the Formatting Toolbar; 3.2 Formatting Values; 3.3 Adjusting Row Height and Column Width; 3.4 Changing Cell Alignment; 3.5 Adding Borders; 3.6 Applying Colors and Patterns; 3.7 Using the Format Painter; 3.8 Using AutoFormat; 3.9 Creating a Custom Number Format; 3.10 Creating, Applying, and Modifying a Style; 3.11 Formatting Cells with Conditional Formatting; 3.12 Merging Cells, Rotating Text, and Using AutoFit; 3.13 Finding and Replacing Formatting; 3.14 Chapter Three Review; Chapter 4: Creating and Working with Charts; 4.1 Creating a Chart; 4.2 Moving and Resizing a Chart; 4.3 Formatting and Editing Objects in a Chart; 4.4 Changing a Chart's Source Data; 4.5 Changing a Chart Type and Working with Pie Charts; 4.6 Adding Titles, Gridlines, and a Data Table; 4.7 Formatting a Data Series and Chart Axis; 4.8 Annotating a Chart; 4.9 Working with 3-D Charts; 4.10 Selecting and Saving a Custom Chart; 4.11 Using Fill Effects; 4.12 Chapter Four Review; Chapter 5: Managing Your Workbooks; 5.1 Switching Between Sheets in a Workbook; 5.2 Inserting and Deleting Worksheets; 5.3 Renaming and Moving Worksheets; 5.4 Working with Several Workbooks and Windows; 5.5 Splitting and Freezing a Window; 5.6 Referencing External Data; 5.7 Creating Headers, Footers, and Page Numbers; 5.8 Specifying a Print Area and Controlling Page Breaks; 5.9 Adjusting Page Margins and Orientation; 5.10 Adding Print Titles and Gridlines; 5.11 Changing the Paper Size and Print Scale; 5.12 Protecting a Worksheet; 5.13 Hiding Columns, Rows, and Sheets; 5.14 Viewing a Worksheet and Comparing Workbooks Side by Side; 5.15 Saving a Custom View; 5.16 Working with Templates; 5.17 Consolidating Worksheets; 5.18 Chapter Five Review; Chapter 6: More Functions and Formulas; 6.1 Formulas with Several Operators and Cell Ranges; 6.2 Using the Insert Function Feature; 6.3 Creating and Using Range Names; 6.4 Selecting Nonadjacent Ranges and Using AutoCalculate; 6.5 Using the IF Function to Create Conditional Formulas; 6.6 Using the PMT Function; 6.7 Displaying and Printing Formulas; 6.8 Fixing Formula Errors; 6.9 Mathematical Functions; 6.10 Financial Functions; 6.11 Date and Time Functions; 6.12 Statistical Functions; 6.13 Database Functions; 6.14 Chapter Six Review; Chapter 7: Working with Lists; 7.1 Creating a List; 7.2 Working with Lists and Using the Total Row; 7.3 Adding Records Using the Data Form Dialog Box and Insert Row; 7.4 Finding Records; 7.5 Deleting Records; 7.6 Sorting a List; 7.7 Filtering a List with the AutoFilter; 7.8 Creating a Custom AutoFilter; 7.9 Filtering a List with an Advanced Filter; 7.10 Copying Filtered Records; 7.11 Using Data Validation; 7.12 Chapter Seven Review; Chapter 8: Automating Tasks with Macros; 8.1 Recording a Macro; 8.2 Playing a Macro and Assigning a Macro a Shortcut Key; 8.3 Adding a Macro to a Toolbar; 8.4 Editing a Macro's Visual Basic Code; 8.5 Inserting Code in an Existing Macro; 8.6 Declaring Variables and Adding Remarks to VBA Code; 8.7 Prompting for User Input; 8.8 Using the If...Then...Else Statement; 8.9 Chapter Eight Review; Chapter 9: Working with Other Programs; 9.1 Inserting an Excel Worksheet into a Word Document; 9.2 Modifying an Inserted Excel Worksheet; 9.3 Inserting a Linked Excel Chart in a Word Document; 9.4 Inserting a Graphic into a Worksheet; 9.5 Opening and Saving Files in Different Formats; 9.6 Chapter Nine Review; Chapter 10: Using Excel with the Internet; 10.1 Adding and Working with Hyperlinks; 10.2 Browsing Hyperlinks and Using the Web Toolbar; 10.3 Saving a Workbook as a Non-Interactive Web Page; 10.4 Saving a Workbook as an Interactive Web Page; 10.5 Import an External Data Source; 10.6 Refresh a Data Source and Set Data Source Properties; 10.7 Create a New Web Query; 10.8 Chapter Ten Review; Chapter 11: Data Analysis and PivotTables; 11.1 Creating a PivotTable; 11.2 Specifying the Data a PivotTable Analyzes; 11.3 Changing a PivotTable's Calculation; 11.4 Selecting What Appears in a PivotTable; 11.5 Grouping Dates in a PivotTable; 11.6 Updating a PivotTable; 11.7 Formatting and Charting a PivotTable; 11.8 Creating Subtotals; 11.9 Using Database Functions; 11.10 Using Lookup Functions; 11.11 Grouping and Outlining a Worksheet; 11.12 Chapter Eleven Review; Chapter 12: What-If Analysis; 12.1 Defining a Scenario; 12.2 Creating a Scenario Summary Report; 12.3 Using a One and Two-Input Data Table; 12.4 Understanding Goal Seek; 12.5 Using Solver; 12.6 Chapter Twelve Review; Chapter 13: Advanced Topics; 13.1 Hiding, Displaying, and Moving Toolbars; 13.2 Customizing Excel's Toolbars; 13.3 Sending Faxes; 13.4 Creating a Custom AutoFill List; 13.5 Changing Excel's Options; 13.6 Password Protecting a Workbook; 13.7 File Properties and Finding a File; 13.8 Sharing a Workbook and Tracking Changes; 13.9 Merging and Revising a Shared Workbook; 13.10 Using Detect and Repair; 13.11 Chapter Thirteen Review; Colophon;