Microsoft Excel 2013: Step by Step

Table of contents

1. Dedication
2. A Note Regarding Supplemental Files
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. A. Glossary
19. B. Keyboard shortcuts
    1. Ctrl combination shortcut keys
    2. Function keys
    3. Other useful shortcut keys
20. C. About the authors
21. Index
22. About the Author
23. Copyright