MrExcel Consulting
Your One Stop for Excel Tips & Solutions

How to Pass Your Interview Excel Test


January 17, 2018 - by Jennifer Feldman

How to Pass Your Interview Excel Test

Many job positions require candidates to have a mastery of Excel. Therefore, employers would like to test potential candidates during the interview process to ensure they can complete the Excel tasks that are required for the job. It is important to score high on your Pre-Employment Excel test and prove to you employer that you have what it takes to excel at the job.

What is an Interview Excel Test?

An interview Excel test is a screening tool employers use in the interview process to test a potential candidates’ skills. Depending on the position you are applying for you are likely to face a pre-employment Excel test with varying level of difficulty. Employers use three levels of testing:

continue reading »

More Reading


VLOOKUP with Multiple Results

VLOOKUP with Multiple Results »

January 15, 2018 - by Bob Umlas


Suppose you want to produce a report from a set of data as if you filtered on a column. But what if you wanted a formula-based version of the same thing?

List all Files in a Folder in Excel Using Power Query

List all Files in a Folder in Excel Using Power Query »

January 5, 2018 - by Bill Jelen


Need to get a list of all of the tax invoice PDF files from a folder in to an Excel spreadsheet. This is easy to do if you are using Excel 2016 on a Windows PC using the new Get & Transform Data tools.

read all news »

Featured Products


Supercharge Power BI

Supercharge Power BI »


If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

100 Excel Simulations

100 Excel Simulations »


Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Excel Video Medley

Excel Video Medley »


Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

see more products »