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.

excel skills

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

  • I've been in a few presentations lately where we were expected to know how to manipulate the cells and move them around(slide cells, organize, etc). Also lots of how to manipulate formulas. Thank goodness at the first presentation the lady showed us how to do it, it had been a while since I had messed around in excel.
  • Things that immediately come to mind are: Pivot tables, create basic formulas, conditional formatting.
    image
    74 books read in 2011
    image
  • 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.

    Lilypie First Birthday tickers
  • I am pretty knowledgeable in Excel but one thing I didn't know before I got the job I have now is how to do a vlookup, which is where you have 2 or more spreadsheets of data and you combine them into 1.  It's so amazingly useful, I do'nt know how I got by without it before!
    Planning & Married Bio... Pro Pics, Vendor Reviews, and Items For Sale!
    image
  • 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.

Sign In or Register to comment.
Choose Another Board
Search Boards