What’s New in Excel 2010

Microsoft Excel 2010 contains many new features that are very helpful for carrying out various activities:

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 tab on the ribbon replaces the Office button and allows easy access to the File and Print menus.

Updated statistical functions: The accuracy of Excel statistical functions has been improved, and several new functions (including RANK.EX, AGGREGATE, WORKDAY.INTL, and NETWORKDAYS.INTL) have been added.

Equations: You can now edit equations in Excel by using an equation editor that is similar to the Microsoft Word equation editor.

Data bars: Data bars have been improved.

Paste Special: Paste Special options now include a live preview.

All the features will be discussed later in details in the following posts. Keep reading !!!!