Microsoft Office Excel 2010 For Dummies Quick Reference..pdf

Desktop Applications/Spreadsheets
™
Making Everything Easier!
Straightforward and
up-to-date — the nitty-gritty
Open the book and find:
on working with Excel ®
• A tour of the Excel 2010 window Microsoft ®
Want to spend more time on your projects and less time
• Keyboard shortcuts that save you time
trying to figure out Excel? This handy, portable guide gives
you the facts in an easy-to-use format. Two Excel gurus • How to undo changes and correct
bring you quickly up to speed on the 2010 version and mistakes
then lay out the stuff you need to know: how pare • All you need to know about naming 2010
workbooks, manage worksheets, enter dates, work with constants and formulas Excel
formulas and functions, and much more. • Advice on formatting numbers and
ranges
• New for 2010 — learn to use the slicer report filter for
PivotTables, in-cell charts (called Sparklines), table and • How to adjust settings and print your
PivotTable search filters, interactive PivotChart filters, worksheet
and PivotTable custom calculations • The different types of charts and how
• More than one — share workbooks, protect them from to change them
unauthorized use, pare two side-by-side • What to do with the slicer report filter
• It’s relative — use relative, absolute, and mixed
references, and convert formulas to values
• Cell development — edit cell contents, copy cells and
ranges, 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
Go to ®
• Tables and more — use tables, PivotTables, and Learn to:
PivotCharts effectively for videos, step-by-step photos,
how-to articles, or to shop! • Navigate the new interface
• Use the Ribbon and Quick Access toolbar
• Create formulas and functions
• Save, protect, and recover
workbook files
$ US / $22. / £ UK
ISBN 978-0-470-52755-9
Colin Banfield is an Excel