Useful shortcuts for data analysis in Excel

Excel provides shortcuts of various command, from formatting to printing. Find your favorite shortcuts of excel when dealing with data analysis task. Here the useful shortcuts:

Ctrl+Alt+F5

Refresh all information in workbook that come from various linked sources

Alt+E, K

Open edit link wizard contained external data sources, location and update command

Alt+T, G

Open goal seek command. Use goal seek to run scenario calculation

Alt+=

Shortcut to display most used calculation: sum, average, maximum, minimum etc

Shitf+F3

Display formula wizard so you can edit the formula arguments at the selected cell

F2

Quick edit. Move the pointer from anywhere to current cell. Use this to edit value, formula at choosing cell.

Shift+alt+right

If you want to collapse a range of cell, try to this command. It will cells together , or expanded it.

Tutorial: Create a Simple Diary with Autohotkey

Share this post

Related Websites

Tags: analysis, Data Analysis, Excel, FAQs Help and Tutorials, shortcut, Spreadsheets, statistics

This entry was posted on Tuesday, December 16th, 2008 at 10:09 am and is filed under Spreadsheet tips. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

Comments (3)
Trackbacks

stag parties says:

July 15, 2010 at 5:44 pm

I don’t know how to do analysis on excel it is much harder. I looked on websites but they only have it for the earlier versions.thanks..

Reply
Programming in Excel says:

June 9, 2010 at 6:33 pm

The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic : Codswallop (tags: excel tutorial tips howto office business tutorials tools.

Reply
Save Workbook says:

April 19, 2010 at 1:38 pm

SUMMARY OUTPUT gives various results as Annova, Residual output etc. Where to get information about it which symbol signifies what?
Save Workbook´s last smart idea ..Showing or Hiding a data table or chart legend

Reply