Financial Modeling in Excel (Concepts and Application)
Mastering Financial Modeling in Excel: Build, Analyze, and Optimize - Learn concepts and Application of concepts
4.00 (2 reviews)
4
students
26 hours
content
Oct 2024
last update
$44.99
regular price
What you will learn
Concepts related to Financial Modeling
Learning Excel basics with hands-on sessions
Understanding excel formulas and functions
Building Financial Model in excel from Scratch
Sheet, Cells ,Tabs and Ribbon, Quick Access Toolbar
Formulas - Sum, Average, Median, Count, Count if, Sum if, If error
Relative Reference and Absolute Reference Partial Absolute reference
Formating- Removing Gridlines,Font related ,Format Printer, Alignment, Merge Cells, Wrap Text, Fill Color, Font Color ,Borders
Date Related Functions, Conditional Formatting, Pivot Table, Vlookup and Hlookup
Data Validation and Cell protection, Protecting Sheet, Protect Workbook
Name Manager, Goal Seek Function, Data Tables, What if Analysis
Understanding basics and Types of Financial Statements (Concepts)
Historical Data plotting in Excel
Ratio Analysis Sheet in excel
Dupont Analysis sheet
Altman's Z Score Analysis
Common Size Statement
Forecasting Income and Expenses in excel
Forecasting Balance sheet
Calculation of Present Value, Future Value, Annuity in excel
Loan repayment schedule in excel
Project evaluation in excel using Net Present Value (NPV)
Project evaluation in excel using Internal rate of return (IRR)
Screenshots
6261931
udemy ID
10/30/2024
course created date
11/8/2024
course indexed date
Bot
course submited by