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. 

Updated on 22 March, 2018
Courses you can instantly connect with... Do an online course on IT, Computing and Technology starting now. See all courses