2007 Advance Version.

As compared to Old 2003 / XP version of MS Excel in 2007 Version several New Interaction to the Features are added. In previous versions of excel Several Features were Availble but not easily visible. But in 2007 Those Feature are put in front row. Like Auto Fiter's Features that were abailable in only Custom Menu is now splited in several parts and made accessible through Simple Second Line Menu Command.

but some interesting features are added with this version.
1. In Filters we are now able to select as many items we want to select but in previous version only the person who knows Advance filter could select more then tow items.


2. Conditional Formatting is now with several designs and Styles possible. you can apply conditional formatting with more then three conditions. New Data Bars, Icon Sets and Colour Scale helps to analysis data with visual effects.

3. Sorting is now more customizable, Also possile with more then 3 sorting priorities.

4. Some newly added function like, BIN2DEC & DEC2BIN and Randbetween.

5. New Menu Style. Added a nice look to Excel. for some persons it is not convenient but it is the matter of practice only.

6. Excel Introduced a new way of Menu Item aproach but kept in considering the approach through older keyboard combination to the menu items is still possible. In some menu items the results are differant like
if you Press Alt + A + T it will show a Pivot Table Wizard but if you use the Lagacy Keyboard Combination the Classic Pivot Tale Wizard is shown.

But the great thing with this version is now Excel Sheet is more Wide and more Long
1048576 rows X 16384 columns = 17179869184 Cells to work

Still some parts in excel that are to be added in Excel but expecting Like
A formula that can convert Numerical Values in Words.
Pivot table is still requires manual refresh.
There is no formula for Getting Formatting Information of any cell or range.
Thera is no Foumula that can provide information about sheet like sheet name sheet Index no. Etc.

Anyways we are soon expecting newer Version 2010 very shortly. lets hope excel will be with us in a new Avtaar.

Some Excel Shortcut Keys

Shortcut Keys Description
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
F7 Spell check selected text and/or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.

Dancing Chart

Ycan make some fun with Chart using Rand or randbetween (only for 2007 or later versions) in excel.
enter the formula in A1
=rand()
or
=randbetween(1,10)
copy the cell and paste it to a1 to j10
select the same range
and press F11
A new sheet with chart is created.
now keep holding F9 key and see the changes.
now change different chart types and colors and Enjoy.

Tip: Short Keys
F11 : Creates a new Sheet with Chart for selected Range
F9 : Re-calculats the entire sheet.