Brief Introduction
Learn the basics of financial ratios in about 30 minutes.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!
Requirements
- Requirements
- No previous knowledge is required
- Bring your positive attitude
- Have Microsoft Excel installed on your computer
Knowledge
- 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
Stefan Ignatovski, Ph.D.
3.7 Raiting
Corporate Finance
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn corporate finance from a practicing CPA Certified Public Accountant We will learn how to read financial statements and how to use them for decision making....
Master Personal Budgeting in Just 1 Hour!
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Take hold of your life. . . and budget right now! Learn to plan ahead and budget the right way! INCLUDED IN THIS COURSE:...
Financial Statements Modeling 2020 Learn With A Professional
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn financial statements modeling with a professional analyst Shorten the learning curve. Learn the skills and gain the hands-on experience needed to become a professional analyst in weeks....
Black Scholes Basics and Beyond
- 3
-
![]()
![]()
![]()
![]()
![]()
This course teaches you how to use Black Scholes to value employee stock options in any company. ...
