Picture Yourself Learning Microsoft Excel 2010

by Hayes, Deidre; Fuller, Laurie U; Riley, Jeffery A.; Fulton, Jennifer

• ISBN13: 9781598638882
• ISBN10: 1598638882
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-17
• Publisher: Cengage Learning PTR

Summary

This book is a guide to the features of Microsoft Excel, one of the key products of the Microsoft Office suite. Step-by-step instructions and visual aides help the reader easily learn the software. PICTURE YOURSELF LEARNING MICROSOFT EXCEL 2010 teaches the latest version of Microsoft Excel by following along in a four-color, highly visual format. Readers will develop the skills needed to complete a multitude of tasks, such as working with formulas, filtering and sorting data, working with charts, and much more.

Table of Contents

Introduction

Just the Basics

Creating a Basic Excel Worksheet

Exploring the Excel Window

Entering Excel Data

Learning Selection Techniques

Editing a Worksheet

Working with Range Names

Using Data Validation

Working with Formulas

Creating Formulas

Copying Formulas

Creating an Absolute Formula Reference

Using Excel Functions

Understanding Function Syntax

Creating a Total with the SUM Function

Using Other Functions

Getting Help with Excel Functions

Troubleshooting Formula Errors

Viewing Formulas

Understanding Common Formula Error Messages

Identifying Formula Precedents and Dependents

Making the Worksheet Look Good

Changing Cell Formats

Working with Alignment and Spacing

Adding Borders and Shading

Discovering Formatting Shortcuts

Handling Larger Workbooks

Managing Large Amounts of Excel Data

Working with Multiple Worksheets

Using Find and Replace

Managing Worksheet Views

Sorting Data

Sorting from the Ribbon

Working with the Sort Command

Sorting by Multiple Criteria

Removing Duplicate Records

Filtering Data

Creating an AutoFilter

Searching for Blank Cells

Performing a Secondary Filter Selection

Choosing Text Comparison Filters

Choosing Additional Comparison Criteria

Reviewing Other Filter Options

Filtering by Date or Time

Splitting Data into Multiple Columns

Adjusting Page Layout

Managing Manual Page Breaks

Specifying a Print Area

Setting the Paper Orientation and Size

Shrinking Worksheets to Fit

Setting Page Margins

Repeating Rows and Columns

Printing Gridlines and Headings

Working with Headers and Footers

Printing Your Worksheet

Previewing Your Work

Printing a Worksheet

E-mailing Workbooks

Working with Graphics

Generating Excel Charts

Creating a Basic Chart

Inserting a Chart

Changing the Chart Options

Inserting Illustrations

ClipArt

Pictures

Shapes

Text Boxes

SmartArt

Excel Tools

Setting Security Options

Hiding a Workbook

Inspecting for Private Information

Protecting Worksheets

Unlocking Cells

Hiding Cell Formulas

Marking a Workbook as Final

Assigning a File Password

Collaborating With Others

Pivot Tables

Excel Options

Table of Contents provided by Publisher. All Rights Reserved.