Microsoft Excel 2010 in depth : Description based on print version record

**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

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

I. Changes in User Interface1 Out vs In actions: Out Pane2 Review Ribbon, QAT, Galleries3 Customizing Ribbon4 Mini Toolbar, Normal vs Page Layout, Zoom, Live Preview5 Keyboard Shortcuts6 Excel Options7 Compatibility Mode (Big Grid, File Formats) II. Calculating with Excel8 Formulas9 Controlling Formulas10 Understanding Functions11 Everyday Functions12 Logical, Lookup, Database13 Financial14 Statistical15 Trig, Matrix, Engineering16 Connecting Worksheets and External Data17 Super Formulas18 Names19 Tables III. Business Intelligence20 Sorting21 Filtering22 Subtotals23 Pivot Tables24 Gemini25 Slicers26 What-If Analysis27 VBA Macros28 Tips and Tricks29 Add-Ins IV. Visual Presentation of Data30 Formatting, Themes, Cell Styles31 Data Visualizations32 Charting33 Sparklines34 Using SmartArt, Shapes, WordArt and TextBoxes35 Pictures and ClipArt V. Sharing36 Printing37 Sharing38 Excel Services Provides comprehensive coverage on the spreadsheet software, including detailed solutions to everyday problems, real-world examples, troubleshooting help, and in-depth explanations of new features.