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]
  • bettypaul

    Thank you for sharing this post. Keep posting.
    http://www.assetbuilders.in/ .

  • Thanks for sharing this information.

    Custom Boxes

  • carl marks

    i will come here soon

  • carl marks

    hello , any body here

  • carl marks

    no doubt it is very interesting and informative

  • carl marks

    u there

  • carl marks

    it is very informative … i like it

  • Nielsen Frames

    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 =-.