Financial Ratios Using Excel (Udemy.com)
Learn the basics of financial ratios in about 30 minutes.
Created by: Stefan Ignatovski, Ph.D.
Last updated July 2017
What you will learn
- Describe the Excel Interface
- Manipulate Worksheets (Spreadsheets)
- Everything about cells
- Format the cells
- Percentages
- Cell references
- Charts basics
- Liquidity Ratios
- Efficiency Ratios
- Leverage Ratios
- Coverage Ratios
- Profitability Ratios
- Cash Flows Analysis
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.3 out of 5higher than 13% of them
- Reviews58#348 of 356 by number of reviews
- Length1.1 hoursshorter than 94% of them
- Last updatedJuly 2017earlier than 86% of them
Course Description
When we are learning something new, we always need to start with the basics.
This course will provide you with the basic skills to calculate and interpret the financial ratios of a company using Excel. After you complete this course you will be able to:
- Work with multiple spreadsheets and manipulate them for your preferences
- Use the cells easily and understand the basic functions
- Know how to use the basic formulas
- Know how to insert and use charts and spark lines
- Retrieve financial statements of various companies
- Use the liquidity, efficiency, leverage, coverage, and profitability ratios
- Perform analysis of a cash flows statement
- Able to continue to more advanced Excel and Financial Analysis courses
I encourage you to take notes, and work together with me during the course. This is very important for you to become confident with application of your knowledge.
I believe that everyone should have the appropriate basic Excel skills and to perform basic financial analysis.
Once you complete the course, review it so that other students can enjoy it too. Enjoy the course!
Instructor Details
- 4.3 Rating
58 Reviews
Stefan Ignatovski, Ph.D.
An Accounting Professor, Investor and Entrepreneur who teaches at multiple colleges in the US, including University of Washington. Stefan has also established multiple companies and invested in multiple start-up companies. Additionally, he is the author of the books "Financial Accounting" and "What College Didn't Teach You!". His area of expertise is concentrated in Accounting Forensics, which focuses on financial fraud, creative accounting, and anti-money laundering.
In every course Stefan makes, you will find the difference in teaching. He has his own way of creating interesting videos (less than 5 minutes, of course) in which you will find everything you need to know about a specific topic. The DIFFERENCE is that his videos are fun to watch and will give you the desired "Aha!" moment. You will never forget the information, since each one is very descriptive.
Stefan's classes are very dynamic and make you eager to learn.
More courses by Stefan Ignatovski, Ph.D.
Accounting: From Beginner to Advanced! (2024)
4.5 (12,923 Reviews)
Provider: Udemy
Time: 11.2h
$24.99
Managerial (Cost) Accounting For Beginners (2023)
4.5 (7,381 Reviews)
Provider: Udemy
Time: 7.5h
$16.99
Forensic Accounting: Fraud Investigation! (Course 1 of 4) (2023)
4.4 (4,782 Reviews)
Provider: Udemy
Time: 1.3h
$12.99
Intermediate Accounting: Learn Everything! (2023)
4.5 (1,925 Reviews)
Provider: Udemy
Time: 4.6h
$11.99
Tax Preparation: Learn Fast! Prepare Taxes with Confidence! (2017)
4.3 (940 Reviews)
Provider: Udemy
Time: 2.4h
$12.99
Forensic Accounting: Fraud Investigation! (Course 2 of 4) (2023)
4.5 (909 Reviews)
Provider: Udemy
Time: 1.4h
$11.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Donu Samuel John on 7/1/2024
got a clear picture of all the ratios which I can use at work and accounting studies
By Anna Frei on 8/28/2022
This is an excellent course to learn ratios and simultaneously see how they're calculated in Excel! If you're already familiar with Excel's basic functions, this course will not specifically benefit you in terms of Excel. Nonetheless, it explains financial ratios very well and makes it easy to understand. That is what I enjoy about Stefan's courses - his explanations are simple and really stick in your mind.
By Daryl Beecham on 9/5/2021
This my first time taking a strictly financial ratios course. I have studied financial ratios and struggled with the basic concepts. This course was great. All the fundementaal ratios were taught in a clear and understandable way. This cousre additionally was very concise and that is good. I found it surprising when the insitructor some did not make it to the end. This course was made understandable to anyone who knows what business is. if you don't know business financial ratios this is a goodplace to start learning it. 5stars.
By Angela Storrs on 5/16/2021
He is very clear and explains this well
By Kevin Vanloo on 7/25/2020
Goof overview - Is a summary of the ratios included with examples?
By Stevan Miletic on 7/10/2020
Sections 4 to 9 are the only ones that actually make some sense, however this could fit in one 10 minute video. Otherwise the course can be viewed as excel basics course which I am sure nobody purchased the course for.
By Jessica Heinz on 2/16/2020
Love that we are physically being shown, but have to read the instructions instead of listening. This ensures that students pay attention if they are to understand.
By Alex Lerner on 9/2/2019
Very thin on added value. The formulas can be looked up anywhere.
By Arturo Zamora Canizalez on 5/31/2017
Claro y ameno. fácil de asimilar.
By Sankara Kumaravel on 4/5/2017
This course gave me an intensive knowledge on financial ratios and the way to analyse the factors.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100












