O'Reilly logo

Microsoft® Excel® 2010: Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required