Excel for Accounting & Finance: Financial Modeling & Val.
What you'll learn
- Understand Financial Modeling in detail
- Learn to prepare Financial Models in Excel
- Before starting Financial Modeling, understand the Financial Statements in detail
- Learn all the key Accounting & Finance terms for Financial Modeling
- Learn Basic Finance, Time Value of Money and DCF
- Learn to calculate Net Present Value - NPV
- Learn to perform complete Financial Appraisal for projects
Requirements
- No prior knowledge or experience is requried. We will start right from the scratch.
- You should have Microsoft Excel: Any version will be fine for us.
Description
Microsoft Excel is the backbone of most office jobs, especially in Accounting and Finance. It is estimated that finance professionals spend over 50 percent of their time working in Excel. For anyone pursuing a career in business, mastering Excel is not just helpful — it is essential.
This course is Module 4 of our 4-part Excel Specialization for Accounting and Finance. It focuses entirely on Financial Modeling — one of the most valuable and high-impact Excel skills in the industry.
Financial Modeling is both an art and a science:
The art of designing future-focused financial statements
The science of making them accurate, dynamic, and decision-ready
At the core of every financial model is Microsoft Excel — the world’s most powerful tool for building structured, scenario-based, and data-driven models. In this course, you will learn how to build robust financial models that automatically update and adapt when inputs or assumptions change, without breaking any calculations.
Finance, Accounting, Financial Statements, and Financial Modeling all form the language of business. These are used by professionals every day to guide decisions, allocate resources, and shape business strategies.
This course teaches you that language by providing you with the tools, techniques, and confidence to create professional-grade financial models from the ground up.
What You’ll Learn:
No prior experience needed — the course starts with the basics
Understand key business reports and financial terms
Learn the accounting logic behind financial statements
Build full financial statements in Excel using raw accounting data
Create a fully linked and dynamic 3-statement financial model using a startup case
Learn core finance concepts: Time Value of Money, Present Value, Future Value, DCF, NPV, and IRR
What Makes This Course Special:
Practical and project-based learning with real Excel use cases
Includes templates, assignments, and case studies
Covers both beginner and advanced Excel techniques
Follows a real-world business scenario from basic reports to advanced modeling
Taught by a Chartered Accountant with real industry and teaching experience
Who Should Enroll:
Finance, Accounting, and Business students
Aspiring finance professionals
Entrepreneurs and business owners
Startup founders and investors
Prerequisites:
No prerequisites. Just bring your curiosity
Basic Excel knowledge is helpful but not required — all key skills are taught in the course
30-Day Money-Back Guarantee:
Enroll with confidence. Udemy offers a full refund within 30 days if the course does not meet your expectations.
Your Instructor:
Chartered Accountant | ex-PwC | Startup Founder | 100,000+ Students Worldwide
Who this course is for:
- Startup and small business founders/owners
- Finance professionals and students
- Accounting professionals and students
- Investors and Venture Capitalists
Instructor
Chartered Accountant with 16 years experience in Accounting, Finance, and Business Intelligence.
I am a Chartered Accountant from ICAEW (Institute of Chartered Accountants of England and Wales) and a Chartered Certified Accountant from ACCA (Association of Chartered Certified Accountants in England) . I also have a Bachelors degree in Commerce.
I started my professional career with PwC as a Functional Consultant, later moved to at FTSE 100 FMCG as a Finance Manager, then working a General Manager developed an outsourcing hub 'Excelsious' for US and UK accounting firms, and finally cofounded Receipt Bot - an accounting automation company which is automating some tedious aspects of Accounting for clients from 21 countries.
Right from the beginning of my career, my role has been to improve the Accounting and Reporting systems. From automating data entry and bookkeeping to the preparation of interactive business analysis dashboards for the senior management, I have led multiple assignments.
Over my professional career of 16 years, I have been teaching several programs of Accounting and BI at some reputed institutes. Over this time, I have trained 20,000+ students from 50+ countries.
I am absolutely delighted to share my skills and experience with you on the Udemy platform!