Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. His team provides custom Excel applications to clients around the world. You can see Bill as a regular guest on Call for Help with Leo Laporte in Australia, in Canada, and on Google Video. Bill produces a daily video podcast about Excel. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up.
Introduction
I Mastering the New User Interface
1 Introducing the Ribbon User Interface . . . . . . . . . . . . . 21
2 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
3 The Mini Toolbar and Other U.I. Improvements . . . 53
4 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
5 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 87
6 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . . . . . 103
II A Tour of Whats New
7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
8 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . . . . . 131
9 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
10 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 191
11 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215
12 Pivot Table Data Crunching for Excel 2007 . . . . . . . 237
13 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . 271
14 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287
15 Using Excel Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299
16 Using SmartArt, Shapes, WordArt, and Text Boxes . . 327
17 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . . . . . 351
III Working in a Legacy Environment
18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365
19 Working with Prior Versions of Excel . . . . . . . . . . . . . . 371
IV Calculating with Excel
20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 385
21 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409
22 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
23 Using Everyday Functions: Math, Date and Time,
and Text Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451
24 Using Powerful Functions: Logical, Lookup, and
Database Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525
25 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 587
26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . . . . . . 631
27 Using Trig, Matrix, and Engineering Functions . . . . 735
28 Connecting Worksheets, Workbooks, and
External Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 797
2...