Help! Excel work samples!

[tiff211]

Still hanging in there for a job I have interviewed for.....3 interviews so far. The hiring manager is in constant communication with me as he travels keeping me updated. Wednesday he emailed me letting me know he needed to check with HR regarding paperwork and I was definitely still in the running and he would call me today. I just got an email requesting letters of recommedation and some samples from powerpoint and excel. I have plenty of powerpoint stuff to show but I don't actively do anything with excel with my current job. I didn't take anything from my last position which is more similar to the one I am applying for. I am going to create a spreadsheet sample but I am at a lost without having a project to create it for, and I usually worked with sales reports that have already been created and or generated.

Help! I reallllly want this job!!

 

[NewJersey]

What is the position dealing with? That would affect what you should do in Excel. If you will be making lots of charts/graphs, do something creating one of those, but make it more complicated, etc etc.

 

[Cindy B]

Make some charts in Excel... that seems to impress many people.

 

[tiff211]

What is the position dealing with? That would affect what you should do in Excel. If you will be making lots of charts/graphs, do something creating one of those, but make it more complicated, etc etc.

It's a sales coordinator position.

 

[NewJersey]

It's a sales coordinator position.

Hmmmm...I would maybe make up some data in excel..use colors and make it look nice. And then also turn them into pie charts, graphs, etc. Make the data about sales per region/office or something...so the charts are showing sales per year, per region..or something like that.

 

[tiggr33]

What about something with sales forcasting. Show previos period data, and projections for an upcoming period. Incorporate the areas of excel you know well.

 

[kaybracon]

Search the Internet for "Excel Tips and Tricks" and try incorporate some of those into your spreadsheet - something that the hiring manager will look at and say how did she do that?!

MrExcel.com
is one good source.

If it's a public company, maybe go back to one of its annual reports and come up with a spreadsheet presenting some of that data in a unique way.

 

[clh2]

If it is related to sales, I would definitely show some data in a pivot table.

Of course, I love pivot tables!!!