Essentials of Financial Analysis using MS Excel

A best course to familiarize with all Ms Excel advanced concepts related to Financial analysis

This course takes the hands-on approach while getting familiarized with some of the Excel’s advanced concepts. The analysis and dash-boarding capabilities are hence practiced to the fullest.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:


Appreciate the usage of Lookup functions – VLOOKUP and HLOOKUP
Explore Reverse Lookup techniques – using INDEX and MATCH
Handle formula related errors effectively and perform auditing on the same
Generate Pivot Tables and Charts from complex datasets, instantly
Explore the various components of Pivot Tables and Charts
Implement Slicers and Sparklines to build interactive dashboards
Learn the techniques to implement Sparklines in reports
Each and every topic mentioned above are explained in detail in the Hands-on videos. Exercises and datasets included in this course are useful to practice and implement the concepts learned in this course. For your reference,additional materials are also provided

This course is is intended for the financial analysts and business users who are willing to explore the advanced tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.