Financial Modelling with AI (PWC)

Categories Business Programs

About Program

Advance your career with Labsity’s Machine Learning Program. IIT Bombay Certification, Internship, and Big4 Placement Assistance.
Show More

What I will learn?

  • • Master Microsoft Excel from beginner to advanced level
  • • Build dynamic financial models and dashboards from scratch
  • • Understand accounting concepts like revenue, assets, and liabilities
  • • Analyze financial statements including balance sheet, P&L, and cash flow
  • • Perform business and financial analysis using real-world case studies
  • • Conduct valuation and budgeting using Excel
  • • Use ChatGPT for financial data analysis and automation
  • • Present data insights professionally using PowerPoint

Program Curriculum

Welcome! Program Introduction

  • What does the program cover?

Microsoft Excel Quick Intoduction

Microsoft Excel – Useful Tools

Microsoft Excel Best Practices That Will Make a Difference

Microsoft Excel Beginner, Intermediate & Advanced Functions

Microsoft Excel – Financial Functions in Excel

Microsoft Excel Practical Exercise Build a P&L From Scratch

Practical Exercise – SUMIFS

Microsoft Excel – Building Professional Charts in Excel

Microsoft Excel Creating Complete Professional Charts from Scratch

Microsoft Excel – Working with Pivot Tables in Excel

Microsoft Excel Pivot Tables & Slicers World Class Financial

Modeling in Excel Building a Complete 3 Statement Model

Modeling in Excel Let’s Build a Flexible Model with Multiple

Modeling in Excel We Are Almost There! Completing the 3 Statement

Accounting Introduction to Accounting & Bookkeeping

Accounting Types of Revenues, Costs, Assets, and Liabilities

Accounting – Revenue Recognition

Accounting – Cost Recognition

Accounting – Understanding the Big Picture Why, What, When

Accounting – The Core Principles of Accounting

Accounting Practical Exercise – The Accounting Transactions

Accounting – The Importance of Timing

Accounting – Preparing a Cash Flow Statement Understanding Cash

Accounting – Trade Receivables

Advanced Accounting – Inventory

Advanced Accounting – Fixed Assets

Advanced Accounting – Trade Payables

Advanced Accounting – Financial Liabilities

Advanced Accounting – Leasing Liabilities

Advanced Accounting – Using Leverage

Advanced Accounting Raising Equity, Types of Equity, and Dividend

Assessment – Accounting

Financial Statement Analysis – An Introduction

Financial Statement Analysis – Subtleties

Financial Statement Analysis Practical Case Study Analyzing P&G’s

Financial Statement Analysis – Tesla Exercise

Working Capital Management

Fundamentals of Business & Financial Analysis

Business Analysis in Excel

Finance 101 – The Time Value of Money and Interest Rate Components

Finance 101 The Value of Cash Flows with Different Timing

Finance 101 – Loan Calculations

Capital Budgeting – Basic Notions

Capital Budgeting – A Complete Case Study

Tesla Practical Case Study: Building a Financial Planning Model

Data Analysis with ChatGPT – Intro
For the person who wants to grow into data analyst

Data Analysis with ChatGPT Exploratory Data Analysis EDA

Data Analysis with ChatGPT – Deal with Inconsistent Data

Data Analysis with ChatGPT – Organize Messy Data

Data Analysis with ChatGPT – Working with Functions

Data Analysis with ChatGPT – Clean Text Data

Data Analysis with ChatGPT – Dates and Time Data

Data Analysis with ChatGPT – Complete Practical Example

PowerPoint – Introduction to PowerPoint

PowerPoint Tips & Tricks That Will Transform You Into An Advanced

Who Does What in the World of Finance

Earn Co-Branded Certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
R
12 hours ago
Collected good information related to Basic of Excel. Excited to learn more advanced techniques and information about Excel and Financial modelling with AI.
₹5,499.00 ₹8,499.00

A Program by

Material Includes

  • • 50+ downloadable Excel and accounting project files
  • • Financial modeling templates and case studies
  • • Practice exercises and assessments
  • • PowerPoint and ChatGPT data analysis resources
  • • Lifetime LMS access and certification from Labsity

Requirements

  • • Basic understanding of Excel recommended
  • • Laptop or PC with Microsoft Excel installed
  • • Stable internet connection for video lessons
  • • Enthusiasm to learn and practice hands-on exercises

Tags

Target Audience

  • • Students aspiring for careers in finance, accounting, or data analytics
  • • Working professionals seeking to upskill in Excel and financial modeling
  • • Entrepreneurs and business owners who want to manage finances efficiently
  • • MBA, BBA, and commerce students preparing for corporate roles
  • • Analysts aiming to transition into investment banking or FP&A

Here's Why You Need To Master This Program

0 k+

Global Job Opening in Market

$ 0 + Billion

Global Market Size

0 Lakh

Average Annual Salary

0 +

Industry Mentors

Get Certified, Get Ahead! Your success starts here!

Explore Your Mentors

Vivek Patel

HCLTech Analyst | 4+ Yrs Exp

Analyst @ HCLTech

Microsoft Co-Pilot & ITIL 4 Certified

Simplifies complex IT concepts into practical, job-ready skills for students.

View Linkedin

Aditya Kumar Upadhaya

Infosys Tech Analyst | 5+ Yrs Exp

Technology Analyst @ Infosys

5+ Yrs Exp | Azure Certified | Ex-Nucleus Software

Shares real project knowledge to help students build strong, industry-ready tech careers.

View LinkedIn

Maneesh Kumar

Java Developer @ TCS

Java Developer @ TCS

4+ Yrs Exp | Microsoft Azure Certified

Delivers hands-on Java and cloud expertise to prepare students for top tech careers.

View LinkedIn

Amar Singh

Senior Engineer @ L&T

Senior Engineer @ L&T

3.2 Yrs Exp | Autodesk Certified | AutoCAD, SolidWorks, Ansys

Expert in design & simulation, guiding students with industry-level tools and projects.

View LinkedIn

Listen their Stories

How I Got Placed at Infosys with 10 LPA | Labsity's AI/ML Program Changed Everything!

How I Got Placed at Infosys with 10 LPA | Labsity's AI/ML Program Changed Everything!

From Confused to Confident | My Labsity Internship Story

From Confused to Confident | My Labsity Internship Story

kala
What stood out for me was the quick resolution of my doubts and queries. Labsity gave me all the support I needed to restart my career - from sharing placement opportunities to interview preparation.
Kala Chaithanya Velagapudi
Placed in EmergentX
tharun
After facing disappointments from campus placement rejections, I turned to Labsity. I learned valuable skills, how to crack interviews, and how to make a strong resume through their guidance. A few months later, I secured a data science internship with Flipkart. It's my first job after graduation. The office is huge, and I love it here!
Tharun Kumar
Placed in Flipkart
pankaj
I had no idea how to enter the corporate world, what kind of job would be a good fit for me, or where to even start. Labsity guided me through the entire process, helping me build the right skills and confidence. Thanks to their support and resources, I was able to secure an internship, which eventually led to a job offer from Star Health and Allied Insurance.
Pankaj
Placed in Star Health & Insurance
yaswanth
Got my dream job at Amazon! I applied to Amazon and got the job! It was my dream. I wanted to get into tech but I was from an electrical background. I learned the skills, which came in handy in my interviews. Thanks to Labsity, I was able to explain the concepts and applications well. They helped me with everything.
Yaswanth Mandapati
Placed in Amazon
yogesh
Go-to platform for students and freshers I landed my first internship from Labsity! This app has opportunities for every student and is a must-have for students looking to build their careers.
Yogesh Singh
Placed in Flipkart
yash
"Joining Labsity was the turning point in my career. The AutoCAD Civil program not only sharpened my technical skills but also connected me with real industry opportunities. Today, I’m working in a reputed company — all thanks to Labsity’s guidance and placement support."
Placed at TASPL
anshu
"As a student at GLA University, I wanted practical exposure in Artificial Intelligence beyond textbooks. Labsity’s AI program gave me exactly that — hands-on projects, mentorship, and the confidence to build real-world solutions while still in college."
Student at GLA University
abhishek
"Being a B.Tech student at Ramaiah, I wanted to stand out with industry-ready skills. Labsity’s Full Stack Development program gave me exactly that — live projects, strong mentorship, and the ability to develop complete applications from scratch."
Student at Ramaiah College
placeholder.png
"Coming from a B.Com background, I never thought I could step into AI and analytics. Labsity’s Financial Modelling with AI program made complex concepts easy to understand and apply. Now, I’m combining finance and AI skills to create powerful solutions."
B.Com Student at IGNOU

Collaborating with 50+ top-tier universities and educational institutions

Want to receive push notifications for all major on-site activities?

Earn like top 1%

Upskill in Industry Relevant Skillset to switch to Top 1% roles in Industry.

What is your topic of interest?
Currently you are?
Download Brochure