Get a useful knowledge for a job interview

This course contains Intermediate Level exercises. It can be very useful for those who just finished the university studies and looking for a job in the finance sector. It will require a good understanding of Excel.

The following topics will be covered in this course: Shortcuts, VLookup, HLookup, Index, Index-match, SumIFs, Named Ranges and Advanced SumIFs, Custom lists.

Even though students are good in Excel, almost 90% of them will not pass an Excel test in job interviews. This course will help you to learn some of the most common advanced formulas.