❗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