Where can I find Excel exercises that will help me ace my job interview?
April 7, 2015 7:08 AM Subscribe
I will be having a job interview that requires me to have some knowledge of Excel. I know this is vague but it includes, I presume, filters, hlookup, vlookup, and establishing filters to search out education data. The interview is to get a data analyst fellowship in the education setting.
I will be doing a job interview that involves presentations in PowerPoint and work with Excel. I have a good knowledge of PowerPoint that I am comfortable with but Excel is an area where I am spotty. The interivew is with Education Pioneers, an advocacy group that tries to utlizie data to answer education questions. I have taken a UDEMY course Advanced Excel and I need more practice. Actual exercises and practice that one would have in a college course on Excel are ideal as well as other alternatives.
I will be doing a job interview that involves presentations in PowerPoint and work with Excel. I have a good knowledge of PowerPoint that I am comfortable with but Excel is an area where I am spotty. The interivew is with Education Pioneers, an advocacy group that tries to utlizie data to answer education questions. I have taken a UDEMY course Advanced Excel and I need more practice. Actual exercises and practice that one would have in a college course on Excel are ideal as well as other alternatives.
Response by poster: My interview is on the 23rd of April.
posted by RapcityinBlue at 7:30 AM on April 7, 2015
posted by RapcityinBlue at 7:30 AM on April 7, 2015
If you can't find adequate guided practice, you could also download a data set from the National Center for Education Statistics and use excel (and google to learn the things you don't know how to do in excel...) to answer some hypothetical question. Also, unless they actually gave you a list of the types of excel skills they want, don't ignore pivot tables. Since education data often involves a lot of "counts", pivot tables are your friend!
posted by mjcon at 7:33 AM on April 7, 2015 [2 favorites]
posted by mjcon at 7:33 AM on April 7, 2015 [2 favorites]
Microsoft's own videos are really helpful. I think being familiar with pivot tables would really serve you well.
posted by advicepig at 9:39 AM on April 7, 2015
posted by advicepig at 9:39 AM on April 7, 2015
Youtube also has a lot of video tutorials. Some people link to templates so you can follow along.
posted by lizbunny at 2:53 PM on April 8, 2015
posted by lizbunny at 2:53 PM on April 8, 2015
« Older Sex Therapy Books or other resources | I'm unhappy with my career at 32, but I'm lost on... Newer »
This thread is closed to new comments.
posted by instead of three wishes at 7:21 AM on April 7, 2015