Play Video
Preview this course

Excel for Finance Analytics

Perform financial analysis & financial modeling using Microsoft excel. For people who want to become a Financial Analyst

0 / 5
Rating
0 +
Students
0 Hrs
Duration

499 375

Price

Excel for Finance Analytics

What you'll learn

Introduction to Financial Ratios

Learn popular Financial ratios & implementation of excel formulas to calculate and automate the Financial ratios

Finance Dashboarding

Learn popular Excel charts. Then we will see the implementation of these charts to create visualize Financial data

Finance Data summarization

Learn Pivot tables, indirect functions, and data formatting to create beautiful summaries of Financial Data

Application based Learning

Throughout the course we will discuss separate case study for each section to solidify your learning of the important concepts

Linear regression model

Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real world Finance problems

Our Happy Students!

This course was a good fit for me. It highlights the use of statistics & machine learning for forecasting & predictions.

5/5

Emotongha Keniyinboh

The course focuses on practical application, which is good part of the course.
5/5

Saurabh Singh

It is the best! Exactly the things I needed to learn.

5/5

Hussain Murtaza

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate‚Äč

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

Excel for Finance Analytics - Desc

Course Content

Course Content

Introduction
Prerequisites: Excel formulas and functions
Time Value of Money
Analysis of Profit and Loss Statement
Loan Repayment Calculations
Methods of calculating Depreciation
Financial Ratio Analysis
Financial Charts and Dashboards – Introduction
Charts and Dashboards using Excel
Pivot Tables and Pivot Charts
Case Study – Finance Dashboard
Predictive Analytics – Introduction
Basics of Statistics
Machine Learning -Introduction
Getting Data Ready for Regression Model
Creating Regression Model
Finance Case Study – Linear Regression
Bonus Section