Australian psychometric aptitude and skills tests | Right People

Microsoft Excel Testing

PricingThe most commonly demanded skill for the majority of jobs across all industries is ability to use Microsoft Excel, at least at a basic level. Testing Excel proficiency before you decide to hire someone is a must for most positions. Many resumes talk about ‘Excel skills’ but this information is largely unverified and can lead to costly hiring mistakes. A simple test can save time and money.

See a Basic / Beginner Excel Test in Action

(Version 2010)

See an Advanced Excel Test in Action

(Version 2010)

What is Excel?

Microsoft ExcelExcel is an electronic spreadsheet program that can be used for storing, organising and manipulating data. It uses a grid of cells arranged in numbered rows and letter-named columns. It offers a large number of built-in functions for managing data and the option of writing your own scripts if necessary.

Prevalence

Excel is the industry standard for spreadsheets (http://en.wikipedia.org/wiki/Microsoft_Excel). Its popularity is evidenced by its availability as a standard program on most PC’s and many Macintosh computers (http://www.ehow.com/how_5873156_create-ms-excel-script.html). Since 1985 when the first version was released, Microsoft Excel has been relied upon for the analysis of numbers, management of budgets, forecasting of financial outcomes and modelling "what-if" scenarios by business people from all levels and across industries.

A number of key reasons for its popularity are outlined by Mark Morini from Business Performance Management (http://bpmmag.net/mag/bpm_article_nwarcarticle_14373/):

  • It is easy to use and intuitive to understand
  • Its interface is rich
  • Its formatting is flexible
  • Its pervasiveness means that new employees and new clients are likely to be familiar with the program
  • As nearly every desktop computer has Excel already installed there is no need to invest time and money in developing, purchasing or training staff in new software

In short, at least basic knowledge of how to use Microsoft Excel is a must in the contemporary world of business.

The most recent version is Excel 2010, but may organisations continue to use Excel 2007 or Excel 2003.

Common uses

Microsoft Excel

  • Performing basic mathematical operations (such as summing rows of figures)
  • Statistical analyses such as average, range, standard deviations
  • Calculating profit and loss
  • Calculating repayment plans
  • Graphing or charting data to clarify information or identify trends and patterns
  • Data mining

Excel-ability

In the 21st Century, most jobs require some level of knowledge of Microsoft Excel.

But while Excel skills are important, they are not always part of standard university or other training courses. Prospective employee’s skill levels may vary as a function of their previous work experience, exposure to Excel at home, school and other learning environments, formal training course attendance and informal learning.

How can an employer measure applicants or employees Excel-ability?

In 90 seconds learn how to make hiring the right staff a breeze

RightPeople can help.

Microsoft ExcelRightPeople’s Excel Testing

RightPeople’s Excel Testing suite examines various elements of Microsoft Excel features and functions.

We offer four levels, tailored to the requirements of the organisation and role being filled. The levels and the Excel features they assess include:

 

 

Expert Excel

  • Add-Ins
  • Charts
  • Collaboration
  • Macros
  • Customising
  • Excel on the Web
  • Formulas
  • Graphics
  • Pivot Tables

Advanced Excel

  • Add-Ins
  • Macros
  • Pivot Tables
  • Charts
  • Collaboration
  • Customising
  • Formulas

Intermediate Excel

  • Formatting
  • Pivot Tables
  • Charts
  • Saving and Printing
  • Customising
  • Excel on the Web
  • Formulas
  • Functions

Beginner Excel

  • Formatting
  • Charts
  • Saving and Printing
  • Formulas
  • Functions

Find out more about this product or service

Small & Medium Business

  • Trial packs for small jobs
  • Pay as you go
  • Tailored to unique roles
  • Feedback on test results
  • No set up fees

Large Businesses

  • Volume discounts
  • Real-time results
  • 7 Day Support
  • Candidate ranking
  • Easily scalable