Microsoft Excel 2013

Introduction

Who this book is for

How this book is organized

Download the practice files

Your companion ebook

Getting support and giving feedback

Errata

We want to hear from you

Stay in touch

1. Getting started with Excel 2013

Identifying the different Excel 2013 programs

Identifying new features of Excel 2013

If you are upgrading from Excel 2010

If you are upgrading from Excel 2007

If you are upgrading from Excel 2003

Working with the ribbon

Customizing the Excel 2013 program window

Zooming in on a worksheet

Arranging multiple workbook windows

Adding buttons to the Quick Access Toolbar

Customizing the ribbon

Maximizing usable space in the program window

Creating workbooks

Modifying workbooks

Modifying worksheets

Inserting rows, columns, and cells

Merging and unmerging cells

Key points

2. Working with data and Excel tables

Entering and revising data

Managing data by using Flash Fill

Moving data within a workbook

Finding and replacing data

Correcting and expanding upon worksheet data

Defining Excel tables

Key points

3. Performing calculations on data

Naming groups of data

Creating formulas to calculate values

Summarizing data that meets specific conditions

Working with iterative calculation options and automatic workbook calculation

Using array formulas

Finding and correcting errors in calculations

Key points

4. Changing workbook appearance

Formatting cells

Defining styles

Applying workbook themes and Excel table styles

Making numbers easier to read

Changing the appearance of data based on its value

Adding images to worksheets

Key points

5. Focusing on specific data by using filters

Limiting data that appears on your screen

Filtering Excel table data by using slicers

Manipulating worksheet data

Selecting list rows at random

Summarizing worksheets by using hidden and filtered rows

Finding unique values within a data set

Defining valid sets of values for ranges of cells

Key points

6. Reordering and summarizing data

Sorting worksheet data

Sorting data by using custom lists

Organizing data into levels

Looking up information in a worksheet

Key points

7. Combining data from multiple sources

Using workbooks as templates for other workbooks

Linking to data in other worksheets and workbooks

Consolidating multiple sets of data into a single workbook

Key points

8. Analyzing data and alternative data sets

Examining data by using the Quick Analysis Lens

Defining an alternative data set

Defining multiple alternative data sets

Analyzing data by using data tables

Varying your data to get a specific result by using Goal Seek

Finding optimal solutions by using Solver

Analyzing data by using descriptive statistics

Key points

9. Creating charts and graphics

Creating charts

Customizing the appearance of charts

Finding trends in your data

Creating dual-axis charts

Summarizing your data by using sparklines

Creating diagrams by using SmartArt

Creating shapes and mathematical equations

Key points

10. Using PivotTables and PivotCharts

Analyzing data dynamically by using PivotTables

Filtering, showing, and hiding PivotTable data

Editing PivotTables

Formatting PivotTables

Creating PivotTables from external data

Creating dynamic charts by using PivotCharts

Key points

11. Printing worksheets and charts

Adding headers and footers to printed pages

Preparing worksheets for printing

Previewing worksheets before printing

Changing page breaks in a worksheet

Changing the page printing order for worksheets

Printing worksheets

Printing parts of worksheets

Printing charts

Key points

12. Working with macros and forms

Enabling and examining macros

Changing macro security settings

Examining macros

Creating and modifying macros

Running macros when a button is clicked

Running macros when a workbook is opened

Inserting form controls and setting form properties

Adding text boxes to UserForms

Adding list boxes to UserForms

Adding combo boxes to UserForms

Adding option buttons to UserForms

Adding graphics to UserForms

Adding spin buttons to UserForms

Writing UserForm data to a worksheet

Displaying, loading, and hiding UserForms

Key points

13. Working with other Office programs

Linking to Office documents from workbooks

Embedding workbooks into other Office documents

Creating hyperlinks

Pasting charts into other Office documents

Key points

14. Collaborating with colleagues

Sharing workbooks

Saving workbooks for electronic distribution

Managing comments

Tracking and managing colleagues' changes

Protecting workbooks and worksheets

Authenticating workbooks

Saving workbooks as web content

Importing and exporting XML data

Working with SkyDrive and Excel Web App

Key points

Glossary

Keyboard shortcuts

Ctrl combination shortcut keys

Function keys

Other useful shortcut keys

Index

About the author