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 12-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.
Course Status : | Upcoming |
Course Type : | Core |
Language for course content : | English |
Duration : | 12 weeks |
Category : |
|
Credit Points : | 4 |
Level : | Postgraduate |
Start Date : | 15 Jul 2025 |
End Date : | 31 Oct 2025 |
Enrollment Ends : | 31 Aug 2025 |
Exam Date : | 13 Dec 2025 IST |
Translation Languages : | English |
NCrF Level : | 6.5 |
Industry Details : | Finance and Investment |
Shift : | 2 |
Note: This exam date is subject to change based on seat availability. You can check final exam date on your hall ticket.
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
Dr. Neha Mathur is working as an Assistant
Professor (Senior Scale) at Centre for Distance and Online Education, Manipal
University Jaipur. She has 16 years of teaching experience and worked in
several reputed Universities in India. Dr. Mathur is expert in Financial
Management, Management accounting, Research Methodology, Statistics for
Management decisions and Business statistics. Under her guidance, she also
supervised 1 Ph. D research successfully.
She was a convenor of various International Conferences and organized
several workshops on Advanced Excel for scholars, faculty, and students. She
has published more than 15 research papers indexed in Scopus, Web of Sciences,
and UGC-Care-listed journals. She has completed several ATAL FDP’s and NPTEL courses, where she was a top
performer. Other than the core responsibility of teaching and research her job
responsibilities in various organization also includes working as Assistant
head of the institute, member- NAAC steering committee and Proctor at school level
in university.
Enrolling and learning from the course is free. However, if you wish to obtain a certificate, you must register and take the proctored exam in person at one of the designated exam centre’s. The registration URL will be announced when the registration form is open. To obtain the certification, you need to fill out the online registration form and pay the exam fee. More details will be provided when the exam registration form is published, including any potential changes. For further information on the exam locations and the conditions associated with filling out the form, please refer to the form.
Grading Policy:
Assessment Type | Weightage |
Weekend Assessment | 25% |
Final Exam | 75% |
Certificate Eligibility:
Score | Type of Certificate |
>=90 | Gold |
76 - 89 | Silver |
61 - 75 | Bronze |
40 - 60 | Successfully Completed |
<39 | No Certificate |
Sample Certificate:
Disclaimer: In order to be eligible for the certificate, you must register for enrolment and exams using the same email ID. If different email IDs are used, you will not be considered eligible for the certificate.
DOWNLOAD APP
FOLLOW US