I'm noexpert by any stretch of the imagination, but here's a brief discussion of things you might want to familiarize yourselves with before starting your Summer Analyst stint. Please feel free to add to this list -- I know I could use some training too!
With that out of the way, let's Control + Page-down to the next part of this discussion...
This is kinda of a high-level overview and this is BASIC stuff, I'm not writing out a bunch of shortcuts because you can find that stuff through Google. But there's a difference between knowing the shortcuts and understanding how to move through the program efficiently.
1. Learn to move around quickly
Switching tabs (Control+Pg Up, Pg Down), switching to cell A1 (Control+Home), selecting data group (Control+Shift+Arrows) are all ways to move around the spreadsheets more efficiently. Figuring out what cells trace to which others (Alt+M+P) is also another useful way to get your speed up. Using the F2 key to change formulas and trace cells is one of the things you'll use more frequently than others -- and editing doesn't hurt either!
2. Learn to copy and paste like a boss
Alt+E+S gives you the paste special screen, and from there you can copy values (V), formulas (F), and formats (T) -- those are the modes I use most frequently. You can also transpose a data set from horizontal to vertical orientation, which is handy, and multiply or divide a data set by a certain constant (like if you have raw data in $1,000,000 form but want to change to $1.0MM for example).
3. Learn vlookup
As an intern, you might get some fun and interesting tasks like consolidating raw data and formatting it / making it more readable. Companies send data over in bizarre states with sometimes-impossible-to-understand naming and labeling conventions, and the senior guys always want to see it nice and pretty. Vlookup is a baller function that will let you manipulate this data in a quick and robust manner. Vlookup, and its rarely-used cousin, Hlookup, is extremely useful...own it.
4. CapIQ plugin
You probably won't get access to this until you start your internship, but if you have a chance to cruise through CapIQ and use the plugin, building formulas is pretty straightforward (and awesome because you can export everything you want toand manipulate the data easily). You know what they say -- 90% of the job is using the CapIQ plugin (well, in reality this is far from the truth, but there's a lot of CapIQ.
5. Random useful shortcuts
Alright alright, here are some of the more frequently used shortcuts in my experience:
Alt+H+O+H/W changes height or width of a row
Control/Shift+Space Bar selects an entire row/column
Alt+I+R adds a row based on current selection
F4 repeats your last command
Alt+H+F+S changes font size
Alt+H+F+C changes font color
Alt+H+A+C/R/L aligns center/right/left
And there are a bunch of other useful thing within Alt+H.
Alt+A+G+G groups and Alt+A+H/J hides and unhides -- also very useful.
There are just a couple of things that I've found useful. I'm still very much a newbie, but other newbies out there can use this list as a good starting point.
Experiencedusers, what can you add to this list? What speeds you up and saves a lot of time when you're going through the motions?
Thanks for reading.