Chapter 1. Solving Problems with Functions

• Introducing the New Functions in Excel 2010

• Scenario and Goals

• The New Way to Work with Data, Formulas, and Functions

• Entering Test Data Fast

• Converting Formula Results into Fixed Values

• Formatting Numeric Values

• Calculating Profit Margin

• Formatting Data as a Table

• Calculating Profit Margin as a Percentage

• Applying Conditional Formatting

• Creating Meaningful Charts

• Working with PivotTables

• Using PivotCharts: Graphical Pivot

This chapter introduces Microsoft Excel and its functions. There are more practical examples with detailed function descriptions in Chapter 7 to Chapter 17 of this book.

First you will become familiar with Excel 2010, because there have been some notable changes since Excel 2007. Even if you are already using Excel 2010, you should be able to find some interesting points and suggestions.