Udemy – Beginner to Pro in Excel: Financial Modeling and Valuation 2020-6

Description

Beginner to Pro in Excel: Financial Modeling and Valuation, is the name of a video training package for working with Microsoft Excel software and in the field of financial modeling and evaluation. The course in front of you will teach you the necessary concepts and skills in using Excel software from the elementary level. By watching the trainings in this course, you will be able to start your work and career correctly from the beginning with financial modeling. At the end of this training course, you will become a professional and expert in working with Excel and financial modeling.

You will also be able to easily work with Excel software in other branches by watching the sessions of this course. You will get acquainted with the features of Excel software by watching the tutorials of this video course. This course will also be very suitable and efficient for those users who have a basic knowledge of Excel. Also, if you are a business and finance expert, this course will be completely useful for you.

Course features:

Basic and advanced learning of Excel skills

Familiarity with all the features of Excel software and how to work with them

Learn efficient skills in performing regular tasks

Learn how to design professional and specialized charts to see progress

Learn how to build valuation models from scratch

Learn to discover how valuable a company is

Beginner to Pro in Excel course specifications: Financial Modeling and Valuation

Publisher: Udemy

Instructor: 365 Careers

Level: Basic to Intermediate

Duration: 13:18:47

Number of lessons: 256 lessons

English language

Course topics

Course content 256 lectures 13:18:47

Beginner to Pro in Excel: Financial Modeling and Valuation – Welcome! 5 lectures 07:44

Introduction to Excel 12 lectures 33:39

Useful tips and tools for your work in Excel 30 lectures 55:53

Keyboard shortcuts in Excel 2 lectures 04:57

Excel’s key functions and functionalities made easy 21 lectures 01:00:01

Update! SUMIFS – Exercise 2 lectures 08:36

Financial functions in Excel 4 lectures 22:26

Microsoft Excel’s Pivot Tables in depth 6 lectures 20:14

Case study – Building a complete P&L from scratch in Excel 20 lectures 49:44

Introduction to Excel charts 6 lectures 14:53

P&L Case Study continued – Let’s create some great-looking professional charts 7 lectures 33:27

Case Study – Building an FMCG Model from Scratch 13 lectures 36:40

Financial modeling fundamentals 12 lectures 42:06

Introduction to Company Valuation 1 lecture 00:00

Introduction to Mergers & Acquisitions 1 lecture 00:00

Learn how to build a Discounted Cash Flow model in Excel 32 lectures 01:28:00

Tesla valuation – Complete practical exercise 32 lectures 01:53:18

Capital budgeting – The theory 9 lectures 29:20

Capital Budgeting – A complete Case study 14 lectures 41:36

Next steps 1 lecture 01:06

APPENDIX – Microsoft Excel 2010 – Introduction to Excel 9 lectures 28:33

APPENDIX – Microsoft Excel 2010 – Useful tips and tricks 16 lectures 25:53

APPENDIX – Microsoft Excel 2010 – Keyboard shortcuts 1 lecture 04:38

Requirements

Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

Changes:

The 2020/1 version has increased in size by about 1.5 GB compared to the 2018/12 version. No other information of the changes is available.

The 2020/6 version is about 1.2 GB larger than the 2020/1 version. No other details of the exact changes are available.