Excel job interview: How to pass all excel interviews

A step by step walktrough on actual excel interview questions set, to learn tricks and tips and to get your next job.

This course is for beginners and for people who want to have a good idea of how an excel interview looks like.

You will benefit from this course by having the confidence to perform on the excel interview and be familiar with the most important elements of excel that a job requires.

At the end of this course, students will gain knowledge that helps them to pass excel interviews and have a confident excel skill set that they need not only for work but in everyday life too.

Time-saving — You will know exactly what to do to get ready.

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

How to use INDEX and MATCH

INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH is incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. If you want to improve your Excel skills, INDEX and MATCH should be on your list. See below for many examples.