9 to 5
Dear Community,
Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Hello out there,
Some background, I just finished up my masters, went straight through from my bachelors, and I'm looking for a job in the non profit world. I have an interview next week (yay!). They gave me the heads up that there is going to be an excel test. We used excel quite a bit in my gaduate program and I feel pretty confident with it, but I'm still a little nervous. What are some excel skills that you think an employer might test for? I'm hoping to get a list going so I can brush up this weekend.
Thanks! Kathryn 
Re: excel skills
74 books read in 2011
Pivot tables!
Linking one sheet to another. Other than that I would think it would be basic formatting, formulas, etc.
I think this depends what kind of field you are in.
I would know the most common things people do with Excel - organizing numbers into columns, basic functions (including that pesky but excellent $ sign), how to make charts, maybe how to format things into colors and borders.
Unless you are in finance or science you probably wouldn't need the higher-level functions or macros, but it would probably be a good idea to understand how to look things up with the help menu.
Based on the fact that you have used it in your grad program I am going to bet that your skills are more than sufficient to pass the test and probably exceed the skills of most of those you would be working with.
I say this because I am known in my team as a computer guru and, really, my skills are rather basic. I just know how to move around the MS Office programs fairly quickly and create some really cool looking graphs in excel (for which excel does 99% of the work!). And I work with some highly intelligent, high-paid professionals.
FWIW, I don't really know how to use vlookup because I prefer to use a stat software program for linking data sourses. It may be a "cool tool" but given its limitations I don't find it useful. Pivot tables, however, are super useful.