Advanced Excel Tutorials

Excel Interview Questions: How To Generate Unique Row ID for Executive Presentation

Posted on
Excel Interview - How To Create Unique Row ID in Excel

During job Interview a lot of time companies test candidate’s knowledge of Microsoft Excel by asking them to work with the real data in application, instead of using test format or simulator questions. Typically employers use workbooks with large sets of data 100K+ rows which wouldn’t be perfectly formatted to simulate real working conditions. One […]

Advanced Excel Tutorials

Excel Interview Questions: Auto Generate Unique Row ID for Executive Presentation [+XLSX Download]

Posted on
Excel Interview Questions: Create Unique ID for Executive Presentation

During job Interview a lot of time companies test candidate’s knowledge of Microsoft Excel by asking them to work with the real data in application, instead of using test format or simulator questions. Typically employers use workbooks with large sets of data 100K+ rows which wouldn’t be perfectly formatted to simulate real working conditions. One […]

Basic Excel Skills Test

Excel Consulting Interview Questions and Answers – Advanced Excel VLOOKUP Test Questions and Answers [XLSX File Download]

Posted on
Excel Consulting Interview VLOOKUP Questions And Answers

In this tutorial we will look at the VLOOKUP Excel Assessment Test Question asked as part of the consulting interview. A lot of time consulting companies test candidates based on the real assignments that they had to complete and use Microsoft Excel Application, instead of using test format or simulator questions. Companies might also share […]

Interview Preparation

Excel Skills Test: Get Ready for Basic Microsoft Excel Employment Assessment

Posted on
Excel Skills Test: Get Ready for Basic Microsoft Excel Employment Assessment

The basic Microsoft Excel skills test assesses candidate’s ability to use Microsoft Excel’s user interface quickly and efficiently to access the right features and perform simple tasks in the application. It validates fundamental knowledge from determining the best way to open a recently closed Workbook to using the correct formula to perform automatic calculations. Candidates […]

Excel Formulas and Functions

Excel SUMIFS Function: How to Implement OR Logic – [Download XLSX Work File to Follow Along]

Posted on
Excel SUMIFS Function: How to Implement OR Logic - [Download XLSX Work File to Follow Along]

Business Problem: Below table lists orders of various products sales for the period between March and July in Microsoft Excel. Our objective is to calculate the total revenue from Wireless Headphones and Flame Lamps sold between May and July using SUMIFS formula   Challenge You would think you can logically use SUMIFS this way (since […]

Excel Assessment Test

Excel Test for Job Interview

Posted on
Microsoft Excel Test for Job Interview

What is Microsoft Excel Microsoft Excel is an electronic spreadsheet program, created by Microsoft Corporation over thirty years ago. It enables users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and column. Microsoft Excel is also used for storing, organizing and manipulating the data as well as […]