Skip to Main Content
Microsoft® Excel® 2010: Data Analysis and Business Modeling
book

Microsoft® Excel® 2010: Data Analysis and Business Modeling

by Wayne L. Winston
January 2011
Beginner to intermediate content levelBeginner to intermediate
720 pages
23h 29m
English
Microsoft Press
Content preview from Microsoft® Excel® 2010: Data Analysis and Business Modeling

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Wayne L. Winston
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780735656864Purchase book