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 CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development 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 Retargeting
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Financial Modeling & Analysis Excel

Excel Crash Course: Master Excel for Financial Analysis

Beginner to Advanced: Learn Excel Shortcuts, Formulas & Functions for Financial Modeling & Corporate Finance
Rating: 4.5 out of 54.5 (4,808 ratings)
23,115 students
Created by Tim Vipond
Last updated 11/2016
English
English [Auto], Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

  • Perform professional level financial analysis in Excel
  • At the end the course students will be able use industry best practices when building financial models in Excel
Curated for the Udemy for Business collection

Requirements

  • Excel 2007, 2010, 2013 or 2016 loaded on your computer.

Description

Course Description

Learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user.  This course is designed specifically for Excel users who are performing professional financial analysis and financial modeling. We cover all levels - from beginner to advanced users. 

Build a strong foundation in Excel for careers in:

  • Investment banking
  • Private equity
  • Corporate development
  • Equity research
  • Financial Planning & Analysis (FP&A)

Learn industry leading best practices.  This course is based on first-hand investment banking training programs at global banks.  The quality of instruction you receive in this course will have you just as sharp as if you took an expensive, live Wall Street course.

Content and Overview  This course starts with the basics and quickly progresses to a level where even experts will learn something new.  We think it's important to start at the bottom and build a solid base, which is why we review all the foundational skills you need.

In the second half of the course you'll notice the functions and formulas getting more sophisticated and the quality of financial analysis and financial modeling becoming much higher.

What am I going to get from this course?

  • Learn everything you need to know about Excel for a career in corporate finance
  • Master shortcuts, functions, and formulas to save time speed up you modeling skills
  • Follow industry leading best practices
  • Stand out in an interview or move up the ladder at work by dramatically boosting your Excel skills and confidence


Who this course is for:

  • This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters.
  • The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more.

Course content

10 sections • 40 lectures • 3h 38m total length

  • Preview00:53
  • Preview00:28
  • Preview01:28
  • Preview00:40
  • Preview01:49

  • Preview02:01
  • Workbooks, worksheets, cells, & formula bar
    Preview01:44
  • Preview09:34

  • Settings overview
    00:36
  • Changing your settings
    09:04

  • Objectives
    01:09
  • Format, background, special numbers, column width, freeze panes
    08:53
  • Paste special, font colors, format numbers, sum
    07:04
  • Percentages, fill right, font colors, borders, view gridlines
    10:08

  • Objectives
    00:34
  • Structure, organization, duplicate sheets, grouping
    05:54
  • Anchoring cells, grouping
    07:30
  • Naming cells, tracing precedents & dependents, auditing
    11:16
  • Go to special, conditional formatting
    05:48
  • Dynamic titles & headers
    04:31

  • Objectives
    00:58
  • Date fuctions and time periods
    08:39
  • Sum, average, sumproduct, median
    06:33
  • IF statements
    11:07
  • Rounding and absolute fuctions
    04:42
  • Min, max, small, large
    04:34
  • IFerror, find and replace
    07:16

  • Objectives
    00:31
  • Scenarios, choose, data validation
    10:35
  • Vlookup, hlookup, index, match
    20:13
  • Data tables and goal seek
    10:56
  • Sumif, countif, if + and
    04:33
  • Xirr and xnpv
    05:04

  • Objectives
    00:43
  • Stacked column and line chart combined
    09:26
  • Waterfall chart (Excel 2016)
    08:46
  • Column, line, and pie charts
    04:16

  • Objectives
    00:21
  • Recording and using macros to seed up modeling
    07:17

  • Download completed file and keep practicing
    00:51

Instructor

Tim Vipond
CEO at Corporate Finance Institute | 350,000+ students
Tim Vipond
  • 4.5 Instructor Rating
  • 12,682 Reviews
  • 92,126 Students
  • 3 Courses

Tim is CEO of the Corporate Finance Institute® (CFI).

Corporate Finance Institute® (CFI) is a leading financial analyst certification company that provides career-focused financial modeling training. CFI’s courses have been delivered to tens of thousands of individuals at the top universities, investment banks, accounting firms and operating companies in the world. CFI is the official provider of the Financial Modeling & Valuation Analyst (FMVA)™ designation.

Tim has over 12 years of experience in capital markets across a wide range of transactions including mergers, acquisitions, divestitures, and capital raising totaling more than $3 billion.  

His professional experience includes investment banking, investment management, corporate development, strategy and corporate finance.

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