❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 17th, 2023]
Work comfortably with Microsoft Excel.
Format spreadsheets in a professional way.
Be much faster carrying out regular tasks.
Create professional charts in Microsoft Excel.
Work with large amounts of data without difficulty.
Understand Accounting and Bookkeeping principles.
Build a company’s P&L from scratch.
Build a company’s Balance Sheet from scratch.
Perform Financial Statement Analysis.
Understand the importance of timing in terms of revenue and cost recognition.
Calculate Liquidity, Solvency, Profitability, and Growth ratios in order to analyze a company’s performance.
Understand 10-K reports.
Assess whether a project is feasible through the Net Present Value Technique.
Calculate a complete loan schedule.
Understand the difference between variable and fixed interest rates.
Perform industry analysis.
Understand what drives a company’s value.
Know how to analyze a business.
Work comfortably with Microsoft PowerPoint.
Create professional company presentations in PowerPoint.
Become a successful Financial Analyst in no time – if you follow the course fully!.
Course Syllabus
Welcome! Course Introduction
Microsoft Excel - Quick Introduction
Microsoft Excel - Useful Tools
Microsoft Excel - Best Practices That Will Make a Difference
Microsoft Excel - Beginner, Intermediate & Advanced Functions
Microsoft Excel - Financial Functions in Excel
Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
Practical Exercise - SUMIFS
Microsoft Excel - Building Professional Charts in Excel
Microsoft Excel - Creating Complete Professional Charts from Scratch
Microsoft Excel - Working with Pivot Tables in Excel
Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting
Modeling in Excel - Building a Complete 3-statement Model
Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios
Modeling in Excel - We Are Almost There! Completing the 3-Statement Model
Accounting - Introduction to Accounting & Bookkeeping
Accounting - Types of Revenues, Costs, Assets, and Liabilities
Accounting - Revenue Recognition
Accounting - Cost Recognition
Accounting - Understanding the Big Picture: Why, What, When, and How Much
Accounting - The Core Principles of Accounting
Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand
Accounting - The Importance of Timing
Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis
Advanced Accounting - Trade Receivables
Advanced Accounting - Inventory
Advanced Accounting - Fixed Assets
Advanced Accounting - Trade Payables
Advanced Accounting - Financial Liabilities
Advanced Accounting - Leasing Liabilties
Advanced Accounting - Using Leverage
Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments
Assessment - Accounting
Financial Statement Analysis - An Introduction
Financial Statement Analysis - Subtleties
Financial Statement Analysis - Practical Case Study "Analyzing P&G's Financials"
Financial Statement Analysis - Tesla Exercise
Working Capital Management
Fundamentals of Business & Financial Analysis
Business Analysis in Excel
Finance 101 - The Time Value of Money and Interest Rate Components
Finance 101 - The Value of Cash Flows with Different Timing
Finance 101 - Loan Calculations
Capital Budgeting - Basic Notions
Capital Budgeting - A Complete Case Study
Tesla Practical Case Study - Building a Financial Planning Model
PowerPoint - Introduction to PowerPoint
PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User
Who Does What in the World of Finance?
Next Steps
