Microsoft Office Excel 2010 QuickSteps | QuickSteps

Home >
Browse >
QuickSteps >
Microsoft Office Excel 2010 QuickSteps

Microsoft Office Excel 2010 QuickSteps

Authors: John Cronan

Published: April 2010

eISBN: 9780071634908 0071634908 | ISBN: 9780071634892

Contents

Acknowledgments

Introduction

Chapter 1 Stepping into Excel

Opening Excel

Explore the Excel Window

Become Familiar with the Ribbon

Work with File View

Customize the Ribbon

Customize the Quick Access Toolbar

Get Help

Open Help

Use the Excel Help Window

Understanding Versions of Office 2010

Using Workbooks

Create a New Workbook

Open an Existing Workbook

Change the Appearance of New Workbooks

Save a Workbook

Understanding Excel’s XML File Formats

Add Identifying Information

Exit an Excel Session

Understanding Excel File Compatibility

Chapter 2 Entering and Editing Data

Understanding Data Types

Enter Data

Enter Text

Completing an Entry

Enter Numeric Data

Enter Dates

Formatting Numbers

Use Times

Understanding Excel Dates and Times

Adding Data Quickly

Edit Data

Edit Cell Data

Remove Cell Contents

Selecting Cells and Ranges

Copy and Paste Data

Using the Office Clipboard

Find and Replace Data

Verify Spelling

Modify Automatic Corrections

Chapter 3 Formatting a Worksheet

Adding and Removing Rows, Columns, and Cells

Work with Cells, Rows, and Columns

Adjust Row Height

Adjust Column Width

Hide and Unhide Rows and Columns

Change Cell Borders

Add a Comment

Formatting Comments

Apply Formatting

Apply Themes

Understanding Excel Formatting

Create Custom Themes

Use Cell Styles

Searching for Themes

Change Fonts

Change Alignment and Orientation

Add a Background

Copy Formatting

Arrange and Organize Worksheets

Lock Rows and Columns

Split a Worksheet

Working with Worksheets

View Worksheets from Multiple Workbooks

Compare Workbooks

Chapter 4 Using Formulas and Functions

Understanding Cell Referencing Types

Reference Cells

Change Cell References

Change to R1C1 References

Name Cells

Using Cell Reference Operators

Go to a Named Cell

Use the Name Manager

Build Formulas

Create a Formula

Adding a Symbolic Formula

Edit a Formula

Move Formulas

Using Formulas

Copy Formulas

Recalculate Formulas

Use External References in Formulas

Understanding the Trust Center

Format Conditionally

Using Functions Quickly

Use Functions

Enter a Function

Enter a Sum in Columns or Rows Quickly

Find and Correct Errors

Check for Errors

Trace Precedent and Dependent Cells

Watch a Cell

Evaluate a Formula in Pieces

Chapter 5 Viewing and Printing Data

Understanding Excel Views

Lay Out a Worksheet

Add Headers and Footers

Adding Content to Headers and Footers

Add Pictures to Headers and Footers

Change Margins

Select Page Orientation

Use Headings as Page Titles

Working with Zoom

Print the Data

Change the Order in Which Pages Print

Print Comments

Choosing Worksheet Print Options

Use Print Areas

Choosing What to Print

Preview the Print Job

Scale Your Data Before Printing

Output the Print Job

Save and View Custom Views

Chapter 6 Charting Data

Building a Chart

Create and Design a Chart

Choose a Chart Type

Selecting Data for Charting

Choose a Chart Location

Modify How the Data Is Plotted

Apply a Chart Layout

Change a Chart’s Style

Selecting Chart Elements

Modify Chart Elements

Add Titles

Show or Hide Axes

Add or Remove Gridlines

Show or Hide a Legend

Identifying Chart Elements

Add Data Labels

Display the Data Table

Create Your Own Chart Type

Add a Second Value Axis

Using Chart Templates

Format Chart Elements

Working with Charts

Use Charts

Add Charts Elsewhere

Analyze Charts

Working with Sparklines

Print a Chart

Create Sparklines

Chapter 7 Working with Illustrations

Understanding Illustrations

Add Illustrations

Add Shapes

Working with Curves

Add Text

Use SmartArt

Changing Smart Art

Insert Pictures

Take Screenshots

Using Pictures

Working with Illustrations

Select, View, and Delete Illustrations

Using Handles and Borders to Change Illustrations

Crop Pictures

Position Illustrations

Combining Illustrations by Grouping

Format Illustrations and Text

Use Styles

Changing a Picture’s Attributes

Apply Styling Elements to Pictures

Change a Shape’s Fill

Add WordArt Styling to Text

Make Detailed Formatting Changes

Chapter 8 Managing Data

Understanding Excel Tables

Build Tables

Create a Table

Adding Rows and Columns to a Table

Delete Rows and Columns Within a Table

Add a Total Row

Apply Styles to a Table

Working with Tables

Validate Data

Locating Validation Data

Organize Data

Sort Data by Columns and Rows

Removing Filters

Create an AutoFilter

Setting Up Criteria and Extract Ranges

Use Advanced Filtering

Outline Data Automatically

Using Outlines

Outline Data by Manually Grouping

Add Subtotals

Add Styles to an Outline

Chapter 9 Analyzing and Sharing Data

Get the Results You Want

Use Goal Seek

Compare Alternatives Using Scenarios

Using a One-Variable Columnar Data Table

Use Multiple Variables to Provide a Result

Explaining the Solver Example

Save Solver Results and Settings

Changing Solver Settings

Work with PivotTables

Understanding PivotTable Terms

Create a PivotTable

Create the PivotTable Layout

Use Slicers

Using PivotTables

Style a PivotTable

Create a PivotTable Chart

Preparing to Share Workbooks

Work with Other Users

Protect Workbooks with Passwords

Share a Workbook

Working with Changes in a Shared Workbook

Protect a Shared Workbook

Discontinue Sharing a Workbook

Work with Views

Protect Worksheet and Workbook Elements

Merging Workbooks

Chapter 10 Extending Excel

Acquire Data

Convert Text to Data

Add a Table from an Access Database

Get Data from the Web

Add External Data from Existing Connections

Setting External Data Range Properties

Manage Connections

Understanding the Difference Between Save and Publish

Use Excel with Web Technology

Save a Workbook as a Web Page

Publish Workbook Items as a Web Page

Understanding SkyDrive, SharePoint, and Excel Services

Use Hyperlinks

Automate Excel

Use Recorded Macros

Edit a Macro

Index