Excel 2010 - Some Important Information

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Microsoft has done minor enhancements and 64 bit support also

 

ü You can undo the last 100 actions

ü Each worksheet holds 1,048,576 rows by 16,384 columns

ü There are 1,024 global fonts available to use, 512 per worksheet

ü Zoom range is from 10 percent to 400 percent

ü You can select 2,147,483,648 cells that are not touching

ü You can have up to 255 arguments in a function

ü You can nest 64 levels of functions per formula

ü You can have up to 255 data series in one chart

ü You can highlight 32,767 cells per worksheet

ü Multi-threading recalculation (MTR) for commonly used functions

ü Improved pivot tables

ü More conditional formatting options

ü Additional image editing capabilities

ü In-cell charts called spark lines

ü Ability to preview before pasting

ü Many new formulas, most highly specialized to improve accuracy

 

Keep Learning

Sanjay Bakshi

mesanjaybakshi@gmail.com