Beginner to Pro in Excel Financial Modeling and Valuation (2020)

[mitsumi]

Beginner to Pro in Excel: Financial Modeling and Valuation (2020)
WEBRip | English | MP4 | 1280 x 720 | AVC ~1433 Kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~12 hours | 6.03 GB
Genre: eLearning Video / Business, Finance
Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!

What you'll learn

Master Microsoft Excel and many of its advanced features
Become one of the top Excel users in your team
Carry out regular tasks faster than ever before
Build P&L statements from a raw data extraction
Build Cash Flow statements
Discover how to value a company
Build Valuation models from scratch
Create models with multiple scenarios
Design professional and good-looking advanced charts

Requirements

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

Description

**Updated for May 2020!**

Do you want to learn how to use Excel in a real working environment?

Are you about to graduate from university and start looking for your first job?

Are you a young professional looking to establish yourself in your new position?

Would you like to become your team's go-to person when it comes to Financial Modeling in Excel?

If you answered yes to any of these, then this is the right course for you!

Join over 85,330 successful students taking this course!

The instructor of this course has extensive experience in Financial Modeling:

Worked in the Financial advisory unit of a top-tier consulting firm

Experience in transactions carried out in Italy, Germany, Switzerland and Poland

Worked in the in-house Mergers & Acquisitions department of a large multinational corporation

Been a financial advisor in multiple M&A deals with sizes ranging from €2 million to €5 billion

Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, and more.

Learn the subtleties of Financial Modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues.

 A comprehensive guide to Financial Modeling in Excel:

Become an Excel expert

Learn how to build sound Financial Models and stand out among your colleagues

Gain an in-depth understanding of the mechanics of Company Valuation

Build your files professionally

Demonstrate superior Excel skills at work

Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career

What we offer:

Well-designed and easy-to-understand materials

Detailed explanations with comprehensible case studies based on real situations

Downloadable course materials

Regular course updates

NEW! Includes professional chart examples that are 1:1 with those used by major banks and consulting firms.

By completing this course, you will:

Be able to work comfortably with Microsoft Excel and many of its advanced features

Become one of the top Excel users in your team

Be much quicker at carrying out regular tasks

Be able to build a P&L statement from a raw data extraction

Be able to build a cash flow statement

Know how to value a company

Be able to build a valuation model from scratch

Know how to create a model with multiple scenarios

Know how to create professional and good-looking advanced charts

About the course:

An unconditional Udemy 30-day money-back guarantee - because we believe in the quality of our content

No significant previous experience is needed to understand the course properly and benefit from its content

Unlimited access to all course materials

Emphasis on learning by doing

You can always contact us for any clarification free of charge

Our goal is to take your Microsoft Excel and Financial Modeling skills to the next level

Make an investment that will be highly rewarded in career prospects, positive feedback, and personal growth.

This course is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position.

People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.

Go ahead and subscribe to this course! If you don't acquire these skills now, you will miss an opportunity to separate yourself from others. Don't risk your future success! Let's start learning together now!

Who this course is for:

Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills

        General
Complete name                            : 7. Use VLOOKUP to fill the database sheet.mp4
Format                                   : MPEG-4
Format profile                           : Base Media
Codec ID                                 : isom (isom/iso2/avc1/mp41)
File size                                : 61.6 MiB
Duration                                 : 5 min 29 s
Overall bit rate                         : 1 570 kb/s
Writing application                      : Lavf58.12.100
IsTruncated                              : Yes

Video
ID                                       : 1
Format                                   : AVC
Format/Info                              : Advanced Video Codec
Format profile                           : Main@L3.1
Format settings                          : CABAC / 4 Ref Frames
Format settings, CABAC                   : Yes
Format settings, RefFrames               : 4 frames
Format settings, GOP                     : M=4, N=60
Codec ID                                 : avc1
Codec ID/Info                            : Advanced Video Coding
Duration                                 : 5 min 29 s
Bit rate                                 : 1 433 kb/s
Nominal bit rate                         : 3 000 kb/s
Width                                    : 1 280 pixels
Height                                   : 720 pixels
Display aspect ratio                     : 16:9
Frame rate mode                          : Constant
Frame rate                               : 30.000 FPS
Color space                              : YUV
Chroma subsampling                       : 4:2:0
Bit depth                                : 8 bits
Scan type                                : Progressive
Bits/(Pixel*Frame)                       : 0.052
Stream size                              : 56.2 MiB (91%)
Writing library                          : x264 core 148
Encoding settings                        : cabac=1 / ref=3 / deblock=1:-1:-1 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.15 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-3 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00

Audio
ID                                       : 2
Format                                   : AAC
Format/Info                              : Advanced Audio Codec
Format profile                           : LC
Codec ID                                 : mp4a-40-2
Duration                                 : 5 min 29 s
Bit rate mode                            : Constant
Bit rate                                 : 128 kb/s
Channel(s)                               : 2 channels
Channel positions                        : Front: L R
Sampling rate                            : 44.1 kHz
Frame rate                               : 43.066 FPS (1024 SPF)
Compression mode                         : Lossy
Stream size                              : 5.02 MiB (8%)
Default                                  : Yes
Alternate group                          : 1   

Screenshots
   

   

   

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction