Essentials of Financial Analysis using MS Excel

Duration : 01:52:53

Guru : GreyCampus

7 Learners

Promo video


Complete Course Description

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. 


What Are The Requirements


  • Some knowledge of basic word processing, computing, and spreadsheets

  • Familiarity with the Microsoft Office work environment


What Am I Going To Get From This Course


  • 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


What Is The Target Audience


  • It has been designed for professionals who wish to explore the practical usage of advanced Excel functions with financial data.