You are previewing Microsoft Excel 2013: Step by Step.
O'Reilly logo
Microsoft Excel 2013: Step by Step

Book Description

The smart way to learn Excel 2013—one step at a time!

Experience learning made easy—and quickly teach yourself how to manage, analyze, and present data with Excel 2013. With Step by Step, you set the pace—building and practicing the skills you need, just when you them! Includes downloadable practice files and companion eBook.

Discover how to:

  • Work with Excel 2013 in touch mode

  • Write formulas, create macros, and organize data

  • Present data visually and add images to worksheets

  • Consolidate multiple sets of data into a single workbook

  • Analyze data using the Quick Analysis Lens

  • Collaborate with colleagues and present workbooks online

  • Table of Contents

    1. Dedication
    2. Special Upgrade Offer
    3. A Note Regarding Supplemental Files
    4. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Download the practice files
      4. Your companion ebook
      5. Getting support and giving feedback
        1. Errata
        2. We want to hear from you
        3. Stay in touch
    5. 1. Getting started with Excel 2013
      1. Identifying the different Excel 2013 programs
      2. Identifying new features of Excel 2013
        1. If you are upgrading from Excel 2010
        2. If you are upgrading from Excel 2007
        3. If you are upgrading from Excel 2003
        4. Working with the ribbon
      3. Customizing the Excel 2013 program window
        1. Zooming in on a worksheet
        2. Arranging multiple workbook windows
        3. Adding buttons to the Quick Access Toolbar
        4. Customizing the ribbon
        5. Maximizing usable space in the program window
      4. Creating workbooks
      5. Modifying workbooks
      6. Modifying worksheets
        1. Inserting rows, columns, and cells
      7. Merging and unmerging cells
      8. Key points
    6. 2. Working with data and Excel tables
      1. Entering and revising data
      2. Managing data by using Flash Fill
      3. Moving data within a workbook
      4. Finding and replacing data
      5. Correcting and expanding upon worksheet data
      6. Defining Excel tables
      7. Key points
    7. 3. Performing calculations on data
      1. Naming groups of data
      2. Creating formulas to calculate values
      3. Summarizing data that meets specific conditions
      4. Working with iterative calculation options and automatic workbook calculation
      5. Using array formulas
      6. Finding and correcting errors in calculations
      7. Key points
    8. 4. Changing workbook appearance
      1. Formatting cells
      2. Defining styles
      3. Applying workbook themes and Excel table styles
      4. Making numbers easier to read
      5. Changing the appearance of data based on its value
      6. Adding images to worksheets
      7. Key points
    9. 5. Focusing on specific data by using filters
      1. Limiting data that appears on your screen
      2. Filtering Excel table data by using slicers
      3. Manipulating worksheet data
        1. Selecting list rows at random
        2. Summarizing worksheets by using hidden and filtered rows
        3. Finding unique values within a data set
      4. Defining valid sets of values for ranges of cells
      5. Key points
    10. 6. Reordering and summarizing data
      1. Sorting worksheet data
      2. Sorting data by using custom lists
      3. Organizing data into levels
      4. Looking up information in a worksheet
      5. Key points
    11. 7. Combining data from multiple sources
      1. Using workbooks as templates for other workbooks
      2. Linking to data in other worksheets and workbooks
      3. Consolidating multiple sets of data into a single workbook
      4. Key points
    12. 8. Analyzing data and alternative data sets
      1. Examining data by using the Quick Analysis Lens
      2. Defining an alternative data set
      3. Defining multiple alternative data sets
      4. Analyzing data by using data tables
      5. Varying your data to get a specific result by using Goal Seek
      6. Finding optimal solutions by using Solver
      7. Analyzing data by using descriptive statistics
      8. Key points
    13. 9. Creating charts and graphics
      1. Creating charts
      2. Customizing the appearance of charts
      3. Finding trends in your data
      4. Creating dual-axis charts
      5. Summarizing your data by using sparklines
      6. Creating diagrams by using SmartArt
      7. Creating shapes and mathematical equations
      8. Key points
    14. 10. Using PivotTables and PivotCharts
      1. Analyzing data dynamically by using PivotTables
      2. Filtering, showing, and hiding PivotTable data
      3. Editing PivotTables
      4. Formatting PivotTables
      5. Creating PivotTables from external data
      6. Creating dynamic charts by using PivotCharts
      7. Key points
    15. 11. Printing worksheets and charts
      1. Adding headers and footers to printed pages
      2. Preparing worksheets for printing
        1. Previewing worksheets before printing
        2. Changing page breaks in a worksheet
        3. Changing the page printing order for worksheets
      3. Printing worksheets
      4. Printing parts of worksheets
      5. Printing charts
      6. Key points
    16. 12. Working with macros and forms
      1. Enabling and examining macros
        1. Changing macro security settings
        2. Examining macros
      2. Creating and modifying macros
      3. Running macros when a button is clicked
      4. Running macros when a workbook is opened
      5. Inserting form controls and setting form properties
        1. Adding text boxes to UserForms
        2. Adding list boxes to UserForms
        3. Adding combo boxes to UserForms
        4. Adding option buttons to UserForms
        5. Adding graphics to UserForms
        6. Adding spin buttons to UserForms
        7. Writing UserForm data to a worksheet
        8. Displaying, loading, and hiding UserForms
      6. Key points
    17. 13. Working with other Office programs
      1. Linking to Office documents from workbooks
      2. Embedding workbooks into other Office documents
      3. Creating hyperlinks
      4. Pasting charts into other Office documents
      5. Key points
    18. 14. Collaborating with colleagues
      1. Sharing workbooks
      2. Saving workbooks for electronic distribution
      3. Managing comments
      4. Tracking and managing colleagues’ changes
      5. Protecting workbooks and worksheets
      6. Authenticating workbooks
      7. Saving workbooks as web content
      8. Importing and exporting XML data
      9. Working with SkyDrive and Excel Web App
      10. Key points
    19. A. Glossary
    20. B. Keyboard shortcuts
      1. Ctrl combination shortcut keys
      2. Function keys
      3. Other useful shortcut keys
    21. C. About the authors
    22. Index
    23. About the Author
    24. Special Upgrade Offer
    25. Copyright