Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Indian Institute of Management Bangalore

Finance Analytics for Decision Making using Excel

Indian Institute of Management Bangalore via Swayam

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
The course “Finance Analytics for Decision Making using Excel” is designed to equip learners with the knowledge and skills to effectively utilize Excel as a tool for Financial Management data analysis and decision-making. In the 9-week course, learners will discover the basics of Finance analytics and master Excel skills to process, analyse, and visualize Finance data effectively. Learners will explore various Finance analytics concepts, such as descriptive, diagnostic, predictive, and prescriptive analytics, and recognize their applications in financial management for decision making. The course will cover topics such as creating Finance dashboards, trend line analysis, correlation, and regression using Excel. Learners will gain hands-on experience in applying Excel's features and functions to interpret Finance metrics, identify trends, and make data-driven decisions. Additionally, they will explore real-world examples and cases of Finance analytics to understand how data insights can drive strategic Finance initiatives and improve workforce management. By the end of the course, learners will be proficient in creating dynamic Finance dashboards, conducting various data analyses, and presenting Finance analytics insights effectively. Whether calculating profit, answering questions about a business, enabling future business forecasting, “Finance Analytics for Decision Making using Excel” enables learners to leverage Excel’s capabilities to improve Finance decision-making.

Syllabus

Week 1: Introduction to Excel

Week 2: Introduction to Finance Analytics

Week 3: Break Even Decisions

Week 4: Time Series Forecasting Decisions

Week 5: Capital Budgeting Decisions

Week 6: Regression Analysis Decisions

Week 7: Business Valuation Decisions-Part I

Week 8: Business Valuation Decisions-Part II

Week 9: Financial Dashboard Decisions

Week 10: Budget Management Decisions

Week 11: Pivot Tables decisions-Part I

Week 12: Pivot Tables decisions-Part II

Taught by

Dr. Neha Mathur

Tags

Reviews

Start your review of Finance Analytics for Decision Making using Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.