Excel 2010 For Dummies Quick Reference

Excel 2010 For Dummies Quick Reference

Paperback For Dummies: Quick Reference (Computers)

By (author) Colin Banfield, By (author) John Walkenbach

$13.92
List price $23.55
You save $9.63 40% off

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: John Wiley & Sons Ltd
  • Format: Paperback | 240 pages
  • Dimensions: 172mm x 214mm x 14mm | 299g
  • Publication date: 27 May 2010
  • Publication City/Country: Chichester
  • ISBN 10: 0470527552
  • ISBN 13: 9780470527559
  • Sales rank: 204,022

Product description

Find the answers to your most important Excel questions with this referenceJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach-along with Excel expert Colin Banfield-answers your most common and important Excel questions in this easy-to-understand reference.You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you're looking for quickly and easily. * Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions * Offers information in a highly organized, easy-to-understand format so you can find exactly what you need * Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more * Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much moreExcel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

Colin Banfield is an Excel expert with more than 20 years in the telecommunications field. John Walkenbach, aka Mr. Spreadsheet, has written more than 50 books on Excel and spreadsheet use. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Back cover copy

Straightforward and up-to-date -- the nitty-gritty on working with ExcelWant to spend more time on your projects and less time trying to figure out Excel? This handy, portable guide gives you the facts in an easy-to-use format. Two Excel gurus bring you quickly up to speed on the 2010 version and then lay out the stuff you need to know: 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 for PivotTables, in-cell charts (called Sparklines), table and PivotTable search filters, interactive PivotChart filters, and PivotTable custom calculationsMore than one -- share workbooks, protect them from unauthorized use, or compare two side-by-sideIt's relative -- use relative, absolute, and mixed references, and convert formulas to valuesCell development -- edit cell contents, copy cells and ranges, and enter dates, formulas, text, and valuesChart your progress -- choose a chart, modify its axis, create and add elements, and add context to numbersTables and more -- use tables, PivotTables, and PivotCharts effectivelyOpen the book and find: A tour of the Excel 2010 windowKeyboard shortcuts that save you timeHow to undo changes and correct mistakesAll you need to know about naming constants and formulasAdvice on formatting numbers and rangesHow to adjust settings and print your worksheetThe different types of charts and how to change themWhat to do with the slicer report filterLearn to: Navigate the new interfaceUse the Ribbon and Quick Access toolbarCreate formulas and functionsSave, protect, and recover workbook files

Table of contents

Part 1: Getting to Know Excel 2010. Part 2: Managing Workbooks. Part 3: Working with Worksheets. Part 4: Entering and Editing Worksheet Data. Part 5: Using Formulas and Functions. Part 6: Creating and Using Names. Part 7: Auditing Your Work. Part 8: Formatting Your Data. Part 9: Previewing and Printing Your Work. Part 10: Charting Your Data. Part 11: Working with Tables. Part 12: Analyzing Data with PivotTables. Part 13: Sorting and Filtering Your Data. Index.