Christmas Posting Dates
Microsoft Excel 2010 in Depth

Microsoft Excel 2010 in Depth

Paperback In Depth

By (author) Bill Jelen

$30.42
List price $40.72
You save $10.30 25% off

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

  • Publisher: Que Corporation,U.S.
  • Format: Paperback | 1152 pages
  • Dimensions: 179mm x 227mm x 57mm | 1,768g
  • Publication date: 25 June 2010
  • Publication City/Country: Indianapolis, IN
  • ISBN 10: 0789743086
  • ISBN 13: 9780789743084
  • Edition: 1
  • Sales rank: 97,481

Product description

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. * By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com * Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence * For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals

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

Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually.

Back cover copy

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals

Table of contents

I. Changes in User Interface 1 Out vs In actions: Out Pane 2 Review Ribbon, QAT, Galleries 3 Customizing Ribbon 4 Mini Toolbar, Normal vs Page Layout, Zoom, Live Preview 5 Keyboard Shortcuts 6 Excel Options 7 Compatibility Mode (Big Grid, File Formats) II. Calculating with Excel 8 Formulas 9 Controlling Formulas 10 Understanding Functions 11 Everyday Functions 12 Logical, Lookup, Database 13 Financial 14 Statistical 15 Trig, Matrix, Engineering 16 Connecting Worksheets and External Data 17 Super Formulas 18 Names 19 Tables III. Business Intelligence 20 Sorting 21 Filtering 22 Subtotals 23 Pivot Tables 24 Gemini 25 Slicers 26 What-If Analysis 27 VBA Macros 28 Tips and Tricks 29 Add-Ins IV. Visual Presentation of Data 30 Formatting, Themes, Cell Styles 31 Data Visualizations 32 Charting 33 Sparklines 34 Using SmartArt, Shapes, WordArt and TextBoxes 35 Pictures and ClipArt V. Sharing 36 Printing 37 Sharing 38 Excel Services