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.
Related articles by Zemanta
- EXCEL REFRESH shortcut, refresh excel hotkey, excel data refresh shortcut, refresh data in excel shortcut, refresh genvej excel, refresh shortcut excel, refresh worksheet shortcut excel, refresh worksheet shortcut in excel, cara menggunakan autohotkey dengan excel tutorial
I need to download the Data Analysis Tool-pack from Excel, but I dont have the original installation disk, how can I do it.thanks.
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..
The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic : Codswallop (tags: excel tutorial tips howto office business tutorials tools.
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 =-.