The Complete Financial Analyst Course 2026

Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!

  • 0.0 (0 Reviews)
  • 0 Students
  • 405 Lessons
  • 365 Careers

Course Overview

* Updated for September 2026: New Hands-on Projects Added *

"If you’re trying to prepare for a career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you" - Business Insider

"A financial analyst career is one of the top-paying entry-level jobs on the market.” 

"Even in the toughest job markets, the best candidates find great positions." - Forbes

You simply need to find a way to acquire practical skills that will give you an edge over the other candidates.

But how can you do that?

You need the proper training, and you have never seen how analysts in large firms do their work ...

Stop worrying, please! We are here to help.

The Complete Financial Analyst Course is the most comprehensive, dynamic, and practical course you will find online.

It covers the following topics, fundamental for every aspiring financial analyst:

  • Microsoft Excel for beginner and intermediate users — become proficient with the world’s #1 productivity software

  • Accounting, financial statements, and ratios — making sense of debits and credits, profit and loss statements, balance sheets, liquidity, solvency, profitability, and growth ratios

  • Finance basics — interest rates, financial math calculations, loan calculations, time value of money, present and future value of cash flows

  • Business analysis — understanding what drives a business, essential items to be analyzed, the importance of industry cycles, important drivers for the business of start-up, growth, mature and declining companies, industry KPIs

  • Capital budgeting — decide whether a company's project is feasible from a financial perspective and compare different investment opportunities

  • Microsoft PowerPoint for beginner and intermediate users — The #1 tool for a visual representation of your work, a necessary skill for every financial analyst

This complete bundle ensures you receive the proper training for each critical aspect.

Here comes the fun part!

After covering each major roadblock, you will be asked to solve a challenge. You will:

  1. Calculate a company’s sales in Excel

  2. Register its bookkeeping entries, produce applicable financial statements and calculate financial ratios

  3. Calculate a complete loan schedule for the company’s debt

  4. Analyze the company’s business performance

  5. Create a PowerPoint presentation based on the results

  6. Receive personalized feedback

  7. Participate in our monthly Amazon Gift Card Lottery

Sounds interesting, right?

At the end of the challenge, you'll send us your work, and we'll reply with personalized feedback - creating an interactive student experience that optimizes what you'll learn from the course.

What makes this course different from other finance courses?

  • High-quality production, HD video and animations (not a collection of boring lectures)

  • Knowledgeable instructors with experience in such prominent companies like Pwc and Coca-Cola

  • Complete training covering all major topics and skills necessary to become a top-class financial analyst

  • Extensive case studies reinforcing everything you’ve learned

  • Course Challenge that creates an interactive experience

  • Excellent support for when you don’t understand a concept or want to drop us a line — you’ll receive an answer within one business day

  • Dynamic instructors who keep up a steady tempo throughout the course

Why should you consider a career as a financial analyst?

  • Salary. A financial analyst job typically leads to a well-paid career

  • Promotions. Financial analysts acquire valuable technical skills, making them the leading candidates for senior roles within a corporation

  • Secure Future. There's high demand for financial analysts on the job market; you won’t have to be concerned about finding a job

  • Growth. This isn’t a tedious job — you'll will face different challenges that will test your existing skills

This course comes with Udemy’s 30-day unconditional, money-back guarantee.

Take advantage of this opportunity to acquire the skills that will advance your career.

See more

FAQ

FAQ area empty

Course curriculum

58 chương 405 bài học 21 giờ 24 phút 7 bài học thử miễn phí
Chương 1 Welcome! Course Introduction
Chương 2 Microsoft Excel - Quick Introduction
Chương 3 Microsoft Excel - Useful Tools
  • Inserting a Line Break with Alt + Enter 0:50
  • Do More with Your Sales Data with Excel's Text to Columns Feature 2:00
  • Do More with Your Sales Data with Excel's Text to Columns Feature
  • Create Easily Printable Excel Documents 1:06
  • How to Wrap Text in Excel and Adjust a Cell's Size 0:43
  • Insert Hyperlinks into Excel Spreadsheets 1:16
  • Using Excel's Freeze Panes to Handle Large Datasets 1:12
  • Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do 0:42
  • A Quick Introduction to Excel's Pivot Tables 2:17
Chương 4 Microsoft Excel - Best Practices That Will Make a Difference
  • Initial Formatting Is Key for Creating Professional-looking Spreadsheets 1:58
  • Macros Are a Great Timesaver! Here's Why. 3:00
  • How to Use the Same Macro On Multiple Workbooks 1:34
  • Macros Are a Great Timesaver! Here's Why.
  • The Secret to Faster Scrolling in Excel 1:36
  • Be even quicker: F5 + Enter 1:50
  • FAQ: F5 + Enter didn't work for me
  • The Secret to Faster Scrolling in Excel
  • Using Absolute and Relative Cell References 2:13
  • Using Absolute and Relative Cell References
  • Find and Select Cells That Meet Specific Conditions 1:38
  • Find and Select Cells That Meet Specific Conditions
  • How to Create Dynamic Names in Excel Spreadsheets 1:21
  • How to Create Dynamic Names in Excel Spreadsheets
  • Using Named Ranges to Make Formulas More Readable 1:34
  • Introduction to Custom Formatting in Excel 6:14
  • Custom Number Formatting 1:34
  • How to Add a Drop-down List in Excel 1:49
  • Using Custom-sort to Sort Multiple Columns Within a Table 1:24
  • Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts 4:58
  • Multiply by 1 1:34
  • Find and Replace - References 3:03
  • FAQ: Why Do We Replace External References and How Does This Help Us?
  • Find and Replace - Formatting 1:53
  • Green References 1:31
  • Beauty Saving - The Professional Way of Saving Files 2:13
  • The Power of F2 1:50
  • Conditional Formatting 5:40
  • Quiz Number 1
Chương 5 Microsoft Excel - Beginner, Intermediate & Advanced Functions
  • Key Excel Functions: IF 2:35
  • Enlarge the Formula Bar 1:03
  • Key Excel Functions: SUM, SUMIF, SUMIFS 4:20
  • A Helpful Consideration
  • Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS 3:59
  • Key Excel Functions: AVERAGE & AVERAGEIF 1:55
  • Key Excel Functions: Average & Averageif
  • Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, & 4:26
  • Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
  • Working with Text in Excel 2:40
  • Find the Highest and Lowest Values in a Range: Max & Min 0:49
  • = and + are Interchangeable When You Start Typing a Formula 0:44
  • Use ROUND in Your Financial Models 0:59
  • Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy 7:30
  • INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP 7:15
  • INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
  • XLOOKUP: a Solid Substitute of VLOOKUP (Office 365 only) 6:39
  • Using Excel's IFERROR Function to Trap Spreadsheet Errors 1:45
  • A Useful Tool for Financial Analysis - The RANK Function 2:36
  • Create Flexible Financial Models with CHOOSE 2:18
  • Goal Seek Will Help You Find the Result You Are Looking For 2:12
  • Goal Seek Will Help You Find the Result You Are Looking For
  • Perform Sensitivity Analysis with Excel's Data Tables Functionality 4:06
  • Perform Sensitivity Analysis with Excel's Data Tables Functionality
  • Quiz Number 2
Chương 6 Microsoft Excel - Financial Functions in Excel
  • Discounting Cash Flows in Microsoft Excel 7:02
  • Calculating Internal Rate of Return (IRR) in Excel 3:30
  • Using the PMT Function to Create a Complete Loan Schedule 6:16
  • Date Functions in Excel 5:38
Chương 7 Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
  • Understand Your Data Source Before You Start Working on It 2:40
  • Ordering the Source Worksheet 2:12
  • Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It 2:05
  • Learn How to Create a Database 2:11
  • Using Lookup Functions (VLOOKUP) to Fill the Database Sheet 6:07
  • Using SUMIF to Complete the Database Sheet 4:41
  • FAQ: Why Net income should be 0?
  • Using INDEX & MATCH as a Substitute for VLOOKUP 4:09
  • XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH 3:20
  • The Mapping Exercise 2:20
  • Mapping the Rows in the Database Sheet 6:02
  • Building the Structure of the P&L Sheet 2:24
  • A Practical Example of Professional Formatting in Excel 3:14
  • Populating the P&L Sheet with SUMIF 2:55
  • Learn How to Find Mistakes with COUNTIF 2:41
  • Calculating Growth Rates in Excel 3:57
  • Quiz Number 3
Chương 8 Practical Exercise - SUMIFS
  • Practical Exercise - SUMIFS 8:05
Chương 9 Microsoft Excel - Building Professional Charts in Excel
  • Introduction to Excel Charts 1:11
  • Beginner's Guide to Inserting Charts in Excel 2:10
  • Modifying Excel Charts - The Easy Way 2:29
  • Making Your Excel Charts Sexier - Proven Tips 3:09
  • Creating a Bridge Chart - As Easy as It Gets 1:42
  • New Ways to Visualize Your Data - Treemap Charts 1:31
  • How to Represent Trends with Sparklines 3:52
Chương 10 Microsoft Excel - Creating Complete Professional Charts from Scratch
  • Introduction 0:29
  • Stacked Column Chart with a Secondary Axis 5:30
  • Doughnut Chart 4:58
  • Area Chart 3:33
  • Bridge Chart 6:51
Chương 11 Microsoft Excel - Working with Pivot Tables in Excel
  • Pivot Tables - Excel's Dynamic and Interactive Tables 1:35
  • Creating a Pivot Table: Choosing Row and Column Parameters 3:30
  • Design the Layout and Format of Your Pivot Tables 1:57
  • Additional Techniques That Will Ease Your Work with Pivot Tables 4:16
  • One of the Most Useful Excel Functions - GETPIVOTDATA 3:28
  • Welcome to the Future - Pivot Table Slicers 4:03
  • Introduction to the Course Challenge 1:04
  • COURSE CHALLENGE - Part 1 1:26
Chương 12 Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting
  • Introduction to the Case Study 2:09
  • Working with an SAP Data Extraction 3:23
  • Preliminary Mapping of the Data Extraction 2:10
  • Creating an Output Structure of the FMCG Model 2:29
  • Improving the Layout and Appearance of the FMCG Report 3:59
  • Inserting Formulas and Automating Calculations 2:30
  • Creating a Master Pivot Table: The Main Data Source for the FMCG Report 1:55
  • GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table 5:45
  • GETPIVOTDATA Fix 1:16
  • FAQ: My GETPIVOTDATA Function Doesn't Work
  • Combining Slicers and GETPIVOTDATA: The Key to Our Success 3:20
  • Getting Fancy with Excel Slicers 3:12
  • This is How the Report Can be Used in Practice by High-level Executives 3:59
Chương 13 Modeling in Excel - Building a Complete 3-statement Model
  • Introduction to the Exercise 3:15
  • Let's Create a Mapping of Financials 2:49
  • Building an Output P&L Sheet 4:07
  • Filling in the Output P&L Sheet with Historical Financials 2:57
  • Calculating Percentage Variances and Applying Conditional Formatting 3:14
  • Building an Output Balance Sheet 3:54
  • Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet 5:10
  • Adding the Forecast Period 4:05
Chương 14 Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios
  • Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios 5:06
  • Building a Flexible Model with CHOOSE & MATCH 1:44
  • Building a Flexible Model with VLOOKUP & COLUMNS 3:22
  • Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities % 5:08
  • Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities 3:16
Chương 15 Modeling in Excel - We Are Almost There! Completing the 3-Statement Model
  • Building a Fixed Asset Roll Forward 5:17
  • Building a Financial Liabilities Schedule 6:24
  • Building an Equity Schedule 4:28
  • Preparing a Cash Flow Structure 2:16
  • Calculating Cash Flows and Completing the Model 6:47
Chương 16 Accounting - Introduction to Accounting & Bookkeeping
  • Accounting: The Science Behind Financial Figures 1:30
  • What is Accounting and Why Do You Need It 5:24
  • The Importance of Bookkeeping - Good Accounting Records Are Essential 2:33
  • An Introduction to Financial Accounting 2:24
  • Quiz Number 3
Chương 17 Accounting - Types of Revenues, Costs, Assets, and Liabilities
  • The Different Types of Accounting Standards 2:36
  • The Three Financial Statements 2:07
  • Types of Revenues 6:37
  • Types of Revenues - Exercise 1:47
  • Types of Expenses 5:24
  • Income Taxes 1:48
  • Depreciation & Amortization 4:35
  • The Two Types of Income Statement Formats 1:15
  • Balance Sheet Items 4:18
  • Asset Categories - Practical Example 3:20
  • Liability Categories - Practical Example 3:19
  • Equity 1:55
  • Equity Categories - Practical Example 4:41
  • Quiz Number 4
Chương 18 Accounting - Revenue Recognition
  • Accrual Accounting 6:15
  • Revenue Recognition Criteria - Technical 3:43
  • Potential Conflicts of Interest When Recognizing Revenue 1:55
  • A Practical Example 5:20
  • FAQ: Doubts Regarding Calculation
Chương 19 Accounting - Cost Recognition
  • Cost recognition principles 2:29
  • Technical Aspects of Cost Recognition 3:12
Chương 20 Accounting - Understanding the Big Picture: Why, What, When, and How Much
  • The Revenue Recognition Principle - Why Is It So Important? 2:34
  • The Expense Recognition Principle - When to Recognize Expenses 2:29
  • Historical Cost vs. Fair Value Accounting 2:23
Chương 21 Accounting - The Core Principles of Accounting
  • The Accounting Equation and Its Importance 1:56
  • Elements of the Accounting System: General Ledger 1:39
  • T-Accounts: The Best Way to Understand Debits and Credits 4:13
  • P&L T-Accounts 2:46
  • The Double-Entry Principle - The Core Principle of Bookkeeping 5:02
  • Quiz Number 5
Chương 22 Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand
  • Case Study - The Accounting Transactions of a Lemonade Stand (1/4) 10:20
  • Case Study - The Accounting Transactions of a Lemonade Stand (2/4) 7:41
  • Case Study - The Accounting Transactions of a Lemonade Stand (3/4) 7:24
  • Case Study - The Accounting Transactions of a Lemonade Stand (4/4) 8:45
Chương 23 Accounting - The Importance of Timing
  • Timing of Cash Flows and Why It Plays an Important Role in a Business 1:08
  • Timing of Income: Principles of Revenue Recognition 5:34
  • Timing of Expenses: Principles of Cost Recognition 3:12
  • Quiz Number 6
Chương 24 Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis
  • Calculating Cash Flows - Understand If a Business Makes or Burns Cash 2:38
  • The Three Parts of Cash Flow Statements Explained 2:11
  • Cash Flow Computations - The Direct Method 2:10
  • Cash Flow Computations - The Indirect Method 3:32
  • Calculating Cash Flow in Practice: A Complete Example 7:31
  • FAQ: Why D&A Has Been Added in Capex?
Chương 25 Advanced Accounting - Trade Receivables
  • Why a Company Needs to Pay Attention to Trade Receivables? 2:33
  • What If Clients Do Not Pay on Time? 3:11
  • How to Handle Non-paying Customers? A Case-study 2:39
  • A Technique to Collect Trade Receivables Sooner 1:47
Chương 26 Advanced Accounting - Inventory
  • The Different Types of Inventory We Can Have 2:37
  • The Connection Between Cost of Goods Sold and Inventory 2:34
  • Cost Flow Methods 4:21
  • Cost Flow Methods - a Practical Exercise 0:55
  • FAQ: How to Apply the Weighted Average Cost Method?
Chương 27 Advanced Accounting - Fixed Assets
  • The Different Types of Fixed Assets 3:08
  • Capitalizing Interest Expenses 2:00
  • Fair Value Accounting 2:26
  • Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life 4:12
  • The Revaluation Model 5:13
  • The Revaluation Model - Practical Exercise 5:19
  • Intangible Assets Created Internally 2:16
Chương 28 Advanced Accounting - Trade Payables
  • How We Account for Trade Payables 2:51
  • What Is the Difference Between Accounts Payable and Notes Payable? 1:26
  • Why Use E-invoicing? 3:07
Chương 29 Advanced Accounting - Financial Liabilities
  • The Difference Between Debt and Equity 2:24
  • Amortizing a Loan 3:04
  • Debt Covenants 3:23
  • Debt Covenants - A Practical Example 1:48
Chương 30 Advanced Accounting - Leasing Liabilties
  • The Reason Companies Lease Assets 1:19
  • Solving a Complete Leasing Exercise 7:07
Chương 31 Advanced Accounting - Using Leverage
  • What is Leverage and Why Companies Use Financial Leverage? 4:23
  • The Implications of Using Excessive Leverage 3:17
Chương 32 Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments
  • The Different Types of Equity 4:13
  • Raising Equity in Different Stages of a Company's Lifecycle 5:55
  • The Types of Dividends Companies Pay to Shareholders 3:38
  • Dividend Payments - a Timeline 3:05
  • What Are Share Repurchases and Why Companies Do Them 3:11
  • The Idea Behind Stock Splits 3:04
Chương 33 Assessment - Accounting
  • Assessment - Accounting
Chương 34 Financial Statement Analysis - An Introduction
  • What is a 10-K Report and Why Is It important for Investors? 2:21
  • Finding, Downloading and Going Through the Annual Report of P&G 6:05
  • What Is the Role of Auditing Firms and What Are the Benefits of an Audit? 2:27
  • Indispensable Tools for Financial Statement Analysis 2:07
  • Quiz Number 7
Chương 35 Financial Statement Analysis - Subtleties
  • Financial Statement Analysis - A Natural Continuation of Financial Accounting 1:48
  • First Steps in Financial Statement Analysis 2:43
  • Horizontal vs. Vertical Financial Statement Analysis 3:33
  • Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO) 2:05
  • Using Accounting Ratios to Assess Business Performance 8:21
  • Quiz Number 8
Chương 36 Financial Statement Analysis - Practical Case Study "Analyzing P&G's Financials"
  • Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2) 6:38
  • Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2) 4:55
  • COURSE CHALLENGE - Part 2 1:42
Chương 37 Financial Statement Analysis - Tesla Exercise
  • What You Will See Next In This Section 1:02
  • How to Download Tesla's Historical Financials 2:37
  • Calculating and Analyzing Growth and Profitability Ratios 10:38
  • Calculating and Analyzing Liquidity Ratios 6:23
  • Calculating and Analyzing Solvency Ratios 2:22
Chương 38 Working Capital Management
  • Introduction 2:53
  • The Importance of Working Capital Optimization: Case Study 8:56
  • Overtrading vs. Excessive Investment 3:30
  • Trade Receivables Management 8:31
  • Re-order Level 3:20
  • Economic Order Quantity (EOQ) 4:05
  • Inventory Optimization Techniques 4:41
  • Trade Payables Management 1:57
  • Working Capital Optimization - a Roadmap 5:07
  • Symptoms of Inefficient Working Capital - Trade Payables 2:03
  • Symptoms of Inefficient Working Capital - Trade Receivables 1:51
Chương 39 Fundamentals of Business & Financial Analysis
  • Fundamentals of Business & Financial Analysis
Chương 40 Business Analysis in Excel
  • Trend analysis - theory
  • Trend analysis 8:22
  • Comparative analysis - theory
  • Comparative analysis 4:48
  • Value-based analysis - theory
  • Value-based analysis 5:00
  • Correlation analysis - theory
  • Correlation analysis 3:41
  • Time series analysis - theory
  • Time series analysis 7:59
  • Regression analysis - theory
  • Regression analysis 5:08
Chương 41 Finance 101 - The Time Value of Money and Interest Rate Components
  • Finance 101: Important Financial Principles That You Will Need 0:44
  • Understanding the Time Value of Money 1:29
  • How Interest Rates Play an Important Role in the Economy? 1:27
  • The Components Forming Interest Rates in Real Life 2:59
  • What Is Libor and What Purpose Does It Serve? 1:07
  • The Difference Between Fixed and Variable Interest Rates 1:58
  • What Is Default Risk and How Does a Bank Account For It? 6:39
  • Corporate Loan Specifics 1:42
Chương 42 Finance 101 - The Value of Cash Flows with Different Timing
  • Calculating the Present Value of Future Cash Flows 5:11
  • A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value 4:00
Chương 43 Finance 101 - Loan Calculations
  • Using Annuities 3:18
  • Calculating a Complete Loan Schedule 6:32
  • COURSE CHALLENGE - Part 3 1:17
Chương 44 Capital Budgeting - Basic Notions
  • What is Capital Budgeting? 1:14
  • When Do We Use Capital Budgeting? 1:57
  • The Time Value of Money in a Capital Budgeting Setting 2:03
  • Calculating Present and Future Value 5:16
  • Cost of Equity 5:56
  • Project-specific Beta 2:53
  • The Weighted Average Cost of Capital (WACC) 1:48
  • The Different Cash Flow Types in a Capital Budgeting Exercise 2:57
  • Modeling Future Cash Flows 5:16
Chương 45 Capital Budgeting - A Complete Case Study
  • An Introduction to the Case Study 2:22
  • Organizing Inputs In the "Drivers" Sheet 4:57
  • Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam 3:22
  • Preparing a Fixed Asset Rollforward Schedule 4:17
  • Calculating the Cash Impact of Extra Working Capital Required 2:16
  • Debt Repayment and Interest Expenses Calculation 2:39
  • The Project's P&L Sheet 1:35
  • The Project's Cash Flow Calculation 2:56
  • Calculating WACC (Weighted Average Cost of Capital) 2:27
  • Estimating Cost of Equity 5:48
  • Discounting Project Cash Flows 3:05
  • Performing Sensitivity Analysis and Wrapping Up the Case Study 4:37
  • FAQ: Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet
Chương 46 Tesla Practical Case Study - Building a Financial Planning Model
  • Organizing External Inputs in a 'Drivers' Sheet 3:55
  • Forecasting Tesla's Expected Deliveries 13:22
  • Comparing Delivery Figures with the Ones of industry Peers 3:15
  • Estimating an Average Selling Price of Tesla Vehicles 4:47
  • Calculating Automotive Revenue 4:07
  • Peer Comparison: Gross Profit % 4:51
  • Calculating Automotive Gross Profit 2:40
  • Calculating Automotive Cost of Sales 1:45
  • Forecasting 'Energy' and 'Services' Revenue 2:27
  • Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales 2:46
  • Forecasting Operating Expenses 4:35
  • Building a Fixed Asset Roll Forward: PP&E 4:06
  • Building a Fixed Asset Roll Forward: Estimating Capex 4:08
  • Building a Fixed Asset Roll Forward: D&A Schedule 3:22
  • Calculating DSO, DIO, DPO 1:57
  • Producing a Clean P&L Output Sheet 1:25
  • Calculating Investments in Working Capital 1:53
  • Forecasting Unlevered Free Cash Flow 3:07
  • Forecasting Other Assets 4:27
  • Forecasting Other Liabilities 2:07
  • Completing Unlevered Free Cash Flow 6:01
  • Modeling Tesla's Financing Needs in the Forecast Period 4:38
  • Calculating Net Income 1:15
  • Bridging Unlevered Free Cash Flow to Net Cash Flow 3:25
  • Balancing the Balance Sheet 0:56
Chương 47 Data Analysis with ChatGPT - Intro
  • How ChatGPT Advanced Data Analysis Will Boost Your Productivity 2:06
  • The Limitations of ChatGPT Advanced Data Analysis 3:13
Chương 48 Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)
  • Exploratory Data Analysis - Intro 3:47
  • Extracting Descriptive Statistics with ChatGPT 2:13
  • Identifying Outliers 2:46
  • Correlation Analysis: Hypothesis Formulation and Feature Ideas 1:59
  • Crafting a Comprehensive EDA Prompt 9:03
Chương 49 Data Analysis with ChatGPT - Deal with Inconsistent Data
  • Identifying and Handling Erroneous Data 3:19
  • Verifying Data for Errors 3:40
  • Eliminating Duplicate Rows 1:20
  • Addressing Unit Discrepancies in Data 1:51
  • Dividing Cell Content into Multiple Cells 4:18
Chương 50 Data Analysis with ChatGPT - Organize Messy Data
  • Organize Messy Data 3:51
  • Data Mapping 2:50
  • Effective Data Classification 2:16
  • Order Data with ChatGPT 2:11
Chương 51 Data Analysis with ChatGPT - Working with Functions
  • COUNTIFS, SUMIFS 2:33
  • Data Lookup 2:47
  • Data Ranking 2:49
  • Fill Until Non-blank Values 2:59
  • Translating Logic into Excel Formulas with ChatGPT 2:06
Chương 52 Data Analysis with ChatGPT - Clean Text Data
  • Correcting Inverted Names 1:43
  • Dealing with Trailing and Leading Spaces in Text Data 1:55
  • Standardizing Letter Capitalization 1:50
  • Handling Multi-lingual Text Data 3:27
  • Multiple "Find and Replace" at the Same Time with ChatGPT 2:35
  • Criteria-based Duplicate Removal 2:31
  • Removing Duplicates Across Multiple Columns 1:58
Chương 53 Data Analysis with ChatGPT - Dates and Time Data
  • Obtain Day and Month From Date 2:37
  • Converting Hours to Decimals 1:40
  • Obtaining Age in Years, Months, Days 1:24
  • Order Dates Chronologically 1:32
Chương 54 Data Analysis with ChatGPT - Complete Practical Example
  • Intro to the Exercise and Preprocessing Ideas from ChatGPT 4:37
  • Preprocessing the 'Free plan users' Sheet (1/2) 7:18
  • Preprocessing the 'Free plan users' Sheet (2/2) 3:33
  • Working on the 'Transactions' Sheet 5:43
  • Dealing with the Country Mapping Issue 2:52
Chương 55 PowerPoint - Introduction to PowerPoint
  • Microsoft PowerPoint: The Most Popular Presentation Software for the Office 0:51
  • The Structure of the PowerPoint Ribbon 5:10
  • General Considerations About Slide Structure 3:52
  • Learn How to Insert Objects in PowerPoint 3:58
  • Shortcuts Allow Us To Be Much Faster When Working in PowerPoint 2:29
  • Add Frequently Used Buttons to the Quick Access Toolbar 3:10
  • How to Easily Align Objects in PowerPoint 3:49
  • How to Edit Shapes in Your Presentation 4:52
  • How to Format Text Boxes in a PowerPoint Presentation 3:47
  • Practical Learning - Exercise 1 3:57
  • Changing an Object's Size and Rotation 1:41
  • Using Slide Masters 3:59
  • Bring to Front and Send to Back - An Important PowerPoint Technique 2:53
  • Learn How to Create, Edit, Resize and Format PowerPoint Tables 5:00
Chương 56 PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User
  • An Introduction to PowerPoint Animations 2:58
  • Modifying the Beginning and Ending of a Line Object 1:47
  • Join Shapes Together By Using Connector Lines 4:11
  • Edit Points - Learn How to Customize PowerPoint Shapes 1:44
  • Group or Ungroup Shapes, Pictures or Other Objects 1:43
  • This is How You Can Fit Text When It Is Larger Than a Shape 1:57
  • Nudge Objects 0:57
  • PowerPoint's Smart Art Feature Offers Great Return for Your Time 3:27
  • Creating Eye-Catching Text Effects in PowerPoint 1:56
  • Practical Exercise - Creating an Organisational Chart 7:37
  • COURSE CHALLENGE - Part 4 2:34
Chương 57 Who Does What in the World of Finance?
  • Who Does What in the World of Finance? 1:01:03
Chương 58 Next Steps
  • Next Steps

Requirment

  • No experience is required. Start from the basics and progressively build your knowledge.

  • You will need Microsoft Excel 2010, 2013, 2016, 2020, or Excel 365

  • You will need Microsoft PowerPoint 2010, 2013, 2016, 2020, or PowerPoint 365

Outcomes

  • Work comfortably with Microsoft Excel

  • Format spreadsheets professionally

  • Perform routine tasks quicker

  • Create professional charts in Microsoft Excel

  • Efficiently work with vast amounts of data

  • Understand accounting and bookkeeping principles

  • Build a company’s P&L from scratch

  • Create a company’s balance sheet

  • Perform Financial statement analysis

  • Understand the timing of revenue and cost recognition

  • Calculate liquidity, solvency, profitability, and growth ratios to analyze a company’s performance

  • Understand 10-K reports

  • Assess whether a project is feasible via the net present value (NPV) technique

  • Calculate a complete loan schedule

  • Know the difference between variable and fixed interest rates

  • Perform industry analysis

  • Realize 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 – if you follow the course entirely!

Instructor

...
365 Careers

0.0

  • ... 0 Student
  • ... 9 Courses
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all