Useful Tools of Excel at Intermediate Level

Course details

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.