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