What is Financial Modelling?
Financial modeling is the task of building an abstract representation of a real world financial situation. This is a mathematical model designed to represent the performance of a financial asset or portfolio of a business, project, or any other investment. It is the process of is the process of creating a summary of a company’s expenses and earnings in the form.
What you will learn in Financial Modelling?
We will learn core concept of Advance Excel
Working with Advance Formulas
Understanding types of charts and where we can use them
Analysis of data
Case studies
How to fetch data large amount of data from Backend through SQL
Course Features
- Lectures 50
- Quizzes 0
- Duration 4 week
- Language English and Hindi
- Students 271
- Certificate No
- Assessments Yes
-
Financial Modelling in Excel
- Mathematical Functions ABS, FACT, GCD, INT, LOG, MROUND, etc…
- Statistical Function in Excel AVERAGE, COUNTIF, COVARIANCE, MIN, etc…
- Text Functions
- Financial Functions Npv, PV, FV, IRR, PMT, etc….
- Flash Fill
- Cell Referencing
- Ranges & Name Box
- Formula Error Messages
- Formula Auditing
- Connecting Worksheets and Workbooks
- Consolidation of Data
- Consolidation of Balance Sheet
- Investment Analysis
- Bond Valuation & Yield
- Coup Function
- Calculation of Accrued Interest
- Analysis ToolPak
- Regression Analysis
- Sales Analysis
- Formatting Worksheets
- Area Charts
- Surface Charts
- Trend line Charts
- Candle Stick Charts
- Pie Charts
- XY (Scatter Charts)
- Time Series Charts
- Bubble Charts
- Radar Charts
- Doughnut Charts
- Rotating 3D Excel Charts
- Sparkline’s in Excel
- Data Form & Printing
- Macros & Hyperlinks
- Data Lock & Data Protection
- Case Studies
-
SQL
- Introduction to SQL
- Creating New Tables
- SQL SELECT Statements
- Manipulating Data(Insert, Delete, Update)
- Distinct, Order By, Join clauses and Aggregate Functions
- Using Primary keys, Foreign keys
- Get Data from Multiple Tables
- Using DDL Statements
- Restricting and Sorting Data
- Using Single-row Functions
- Conversion Functions
- Conditional Expressions
- Using the Group Functions
- Subqueries to solve queries
