Chapter 1. What’s New in Excel 2010

Microsoft Excel 2010 contains many new features that are helpful to the business analyst, including these:

  • Customizable ribbon. Now you can completely customize the appearance of the ribbon.

  • Sparklines. Cool graphs that summarize lots of data in a single cell.

  • Slicers. Dashboard controls that make “slicing and dicing” PivotTable calculations much easier.

  • PowerPivot. A free add-in that enables you to quickly create PivotTables with up to 100 million rows of data based on data from many sources (databases, spreadsheets, and websites).

  • Solver. An improved Solver allows you to find the “best” solution to many business problems for which previous versions of the Solver returned incorrect answers.

  • File tab. The new File ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.