FINANCIAL MODELLING ENHANCED

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

ADVANCED EXCEL

  • Macros and Excel Visualization
  • Combination of multiple functions in a problem as VLOOKUP +Match, Index+ Match, VLOOKUP and If
  • Using Excel for Statistical Analysis like Correlation, Regression, Variance.
  • Summarising data from different sheets and collating them into a single sheet using Indirect function
  • Charts – Waterfall Charts, Thermometer Charts
  • Practical Application of Formulas and Charting through Creation of Dashboards
  • Advanced excel formulas and Conditional formatting
  • Using referencing framework (usage of $) to effectively use formulas

CORPORATE ANALYSIS

PROJECT VALUATION

Student Ratings & Reviews

No Review Yet
No Review Yet