Contents at a Glance

Introduction

I Mastering the New User Interface

1 Introducing the Ribbon User Interface

2 The Quick Access Toolbar

3 The Mini Toolbar and Other U.I. Improvements

4 Keyboard Shortcuts

5 Galleries, Live Preview, and Themes

6 The Excel Options Dialog

II A Tour of What’s New

7 The Big Grid

8 Fabulous Table Intelligence

9 Visualizing Data in Excel

10 Using Pivot Tables to Analyze Data

11 Formatting Pivot Tables

12 Pivot Table Data Crunching for Excel 2007

13 Removing Duplicates and Filtering

14 Sorting Data

15 Using Excel Charts

16 Using SmartArt, Shapes, WordArt, and Text Boxes

17 Using Pictures and Clip Art

III Working in a Legacy Environment

18 File Format Differences

19 Working with Prior Versions of Excel.

IV Calculating with Excel

20 Understanding Formulas

21 Controlling Formulas

22 Understanding Functions

23 Using Everyday Functions: Math, Date and Time, and Text Functions

24 Using Powerful Functions: Logical, Lookup, and Database Functions

25 Using Financial 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

30 Using Names in Excel

31 Using What If, Scenario Manager, Goal Seek, and Solver

V Formatting and Sharing Information

32 Formatting Worksheets

33 Printing

34 Sharing Workbooks with Others

35 More Tips and Tricks for Excel 2007

VI More Power

36 Automating Repetitive Functions Using VBA Macros

37 Interacting with Other Office Applications

38 A Tour of the Best Add-Ins for Excel

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.119.163.238