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

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