Excel 2010 For Dummies Quick Reference - Softcover

Banfield, Colin; Walkenbach, John

Softcover

ISBN 10: 0470527552 ISBN 13: 9780470527559

Publisher: For Dummies, 2010

Synopsis

Find the answers to your most important Excel questions withthis reference

John Walkenbach’s name is synonymous with excellence incomputer books that decipher complex technical topics. Known as"Mr. Spreadsheet," Walkenbach—along with Excel expert ColinBanfield—answers your most common and important Excelquestions in this easy-to-understand reference.

You'll learn how to open, save, protect, and recover workbookfiles; add, copy, and delete worksheets; enter and edit data andtext; create formulas and functions; audit, format, and print; andmore. Highly organized and free of unnecessary jargon, thisessential reference allows you to find the answers you’relooking for quickly and easily.

• Excel gurus Walkenbach and Banfield offer quick and easyanswers to common Excel questions
• Offers information in a highly organized, easy-to-understandformat so you can find exactly what you need
• Includes information on opening, saving, protecting andrecovering workbook files; adding, copying, and deletingworksheets; entering and editing data and text; creating formulasand functions; auditing; formatting; printing; and more
• Covers navigating the user interface; using the Ribbon andQuick Access toolbar; saving, protecting, and recovering workbookfiles; entering and editing data; creating formulas and functions,and much more

Excel 2010 For Dummies Quick Reference enables you tospend more time working on your projects rather than trying tofigure how to make Excel work for you!

About this title

From the Back Cover

Straightforward and up-to-date — the nitty-gritty onworking with Excel

Want to spend more time on your projects and less time trying tofigure out Excel? This handy, portable guide gives you the facts inan easy-to-use format. Two Excel gurus bring you quickly up tospeed on the 2010 version and then lay out the stuff you need toknow: how to compare workbooks, manage worksheets, enter dates,work with formulas and functions, and much more.

• New for 2010 — learn to use the slicer report filter forPivotTables, in-cell charts (called Sparklines), table andPivotTable search filters, interactive PivotChart filters, andPivotTable custom calculations

• More than one — share workbooks, protect them fromunauthorized use, or compare two side-by-side

• It's relative — use relative, absolute, and mixedreferences, and convert formulas to values

• Cell development — edit cell contents, copy cells andranges, and enter dates, formulas, text, and values

• Chart your progress — choose a chart, modify its axis,create and add elements, and add context to numbers

• Tables and more — use tables, PivotTables, and PivotChartseffectively

Open the book and find:

• A tour of the Excel 2010 window

• Keyboard shortcuts that save you time

• How to undo changes and correct mistakes

• All you need to know about naming constants and formulas

• Advice on formatting numbers and ranges

• How to adjust settings and print your worksheet

• The different types of charts and how to change them

• What to do with the slicer report filter

Learn to:

• Navigate the new interface

• Use the Ribbon and Quick Access toolbar

• Create formulas and functions

• Save, protect, and recover workbook files

About the Author

Colin Banfield is an Excel expert with more than 20 years inthe telecommunications field.

John Walkenbach, aka Mr. Spreadsheet, has written morethan 50 books on Excel and spreadsheet use. Visit his popularSpreadsheet Page at spreadsheetpage.com.

Edition details

• Publisher: For Dummies
• Publication date: 2010
• ISBN 10: 0470527552
• ISBN 13: 9780470527559
• Binding: Plastic Comb
• Language: English
• Edition number: 1
• Number of pages: 240