You are previewing My Excel® 2013.
O'Reilly logo
My Excel® 2013

Book Description

Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013.

Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do.
Help when you run into Excel 2013 problems or limitations.
Tips and Notes to help you get the most from Excel 2013.

• Quickly find and use the Excel 2013 features you’re looking for
• Create, save, and organize your spreadsheets
• Build custom formulas using Excel’s powerful built-in functions
• Master time-saving techniques to find, replace, move, filter, and sort data
• Find, fix, and avoid errors that break spreadsheets or cause inaccuracies
• Create a unique look and feel for your spreadsheets with formatting
• Generate powerful charts and visualizations with Excel’s new tools
• Insert images, shapes, SmartArt, and even org charts
• Precisely control what you print and how it looks
• Secure your spreadsheets and control who can view or edit them
• Use improved PivotTables to analyze huge amounts of data
• Store and share workbooks on the Web with SkyDrive

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