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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial