nothing wrong with the mouse, you only save like 2 seconds by doing the short cuts. But good list anyway :)

Id say they save you 2 seconds per action while making a model...shortcuts save a considerable amount of time. And dont forget alll the alt + letters combinations in excel. Its just quick menu use, not exactly shortcuts, but they are incredibly time saving

I've got a couple that for some reason people don't seem to know:

Ctrl + Shift + - (minus): remove all borders in selection.

^ This one saves me a considerable amount of time

Ctrl + Shift + 7: Apply border around selection.

Alt + ; : Define Styles dialog

Ctrl + ; : Insert current date

Ctrl + 1 : Format cells dialog (duh, the most used)

Do you have any idea what you are talking about? I hope you say that in an interview.

I sometimes use the mouse if I'm particularly bored with a task to mix it up a bit but I inevitably get annoyed and go back to the keyboard. Most of the shortcuts I know about I've found out by accident...tough to remember a long list of them from day one.

I remember in my first week being taken through the comp template by a senior analyst and him telling me "you need to play that keyboard like a piano" which at the time I thought was amusing/ sad. I totally get it now though.

Is there a shortcut to tab between frames on a webpage?

good call

you save a lot more time than that with keyboard shortcuts.

all the alt e-s's will save you a lot of time.

the key is having both hands on the keyboard at all times--very efficient.

Anyone that says shortcuts don't save time doesn't know them.

Force yourself to use them for a week and thank us later.

Thanks...Much appreciated

nice. very nice.

Anyone know how to move from a cell to the fx bar to edit something?

Thanks!

thanks for the Alt + "=" . it is really helpful. i used to rather write the formula on the keyboard than having to click the sigma sign with the mouse.

and you need the keyboard shortcuts, not for the 2 seconds,but it is just that using the mouse becomes really irritating and annoying, anyone who works a lot with excel should know that. sometimes you do stuff that take a few more seconds with the keyboard just not to use the mouse, and having to lift your hand, take it off the keyboard and click the mouse, then putting your hand back to the keyboard. it is just annoying.

btw, i am not doing an internship in IB but somewhere else. i hope i get one next summer.

I always hit F1 instead of F2 and was about to DDT my Monitor one night when I found out Ctrl+F1 takes away the help menu....

F9 - Update

:)

F9 - Update
F9 - Update
F9 - Update
F9 - Update!!!!!!!

'ctrl'+'tab' to switch between tabs on firefox

Crtl + Page Up/Page Down = Move between tabs in an Excel Workbook

This is a good custom excel shortcuts add-in:

http://www.simpleshortcuts.net

^^

Consultant in the house, biatches.

Control - Space, Alt - O, C, A

or

Shirt - Space, Alt - O, R, A

P.S. Some use of the mouse is actually quicker (i.e. selecting a background color in the formatting dialog box--do you really want to hit the arrow that many times?)

P.P.S. Thanks for reminding me about Alt - = and Control - ] and Control - [.

It's A, not H - but I'm sure most idiots could figure that out.

I'm really suprised no one has mentioned the following (which has made my life so, so much easier):

To truly unlock the power of Excel - create your own shortcuts. To assign a shortcut key to any of the toolbar buttons, do the following.

1. Right click on the toolbar area at the top of excel - a menu will pop-down
2. Click "Customize..." at the bottom of the pop-down menu - this will open a dialogue box.
3. While this dialogue box is open, you're still able to click 'behind' the dialogue box on any of the buttons in the toolbars.

4. Pick the button that you want to assign an alt + "any key" shortcut to. For this example, lets choose the 'remove decimal' button (for clarity, the button which if you're on a cell(s) with "0.00" formatting if you click once, removes one decminal place, click twice and it removes the second decimal place,).
5. Right click on this button and you'll get another pop-down menu.
6. Check off "Image and Text"
7. In the Name Dialogue box of this same pop-down menu replace the current entry with "&." (where the & = the 'alt' key, and the "." equals the corresponding shortcut key)
8. Click anywhere to exit the pop-down menu, then exit from the Customize menu.
9. Now take a look at your button. It should have your shortcut key (".") next to it with an underline.
10. Now in your sheet type a number, format it to two decimal places, then use your new alt + "." (although i think of it as alt + ">", and my add decimal place key is alt + "<")

As you might have discerned, the possibilities with this feature are endless. I've created shortcuts for cell justification, adding the "," for thousands, indenting. These shortcuts esstially eliminate the need to alt > release > ctrl + tab your way to these buttons.

When you're in customize mode (step #2 and #3 above) you can also move all the toolbar buttons into a more favorable position to (if you must) make your alt > release > ctrl + tabbing a little faster (e.g. move your border button or your text style and size all the way to the left)

My favorite shortcut of all:

In the customize dialogue box (step #2 above), go to the "Commands" menu tab and find the Font Color and Fill Color buttons (in the Format category). Drag these two items, into the Format menu at the very top of Excel and place them where you please in the menu (towards the top). Then go to this format menu (where you just dragged the button) and right click on it - this will drop down a similar menu as above (step #5) where you can make the same changes as you did in the decimal place example above (e.g. make sure the Name box is set to "&Font Color" - note, whichever letter the "&" preceeds will be your shortcut key). Then do the same thing to the Fill color button, setting the Name box to: "Font C&olor".

Now monkeys you can alt + o + f and alt + o + o your way to font and cell coloring bliss. Might take a bit to get used to, but now I find that if i'm using a computer that doesn't have these keys programmed, I go insane.

you're welcome

no, this should work for 2003, it works for me

i should have specified..
you dont have to check off Image and Text for any of the shortcuts in the menus (font and cell color in this case). Just make sure the "Name" box shows:

for Font Color -> "&Font Color"
for Fill Color -> "Fill C&olor"

This shortcut now functions like any other menu short cuts (like alt + e + s, for example) as opposed to the toolbar shortcuts that i outlined. So for example, for Font Color hit alt + o + f and then use your cursor key to find the desired color then hit enter. go have a ball.