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 […]

Advanced Excel Tutorials

VLOOKUP Test for Interview

Posted on
VLOOKUP Interview Questions

In this tutorial you will learn VLOOKUP formula and review sample VLOOKUP Excel Assessment Test and Interview questions. You will also learn typical implementations of VLOOKUP based and will be able to download Excel Source Files used in the tutorial. Why Employers Test Job Candidates for VLOOKUP knowledge? VLOOKUP is one of the most frequently […]

Excel Assessment Test

Excel Assessment Test: Excel Formulas and Functions (SUM, MIN, MAX, COUNT, AVERAGE)

Posted on

Formulas and functions are very popular topics in Microsoft Excel assessment test. They’re also used very frequently in Excel interview. In this tutorial I am going to introduce you to Excel formulas and functions with some basic operations. Also learning about key functions that are used as part of Excel interview and Excel assessment test. […]

Basic Excel Skills Test

Video Files Download: How to Pass Excel Assessment Test For Job Applications [XLSX Download]

Posted on

https://youtu.be/b-GxQvV9SWg   There are 2 Excel Assessment work files included in this free download. Please complete below form and you will be redirected to the download page. Excel Assessment Test Practice.xlsx – Starting file for you to to follow along with the video. Use this file as a starting point to follow along with the video […]

Excel Assessment Test

Excel Formulas and Functions for Excel Skills Test (SUM, MIN, MAX, COUNT, AVERAGE) – VIDEO Tutorial with XLSX Workfiles Download

Posted on
Excel.Assessment.Test.Formulas.Functions.SUM.MIN.MAX.AVERAGE.COUNT

Why knowledge of Excel Formulas and Functions is important for Assessment Test? Excel Formula is an expression that calculates the value of a cell. For example, =B2+B2+C3+C4 is a formula that adds up the values in cells listed. Function is a predefined formula already available in Excel. Samples of Predefined functions are SUM, MIN, MAX, […]

Basic Excel Skills Test

Video Files Download: EXCEL Formulas and Functions: SUMIFS Tutorial for Excel Employment Test Questions

Posted on

SUMIFS Function in Microsoft Excel adds all of the arguments that meet multiple criteria. In this SUMIF Tutorial you will refresh your Excel skills and learn how to get ready for Excel interview and pass Excel Assessment Test for job application by answering questions related to SUMIFS Formula.   Below image shows definition and Syntax of SUMIFS […]

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 […]