Skip to content
Write a review
UdemyAccountingPaid courseAll LevelsCertificate

Financial Statements, Ratios, & Financial Analytics in Excel (Udemy.com)

Master Financial Statement Preparation, Ratio Analysis & Financial Dashboards Using Excel’s Most Powerful Tools

4.4
375 reviews

Created by: Irfan Sharif ACA ACCA

Last updated August 2026

Our take

Based on the ratings of 375 students, a sample of their written reviews and the syllabus, as the course stood in August 2026. No course pays to be reviewed.

This is a finance course taught through Excel's data tools. Irfan Sharif, a chartered accountant, shows how to bring in a trial balance, relate tables in Power Pivot, and write DAX measures that feed a profit and loss statement, balance sheet, cash flow statement and statement of changes in equity. The syllabus runs 94 lectures over about 10.8 hours, with dashboards and horizontal and vertical analysis near the end. It is aimed at accountants, analysts and finance managers more than casual spreadsheet users.

Reviewers mostly like it. They mention detailed, step-by-step teaching, useful DAX and data modeling, and a dashboard section one called a detailed walkthrough. One student with no finance background said they still picked up advanced Excel. The complaints are mild but real. One reviewer found it extremely difficult for people who are not fully prepared, and the course has no quizzes or coding exercises, so practice means following along. The rating is 4.4 from 375 reviews, with 208 five-star and only 10 below three stars.

The content was last updated in August 2026, which matters for a tool-heavy topic like this. About 4,200 students have enrolled. It makes sense after a basic Excel course and some accounting knowledge, and it is a poor first step into either. One reviewer expects it to improve their reporting models significantly, which fits the course's focus on cutting repetitive work. Anyone still learning what a balance sheet is should start elsewhere.

Best forAccountants and analysts with basic Excel who want statements and dashboards that refresh from a data model.
Skip it ifYou want accounting basics or ratio theory, or need quizzes and exercises to practice on.

Pros

  • Builds P&L, balance sheet, cash flow and equity statements that refresh through DAX
  • Reviewers praise the detailed, step-by-step teaching from a chartered accountant
  • Three dashboard sections run over two and a half hours, plus horizontal and vertical analysis
  • Updated August 2026, with 375 reviews averaging 4.4 stars

Cons

  • No quizzes or coding exercises, so practice means following along on your own
  • One reviewer found it extremely difficult without solid preparation first
  • Ratio coverage looks thin: one six-lecture working capital section in the syllabus
It's an amazing course and i have learned many excel tricks and DAX formulas and data modeling in excel.
Saran S, a student

Listed for all levels, but it assumes basic Excel and financial reports; one reviewer called it very hard without that.

icon
What you will learn

  • Financial Reporting
  • Dynamic Profit & Loss Statement aka Income Statement
  • Dynamic Balance Sheet
  • Dynamic Cash Flow Statement
  • Dynamic Statement of Changes in Equity
  • Dynamic Financial Ratios and Financial Analysis
  • Dynamic Visualizations and Dashboards
  • All the Power Pivot & DAX needed
  • Dynamic Horizontal Analysis
  • Dynamic Vertical Analysis

Course content

16 sections · 94 lectures · 11 hours of video 7 articles

  1. 1Getting started 2 free previews8 lectures · 35 min
  2. 2Preparation of Profit & Loss Statement6 lectures · 35 min
  3. 3Getting started with DAX8 lectures · 34 min
  4. 4Introduction to next level DAX5 lectures · 27 min
  5. 5Preparation of Balance Sheet6 lectures · 26 min
  6. 6Working Capital Ratios6 lectures · 19 min
  7. 7Trial Balance | Drill down | Account Transactions or Ledgers3 lectures · 21 min
  8. 8Preparing the Cash Flow Statement12 lectures · 1.4 hours
  9. 9Statement of Changes in Equity8 lectures · 46 min
  10. 10Basic Dashboard for cross-country comparison4 lectures · 47 min

Who it is for

The instructor says it suits

  • Financial Analysts
  • Business Analysts
  • Finance Managers
  • Financial Controllers
  • Accountants
  • Bookkeepers
  • Accounting & Finance students

What you need before you start

  • Basic knowledge of Financial Reports and Ratios
  • Basic knowledge of Microsoft Excel

icon
Course Description

Master Financial Reporting & Analysis with Excel’s Most Powerful Tools

Why stop at basic spreadsheets when Excel can deliver powerful financial insights? In this masterclass, you’ll learn how to transform raw financial data into automated financial statements, interactive dashboards, KPIs, ratios, and meaningful business insights — all within Excel.

Using Power Query, Power Pivot, and DAX, you’ll build sophisticated financial reporting and analysis solutions that can be refreshed and updated with minimal manual effort.

What You’ll Learn

  • Automated Financial Statements — Build Income Statements, Balance Sheets, Cash Flow Statements, and other financial reports.

  • Financial Ratio Analysis — Calculate and analyze profitability, liquidity, efficiency, leverage, and other key financial ratios.

  • Dynamic Analysis with DAX — Create powerful calculations, KPIs, and measures that respond dynamically to filters and slicers.

  • Interactive Financial Dashboards — Build professional dashboards that communicate financial performance and support better decision-making.

  • Power Query for Data Transformation — Import, clean, transform, and automate financial data from multiple sources.

  • Power Pivot & Data Models — Build scalable financial models using relationships and structured data.

  • Financial Analytics in Excel — Turn complex financial data into actionable insights using Excel’s advanced analytical capabilities.

Who Is This Course For?

This course is designed for:

  • Financial Analysts who want to strengthen their financial analysis and reporting skills.

  • Accountants who want to automate reporting and reduce repetitive Excel work.

  • Business Analysts who want to develop stronger data-driven decision-making skills.

  • Finance Professionals looking to master advanced Excel tools for financial reporting and analytics.

  • Entrepreneurs & Business Owners who want to better understand and analyze their business performance.

  • Students pursuing careers in accounting, finance, business analysis, or data analytics.

Why Take This Course?

  • Practical & Real-World: Learn through realistic financial data, scenarios, exercises, and case studies.

  • Hands-On Learning: Build financial reports, dashboards, models, and analytical solutions yourself.

  • Advanced Excel Skills: Go beyond basic formulas and spreadsheets with Power Query, Power Pivot, and DAX.

  • Automation-Focused: Learn techniques that reduce manual work and make financial reporting faster and more efficient.

  • Career-Relevant: Develop practical skills that you can apply immediately in accounting, finance, and business analysis roles.

  • Lifetime Access: Learn at your own pace with ongoing access to the course and future updates.

  • Certificate of Completion: Receive a certificate upon completing the course.

By the end of this course, you’ll be able to use Excel not just for spreadsheets, but as a powerful platform for financial reporting, analysis, automation, and business intelligence.
Read More All Levels All Levels product length iconTime: 10.8h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Irfan Sharif ACA ACCA

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!

Read More

icon
More courses by Irfan Sharif ACA ACCA

$24.99

$15.99

$11.99

$69.99

$11.99

$54.99

All courses by Irfan Sharif ACA ACCA

icon
More Accounting courses

$18.99

$11.99

$119.99

$22.99

$13.99

$12.99

All Accounting courses

icon
Reviews

4.4

375 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Saran S on 2/24/2025

It's an amazing course and i have learned many excel tricks and DAX formulas and data modeling in excel. Thanks for this course.

By Abdullah Hamze on 10/16/2024

This course is a comprehensive guide to mastering DAX using accounting datasets. The visualization section offers a detailed walkthrough to creating a powerful dashboard. It was a good course and I'm looking forward to deploying these skills in my future projects.

By Gracjan Szajewski vel Krzejewski on 11/6/2023

This is a very good course refering to accounting, however it could be extremely difficult especially for those who are not fully prepared.

By Noman Afzal on 10/11/2023

Best course with clear understanding. I have taken Power BI Financial Analysis and Financial Reporting course of Mr. Irfan, which has deep and detailed learning, similarly, as this Accounting Analytics .... course started, I found same level of energy and detailed learning.

By Omar alqannoor on 8/6/2023

Did not say how to move columns to the right to make spaces

By Muchengeti Masiya Musarakufa on 5/20/2023

He explains clearly how to build up databases and how we integrate the information to come up with meaningful reports

By Burhanuddin Lokhandwala on 5/11/2023

I liked the course. I wish the author of the course spent more time showing us more complex charts! But overall, the course was amazing! 10/10 would recommend over and over again!

By Wayne Phillips on 2/26/2023

An excellent introduction to using PowerPivot and DAX for financial reporting. I'm very excited to use the concepts and techniques taught on real world problems.

By Zamangwane Ngozi on 1/3/2023

I need help in downloading power pivot.

By Rahul Synap on 7/12/2022

Good class, but your P & L and Cashflow PBIT do not match. And I couldn't be able to understand your value-type in CashFlow_St. Though it is a nice hack, could you elaborate on it? Can you provide reference material in your lesson by updating it on Udemy? Just add an excel sheet, all the items in cashflow with their respective value_type. It would be a great help. Thank you.

Showing all 10 reviews on CourseDuck

Read all 375 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100

Financial Statements, Ratios, & Financial Analytics in Excel
Visit course on Udemy Write a review
  • Video Duration: icon 10.8h
  • Price: $64.99
  • Provider: icon Udemy
  • Updated: icon August 2026
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
  • Lectures:94 in 16 sections
  • Students:4,162
  • Subtitles:1 language
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com