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.

Reblog this post [with Zemanta]