Excel 2010 For Dummies, Portable Edition E-Book

Greg Harvey

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch

Seitenzahl: 289

Veröffentlichungsjahr: 2012

Beschreibung

Crunch numbers, create spreadsheets, and get up to speed on Excel 2010! This friendly book gets you started with the basics of Excel 2010, such as creating a spreadsheet from scratch, selecting commands from the Ribbon, customizing the Quick Access toolbar, creating simple formulas, moving and copying data with drag and drop, using the AutoCorrect and AutoFill features, and more. * Navigate effectively -- see how the Ribbon interface and the Backstage View give you access to all the tools you need for every task * Be a mover and a shaker -- move and copy data with cut, copy, and paste or drag and drop * Summing up -- total columns and rows of numbers with the AutoSum button * Making it pretty -- format data tables, adjust column widths and row heights, hide columns and rows, and format with Styles or the Format Painter * Safety net -- save your work and recover spreadsheets after a computer crash Open the book and find: * What's new in Excel 2010 * How to surf an Excel 2010 worksheet and workbook * Instructions for entering data in a worksheet * Tips for keeping your data secure * How to enter and edit formulas with built-in functions * Tips for undoing or deleting data entry mistakes Learn to: * Get comfortable with Excel 2010 and Backstage View * Create and edit spreadsheets * Format cells, create formulas, and fix data entry errors * Copy, cut, move, paste, or delete data

Leseprobe

Excel® 2010 For Dummies®, Portable Edition

Table of Contents

Introduction

About This Book

How to Use This Book

What You Can Safely Ignore

Foolish Assumptions

Conventions Used in This Book

Keyboard and mouse

Special icons

Where to Go from Here

Chapter 1: The Excel 2010 User Experience

Excel’s Ribbon User Interface

Going Backstage via File

Bragging about the Ribbon

Customizing the Quick Access toolbar

Having fun with the Formula bar

What to do in the Worksheet area

Showing off the Status bar

Launching and Quitting Excel

Starting Excel from the Start menu

Starting Excel from the Windows XP Start menu

Pinning a Microsoft Excel 2010 option on your Windows Start menu

Adding a Microsoft Excel 2010 shortcut to your Windows desktop

Adding Excel to the Windows Quick Launch toolbar

Pinning an Excel icon to the Windows 7 taskbar

Exiting Excel

Help Is on the Way

Chapter 2: Creating a Spreadsheet from Scratch

So What Ya Gonna Put in That New Workbook of Yours?

The ins and outs of data entry

You must remember this . . .

Doing the Data-Entry Thing

It Takes All Types

The telltale signs of text

How Excel evaluates its values

Fabricating those fabulous formulas!

If you want it, just point it out

Altering the natural order of operations

Formula flub-ups

Fixing Those Data Entry Flub-Ups

You really AutoCorrect that for me

Cell editing etiquette

Taking the Drudgery out of Data Entry

I’m just not complete without you

Fill ’er up with AutoFill

Inserting special symbols

Entries all around the block

Data entry express

How to Make Your Formulas Function Even Better

Inserting a function into a formula with the Insert Function button

Editing a function with the Insert Function button

I’d be totally lost without AutoSum

Making Sure That the Data Is Safe and Sound

The Save As dialog box in Windows 7 and Windows Vista

The Save As dialog box in Windows XP

Changing the default file location

The difference between the XLSX and XLS file format

Saving the Workbook as a PDF

Document Recovery to the Rescue

Chapter 3: Editing a Spreadsheet

Opening the Darned Thing Up for Editing

Operating the Open dialog box

Opening more than one workbook at a time

Opening recently edited workbooks

When you don’t know where to find them

Opening files with a twist

Much Ado about Undo

Undo is Redo the second time around

What ya gonna do when you can’t Undo?

Doing the Old Drag-and-Drop Thing

Copies, drag-and-drop style

Insertions courtesy of drag and drop

Formulas on AutoFill

Relatively speaking

Some things are absolutes!

Cut and paste, digital style

Paste it again, Sam . . .

Keeping pace with Paste Options

Paste it from the Clipboard task pane

So what’s so special about Paste Special?

Let’s Be Clear about Deleting Stuff

Sounding the all clear!

Get these cells outta here!

Staying in Step with Insert

Stamping Out Your Spelling Errors

Chapter 4: Formatting a Spreadsheet

Choosing a Select Group of Cells

Point-and-click cell selections

Keyboard cell selections

Having Fun with the Format as Table Gallery

Cell Formatting from the Home Tab

Formatting Cells Close to the Source with the Mini-Toolbar

Using the Format Cells Dialog Box

Getting comfortable with the number formats

The values behind the formatting

Make it a date!

Ogling some of the other number formats

Calibrating Columns

Rambling rows

Now you see it, now you don’t

Futzing with the Fonts

Altering the Alignment

Intent on indents

From top to bottom

Tampering with how the text wraps

Reorienting cell entries

Shrink to fit

Bring on the borders!

Applying fill colors, patterns, and gradient effects to cells

Do It in Styles

Creating a new style for the gallery

Copying custom styles from one workbook into another

Fooling Around with the Format Painter

Conditional Formatting

Conditionally formatting values with sets of graphic scales and markers

Highlighting cells according to what ranges the values fall into

Chapter 5: Printing a Spreadsheet

Taking a Gander at the Pages in Page Layout View

Checking and Printing a Report from the Print Panel

Printing Just the Current Worksheet

My Page Was Set Up!

Using the buttons in the Page Setup group

Using the buttons in the Scale to Fit group

Using the Print check boxes in the Sheet Options group

From Header to Footer

Adding an Auto Header or Auto Footer

Creating a custom header or footer

Solving Page Break Problems

Letting Your Formulas All Hang Out

Chapter 6: Top Ten Features in Excel 2010

Excel® 2010 For Dummies®, Portable Edition

by Greg Harvey, PhD

Excel® 2010 For Dummies®, Portable Edition

Published byJohn Wiley & Sons, Inc.111 River St.Hoboken, NJ 07030-5774

www.wiley.com

Copyright © 2012 by John Wiley & Sons, Inc.

Published by John Wiley & Sons, Inc., Hoboken, NJ

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the Publisher. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.

Trademarks: Wiley, the John Wiley & Sons, Inc. logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc., and/or its affiliates in the United States and other countries, and may not be used without written permission. Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc., is not associated with any product or vendor mentioned in this book.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

For technical support, please visit www.wiley.com/techsupport.

Wiley also publishes its books in a variety of electronic formats and by print-on-demand. Not all content that is available in standard print versions of this book may appear or be packaged in all book formats. If you have purchased a version of this book that did not include media that is referenced by or accompanies a standard print version, you may request this media by visiting http://booksupport.wiley.com. For more information about Wiley products, visit us at www.wiley.com.

ISBN: 978-1-118-31524-8 (pbk); ISBN: 978-1-118-33215-3 (ebk); ISBN: 978-1-118-33423-2 (ebk); ISBN: 978-1-118-33537-6 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-in-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

Dedication

An Erucolindo melindonya

Author's Acknowledgments

Let me take this opportunity to thank all the people, both at John Wiley & Sons, Inc., and at Mind over Media, Inc., whose dedication and talent combined to get this book out and into your hands in such great shape.

Publisher’s Acknowledgments

We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

Some of the people who helped bring this book to market include the following:

Acquisitions and Editorial

Project Editor: Paul Levesque      (Previous Edition: Nicole Sholly)

Acquisitions Editor: Katie Feltman

Copy Editor: Brian Walls

Technical Editors: Mike Talley, Joyce Nielsen

Editorial Manager: Leah Michael

Editorial Assistant: Amanda Graham

Sr. Editorial Assistant: Cherie Case

Cover Photo: © iStockphoto.com / Cary Westfall

Cartoons: Rich Tennant (www.the5thwave.com)

Composition Services

Senior Project Coordinator: Kristie Rees

Layout and Graphics: Carrie A. Cesavice

Proofreaders: Lindsay Amones, Debbye Butler, John Greenough

Indexer: BIM Indexing & Proofreading Services

Publishing and Editorial for Technology Dummies

Richard Swadley, Vice President and Executive Group Publisher

Andy Cummings, Vice President and Publisher

Mary Bednarek, Executive Acquisitions Director

Mary C. Corder, Editorial Director

Publishing for Consumer Dummies

Kathy Nebenhaus, Vice President and Executive Publisher

Composition Services

Debbie Stailey, Director of Composition Services

Introduction

I’m very proud to present you with Excel 2010 For Dummies, Portable Edition, the latest version of everybody’s favorite book on Microsoft Office Excel for readers with no intention whatsoever of becoming spreadsheet gurus.

Excel 2010 For Dummies, Portable Edition, covers all the fundamental techniques you need to know in order to create, edit, format, and print your own spreadsheets. This book concentrates on spreadsheets because spreadsheets are what most regular folks create with Excel.

About This Book

This book isn’t meant to be read cover to cover. Although its chapters are loosely organized in a logical order (progressing as you might when studying Excel in a classroom situation), each topic covered in a chapter is really meant to stand on itsown.