Financial Ratios Using Excel
What you'll 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
Requirements
- No previous knowledge is required
- Bring your positive attitude
- Have Microsoft Excel installed on your computer
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!
Who this course is for:
- Everyone is welcome to the course
- Beginner Investors
- Finance and accounting students
Instructor
- 4.5 Instructor Rating
- 23,632 Reviews
- 92,875 Students
- 10 Courses
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.