Excel Financial Analysis

24 casts | 5:01:47 for the total course

Data Analytics Excel Finance

Description

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.

Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

  • 1. Intro to the Course
    • Excel Financial Analysis | Intro to the Course | 1.1

      4:16

    • Excel Financial Analysis | Why Should You Learn Financial Analysis | 1.2

      4:23

    • Excel Financial Analysis | Intro of the Instructor | 1.3

      6:24

    • Excel Financial Analysis | Course Requirements | 1.4

      5:47

  • 2. Excel Statement Models
    • Excel Financial Analysis | What Will We Learn In This Section | 2.1

      2:35

    • Excel Financial Analysis | Preparing Data Source For P&I | 2.2

      16:08

    • Excel Financial Analysis | Create P&I Structure | 2.3

      13:27

    • Excel Financial Analysis | Adding Data To P&I | 2.4

      19:49

    • Excel Financial Analysis | Calculating Variances | 2.5

      11:52

    • Excel Financial Analysis | Balance Sheet Structure | 2.6

      10:43

    • Excel Financial Analysis | Adding Values On Bs From Different Files Format | 2.7

      20:38

    • Excel Financial Analysis | Cash Flow Structure | 2.8

      10:25

    • Excel Financial Analysis | Calculating Cash Flow | 2.9

      11:05

    • Excel Financial Analysis | Challenge | 2.10

      1:36

  • 3. Excel Finance Methods
    • Excel Financial Analysis | What Will We Learn In This Section | 3.1

      5:49

    • Excel Financial Analysis | Forecast With Scenarios | 3.2

      23:30

    • Excel Financial Analysis | How To Calculate Finance Main KPI's | 3.3

      15:39

    • Excel Financial Analysis | Fixed Assets Roll Forward | 3.4

      18:29

    • Excel Financial Analysis | Loan Schedule | 3.5

      13:54

    • Excel Financial Analysis | AR Management Basics | 3.6

      20:49

    • Excel Financial Analysis | Customers Rank | 3.7

      11:56

    • Excel Financial Analysis | Create Budgets Categories | 3.8

      19:46

    • Excel Financial Analysis | Challenge | 3.9

      1:25

  • 4. Summary
    • Excel Financial Analysis | Course Summary and Next Steps | 4.1

      31:22

Created By

Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more. Over 11 years, Mammoth Interactive has built a global student community with 3.3 million

US$19.98

  US$199.00

Buy Now (US$19.98) ➔

Lifetime Access
30-Day Money-Back Guarantee.

Reviews
No reviews yet