Excel is the most commonly used business analysis program on the market today. 81% of organizations use Excel, so it's critically important that your job applicants have solid Excel knowledge. They won't be able to function effectively with customers and co-workers if they don't have those skills.
Excel Tools to Know
There are literally hundreds of Excel tools in the program. 475+ formulas and functions. Multiple charts and graphs (bar, scatter, pie and many more), plus editing and formatting tools. Some are simple to use (Print, Bold, etc). But most features of the program require prior job experience or prior training to know. Even creating simple graphs can be challenging, if you don't know how to do it.
One tiny error = One Big Mess
One simple Excel error can cost your company thousands of dollars. If the wrong formula is entered, reports will show incorrect information, which can impact your business decisions. Wrong price quotes = lost customers. Wrong analysis on purchases. Many things will go wrong if your employees are making preventable Excel errors.
That's why it's important for your new employees to have solid Excel skills when they are hired. They need to be productive on Day 1.
How we help
Our interactive Microsoft Excel tests are designed to test job applicants on the most common business uses of Excel. The tests cover everything from Excel basics to advanced skills and you can pick which level you want, based on the needs of your job. (Use form to get a free test sample or watch the quick video above).
Our interactive Excel questions require the user to perform the desired task in the simulated Excel worksheet. The user answers questions using the toolbars, shortcut keys or menus, whichever method they know best, where applicable. The tests are available in Excel 365 (2019), 2016, and earlier versions. The test taker doesn't need Excel installed on their computer. Our tests work in a regular web browser (Chrome, Edge, Safari, Firefox) and nothing needs to be installed on the test taker's computer (no plug-ins or scary downloads).
Using pre-employment tests, such as the Microsoft Excel test, is one way to avoid bias in the hiring process. Bias can be conscious or unconscious and recruiters may not be aware that they have them. But using research-based, validated pre-hire tests reduces bias that may come from work or educational experience. All of our tests follow the guidelines of the EEOC and US Department of Labor's Uniform Guidelines on Employee Selection.
Excel Test Levels
The most commonly used Excel test is our "Intermediate" level, which gives an overall "snapshot" of Excel skills. The Beginner Excel test includes basic editing and formatting tasks. The Advanced Excel test has questions on pivot tables, advanced customization, data validation and advanced charts. While important, Advanced is less often used than Beginner or Intermediate level. You can use any level you need, as your job openings change. You can customize tests to meet the exact requirements for the job (minimums may apply) and we have timed versions too.
- Formatting--Borders, Columns, Paper Size and more
- Editing--Insert Rows, Find/Replace, Undo and more
- Functions--Pivot Tables, Autosum and more
- Tools--Protecting Cells, Ranges, Zoom and more
- Charts & Graphs--Creating, Using Different Types, and more
How is the Excel test scored?
Our system instantly generates the score and the test administrator is emailed the report as soon as each test is completed (no "scoring by hand" or waiting on us). The test taker does not receive or view the results. These reports are highly detailed and cover the below topics (see sample report):
- Percent of Correct Answers (80%, 50%, 100%, etc)
- Skill Level: Beginning, Intermediate, or Advanced
- Correct/Incorrect for each question
- Time taken per question and more
We have other Microsoft Office tests (Microsoft Word, PowerPoint and Outlook tests) that are often used in combination with the Excel test. If you need combination tests that cover a bit of Excel, Word and Outlook in a single test, we have those too.
If you need to administer other tests, such as reasoning skills, behavioral skills, clerical skills or industry knowledge, we have those too. Here's the entire test list.
How does it work?
It's simple. You'll email a test session link to the applicants from our easy-to-use admin dashboard. The applicant clicks on the link to start the test session. The test session can include either a single test or multiple tests, based on your needs.
Tests are taken either in your office or from your applicants' home/office, at any time--day, night or weekends. Our team is available if you or the applicants need help at any time.
Can I customize the Excel tests?
With our TestBuilder tool, we can customize tests from our question bank. A 25 credit purchase ($450) provides one custom test, built to your specs. You can purchase TestBuilder separately to create your own custom tests from the question bank.
How much does it cost?
We have two pricing plans, "per test" and an annual license. If you're testing fewer than 100 people per year, the "per test" pricing is often better for you. "Per test" pricing start around $20 per test for low volumes with FREE account set up. Testing more than 100 applicants? An annual plan may be better.
Either way, you have access to not only the Excel tests, but also our entire list of 100+ tests. Let's talk to see which works best. Call 1.800.836.1901, Ext. 1, or complete the form and we’ll send a free sample test.
Ready to get started now? Click below to visit our pricing page for immediate access!