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:
Refresh all information in workbook that come from various linked sources
Open edit link wizard contained external data sources, location and update command
Open goal seek command. Use goal seek to run scenario calculation
Shortcut to display most used calculation: sum, average, maximum, minimum etc
Display formula wizard so you can edit the formula arguments at the selected cell
Quick edit. Move the pointer from anywhere to current cell. Use this to edit value, formula at choosing cell.
If you want to collapse a range of cell, try to this command. It will cells together , or expanded it.