- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Suggestions for creating an Excel Test/Project
Posted on 4/26/18 at 2:54 pm
Posted on 4/26/18 at 2:54 pm
My boss wants to give applicants an excel test
I've seen some online programs, but I'm not sure if they're cost-prohibitive for a small office
I thought about maybe coming up with a list of commands for them to perform, but I'm just not sure where to start
I've seen some online programs, but I'm not sure if they're cost-prohibitive for a small office
I thought about maybe coming up with a list of commands for them to perform, but I'm just not sure where to start
4
Posted on 4/26/18 at 3:13 pm to Paige
(no message)
This post was edited on 2/15/25 at 3:44 pm
Posted on 4/26/18 at 3:16 pm to lnomm34
what? We’ve been going through a temp agency and requested they be proficient in exce butl then I have to teach them how to create borders
Posted on 4/26/18 at 3:22 pm to Paige
The range of expertise that different people use Excel is very wide. Excel knowledge can mean a lot of different things to different people.
Are there specific Excel skills does that your boss wants to make sure the applicant has? Or does he just want someone who "knows excel".
Are there specific Excel skills does that your boss wants to make sure the applicant has? Or does he just want someone who "knows excel".
Posted on 4/26/18 at 3:43 pm to moneyg
you're so right. they think I'm expert level, but I know nowhere near what all it can do
they really just need someone intermediate who knows how to google. but she wants them to be able to prove some knowledge before we hire them
they really just need someone intermediate who knows how to google. but she wants them to be able to prove some knowledge before we hire them
Posted on 4/26/18 at 4:09 pm to Paige
I know the Mr Excel website has one, but I have no clue how much it costs. I've been curious about it.
If you want to develop one yourself, take something that they would need to do regularly and have them do it from scratch.
If you want to develop one yourself, take something that they would need to do regularly and have them do it from scratch.
Posted on 4/26/18 at 4:16 pm to CubsFanBudMan
That's a great idea!
Posted on 4/26/18 at 4:35 pm to Paige
He wants a test for them to perform in Excel? Like as he watches them do it? The skill level can usually be ascertained through a few questions and discussion about past projects.
Are we talking borders, formatting, rows/column insertion? Formulas? Graphs? Pivot tables? Macro/VBA?
A simple test would be to create a simple matrix, with formatting, and a graph. For example, price of various quantities of items over time, then a graph of that pricing.
Make the date format something non-standard, the price/quantity a multiple to allow using a formula. Maybe add in average price. Then a graph of some type.
Hand it to them printed and have them recreate it.
Are we talking borders, formatting, rows/column insertion? Formulas? Graphs? Pivot tables? Macro/VBA?
A simple test would be to create a simple matrix, with formatting, and a graph. For example, price of various quantities of items over time, then a graph of that pricing.
Make the date format something non-standard, the price/quantity a multiple to allow using a formula. Maybe add in average price. Then a graph of some type.
Hand it to them printed and have them recreate it.
Posted on 4/26/18 at 5:48 pm to LSUtigerME
Giving it to them printed is a good idea
The main formulas I use are vlookups and sumif
My boss is impressed because I know how to copy formulas/formatting down the page. They’re old
The main formulas I use are vlookups and sumif
My boss is impressed because I know how to copy formulas/formatting down the page. They’re old
Posted on 4/26/18 at 6:22 pm to Paige
quote:
they really just need someone intermediate who knows how to google. but she wants them to be able to prove some knowledge before we hire them
Honestly, she could hire anyone with good analysis skills whether they know Excel or not. Find someone in a STEM degree program, that person will know how to use Google for help.
Posted on 4/26/18 at 6:29 pm to Paige
Give them a task they would have to complete on a regular basis and a computer. See if they do it in a reasonable time frame. Memorizing formulas is rather high school-ish.
Posted on 4/26/18 at 6:32 pm to philabuck
I think that’s the route I’ll go
Foshizzle, it’s just an office assistant job
Foshizzle, it’s just an office assistant job
Posted on 4/26/18 at 10:27 pm to Paige
I built my own test for analysts. I would say it requires intermediate skill but definitely not expert. I have it timed at 45 minutes for them to answer about 15-17 questions. It’s a big day sheet and they have to do a mix of different formulas to answer each one.
It has worked pretty well so far.
It has worked pretty well so far.
Posted on 4/28/18 at 9:33 pm to lynxcat
Can you send me a copy of that test? Want to see how I do personally I promise not to use it in any other manner.
Nhseks@gmail.com
I promise not to use it in any other manner. Nhseks@gmail.com
Posted on 4/28/18 at 11:11 pm to lynxcat
Would the answer 288 get me a 17/17 on that test?
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News