Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

1. Chapter 1 Setting Up a Workbook

   1. Creating Workbooks

   2. Modifying Workbooks

   3. Modifying Worksheets

   4. Customizing the Excel 2010 Program Window

   5. Key Points

2. Chapter 2 Working with Data and Excel Tables

   1. Entering and Revising Data

   2. Moving Data Within a Workbook

   3. Finding and Replacing Data

   4. Correcting and Expanding Upon Worksheet Data

   5. Defining Excel Tables

   6. Key Points

3. Chapter 3 Performing Calculations on Data

   1. Naming Groups of Data

   2. Creating Formulas to Calculate Values

   3. Summarizing Data That Meets Specific Conditions

   4. Finding and Correcting Errors in Calculations

   5. Key Points

4. Chapter 4 Changing Workbook Appearance

   1. Formatting Cells

   2. Defining Styles

   3. Applying Workbook Themes and Excel Table Styles

   4. Making Numbers Easier to Read

   5. Changing the Appearance of Data Based on Its Value

   6. Adding Images to Worksheets

   7. Key Points

5. Chapter 5 Focusing on Specific Data by Using Filters

   1. Limiting Data That Appears on Your Screen

   2. Manipulating Worksheet Data

   3. Defining Valid Sets of Values for Ranges of Cells

   4. Key Points

6. Chapter 6 Reordering and Summarizing Data

   1. Sorting Worksheet Data

   2. Organizing Data into Levels

   3. Looking Up Information in a Worksheet

   4. Key Points

7. Chapter 7 Combining Data from Multiple Sources

   1. Using Workbooks as Templates for Other Workbooks

   2. Linking to Data in Other Worksheets and Workbooks

   3. Consolidating Multiple Sets of Data into a Single Workbook

   4. Grouping Multiple Sets of Data

   5. Key Points

8. Chapter 8 Analyzing Alternative Data Sets

   1. Defining an Alternative Data Set

   2. Defining Multiple Alternative Data Sets

   3. Varying Your Data to Get a Desired Result by Using Goal Seek

   4. Finding Optimal Solutions by Using Solver

   5. Analyzing Data by Using Descriptive Statistics

   6. Key Points

9. Chapter 9 Creating Dynamic Worksheets by Using PivotTables

   1. Analyzing Data Dynamically by Using PivotTables

   2. Filtering, Showing, and Hiding PivotTable Data

   3. Editing PivotTables

   4. Formatting PivotTables

   5. Creating PivotTables from External Data

   6. Key Points

10. Chapter 10 Creating Charts and Graphics

    1. Creating Charts

    2. Customizing the Appearance of Charts

    3. Finding Trends in Your Data

    4. Summarizing Your Data by Using Sparklines

    5. Creating Dynamic Charts by Using PivotCharts

    6. Creating Diagrams by Using SmartArt

    7. Creating Shapes and Mathematical Equations

    8. Key Points

11. Chapter 11 Printing

    1. Adding Headers and Footers to Printed Pages

    2. Preparing Worksheets for Printing

    3. Printing Worksheets

    4. Printing Parts of Worksheets

    5. Printing Charts

    6. Key Points

12. Chapter 12 Automating Repetitive Tasks by Using Macros

    1. Enabling and Examining Macros

    2. Creating and Modifying Macros

    3. Running Macros When a Button Is Clicked

    4. Running Macros When a Workbook Is Opened

    5. Key Points

13. Chapter 13 Working with Other Microsoft Office Programs

    1. Including Office Documents in Workbooks

    2. Storing Workbooks as Parts of Other Office Documents

    3. Creating Hyperlinks

    4. Pasting Charts into Other Documents

    5. Key Points

14. Chapter 14 Collaborating with Colleagues

    1. Sharing Workbooks

    2. Managing Comments

    3. Tracking and Managing Colleagues’ Changes

    4. Protecting Workbooks and Worksheets

    5. Authenticating Workbooks

    6. Saving Workbooks for the Web

    7. Key Points

1. Glossary

2. Appendix Keyboard Shortcuts

   1. Ctrl Combination Shortcut Keys

   2. Function Keys

   3. Other Useful Shortcut Keys

3. Appendix About the Author