Essentials of Financial Analysis using MS Excel - Online Self Learning

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.

USD 199

Enroll
1 year e-learning access
Hands-on videos
Data sets and Exercises
Additional Materials

Course Objectives :

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

  • High impact, proven training – 30000+ professionals trained globally

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

  • Classroom Training programs delivered across 50+ locations globally

  • Content is developed in-house in GreyCampus by highly experienced industry experts

FAQ's :

Q. What are the Pre-requisites for this course?

A. Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment. Knowledge of financial terms would be an added advantage.