Microsoft Excel 2010 Plain & Simple

by Frye, Curtis

• ISBN13: 9780735627277
• ISBN10: 0735627274
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-15
• Publisher: Microsoft Press

Summary

Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.Here's WHAT you'll learn: Navigate the user interface with Backstage view and the customizable ribbon Create formulas and functions Use charts and diagrams to display information visually Enhance your spreadsheet with graphic effects Reuse data from other Microsoft Office documents Team up and share spreadsheets with colleaguesAnd here's HOW you'll learn it: Jump in wherever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help you apply what you learn right away

Author Biography

Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.

Table of Contents

Acknowledgments

Introduction: About This Book

No Computerese!

Useful Tasks...

...And the Easiest Way to Do Them

A Quick Overview

A Few Assumptions

A Final Word (or Two);

What's New and Improved in Excel 2010

Managing Excel Files and Settings in Backstage View

Previewing Data Using Paste Preview

Customizing the Excel 2010 User Interface

Summarizing Data Using More Accurate Functions

Summarizing Data Using Sparklines

Visualizing Data Using Improved Conditional Formats

Creating and Displaying Math Equations

Editing Pictures Within Excel 2010;

Getting Started with Excel 2010

Surveying the Excel Program Window

Starting Excel

Finding and Opening Existing Workbooks

Using File Properties

Creating a New Workbook

Working with Multiple Workbooks

Sizing and Viewing Windows

Zooming In or Out on a Worksheet

Viewing a Worksheet in Full-Screen Mode

Saving and Closing an Excel Workbook

Using the Excel Help System;

Building a Workbook

Understanding How Excel Interprets Data Entry

Navigating the Worksheet

Selecting Cells

Entering Text in Cells

Entering Numbers in Cells

Entering Dates and Times in Cells

Entering Data Using Fills

Entering Data with Other Shortcuts

Creating an Excel Table

Editing Cell Contents

Inserting a Symbol in a Cell

Creating Hyperlinks

Cutting, Copying, and Pasting Cell Values

Clearing Cell Contents

Using the Office Clipboard

Undoing or Redoing an Action

Finding and Replacing Text

Checking the Spelling of Your Worksheet;

Managing and Viewing Worksheets

Viewing and Selecting Worksheets

Renaming Worksheets

Moving Worksheets

Copying Worksheets

Inserting and Deleting Worksheets

Hiding or Showing a Worksheet

Changing Worksheet Tab Colors

Inserting, Moving, and Deleting Cells

Inserting, Moving, and Deleting Columns and Rows

Hiding and Unhiding Columns and Rows

Entering Data and Formatting Many Worksheets at the Same Time

Changing How You Look at Excel Workbooks

Naming and Using Worksheet Views;

Using Formulas and Functions

Understanding Formulas and Cell References in Excel

Creating Simple Cell Formulas

Assigning Names to Groups of Cells

Using Names in Formulas

Creating a Formula That References Values in an Excel Table

Creating Formulas That Reference Cells in Other Workbooks

Summing a Group of Cells Without Using a Formula

Creating a Summary Formula

Summing with Subtotals and Grand Totals

Exploring the Excel Function Library

Using the IF Function

Checking Formula References

Debugging Your Formulas;

Formatting the Cell

Formatting Cell Contents

Formatting Cells Containing Numbers

Formatting Cells Containing Dates

Adding Cell Backgrounds and Shading

Formatting Cell Borders

Defining Cell Styles

Aligning and Orienting Cell Contents

Formatting a Cell Based on Conditions

Changing How Conditional Formatting Rules Are Applied

Stop When a Condition Is Met

Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values

Deleting Conditional Formats

Copying Formats with Format Painter

Merging or Splitting Cells or Data;

Formatting the Worksheet

Applying Workbook Themes

Coloring Sheet Tabs

Changing a Worksheet's Gridlines

Changing Row Heights and Column Widths

Inserting Rows or Columns

Moving Rows and Columns

Deleting Rows and Columns

Outlining to Hide and Show Rows and Columns

Hiding Rows and Columns

Protecting Worksheets from Changes

Locking Cells to Prevent Changes;

Printing Worksheets

Previewing Worksheets Before Printing

Printing Worksheets with Current Options

Choosing Whether to Print Gridlines and Headings

Choosing Printers and Paper Options

Printing Part of a Worksheet

Printing Row and Column Headings on Each Page

Setting and Changing Print Margins

Setting Page Orientation and Scale

Creating Headers and Footers

Adding Graphics to a Header or a Footer

Setting and Viewing Page Breaks;

Customizing Excel to the Way You Work

Opening Ready-to-Use Workbook Templates

Adding Commands to the Quick Access Toolbar

Modifying the Ribbon User Interface

Controlling Which Error Messages Appear

Defining AutoCorrect and AutoFormat Entries;

Sorting and Filtering Worksheet Data

Sorting Worksheet Data

Creatingggggg a Custom Sort List

Filtering Data Quickly with AutoFilter

Creating an Advanced Filter

Validating Data for Correctness During Entry;

Summarizing Data Visually Using Charts

Displaying Data Graphically

Creating a Chart Quickly

Changing a Chart's Appearance

Formatting Chart Legends and Titles

Changing the Body of a Chart

Customizing Chart Data

Working with Common Charts

Working with Uncommon Charts

Adding a Trendline to a Chart

Summarizing Data Using Sparklines;

Enhancing Your Worksheets with Graphics

Working with Graphics in Your Worksheets

Adding Graphics to Worksheets

Adding Drawing Objects to a Worksheet

Adding Fills to Drawing Objects

Adding Effects to Drawing Objects

Customizing Pictures and Objects

Aligning and Grouping Drawing Objects

Using WordArt to Create Text Effects in Excel

Inserting Clip Art into a Worksheet

Inserting and Changing a Diagram

Creating an Organization Chart

Adding an Equation to a Shape;

Sharing Excel Data with Other Programs

Introducing Linking and Embedding

Linking and Embedding Other Files

Exchanging Table Data Between Excel and Word

Copying Excel Charts and Data into PowerPoint

Exchanging Data Between Access and Excel

Importing a Text File;

Using Excel in a Group Environment

Sharing Workbooks in Excel

Commenting in Cells

Tracking Changes in Workbooks

Accepting or Rejecting Changes

Saving Worksheets to the Web

Dynamically Update Worksheets Published to the Web

Retrieving Web Data Using Excel

Modifying Web Queries

Introducing XML

Interacting over the Web Using XML;

Table of Contents provided by Publisher. All Rights Reserved.