| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Stepping into Excel | |
| |
| |
| Start Excel | |
| |
| |
| Use the Start Menu to Load Excel | |
| |
| |
| Starting Excel | |
| |
| |
| Open a Workbook | |
| |
| |
| Opening a Workbook | |
| |
| |
| Add Identifying Information | |
| |
| |
| Find a Workbook | |
| |
| |
| Using Task Panes | |
| |
| |
| Personalize Excel | |
| |
| |
| Remove the Getting Started Task Pane | |
| |
| |
| Select a Toolbar to Display | |
| |
| |
| Show Toolbars on Two Rows | |
| |
| |
| Customize a Toolbar | |
| |
| |
| Using Toolbars | |
| |
| |
| Get Help | |
| |
| |
| Open Help | |
| |
| |
| Using Help | |
| |
| |
| Do Research | |
| |
| |
| End Your Excel Workbook | |
| |
| |
| Save a Workbook Automatically | |
| |
| |
| Save a Workbook Manually | |
| |
| |
| Save a Copy of Your Workbook | |
| |
| |
| Save a Workbook As a Template | |
| |
| |
| Close an Excel Session | |
| |
| |
| |
| Entering and Editing Data | |
| |
| |
| Enter Data | |
| |
| |
| Enter Text | |
| |
| |
| Completing an Entry | |
| |
| |
| Enter Numeric Data | |
| |
| |
| Enter Dates | |
| |
| |
| Formatting Numbers | |
| |
| |
| Use Times | |
| |
| |
| Adding Data Quickly | |
| |
| |
| Edit Data | |
| |
| |
| Edit Cell Data | |
| |
| |
| Remove Cell Contents | |
| |
| |
| Selecting Cells and Ranges | |
| |
| |
| Copy and Paste Data | |
| |
| |
| Use Paste Special | |
| |
| |
| Find and Replace Data | |
| |
| |
| Verify Spelling | |
| |
| |
| Modify Automatic Corrections | |
| |
| |
| |
| Formatting a Worksheet | |
| |
| |
| Work with Cells, Rows, and Columns | |
| |
| |
| Adding and Removing Rows, Columns, and Cells | |
| |
| |
| Adjust Row Height | |
| |
| |
| Adjust Column Width | |
| |
| |
| Hide and Unhide Rows and Columns | |
| |
| |
| Change Cell Borders | |
| |
| |
| Add a Background | |
| |
| |
| Add a Comment | |
| |
| |
| Change How Text Looks | |
| |
| |
| Use Fonts | |
| |
| |
| Using Comments | |
| |
| |
| Change Alignment and Orientation | |
| |
| |
| Use Styles | |
| |
| |
| Transfer Formatting | |
| |
| |
| Format Automatically | |
| |
| |
| Format Conditionally | |
| |
| |
| Arrange and Organize Worksheets | |
| |
| |
| Lock Rows and Columns | |
| |
| |
| Split a Worksheet | |
| |
| |
| View Worksheets from Multiple Workbooks | |
| |
| |
| Working with Worksheets | |
| |
| |
| |
| Using Formulas and Functions | |
| |
| |
| Reference Cells | |
| |
| |
| Change Cell References in Formulas | |
| |
| |
| Change to R1C1 References | |
| |
| |
| Using Cell Reference Operators | |
| |
| |
| Name a Cell | |
| |
| |
| Go to a Named Cell | |
| |
| |
| Build Formulas | |
| |
| |
| Create a Formula | |
| |
| |
| Edit a Formula | |
| |
| |
| Move Formulas | |
| |
| |
| Copy Formulas | |
| |
| |
| Using Formulas | |
| |
| |
| Recalculate Formulas | |
| |
| |
| Use External References in Formulas | |
| |
| |
| Use Functions | |
| |
| |
| Enter a Function | |
| |
| |
| Using Functions | |
| |
| |
| Sum Numbers in Columns or Rows Quickly | |
| |
| |
| Find and Correct Errors | |
| |
| |
| Check for Errors | |
| |
| |
| Trace Precedent and Dependent Cells | |
| |
| |
| Watch a Cell | |
| |
| |
| Evaluate a Formula in Pieces | |
| |
| |
| |
| Printing Data | |
| |
| |
| Set Up the Print Job | |
| |
| |
| Add Headers and Footers | |
| |
| |
| Formatting Headers and Footers | |
| |
| |
| Add Pictures to Headers and Footers | |
| |
| |
| Adjust Margins | |
| |
| |
| Select Page Orientation and Scaling | |
| |
| |
| Use Headings as Page Titles | |
| |
| |
| Choosing Worksheet Print Options | |
| |
| |
| Change the Order Pages Print | |
| |
| |
| Print Comments | |
| |
| |
| Choosing What to Print | |
| |
| |
| Print the Data | |
| |
| |
| Use Print Areas | |
| |
| |
| Preview the Print Job | |
| |
| |
| Output the Print Job | |
| |
| |
| |
| Charting Data | |
| |
| |
| Build a Chart with the Chart Wizard | |
| |
| |
| Start the Chart Wizard | |
| |
| |
| Choose a Chart Type | |
| |
| |
| Select Data for Charting | |
| |
| |
| Modify Chart Items | |
| |
| |
| Choose a Chart Location | |
| |
| |
| Modify Existing Charts | |
| |
| |
| Create a Chart from the Chart Toolbar | |
| |
| |
| Selecting Chart Items | |
| |
| |
| Identify Items | |
| |
| |
| Add Titles | |
| |
| |
| Show or Hide Axes | |
| |
| |
| Add or Remove Gridlines | |
| |
| |
| Show or Hide a Legend | |
| |
| |
| Add Data Labels | |
| |
| |
| Display the Data Table | |
| |
| |
| Format Chart Items | |
| |
| |
| Add a Second Value Axis | |
| |
| |
| Create Your Own Chart Type | |
| |
| |
| Working with Charts | |
| |
| |
| Use Charts | |
| |
| |
| Add Pictures and Text | |
| |
| |
| Add a Trendline | |
| |
| |
| Print a Chart | |
| |
| |
| Work with Pie Charts | |
| |
| |
| |
| Working with Graphics | |
| |
| |
| Add Graphics | |
| |
| |
| Add Pictures | |
| |
| |
| Organize Clip Art | |
| |
| |
| Use Clip Art | |
| |
| |
| Add AutoShapes | |
| |
| |
| Add Objects from Other Programs | |
| |
| |
| Working with Curves | |
| |
| |
| Add Special Effects to Text | |
| |
| |
| Create a Diagram | |
| |
| |
| Format and Modify Graphics | |
| |
| |
| Use Color Effects | |
| |
| |
| Using Handles and Borders to Change Graphics | |
| |
| |
| Resize and Rotate a Graphic | |
| |
| |
| Trim a Picture | |
| |
| |
| Positioning Graphics | |
| |
| |
| Combine Graphics by Grouping | |
| |
| |
| Create a Mirrored Image | |
| |
| |
| Keep Changes Intact | |
| |
| |
| |
| Managing Data | |
| |
| |
| Build Lists | |
| |
| |
| Create a List | |
| |
| |
| Adding Rows and Columns to a List | |
| |
| |
| Enter and Manage Data Using a Form | |
| |
| |
| Locating Data Using a Form | |
| |
| |
| Add a Total Row | |
| |
| |
| Remove a List | |
| |
| |
| Validate Data | |
| |
| |
| Organize Data | |
| |
| |
| Sort Data by Columns | |
| |
| |
| Sort Data by Rows | |
| |
| |
| Create an AutoFilter | |
| |
| |
| Removing Filters | |
| |
| |
| Outline Data Automatically | |
| |
| |
| Outline Data by Grouping | |
| |
| |
| Add Styles to an Outline | |
| |
| |
| Using Outlines | |
| |
| |
| Acquire Data | |
| |
| |
| Convert Text to Data | |
| |
| |
| Add All Data from an Access Table | |
| |
| |
| Add Selective Data from an Access Table | |
| |
| |
| Get Data from the Web | |
| |
| |
| Change External Data | |
| |
| |
| Setting External Data Range Properties | |
| |
| |
| |
| Analyzing and Sharing Data | |
| |
| |
| Get the Results You Want | |
| |
| |
| Use Goal Seek | |
| |
| |
| Compare Alternatives Using Scenarios | |
| |
| |
| Use Multiple Variables to Provide a Result | |
| |
| |
| Save Solver Results and Settings | |
| |
| |
| Changing Solver Settings | |
| |
| |
| Work with PivotTables | |
| |
| |
| Create a PivotTable | |
| |
| |
| Create the PivotTable Layout | |
| |
| |
| Using PivotTables | |
| |
| |
| Create a PivotTable Chart | |
| |
| |
| Work with Others | |
| |
| |
| Guard Workbooks with Passwords | |
| |
| |
| Using Passwords in a Shared Workbook | |
| |
| |
| Share a Workbook | |
| |
| |
| Merge Shared Workbooks | |
| |
| |
| Working with Changes in a Shared Workbook | |
| |
| |
| Protect a Shared Workbook | |
| |
| |
| Work with Views | |
| |
| |
| Protect Non-Shared Workbooks and Worksheets | |
| |
| |
| |
| Extending Excel | |
| |
| |
| Use Excel with Web Technology | |
| |
| |
| Save or Publish a Workbook as a Web Page | |
| |
| |
| Save Workbook Items as a Web Page | |
| |
| |
| Publish Workbook Items | |
| |
| |
| Using Excel Interactive Web Pages | |
| |
| |
| Keep Web Pages Updated | |
| |
| |
| Package Excel Web Files | |
| |
| |
| Use Hyperlinks | |
| |
| |
| Plan for the Future | |
| |
| |
| Automate Excel | |
| |
| |
| Use Recorded Macros | |
| |
| |
| Edit a Macro | |
| |
| |
| Starting a Macro | |
| |
| |
| Communicate with Excel | |
| |
| |
| Listen to Excel | |
| |
| |
| Tell Excel What to Do | |
| |
| |
| Index | |