arrow_back
Must Read Information
Introduction
Welcome to the course
Prerequisites: Excel formulas and function
Basic Formula Operations of Excel
Lecture_1_Mathematical
Mathematical Formulas
Lecture_2_Textual
Textual Formulas
Lecture_3_logical
Logical Formulas
Lecture_4_Dates
Date-Time Formulas
Download File for Lecture_5_Lookups
Lookup Formulas_(V Lookup, Hlookup, Index-Match)
Time Value of Money
01_Future value
Future value
Excel: Simple Interest and Compound Interest
02_Present Value
Net Present Value
03_IRR
Internal Rate of Return
EXCEL: NPV and PV for calculating Present Value
Excel: Internal Rate of Return
11_Solver_reg
XNPV and XIRR solved
Excel: NPV and IRR for particular dates
Analysis of Profit and Loss Statement
Horizontal and Vertical Analysis
Horizontal and Vertical Analysis
Excel: Vertical Analysis
Excel: Horizontal Analysis
Loan Repayment Calculations
Loan Repayment
Loan Repayment concepts
Excel: Calculating Payments
Excel: Calculating Rate or Term
Methods of calculating Depreciation
Depreciation Methods and Straight Line Method
Depreciation Methods and Straight Line Method
Double Declining Balance Depreciation
Sum of Years Digits Method
Excel: Calculating Depreciation
Financial Ratio Analysis
08_Ratio Analysis
Theory: Financial Ratios
Excel: Building a Template for Financial Ratio Analysis
Financial Charts and Dashboards - Introduction
09_Financial Dashboard
Financial Charts - Introduction
Chart 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
Lecture_7_Formatting
06_formatting
Formatting charts
07_Line_charts
Line Charts
Area Charts
22 Area Charts
Pie and Doughnut Charts
09_Pie_charts
Why we should avoid Pie charts
10_Scatterplot
Scatter plot or XY chart
11_Histogram
Frequency Distribution and Histograms
13_sparklines
Sparklines
Waterfall Chart
Case Study - Finance Dashboard
Financial Dashboard - Introduction
Financial Dashboard - Introduction
Financial Dashboard - Time Series of Profit & Profit Margin
Financial Dashboard - Trend of Revenue and Projection
Financial Dashboard - Expense Analysis using Pie Chart
Financial Dashboard - Target monitoring using Column chart
Financial Dashboard - Collating and Formatting to create a Dashboard
Pivot Tables
Lecture_8_PivotTables
Pivot Tables
Pivot Charts
Predective Analytics - Introduction
Linear Regression - Introduction
Basics of Statistics
Lecture_6_Data
Types of Data
Types of Statistics
Describing data Graphically
Measures of Centers
Measures of Dispersion
Machine learning - Introduction
Introduction to Machine Learning
Building a Machine Learning model
Getting Data Ready For Regression Model
Gathering Business Knowledge
Data Exploration
The Data and the Data Dictionary
Univariate analysis and EDD
Discriptive Data Analytics in Excel
Outlier Treatment
Outlier Treatment
Identifying and Treating Outliers in Excel
Missing Value Imputation
Missing Value Imputation
Identifying and Treating missing values in Excel
Variable Transformation in Excel
Dummy variable
Dummy variable creation Handling qualitative data
Dummy variable
Dummy Variable Creation in Excel
Correlation Analysis
Correlation Analysis
Creating Correlation Matrix in Excel
Creating Regression Model
10_Regression Model
The Problem Statement
Basic Equations and Ordinary Least Squares (OLS) method
Assessing accuracy of predicted coefficients
Assessing Model Accuracy RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression
Multiple Linear Regression
The F - statistic
Interpreting results of Categorical variables
Creating Multiple Linear Regression model
Finance Case Study - Linear Regression
Case Study Linear Regression - Introduction
Case study Linear Regression - Data
Case study Linear Regression - Preprocessing
Case study Linear Regression - Results
Case study Linear Regression - Prediction
