Microsoft Excel 2010 In Depth

Author description

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.

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