Financial Modeling Training in Lahore

Financial Modeling Training and Data Visualization

Introduction to Financial Modeling Training in Lahore Pakistan

This course can be taken as a follow on from the Intermediate Financial Modelling course, or by those who already have a working knowledge of using Excel. This course uses your Excel skills to build a lifelike model which forecasts the future performance of a company.

This course also introduces a number of important accounting issues, which are demonstrated in a practical situation, helping candidates see how these issues are dealt with and why. Each session starts with a lecture which is followed by a demonstration of the key points from the lecturer. Candidates are then tasked with putting this into practise on their own models.

Tools for Building Dynamic Financial Models

Formulas:

Absolute and Relative References

Lookup Functions

Logical Functions

Form Controls:

Combo Box

List Box

Check Box

Option (Radio) Button

Data Validation:

Basics

Single Level/ Multi Level Lists

Excel Analysis Tools:

Conditional Formatting

Data Table

Solver

 

Dashboard/ Data Visualization

Reporting with Pivot Table:

Pivot Table Features

Calculated Fields

Excel Charts:

2 Axis Charts

Tailored Charts

Power BI:

Get Data

Formatting

Charting

Sorting

Filtering

Data Drill

Financial Modeling – Case Study

Structuring Input Sheet

Loan Amortization Schedule

Projected Income Statement

Projected Cash Flow Statement

Model Dashboard

You can either fill the form below and send us your query or send us email at info@thebscon.com, call us at +92 321 8408828.

WhatsApp WhatsApp us