Excel Exercises for Job Interview

1
Add your review

$9.95

Excel Exercises for Job Interview
Excel Exercises for Job Interview

$9.95

Description

Excel Exercises Job Interview

 

DESCRIPTION

This is an Excel employment test that includes 20 Excel exercises included in job interviews. All excel practice questions are focused on topics usually included in hiring tests developed by companies to assess candidates knowledge of Excel tools, functions and formulas.
The test is divided into two parts (10 problems each) with two different datasets. One of 20 and another of 850 rows.
All Excel assignments are real and simulate a regular situation or problem (based on the data provided) that you will have to solve using the most suitable Excel function or tool. Basically, these exercises replicate real world problems or situations that you may encounter at any position of wide range of  industries.
Once you finish all the exercises, you will be more confident with Excel and gain the expertise and knowledge required to succeed any job interview.

SUBJECTS TESTED

1) Find duplicates
2) Cell formatting
3) Calculations with dates
4) Count values
5) Conditional formatting
6) Nested functions
7) Sort and filter data
8) Conditional statements
9) Array formulas
10) Drop down lists
11) Protect sheets
12) VLOOKUP
13) Analyze and perform calculations on a large dataset.
14) Named ranges
15) Etc

INSTRUCTOR

Rhynard Prins is a Business Development Manager, at Pragma Global, an Asset Management company. Based in South Africa, he holds a Bachelor of Engineering, Industrial engineering.

REQUIREMENTS

All Excel exercises for job interviews are designed to test candidates that apply for positions in engineering, finance, consulting, accounting, audit and many others that require an intermediate level of Excel.
The spreadsheets included in the project have been done with the latest Excel version. It is then compatible with Excel 2007, Excel 2010, Excel 2013 and Excel 2016.

DOWNLOAD

After purchase, you will receive a Zip folder in the  confirmation email. It is also available on your Practity account:
The Zip includes 2 PDFs and 2 Excel files:
– PDF with 20 Excel practice questions.
– PDF with the  solutions (14 pages). It includes detailed explanations about how to solve each problem and print  screens   with the  formulas required to solve each problem.
– 2 datasets.

CONTACT
If you need additional information, do not hesitate to contact us.

  •  

Additional information

Specification: Excel Exercises for Job Interview

Difficulty

Time Estimate

12 Hours

Reviews (1)

1 review for Excel Exercises for Job Interview

0.0 out of 5
0
0
0
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Jenny H

    Great way to learn by doing!

    Helpful(0) Unhelpful(0)You have already voted this

    Only logged in customers who have purchased this product may leave a review.

    Python and Excel Projects for practice
    Register New Account
    Shopping cart