| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Stepping into Excel | |
| |
| |
| Opening Excel | |
| |
| |
| Get Started with Excel | |
| |
| |
| Explore the Excel Window | |
| |
| |
| Create a Workbook | |
| |
| |
| Understanding the Ribbon | |
| |
| |
| Open an Existing Workbook | |
| |
| |
| Change the Appearance of New Workbooks | |
| |
| |
| Customize the Quick Access Toolbar | |
| |
| |
| Get Help | |
| |
| |
| Open Help | |
| |
| |
| Use the Excel Help Window | |
| |
| |
| Understanding Excel's XML File Formats | |
| |
| |
| Close Your Excel Workbook | |
| |
| |
| Save a Workbook Automatically | |
| |
| |
| Save a Workbook Manually | |
| |
| |
| Save a Copy of Your Workbook | |
| |
| |
| Add Identifying Information | |
| |
| |
| Understanding Excel File Compatibility | |
| |
| |
| Exit an Excel Session | |
| |
| |
| |
| Entering and Editing Data | |
| |
| |
| Understanding Data Types | |
| |
| |
| Enter Data | |
| |
| |
| Enter Text | |
| |
| |
| Enter Numeric Data | |
| |
| |
| Completing an Entry | |
| |
| |
| Enter Dates | |
| |
| |
| Use Times | |
| |
| |
| Formatting Numbers | |
| |
| |
| Understanding Excel Dates and Times | |
| |
| |
| Edit Data | |
| |
| |
| Edit Cell Data | |
| |
| |
| Adding Data Quickly | |
| |
| |
| Remove Cell Contents | |
| |
| |
| Copy and Paste Data | |
| |
| |
| Selecting Cells and Ranges | |
| |
| |
| Use Paste Special | |
| |
| |
| Find and Replace Data | |
| |
| |
| Verify Spelling | |
| |
| |
| Modify Automatic Corrections | |
| |
| |
| |
| Formatting a Worksheet | |
| |
| |
| Adding and Removing Rows, Colunms, and Cells | |
| |
| |
| Work with Cells, Rows, and Columns | |
| |
| |
| Adjust Row Height | |
| |
| |
| Adjust Column Width | |
| |
| |
| Hide and Unhide Rows and Columns | |
| |
| |
| Change Cell Borders | |
| |
| |
| Add a Comment | |
| |
| |
| Formatting Comments | |
| |
| |
| Apply Formatting | |
| |
| |
| Understanding Excel Formatting | |
| |
| |
| Apply Themes | |
| |
| |
| Create Custom Themes | |
| |
| |
| Searching for Themes | |
| |
| |
| Use Cell Styles | |
| |
| |
| Change Fonts | |
| |
| |
| Change Alignment and Orientation | |
| |
| |
| Add a Background | |
| |
| |
| Transfer Formatting | |
| |
| |
| Arrange and Organize Worksheets | |
| |
| |
| Lock Rows and Columns | |
| |
| |
| Split a Worksheet | |
| |
| |
| Working with Worksheets | |
| |
| |
| View Worksheets from Multiple Workbooks | |
| |
| |
| Compare Workbooks | |
| |
| |
| |
| Using Formulas and Functions | |
| |
| |
| Understanding Cell Referencing Types | |
| |
| |
| Reference Cells | |
| |
| |
| Change Cell References | |
| |
| |
| Change to R1C1 References | |
| |
| |
| Name Cells | |
| |
| |
| Using Cell Reference Operators | |
| |
| |
| Go to a Named Cell | |
| |
| |
| Build Formulas | |
| |
| |
| Create a Formula | |
| |
| |
| Working with Cell Names | |
| |
| |
| Edit a Formula | |
| |
| |
| Move Formulas | |
| |
| |
| Using Formulas | |
| |
| |
| Copy Formulas | |
| |
| |
| Recalculate Formulas | |
| |
| |
| Use External References in Formulas | |
| |
| |
| Understanding the Trust Center | |
| |
| |
| Format Conditionally | |
| |
| |
| Using Functions Quickly | |
| |
| |
| Use Functions | |
| |
| |
| Enter a Function | |
| |
| |
| Enter a Sum 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 | |
| |
| |
| |
| Viewing and Printing Data | |
| |
| |
| Understanding Excel Views | |
| |
| |
| Lay Out a Worksheet | |
| |
| |
| Add Headers and Footers | |
| |
| |
| Adding Content to Headers and Footers | |
| |
| |
| Add Pictures to Headers and Footers | |
| |
| |
| Change Margins | |
| |
| |
| Select Page Orientation | |
| |
| |
| Use Headers as Page Titles | |
| |
| |
| Working with Zoom | |
| |
| |
| Print the Data | |
| |
| |
| Change the Order in Which Pages Print | |
| |
| |
| Choosing Worksheet Print Options | |
| |
| |
| Print Comments | |
| |
| |
| Use Print Areas | |
| |
| |
| Choosing What to Print | |
| |
| |
| Preview the Print Job | |
| |
| |
| Scale Your Data Before Printing | |
| |
| |
| Output the Print Job | |
| |
| |
| |
| Charting Data | |
| |
| |
| Building a Chart | |
| |
| |
| Create and Design a Chart | |
| |
| |
| Choose a Chart Type | |
| |
| |
| Selecting Data for Charting | |
| |
| |
| Choose a Chart Location | |
| |
| |
| Modify How the Data Is Plotted | |
| |
| |
| Apply a Chart Layout | |
| |
| |
| Change a Chart's Style | |
| |
| |
| Selecting Chart Elements | |
| |
| |
| Modify Chart Elements | |
| |
| |
| Add Titles | |
| |
| |
| Show or Hide Axes | |
| |
| |
| Add or Remove Gridlines | |
| |
| |
| Identifying Chart Elements | |
| |
| |
| Show or Hide a Legend | |
| |
| |
| Add Data Labels | |
| |
| |
| Display the Data Table | |
| |
| |
| Create Your Own Chart Type | |
| |
| |
| Add a Second Value Axis | |
| |
| |
| Format Chart Elements | |
| |
| |
| Working with Charts | |
| |
| |
| Use Charts | |
| |
| |
| Add Charts Elsewhere | |
| |
| |
| Analyze Charts | |
| |
| |
| Print a Chart | |
| |
| |
| |
| Working with Shapes and Pictures | |
| |
| |
| Understanding Shapes | |
| |
| |
| Add Shapes, Pictures, and Text | |
| |
| |
| Add Shapes | |
| |
| |
| Working with Curves | |
| |
| |
| Insert Pictures | |
| |
| |
| Using Pictures | |
| |
| |
| Organize Pictures | |
| |
| |
| Add Text | |
| |
| |
| Use SmartArt | |
| |
| |
| Changing SmartArt | |
| |
| |
| Working with Shapes | |
| |
| |
| Select, View, and Delete Shapes | |
| |
| |
| Using Handles and Borders to Change Shapes | |
| |
| |
| Crop Pictures | |
| |
| |
| Position Shapes | |
| |
| |
| Combining Shapes by Grouping | |
| |
| |
| Formatting Shapes and Text | |
| |
| |
| Use Styles | |
| |
| |
| Apply Styling Elements to Pictures | |
| |
| |
| Changing a Picture's Attributes | |
| |
| |
| Change a Shape's Fill | |
| |
| |
| Add WordArt Styling to Text | |
| |
| |
| Make Detailed Formatting Changes | |
| |
| |
| |
| Managing Data | |
| |
| |
| Understanding Excel Tables | |
| |
| |
| Build Tables | |
| |
| |
| Create a Table | |
| |
| |
| Adding Rows and Columns to a Table | |
| |
| |
| Delete Rows and Columns Within a Table | |
| |
| |
| Add a Total Row | |
| |
| |
| Apply Styles to a Table | |
| |
| |
| Working with Tables | |
| |
| |
| Validate Data | |
| |
| |
| Locating Validation Data | |
| |
| |
| Organize Data | |
| |
| |
| Sort Data by Columns | |
| |
| |
| Sort Data by Rows | |
| |
| |
| Removing Filters | |
| |
| |
| Create an AutoFilter | |
| |
| |
| Setting Up Criteria and Extract Ranges | |
| |
| |
| Use Advanced Filtering | |
| |
| |
| Outline Data Automatically | |
| |
| |
| Using Outlines | |
| |
| |
| Outline Data by Manually Grouping | |
| |
| |
| Add Subtotals | |
| |
| |
| Add Styles to an Outline | |
| |
| |
| |
| 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 | |
| |
| |
| Understanding PivotTable Terms | |
| |
| |
| Create the PivotTable Layout | |
| |
| |
| Style a PivotTable | |
| |
| |
| Using PivotTables | |
| |
| |
| Create a PivotTable Chart | |
| |
| |
| Work with Other Users | |
| |
| |
| Protect Workbooks with Passwords | |
| |
| |
| Share a Workbook | |
| |
| |
| Working with Changes in a Shared Workbook | |
| |
| |
| Protect a Shared Workbook | |
| |
| |
| Discontinue Sharing a Workbook | |
| |
| |
| Work with Views | |
| |
| |
| Protect Worksheet and Workbook Elements | |
| |
| |
| |
| Extending Excel | |
| |
| |
| Acquire Data | |
| |
| |
| Convert Text to Data | |
| |
| |
| Add a Table from an Access Database | |
| |
| |
| Get Data from the Web | |
| |
| |
| Add External Data from Existing Connections | |
| |
| |
| Setting External Data Range Properties | |
| |
| |
| Manage Connections | |
| |
| |
| Use Excel with Web Technology | |
| |
| |
| Understanding the Difference Between Save and Publish | |
| |
| |
| Save a Workbook as a Web Page | |
| |
| |
| Publish Workbook Items as a Web Page | |
| |
| |
| Understanding Excel Services | |
| |
| |
| Use Hyperlinks | |
| |
| |
| Automate Excel | |
| |
| |
| Use Recorded Macros | |
| |
| |
| Edit a Macro | |
| |
| |
| Index | |