I Mastering the New User Interface
1 Introducing the Ribbon User Interface
3 The Mini Toolbar and Other U.I. Improvements
5 Galleries, Live Preview, and Themes
10 Using Pivot Tables to Analyze Data
12 Pivot Table Data Crunching for Excel 2007
13 Removing Duplicates and Filtering
16 Using SmartArt, Shapes, WordArt, and Text Boxes
17 Using Pictures and Clip Art
III Working in a Legacy Environment
19 Working with Prior Versions of Excel.
23 Using Everyday Functions: Math, Date and Time, and Text Functions
24 Using Powerful Functions: Logical, Lookup, and Database Functions
26 Using Statistical Functions
27 Using Trig, Matrix, and Engineering Functions
28 Connecting Worksheets, Workbooks, and External Data
29 Using Super Formulas in Excel
31 Using What If, Scenario Manager, Goal Seek, and Solver
V Formatting and Sharing Information
34 Sharing Workbooks with Others
35 More Tips and Tricks for Excel 2007
36 Automating Repetitive Functions Using VBA Macros
37 Interacting with Other Office Applications
18.119.163.238