- Welcome to the Course
- Course Resources
Online
₹ 700 1,920
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 700 ₹1,920
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Prerequisites: Excel Formulas and Functions
- Basic Formula Operations
- This is a milestone!
- Mathematical Functions - Part 1
- Mathematical Functions - Part 2
- Textual Formulas
- Logical Formulas
- Date-Time Formulas
- Lookup Formulas_(V Lookup, Hlookup, Index-Match)
Time Value of Money
- Future Value
- Excel: Simple Interest and Compound Interest
- Net Present Value
- Internal Rate of Return
- EXCEL: NPV and PV for calculating Present Value
- Excel: Internal Rate of Return
- Excel: NPV and IRR for particular dates
Analysis of Profit and Loss Statement
- Horizontal and Vertical Analysis
- Excel: Vertical Analysis
- Excel: Horizontal Analysis
Loan Repayment Calculations
- Loan Repayment concepts
- Excel: Calculating Payments
- Excel: Calculating Rate or Term
Methods of Calculating Depreciation
- Depreciation Methods and Straight Line Method
- Double Declining Balance Depreciation
- Sum of Years Digits Method
- Excel: Calculating Depreciation
Financial Ratio Analysis
- Theory: Financial Ratios
- Excel: Building a Template for Financial Ratio Analysis
Financial Charts and Dashboards- Introduction
- Financial Charts - Introduction
Charts and Dashboards using Excel
- Excel Charts - Categories of messages that can be conveyed
- Elements of charts
- The Easy way of creating charts
- Bar and column charts
- Formating charts
- Line Charts
- Area Charts
- Pie and Doughnut Charts
- Why we should avoid Pie charts
- Scatter plot or XY chart
- Frequency Distribution and Histograms
- Stock Charts
- Sparklines
- Waterfall Chart
- Heat Maps
- Quiz
Case Study - Financial Dashboard
- Financial Dashboard