My Excel® 2013

Table of contents

1. About This eBook
2. Title Page
3. Copyright Page
4. Contents at a Glance
5. Table of Contents
6. About the Author
7. Dedication
8. Acknowledgments
9. We Want to Hear from You!
10. Reader Services
11. Introduction
    1. What’s in This Book
12. 1. Working with Excel’s Ribbon Menus
    1. Familiarizing Yourself with the Ribbon Tabs
    2. Understanding Workbooks and Worksheets
    3. Understanding Contextual Tabs
    4. Customizing the Quick Access Toolbar
13. 2. Managing Workbooks and Worksheets
    1. Opening an Excel Workbook
    2. Closing an Excel Workbook
    3. Saving a Workbook
    4. Switching Between Open Workbooks
    5. Switching Between Worksheets
    6. Viewing Multiple Workbooks
    7. Inserting and Deleting Worksheets
    8. Renaming Worksheets
    9. Coloring Worksheet Tabs
    10. Moving Worksheets Within a Workbook
    11. Copying Worksheets Between Workbooks
    12. Password Protect a Workbook
    13. Protecting a Worksheet
14. 3. Entering and Managing Data
    1. Entering Data
    2. Editing and Deleting Existing Data
    3. Zooming into Your Data
    4. Undoing and Redoing Changes
    5. Copying and Pasting Data
    6. Freezing Rows and Columns
    7. Splitting a Worksheet
    8. Inserting Cells
    9. Deleting Cells
    10. Inserting and Deleting Rows
    11. Inserting and Deleting Columns
    12. Moving Data
    13. Finding Data
    14. Replacing Data
    15. Applying a Data Filter
    16. Sorting Data
    17. Adding and Managing Cell Comments
15. 4. Formatting Worksheet Data
    1. Changing the Font and Font Size
    2. Changing Column Width
    3. Changing the Color of the Cell Background and Cell Text
    4. Formatting the Display of Numeric Data
    5. Applying Bold, Italic, and Underline
    6. Using Merge and Center on Cells
    7. Changing Horizontal Data Alignment
    8. Changing Row Height
    9. Changing Vertical Data Alignment
    10. Changing Cell Orientation
    11. Wrapping Data in a Cell
    12. Changing Borders
    13. Indenting Entries in a Cell
    14. Clearing Formatting
    15. Hiding and Unhiding Rows
    16. Hiding and Unhiding Columns
    17. Hiding and Unhiding a Worksheet
    18. Using Format as Table
    19. Copying Formatting
    20. Creating and Applying a Formatting Style
    21. Using Conditional Formatting
16. 5. Working with Formulas and Functions
    1. Using AutoSum Calculations
    2. Entering a Formula
    3. Editing a Formula or Function
    4. Copying a Formula
    5. Assigning Names to a Cell or Range
    6. Referencing Names in a Function
    7. Using Functions Across Worksheets
    8. Using Auto-Calculate
    9. Finding and Using Excel Functions
    10. Recognizing and Fixing Errors
    11. Recognizing Circular References
    12. Checking for Formula References (PRECEDENTS)
    13. Checking for Cell References (DEPENDENTS)
17. 6. Working with Charts
    1. Creating a Chart
    2. Changing the Chart Type
    3. Altering the Source Data Range
    4. Altering Chart Options
    5. Formatting the Plot Area
    6. Formatting the Chart Area
    7. Formatting the Axis Scale
    8. Altering the Original Data
    9. Adding Data to Charts
    10. Adding a Legend
18. 7. Working with Graphics
    1. Using Drawing Tools
    2. Inserting Clip Art
    3. Inserting a Picture from File
    4. Using AutoShapes
    5. Inserting WordArt
    6. Using Smart Art in Excel
    7. Inserting a Diagram
    8. Inserting Objects
    9. Working with Inserted Objects
19. 8. Printing in Excel
    1. Using Print Preview
    2. Setting the Print Area
    3. Adjusting Page Margins
    4. Inserting Page Breaks
    5. Working in Page Break Preview Mode
    6. Printing a Worksheet on One Page
    7. Printing in Portrait or Landscape Orientation
    8. Centering a Worksheet on a Page
    9. Printing Gridlines and Row/Column Headers
    10. Printing Cell Comments
    11. Printing Cell Error Indicators
    12. Printing Repeating Row and Column Titles
    13. Adding Headers and Footers
    14. Printing Your Worksheets
20. 9. Working with Pivot Tables
    1. Creating a Pivot Table
    2. Rearranging a Pivot Table
    3. Adding a Report Filter
    4. Refreshing Pivot Table Data
    5. Adding Pivot Table Data
    6. Customizing Field Names
    7. Applying Numeric Formats to Data Fields
    8. Changing Summary Calculations
    9. Showing and Hiding Data Items
    10. Sorting Your Pivot Table
21. 10. Using SkyDrive to Store and Share Excel Files
    1. Signing Up For SkyDrive
    2. Signing into SkyDrive
    3. Saving a Workbook to SkyDrive
    4. Opening a SkyDrive Workbook
    5. Downloading a Workbook from SkyDrive
    6. Sharing Your SkyDrive Workbooks with Others
    7. Managing SkyDrive Workbooks
22. A. Excel Shortcut Keys
    1. Using the Excel Shortcut Key Reference Table
23. Index