![]() ![]() Hiring for a front-office position that needs to know how to create simple spreadsheets and use a SUM formula is an entirely different Excel skill set than hiring for a bookkeeper or finance administrator.Ĭertain Excel skills will be necessary for your specific open role. Excel Skills to Testĭepending on the position you need to fill, the job applicant’s qualifications might vary. When done later in the hiring process, however, it can help you separate the outstanding applicants from the average. The biggest downside here is that this takes time to schedule and requires a proctor to sit in with the candidate. This method lets you learn what the applicant knows off hand. This allows you to see the applicant work through the test, giving you a better idea of how long it takes them to complete. You may choose to give job applicants an Excel test in person. Scroll through the images below for information on what each results sheet illustrates about your candidate. Pay attention to individual questions and not just the final score, as some applicants may score lower overall but have more proficiency in the area you need. It is for grading purposes only and should be used as a guide to examine how well the individual performed on their assessment. The Excel Test Results file contains the test answers, so do not send this file to your job applicants. In Stage 2: Conversions of the Excel test, applicants will use data collected to calculate the PECI-SCORE, and use VLOOKUP to populate the PECI-CODE from the tab FITNESS TABLE tab into their answers. The Fitness Table shows the PECI-SCORE, PECI-LEVEL and PECI-CODE. ![]() This data is used in the Context & Tasks tab to complete the Excel test. The Clubdata tab lists the demographic information of all club members of our fictional club, including name, birthdate, sex, height, and weight, among other data. Stage 6: Print Setup and Output – This stage tests the individual’s ability to create a header using Page Setup, as well as print the document to a PDF file.Stage 5: Sorting and Pivotchart – This stage tests the individual’s ability to sort data within a pivot table or pivotchart.Stage 4: Pivot Table 2 – This stage tests the individual’s ability to take an existing pivot table and change its values, creating new value tabs.Stage 3: Pivot Table 1 – This stage tests the individual’s ability to create a pivot table.Stage 2: Conversions – This stage tests the individual’s ability to convert formulas (i.e., centimeters to inches) and use the VLOOKUP (vertical lookup) function to populate them.Stage 1: Standardizing the Dataset – This stage tests the individual’s ability to process data between different types of variables.The test consists of the following stages: The information in the left columns shows the skills and familiarity required to complete the tasks in each stage. The Context & Tasks tab includes the various accelerated Excel functions that will be tested and instructions for performing those tasks using data provided across all three tabs. For the purpose of completing the Excel skills tests, these tabs relate to a fictional facility: The Patagonia Exploration Club International. When your test subject downloads the provided Excel test, they will see multiple tabs-Context & Tasks, Clubdata, and Fitness Table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |