Mô tả

* Updated for May 2023! *

"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.

Bạn sẽ học được gì

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!

Yêu cầu

  • 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

Nội dung khoá học

58 sections

Welcome! Course Introduction

4 lectures
What Does the Course Cover?
07:16
Everything We Will Learn Has a Practical Application
03:27
The Best Way to Take This Course
03:11
Download All Course Materials and FAQ
02:18

Microsoft Excel - Quick Introduction

14 lectures
Microsoft Excel: The World's #1 Office Software
01:00
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
03:32
Data Entry Techniques in Excel
03:00
How to Make Your Spreadsheets Look Professional
05:49
Data Entry Techniques in Excel
1 question
Inserting, Deleting, and Modifying Rows & Columns
01:44
Inserting, Deleting, and Modifying Rows & Columns
1 question
Excel Formulas for Beginners
02:54
Excel Formulas for Beginners
1 question
A Beginner's Introduction to Excel Functions
03:41
Format Cells
05:24
Work Efficiently by Using Cut, Copy, and Paste
02:10
Work Efficiently by Using Cut, Copy, and Paste
1 question
Pasting Values, Formulas and Formats with Paste Special
01:16

Microsoft Excel - Useful Tools

9 lectures
Inserting a Line Break with Alt + Enter
00:54
Do More with Your Sales Data with Excel's Text to Columns Feature
01:52
Do More with Your Sales Data with Excel's Text to Columns Feature
1 question
Create Easily Printable Excel Documents
01:12
How to Wrap Text in Excel and Adjust a Cell's Size
00:43
Insert Hyperlinks into Excel Spreadsheets
01:16
Using Excel's Freeze Panes to Handle Large Datasets
01:12
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
00:46
A Quick Introduction to Excel's Pivot Tables
02:17

Microsoft Excel - Best Practices That Will Make a Difference

29 lectures
Initial Formatting Is Key for Creating Professional-looking Spreadsheets
02:05
Macros Are a Great Timesaver! Here's Why.
03:04
How to Use the Same Macro On Multiple Workbooks
01:34
Macros Are a Great Timesaver! Here's Why.
1 question
The Secret to Faster Scrolling in Excel
01:36
Be even quicker: F5 + Enter
01:50
FAQ: F5 + Enter didn't work for me
00:13
The Secret to Faster Scrolling in Excel
1 question
Using Absolute and Relative Cell References
02:20
Using Absolute and Relative Cell References
1 question
Find and Select Cells That Meet Specific Conditions
01:30
Find and Select Cells That Meet Specific Conditions
1 question
How to Create Dynamic Names in Excel Spreadsheets
01:27
How to Create Dynamic Names in Excel Spreadsheets
1 question
Using Named Ranges to Make Formulas More Readable
01:34
Introduction to Custom Formatting in Excel
06:14
Custom Number Formatting
01:34
How to Add a Drop-down List in Excel
01:49
Using Custom-sort to Sort Multiple Columns Within a Table
01:28
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
04:15
Multiply by 1
01:34
Find and Replace - References
03:03
FAQ: Why Do We Replace External References and How Does This Help Us?
00:24
Find and Replace - Formatting
01:53
Green References
01:31
Beauty Saving - The Professional Way of Saving Files
02:13
The Power of F2
01:50
Conditional Formatting
05:40
Quiz Number 1
5 questions

Microsoft Excel - Beginner, Intermediate & Advanced Functions

25 lectures
Key Excel Functions: IF
02:35
Enlarge the Formula Bar
01:03
Key Excel Functions: SUM, SUMIF, SUMIFS
04:20
A Helpful Consideration
00:45
Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
04:06
Key Excel Functions: AVERAGE & AVERAGEIF
01:59
Key Excel Functions: Average & Averageif
1 question
Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
04:29
Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
1 question
Working with Text in Excel
02:40
Find the Highest and Lowest Values in a Range: Max & Min
00:52
= and + are Interchangeable When You Start Typing a Formula
00:44
Use ROUND in Your Financial Models
01:01
Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy
07:43
INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
07:27
INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
1 question
XLOOKUP: a Solid Substitute of VLOOKUP (Office 365 only)
06:40
Using Excel's IFERROR Function to Trap Spreadsheet Errors
01:43
A Useful Tool for Financial Analysis - The RANK Function
02:36
Create Flexible Financial Models with CHOOSE
02:24
Goal Seek Will Help You Find the Result You Are Looking For
02:17
Goal Seek Will Help You Find the Result You Are Looking For
1 question
Perform Sensitivity Analysis with Excel's Data Tables Functionality
04:10
Perform Sensitivity Analysis with Excel's Data Tables Functionality
1 question
Quiz Number 2
5 questions

Microsoft Excel - Financial Functions in Excel

4 lectures
Discounting Cash Flows in Microsoft Excel
07:02
Calculating Internal Rate of Return (IRR) in Excel
03:30
Using the PMT Function to Create a Complete Loan Schedule
06:16
Date Functions in Excel
05:38

Microsoft Excel - Practical Exercise "Build a P&L From Scratch"

19 lectures
Introduction to the Case Study
00:50
What You Will See Next
01:06
Understand Your Data Source Before You Start Working on It
02:42
Ordering the Source Worksheet
02:16
Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It
01:59
Learn How to Create a Database
01:58
Using Lookup Functions (VLOOKUP) to Fill the Database Sheet
05:29
Using SUMIF to Complete the Database Sheet
04:06
FAQ: Why Net income should be 0?
00:48
Using INDEX & MATCH as a Substitute for VLOOKUP
03:51
XLOOKUP as a Substitute for VLOOKUP and INDEX&MATCH
02:53
The Mapping Exercise
01:41
Mapping the Rows in the Database Sheet
06:15
Building the Structure of the P&L Sheet
02:21
A Practical Example of Professional Formatting in Excel
03:17
Populating the P&L Sheet with SUMIF
02:47
Learn How to Find Mistakes with COUNTIF
02:14
Calculating Growth Rates in Excel
03:08
Quiz Number 3
3 questions

Practical Exercise - SUMIFS

1 lectures
Practical Exercise - SUMIFS
08:05

Microsoft Excel - Building Professional Charts in Excel

7 lectures
Introduction to Excel Charts
01:11
Beginner's Guide to Inserting Charts in Excel
02:10
Modifying Excel Charts - The Easy Way
02:29
Making Your Excel Charts Sexier - Proven Tips
03:09
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
01:42
New Ways to Visualize Your Data - Treemap Charts
01:31
How to Represent Trends with Sparklines
03:52

Microsoft Excel - Creating Complete Professional Charts from Scratch

5 lectures
Introduction
00:29
Stacked Column Chart with a Secondary Axis
05:30
Doughnut Chart
04:58
Area Chart
03:33
Bridge Chart
06:51

Microsoft Excel - Working with Pivot Tables in Excel

8 lectures
Pivot Tables - Excel's Dynamic and Interactive Tables
01:35
Creating a Pivot Table: Choosing Row and Column Parameters
03:30
Design the Layout and Format of Your Pivot Tables
01:57
Additional Techniques That Will Ease Your Work with Pivot Tables
04:16
One of the Most Useful Excel Functions - GETPIVOTDATA
03:28
Welcome to the Future - Pivot Table Slicers
04:03
Introduction to the Course Challenge
01:04
COURSE CHALLENGE - Part 1
01:26

Microsoft Excel - Pivot Tables & Slicers - World-Class Financial Reporting

13 lectures
Introduction to the Case Study
02:09
Working with an SAP Data Extraction
03:23
Preliminary Mapping of the Data Extraction
02:10
Creating an Output Structure of the FMCG Model
02:29
Improving the Layout and Appearance of the FMCG Report
03:59
Inserting Formulas and Automating Calculations
02:30
Creating a Master Pivot Table: The Main Data Source for the FMCG Report
01:55
GETPIVOTDATA is Great! Extracting Data from the Master Pivot Table
05:45
GETPIVOTDATA Fix
01:16
FAQ: My GETPIVOTDATA Function Doesn't Work
00:14
Combining Slicers and GETPIVOTDATA: The Key to Our Success
03:20
Getting Fancy with Excel Slicers
03:12
This is How the Report Can be Used in Practice by High-level Executives
03:59

Modeling in Excel - Building a Complete 3-statement Model

8 lectures
Introduction to the Exercise
03:15
Let's Create a Mapping of Financials
02:49
Building an Output P&L Sheet
04:07
Filling in the Output P&L Sheet with Historical Financials
02:57
Calculating Percentage Variances and Applying Conditional Formatting
03:14
Building an Output Balance Sheet
03:54
Using INDEX, MATCH, MATCH to Fill in the Output Balance Sheet
05:10
Adding the Forecast Period
04:05

Modeling in Excel - Let's Build a Flexible Model with Multiple Scenarios

5 lectures
Calculating Historical Percentage Ratios and Use OFFSET and MATCH for Scenarios
05:06
Building a Flexible Model with CHOOSE & MATCH
01:44
Building a Flexible Model with VLOOKUP & COLUMNS
03:22
Calculating Historical DSO, DPO, DIO, Other Assets %, and Other Liabilities %
05:08
Forecasting DSO, DPO, DIO, Other Assets and Other Liabilities
03:16

Modeling in Excel - We Are Almost There! Completing the 3-Statement Model

5 lectures
Building a Fixed Asset Roll Forward
05:17
Building a Financial Liabilities Schedule
06:24
Building an Equity Schedule
04:28
Preparing a Cash Flow Structure
02:16
Calculating Cash Flows and Completing the Model
06:47

Accounting - Introduction to Accounting & Bookkeeping

5 lectures
Accounting: The Science Behind Financial Figures
01:30
What is Accounting and Why Do You Need It
05:24
The Importance of Bookkeeping - Good Accounting Records Are Essential
02:33
An Introduction to Financial Accounting
02:24
Quiz Number 3
2 questions

Accounting - Types of Revenues, Costs, Assets, and Liabilities

14 lectures
The Different Types of Accounting Standards
02:36
The Three Financial Statements
02:07
Types of Revenues
06:37
Types of Revenues - Exercise
01:47
Types of Expenses
05:24
Income Taxes
01:48
Depreciation & Amortization
04:35
The Two Types of Income Statement Formats
01:15
Balance Sheet Items
04:18
Asset Categories - Practical Example
03:20
Liability Categories - Practical Example
03:19
Equity
01:55
Equity Categories - Practical Example
04:41
Quiz Number 4
3 questions

Accounting - Revenue Recognition

5 lectures
Accrual Accounting
06:15
Revenue Recognition Criteria - Technical
03:43
Potential Conflicts of Interest When Recognizing Revenue
01:55
A Practical Example
05:20
FAQ: Doubts Regarding Calculation
00:26

Accounting - Cost Recognition

2 lectures
Cost recognition principles
02:29
Technical Aspects of Cost Recognition
03:12

Accounting - Understanding the Big Picture: Why, What, When, and How Much

3 lectures
The Revenue Recognition Principle - Why Is It So Important?
02:34
The Expense Recognition Principle - When to Recognize Expenses
02:29
Historical Cost vs. Fair Value Accounting
02:23

Accounting - The Core Principles of Accounting

6 lectures
The Accounting Equation and Its Importance
01:56
Elements of the Accounting System: General Ledger
01:39
T-Accounts: The Best Way to Understand Debits and Credits
04:13
P&L T-Accounts
02:46
The Double-Entry Principle - The Core Principle of Bookkeeping
05:02
Quiz Number 5
4 questions

Accounting - Practical Exercise: The Accounting Transactions of a Lemonade Stand

4 lectures
Case Study - The Accounting Transactions of a Lemonade Stand (1/4)
10:15
Case Study - The Accounting Transactions of a Lemonade Stand (2/4)
07:39
Case Study - The Accounting Transactions of a Lemonade Stand (3/4)
07:21
Case Study - The Accounting Transactions of a Lemonade Stand (4/4)
08:08

Accounting - The Importance of Timing

4 lectures
Timing of Cash Flows and Why It Plays an Important Role in a Business
01:08
Timing of Income: Principles of Revenue Recognition
05:34
Timing of Expenses: Principles of Cost Recognition
03:12
Quiz Number 6
3 questions

Accounting - Preparing a Cash Flow Statement: Understanding Cash Flow Analysis

6 lectures
Calculating Cash Flows - Understand If a Business Makes or Burns Cash
02:38
The Three Parts of Cash Flow Statements Explained
02:11
Cash Flow Computations - The Direct Method
02:10
Cash Flow Computations - The Indirect Method
03:32
Calculating Cash Flow in Practice: A Complete Example
07:31
FAQ: Why D&A Has Been Added in Capex?
01:18

Advanced Accounting - Trade Receivables

4 lectures
Why a Company Needs to Pay Attention to Trade Receivables?
02:33
What If Clients Do Not Pay on Time?
03:11
How to Handle Non-paying Customers? A Case-study
02:39
A Technique to Collect Trade Receivables Sooner
01:47

Advanced Accounting - Inventory

5 lectures
The Different Types of Inventory We Can Have
02:37
The Connection Between Cost of Goods Sold and Inventory
02:34
Cost Flow Methods
04:21
Cost Flow Methods - a Practical Exercise
00:55
FAQ: How to Apply the Weighted Average Cost Method?
00:27

Advanced Accounting - Fixed Assets

7 lectures
The Different Types of Fixed Assets
03:08
Capitalizing Interest Expenses
02:00
Fair Value Accounting
02:26
Intangible Assets with Finite Life vs. Intangible Assets with Infinite Life
04:12
The Revaluation Model
05:13
The Revaluation Model - Practical Exercise
05:19
Intangible Assets Created Internally
02:16

Advanced Accounting - Trade Payables

3 lectures
How We Account for Trade Payables
02:51
What Is the Difference Between Accounts Payable and Notes Payable?
01:26
Why Use E-invoicing?
03:07

Advanced Accounting - Financial Liabilities

4 lectures
The Difference Between Debt and Equity
02:24
Amortizing a Loan
03:04
Debt Covenants
03:23
Debt Covenants - A Practical Example
01:48

Advanced Accounting - Leasing Liabilties

2 lectures
The Reason Companies Lease Assets
01:19
Solving a Complete Leasing Exercise
07:07

Advanced Accounting - Using Leverage

2 lectures
What is Leverage and Why Companies Use Financial Leverage?
04:23
The Implications of Using Excessive Leverage
03:17

Advanced Accounting - Raising Equity, Types of Equity, and Dividend Payments

6 lectures
The Different Types of Equity
04:13
Raising Equity in Different Stages of a Company's Lifecycle
05:55
The Types of Dividends Companies Pay to Shareholders
03:38
Dividend Payments - a Timeline
03:05
What Are Share Repurchases and Why Companies Do Them
03:11
The Idea Behind Stock Splits
03:04

Assessment - Accounting

1 lectures
Assessment - Accounting
10 questions

Financial Statement Analysis - An Introduction

5 lectures
What is a 10-K Report and Why Is It important for Investors?
02:21
Finding, Downloading and Going Through the Annual Report of P&G
06:13
What Is the Role of Auditing Firms and What Are the Benefits of an Audit?
02:27
Indispensable Tools for Financial Statement Analysis
02:07
Quiz Number 7
2 questions

Financial Statement Analysis - Subtleties

6 lectures
Financial Statement Analysis - A Natural Continuation of Financial Accounting
01:48
First Steps in Financial Statement Analysis
02:43
Horizontal vs. Vertical Financial Statement Analysis
03:33
Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)
02:05
Using Accounting Ratios to Assess Business Performance
08:21
Quiz Number 8
2 questions

Financial Statement Analysis - Practical Case Study "Analyzing P&G's Financials"

3 lectures
Case Study - Calculating Ratios and Analyzing P&G's Financials (1/2)
06:38
Case Study - Calculating Ratios and Analyzing P&G's Financials (2/2)
04:55
COURSE CHALLENGE - Part 2
01:42

Financial Statement Analysis - Tesla Exercise

5 lectures
What You Will See Next In This Section
01:02
How to Download Tesla's Historical Financials
02:37
Calculating and Analyzing Growth and Profitability Ratios
10:38
Calculating and Analyzing Liquidity Ratios
06:23
Calculating and Analyzing Solvency Ratios
02:22

Working Capital Management

11 lectures
Introduction
02:53
The Importance of Working Capital Optimization: Case Study
08:56
Overtrading vs. Excessive Investment
03:30
Trade Receivables Management
08:31
Re-order Level
03:20
Economic Order Quantity (EOQ)
04:05
Inventory Optimization Techniques
04:41
Trade Payables Management
01:57
Working Capital Optimization - a Roadmap
05:07
Symptoms of Inefficient Working Capital - Trade Payables
02:03
Symptoms of Inefficient Working Capital - Trade Receivables
01:51

Fundamentals of Business & Financial Analysis

1 lectures
Fundamentals of Business & Financial Analysis
41 pages

Business Analysis in Excel

12 lectures
Trend analysis - theory
01:17
Trend analysis
08:22
Comparative analysis - theory
01:46
Comparative analysis
04:48
Value-based analysis - theory
02:25
Value-based analysis
05:00
Correlation analysis - theory
02:28
Correlation analysis
03:41
Time series analysis - theory
01:21
Time series analysis
07:59
Regression analysis - theory
03:11
Regression analysis
05:08

Finance 101 - The Time Value of Money and Interest Rate Components

8 lectures
Finance 101: Important Financial Principles That You Will Need
00:44
Understanding the Time Value of Money
01:29
How Interest Rates Play an Important Role in the Economy?
01:27
The Components Forming Interest Rates in Real Life
02:59
What Is Libor and What Purpose Does It Serve?
01:07
The Difference Between Fixed and Variable Interest Rates
01:58
What Is Default Risk and How Does a Bank Account For It?
06:39
Corporate Loan Specifics
01:42

Finance 101 - The Value of Cash Flows with Different Timing

2 lectures
Calculating the Present Value of Future Cash Flows
05:11
A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value
04:00

Finance 101 - Loan Calculations

3 lectures
Using Annuities
03:18
Calculating a Complete Loan Schedule
06:32
COURSE CHALLENGE - Part 3
01:17

Capital Budgeting - Basic Notions

9 lectures
What is Capital Budgeting?
01:14
When Do We Use Capital Budgeting?
01:57
The Time Value of Money in a Capital Budgeting Setting
02:03
Calculating Present and Future Value
05:16
Cost of Equity
05:56
Project-specific Beta
02:53
The Weighted Average Cost of Capital (WACC)
01:48
The Different Cash Flow Types in a Capital Budgeting Exercise
02:57
Modeling Future Cash Flows
05:16

Capital Budgeting - A Complete Case Study

13 lectures
An Introduction to the Case Study
02:22
Organizing Inputs In the "Drivers" Sheet
04:57
Modeling Expected Savings - Building Cars In Italy vs. Building Cars In Vietnam
03:22
Preparing a Fixed Asset Rollforward Schedule
04:17
Calculating the Cash Impact of Extra Working Capital Required
02:16
Debt Repayment and Interest Expenses Calculation
02:39
The Project's P&L Sheet
01:35
The Project's Cash Flow Calculation
02:56
Calculating WACC (Weighted Average Cost of Capital)
02:27
Estimating Cost of Equity
05:48
Discounting Project Cash Flows
03:05
Performing Sensitivity Analysis and Wrapping Up the Case Study
04:37
FAQ: Data Does Not Change in the DCF Sheet, It Changes From the Drivers Sheet
00:13

Tesla Practical Case Study - Building a Financial Planning Model

25 lectures
Organizing External Inputs in a 'Drivers' Sheet
03:55
Forecasting Tesla's Expected Deliveries
13:22
Comparing Delivery Figures with the Ones of industry Peers
03:15
Estimating an Average Selling Price of Tesla Vehicles
04:47
Calculating Automotive Revenue
04:07
Peer Comparison: Gross Profit %
04:51
Calculating Automotive Gross Profit
02:40
Calculating Automotive Cost of Sales
01:45
Forecasting 'Energy' and 'Services' Revenue
02:27
Calculating 'Energy' and 'Services' Gross Profit and Cost of Sales
02:46
Forecasting Operating Expenses
04:35
Building a Fixed Asset Roll Forward: PP&E
04:06
Building a Fixed Asset Roll Forward: Estimating Capex
04:08
Building a Fixed Asset Roll Forward: D&A Schedule
03:22
Calculating DSO, DIO, DPO
01:57
Producing a Clean P&L Output Sheet
01:25
Calculating Investments in Working Capital
01:53
Forecasting Unlevered Free Cash Flow
03:07
Forecasting Other Assets
04:27
Forecasting Other Liabilities
02:07
Completing Unlevered Free Cash Flow
06:01
Modeling Tesla's Financing Needs in the Forecast Period
04:38
Calculating Net Income
01:15
Bridging Unlevered Free Cash Flow to Net Cash Flow
03:25
Balancing the Balance Sheet
00:56

Data Analysis with ChatGPT - Intro

2 lectures
How ChatGPT Advanced Data Analysis Will Boost Your Productivity
02:06
The Limitations of ChatGPT Advanced Data Analysis
03:13

Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)

5 lectures
Exploratory Data Analysis - Intro
03:47
Extracting Descriptive Statistics with ChatGPT
02:13
Identifying Outliers
02:46
Correlation Analysis: Hypothesis Formulation and Feature Ideas
01:59
Crafting a Comprehensive EDA Prompt
09:03

Data Analysis with ChatGPT - Deal with Inconsistent Data

5 lectures
Identifying and Handling Erroneous Data
03:19
Verifying Data for Errors
03:40
Eliminating Duplicate Rows
01:20
Addressing Unit Discrepancies in Data
01:51
Dividing Cell Content into Multiple Cells
04:18

Data Analysis with ChatGPT - Organize Messy Data

4 lectures
Organize Messy Data
03:51
Data Mapping
02:50
Effective Data Classification
02:16
Order Data with ChatGPT
02:11

Data Analysis with ChatGPT - Working with Functions

5 lectures
COUNTIFS, SUMIFS
02:33
Data Lookup
02:47
Data Ranking
02:49
Fill Until Non-blank Values
02:59
Translating Logic into Excel Formulas with ChatGPT
02:06

Data Analysis with ChatGPT - Clean Text Data

7 lectures
Correcting Inverted Names
01:43
Dealing with Trailing and Leading Spaces in Text Data
01:55
Standardizing Letter Capitalization
01:50
Handling Multi-lingual Text Data
03:27
Multiple "Find and Replace" at the Same Time with ChatGPT
02:35
Criteria-based Duplicate Removal
02:31
Removing Duplicates Across Multiple Columns
01:58

Data Analysis with ChatGPT - Dates and Time Data

4 lectures
Obtain Day and Month From Date
02:37
Converting Hours to Decimals
01:40
Obtaining Age in Years, Months, Days
01:24
Order Dates Chronologically
01:32

Data Analysis with ChatGPT - Complete Practical Example

5 lectures
Intro to the Exercise and Preprocessing Ideas from ChatGPT
04:37
Preprocessing the 'Free plan users' Sheet (1/2)
07:18
Preprocessing the 'Free plan users' Sheet (2/2)
03:33
Working on the 'Transactions' Sheet
05:43
Dealing with the Country Mapping Issue
02:52

PowerPoint - Introduction to PowerPoint

14 lectures
Microsoft PowerPoint: The Most Popular Presentation Software for the Office
00:51
The Structure of the PowerPoint Ribbon
05:10
General Considerations About Slide Structure
03:52
Learn How to Insert Objects in PowerPoint
03:58
Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
02:29
Add Frequently Used Buttons to the Quick Access Toolbar
03:10
How to Easily Align Objects in PowerPoint
03:49
How to Edit Shapes in Your Presentation
04:52
How to Format Text Boxes in a PowerPoint Presentation
03:47
Practical Learning - Exercise 1
03:57
Changing an Object's Size and Rotation
01:41
Using Slide Masters
03:59
Bring to Front and Send to Back - An Important PowerPoint Technique
02:53
Learn How to Create, Edit, Resize and Format PowerPoint Tables
05:00

PowerPoint - Tips & Tricks That Will Transform You Into An Advanced User

11 lectures
An Introduction to PowerPoint Animations
02:58
Modifying the Beginning and Ending of a Line Object
01:47
Join Shapes Together By Using Connector Lines
04:11
Edit Points - Learn How to Customize PowerPoint Shapes
01:44
Group or Ungroup Shapes, Pictures or Other Objects
01:43
This is How You Can Fit Text When It Is Larger Than a Shape
01:57
Nudge Objects
00:57
PowerPoint's Smart Art Feature Offers Great Return for Your Time
03:27
Creating Eye-Catching Text Effects in PowerPoint
01:56
Practical Exercise - Creating an Organisational Chart
07:37
COURSE CHALLENGE - Part 4
02:34

Who Does What in the World of Finance?

1 lectures
Who Does What in the World of Finance?
01:01:03

Next Steps

1 lectures
Next Steps
00:32

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.