Microsoft Excel 2010
Wednesday, February 03, 2010
, Posted by gurur@j at 2/03/2010 07:29:00 AM
Microsoft Excel 2010
Exel hasn't been worked upons as much as the other applicatiosn in office 2010,but nevertheless it gets the same general improvenment in the interface:the look is simpler and cleaner,you can add recent files to the backstage menue like in word and the print preview has been thoroughly improved and now lets yous see the margins and zoom in zoom out features has been added to see the whole page or zoom in to read individual cells.
The conditional formating feature has also been overhauled,and new styles and icons have been added.
One new feature inexel is powerpivot which lets you quickly scroll through millions of rows of data in seconds for large data sheets.Complicated charts render far faster than exel 2007(which introudsed a powerful but slow new charting engine)althrough still not as fast as they used to do in 2003(lesser functionality then,of course).Spread sheets now laod and save more quickly(especially if you're using the binary XLS format).Statistical functions in exel have previously been notoriously inaccurate.But Excel 2010 has newly accurate statistical functions sigined of f for accuracy by professional number-crunchers.
If you use pivot tables,a new feature called"slices"makes it easier having to turn columns and categories on and off in the task pane like in prevous versions.With"Sparklines"that can be embedded in any work sheet,you can add instant vissulaisations to your data that give you a picture of what the numbers means without creating a chart for every cell.You might take some time learning to exploit them,but these give you the kind of visualisations we're gettings used to seeing in web2.0 apps inside your spread sheet.
Currently have 0 comments: