Understand and communicate the fundamentals of financial analysis, important ratios & Excel formulas to shine at work.
This Smart Tips course provides an introduction to financial analysis, covering several topics, which are fundamental for every aspiring Financial Analyst.
What you’ll learn
- Navigate through Financial Reports with Ease.
- Create Financial Statements from Scratch.
- Analyze a Company’s Performance Based on its Annual Report.
- Prepare Forecasts and Use Regression Analysis to Make Predictions.
- Knowledge of all Essential Excel Functions & Features Required for Financial Analysis.
- Understand Variance and Standard Deviation Calculations with Practical Examples.
Course Content
- Introduction –> 1 lecture • 1min.
- Financial Analysis Overview –> 3 lectures • 10min.
- Financial Statements –> 9 lectures • 1hr 5min.
- Important Functions for Financial Analysts –> 8 lectures • 45min.
- Master Pivot Tables for Finanical Analysis –> 5 lectures • 35min.
- Common Charts & Graphs for Financial Analysis –> 7 lectures • 36min.
- The Time Value of Money –> 4 lectures • 20min.
- Financial Forecasting –> 7 lectures • 36min.
- Next Steps –> 1 lecture • 1min.
Requirements
- A Computer with Microsoft Excel.
- Familiarity with basic Excel features and formulas.
- Willingness to learn. Let’s do this!.
This Smart Tips course provides an introduction to financial analysis, covering several topics, which are fundamental for every aspiring Financial Analyst.
You’ll get short focused lectures about different aspects of financial analysis. Because the lectures are short, you’ll be able to learn fast, so that you can immediately apply it to your work. The tutorials in this course are standalone. That means you don’t have to watch in any particular order. If you’re searching for a specific topic that’s relevant for you, take a look through the available tips to find the knowledge you need when you need it. So feel free to jump around as you like.
Here are the topics we cover:
- Overview of the main financial statements and how to create an income statement, balance sheet and cash flow statement from scratch. You’ll also learn how to use ratios to conduct a comprehensive analysis to assess the overall financial condition and performance of a company.
- The most important Excel formulas and functions as well as important Excel features a good financial analyst needs to work with. You’ll lean how to use Excel Pivot Tables to quickly summarize data and create charts to visualize the results effectively.
- Important concepts in financial analysis such as the time value of money, discounted cash flows, NPV and annuities. You’ll learn various techniques to forecast and apply regression analysis to make predictions.
Get started now! This is the course for busy professionals to learn fast and make a lasting impression at work.