U.S. CitiesCity-Data Forum Index
Covid-19 Information Page
Go Back   City-Data Forum > General Forums > Work and Employment > Job Search
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
 
Old 04-06-2013, 06:37 PM
 
1,305 posts, read 2,311,249 times
Reputation: 1822

Advertisements

Has anyone had to take an Excel test during the interview to test their knowledge on excel? I have to take one for an interview in 6 days from now. All they said is that I should brush up on pivot tables. What should I expect on this? Are these tests common? Will it be difficult?
Rate this post positively Quick reply to this message

 
Old 04-06-2013, 06:44 PM
 
Location: Metro Detroit, Michigan
18,077 posts, read 16,531,873 times
Reputation: 17999
I did about 4 years ago. I had to demonstrate basic level proficiency by constructing a small spreadsheet with provided data. Obviously, this was a rather simple test and didn't take long. Rather kind of them to tell you what you will have to demonstrate during the interview. There are plenty of resources available online that should help you review if you need to brush up.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 07:37 PM
 
2,091 posts, read 6,773,121 times
Reputation: 2161
I have had to test on word, excel, access and typing for speed. I learned all but typing by reading the for dummies books.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 09:04 PM
 
7,237 posts, read 11,551,347 times
Reputation: 5595
They're likely going to give you one of those Kenexa Prove It Tests, which are a breeze IMO.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 10:01 PM
 
Location: home state of Myrtle Beach!
6,419 posts, read 20,309,431 times
Reputation: 3638
This is fairly standard anywhere these skills are required. Is this your first interview? Have you worked with pivot tables? If not better find some tutorials.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 10:06 PM
Status: "Enjoying the winter" (set 25 days ago)
 
Location: East of Seattle since 1992, originally from SF Bay Area
34,062 posts, read 61,960,043 times
Reputation: 37994
It's a good idea, and I often wish we had done that with some people. We merely ask people to rate themselves on various standard software and ask a few questions to help verify their answers. Sometimes we can get burned, but then the person is not likely to pass probation.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 10:14 PM
 
Location: NW San Antonio
2,960 posts, read 9,035,624 times
Reputation: 3246
Microsoft online help has tests to try to increase your abilities.
Rate this post positively Quick reply to this message
 
Old 04-06-2013, 10:17 PM
 
Location: California
4,402 posts, read 12,422,180 times
Reputation: 3136
Excel itself has the tutorials available...could be Microsoft online as the other person suggested. I would go through them. They are not that hard.

My biggest Excel pet peeve that I can NEVER remember is if you enter numbers in a column and get ##### it means you need to make the column bigger. Doubting this will ever matter to you, but that is the Excel thing I am unable to remember.
Rate this post positively Quick reply to this message
 
Old 04-07-2013, 09:14 AM
Status: "Enjoying the winter" (set 25 days ago)
 
Location: East of Seattle since 1992, originally from SF Bay Area
34,062 posts, read 61,960,043 times
Reputation: 37994
i would also suggest being familiar with extracting data from a relational database, such as MS SQL server. Many systems provide reports that are exportable as Excel spreadsheet or CSV files, but if you need data from tables not included in the reports and you don't have business intelligence software such as Tableau or Jasper, getting it quickly through Excel saves a lot of time.
Rate this post positively Quick reply to this message
 
Old 04-07-2013, 02:58 PM
 
400 posts, read 1,396,846 times
Reputation: 413
ive online heard of such nonsense for temporary agencies or recruiters i.e. apple one, robert half, .... just take a refresher course on microsoft.com
Rate this post positively Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


 
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:
Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Work and Employment > Job Search
Similar Threads

All times are GMT -6.

© 2005-2021, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top