Learn Excel 2007 Through Excel 2010 from Mr. Excel: 512 Excel Mysteries Solved

Front Cover
Tickling Keys, Inc., 2011 - Computers - 827 pages
0 Reviews
Reviews aren't verified, but Google checks for and removes fake content when it's identified

Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. Mr. Excel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common "gotchas” that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

The Excel Environment
1
CALCULATING WITH EXCEL
129
WRANGLING DATA
365
MAKING THINGS LOOK GOOD
599
Back Cover
831
Copyright

Common terms and phrases

Additional Details Alt key Alternate Strategy appear argument arrow keys AutoComplete AutoSum axis blank cell bottom button calculate cell pointer chart Click OK color column widths command conditional formatting convert copy the formula create data set default delete Design tab dialog box display dollar signs Double-click drag drop zone dropdown Edit entry Excel Figure fill handle Filter Follow these steps font formula bar function Gotcha Here’s Home tab hyperlink icon Insert look lookup table macro match menu Microsoft month mouse move OLAP Options Paste Special pivot chart pivot table PowerPivot press Enter Print Problem Quick Access toolbar range ribbon tab right-click scroll Select cell Select Home select the cell shape shortcut slicers SmartArt sort sparklines spreadsheet style subtotals Tools ToolTip values VLOOKUP Wal-Mart WordArt workbook worksheet zero

About the author (2011)

Bill Jelen is the host of www.MrExcel.com, Microsoft MVP, contributing editor for CFO.com, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 33 books about Excel.

Bibliographic information

QR code for Learn Excel 2007 Through Excel 2010 from Mr. Excel
TitleLearn Excel 2007 Through Excel 2010 from Mr. Excel: 512 Excel Mysteries Solved
AuthorBill Jelen
PublisherTickling Keys, Inc., 2011
ISBN1932802444, 9781932802443
Length827 pages
Subjects ›  › 

Computers / Desktop Applications / Spreadsheets
  
Export CitationBiBTeX EndNote RefMan