Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-12 10:03:42
30-Day Money-Back Guarantee
Finance & Accounting Financial Modeling & Analysis Financial Modeling

Beginner to Pro in Excel: Financial Modeling and Valuation

Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!
Bestseller
Rating: 4.6 out of 54.6 (32,517 ratings)
140,849 students
Created by 365 Careers
Last updated 2/2021
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Requirements

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

Description

**Updated for February 2021!**

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 119,002 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

Featured review

Abraham Eninla
Abraham Eninla
17 courses
9 reviews
Rating: 5.0 out of 5a year ago
Wow! this is a great experience for me. Before purchasing this course, I went through the reviews and I was encouraged by the good ones I read. Although few of them made contrary opinions and observations. But for me, after making significant progress in the course, I can only say this... This course is the best I have taken online. The trainer demonstrates a very good knowledge of the subject.

Course content

25 sections • 271 lectures • 14h 28m total length

  • Preview03:31
  • Bonus! Welcome gift
    1 page
  • Welcome gift number 2
    1 page
  • Preview01:56
  • Download all course materials and frequently asked questions (FAQ)
    02:17

  • Preview00:37
  • Overview of Excel
    03:33
  • Overview of Excel
    1 question
  • The Excel ribbon
    02:38
  • Basic operations with rows and columns
    01:44
  • Data entry in Excel
    03:00
  • Introduction to formatting
    05:39
  • Rows and columns
    1 question
  • Introduction to Excel formulas
    03:57
  • Introduction to Excel formulas
    1 question
  • Introduction to Excel functions
    03:41
  • Cut, copy, & paste
    02:10
  • Cut, copy, & paste
    1 question
  • Paste special
    01:16
  • Format cells
    05:24
  • Basic operations in Excel - 38 pages
    37 pages

  • Excel best practices - Welcome lecture
    00:41
  • Initial formatting of Excel sheets for a professional layout
    01:57
  • Fast scrolling through Excel sheets
    01:34
  • Fast scrolling through Excel sheets
    1 question
  • Be even quicker: F5 + Enter
    01:51
  • Fixing cell references
    02:12
  • Introduction to fixing of cell references
    1 question
  • Alt + Enter
    00:48
  • Preview02:00
  • Learn how to organize your data with text to columns
    1 question
  • The wrap text button
    00:43
  • Set print area
    01:10
  • Custom sort helps you sort multiple columns in Excel tables
    01:21
  • Create drop-down lists with data validation
    01:48
  • Preview01:37
  • Select Special
    1 question
  • Assign dynamic names in a financial model
    01:20
  • Assigning dynamic names
    1 question
  • Define a named range in Excel
    01:34
  • Create a great Index page at the beginning of your models - Hyperlinks
    01:16
  • Introduction to custom formatting in Excel
    06:14
  • Apply custom formatting in a financial model
    01:33
  • Preview02:58
  • How to save macros and use them across several workbooks
    01:34
  • Excel macros - quiz
    1 question
  • Fix the top row of your table with freeze panes
    01:11
  • How to search functionalities in Excel
    00:40
  • Filter by color - an excellent tool
    01:43
  • Working with conditional formatting
    05:40
  • Useful tips and tools for your work in Excel - quiz
    5 questions
  • A neat trick - 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
  • Removing (automatic) green arrows
    01:31
  • Preview02:13
  • Formula auditing with F2
    01:50

  • Keyboard shortcuts save LOTS of time in Excel
    04:57
  • Keyboard shortcuts in Excel
    11 pages

  • Excel's key functions - Welcome lecture
    00:45
  • A helpful consideration
    00:45
  • Key functions in Excel: IF
    02:35
  • Key Excel functions: SUM, SUMIF and SUMIFS
    04:20
  • = and + are interchangeable when you start typing a formula
    00:44
  • Key Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFS
    03:59
  • Key Excel functions: AVERAGE and AVERAGEIF
    01:54
  • Key Excel functions: AVERAGE and AVERAGEIF
    1 question
  • Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
    04:24
  • Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
    1 question
  • Working with text (continued)
    02:40
  • Find the minimum or maximum value in a range of cells in Excel
    00:50
  • Include ROUND in your financial models
    00:59
  • Key Excel functions: VLOOKUP and HLOOKUP
    07:30
  • How to enlarge the formula bar
    01:03
  • INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
    07:15
  • A great Excel technique: INDEX, MATCH, MATCH
    04:59
  • INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
    1 question
  • Using Excel's IFERROR function to trap spreadsheet errors
    01:48
  • RANK is a valuable tool when using Excel for financial and business analysis
    02:36
  • CHOOSE - Learn how to render your models flexible
    02:17
  • Use Goal Seek to find the result that you are looking for
    02:12
  • Use Goal Seek in order to find the result that you are looking for
    1 question
  • Include sensitivity analysis in your models through Data Tables
    04:06
  • Include sensitivity analysis in your models through Data Tables
    1 question
  • Excel's dynamic and interactive tables: Pivot tables
    02:13
  • Excel's key functions and functionalities made easy
    5 questions

  • Exercise - Excel's SUMIFS function - unsolved
    1 page
  • Exercise - Excel's SUMIFS function - solved & explained
    Preview08:05

  • Future and present values in Excel
    07:02
  • Calculating the rate of return of an investment with the IRR function
    03:30
  • Calculating a complete loan schedule in Excel
    06:16
  • Date functions in Excel
    05:38

  • Introduction to Pivot Tables and the way they are applied
    01:35
  • Creating Pivot Tables easily!
    03:30
  • Give your Excel Pivot Tables a makeover
    01:57
  • Modifying and pivoting fields to obtain the Pivot Table you need
    04:16
  • Learn more about GETPIVOTDATA - A very important Excel function
    03:28
  • Preview04:03

  • Case study - Build a P&L from scratch - Welcome lecture
    01:02
  • Introduction to the case study
    01:06
  • Understand your data source before you start working on it
    02:42
  • Order the source worksheets
    02:16
  • Create a code: the best way to organize your data and work efficiently with it
    01:59
  • Learn how to create a database
    01:58
  • Use VLOOKUP to fill the database sheet
    05:29
  • Use SUMIF to complete the database sheet
    04:06
  • FAQ: Sum of FY2018 doens't go down to zero
    00:48
  • Use INDEX & MATCH as a substitute for VLOOKUP
    03:51
  • Mapping the rows in the database sheet
    02:16
  • In case you have any doubts about the Mapping exercise
    06:15
  • Building the structure of the P&L sheet
    02:21
  • Formatting sets You apart from the competition in Excel - A Practical Example
    03:17
  • Populate the P&L sheet with SUMIF
    02:47
  • FAQ: Why the sum of the check should be 0?
    00:18
  • Learn how to find mistakes with COUNTIF
    02:14
  • Calculating year-on-year percentage variations the proper way
    03:08
  • FAQ: Why do we subtract -1 when calculating year-on-year growth?
    00:47

  • How to insert a chart in Excel
    02:10
  • Editing Excel charts
    02:29
  • Excel chart formatting
    03:09
  • How to create a bridge chart in Excel
    01:42
  • New ways to visualize your data - Treemap charts
    01:31
  • Sparklines
    03:52

Instructor

365 Careers
Creating opportunities for Business & Finance students
365 Careers
  • 4.5 Instructor Rating
  • 392,456 Reviews
  • 1,343,027 Students
  • 70 Courses

365 Careers is the #1 best-selling provider of finance courses on Udemy. The company’s courses have been taken by more than 1,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.  

Currently, the firm focuses on the following topics on Udemy:  

1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA

2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics

3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing

4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook

5) Blockchain for Business

All of the company’s courses are:  

Pre-scripted  

Hands-on  

Laser-focused  

Engaging  

Real-life tested  

By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.  

If you want to become a financial analyst, a finance manager, an FP&A analyst, an investment banker, a business executive, an entrepreneur, a business intelligence analyst, a data analyst, or a data scientist, 365 Careers’ courses are the perfect place to start. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.