Excel Crash Course: Master Excel for Financial Analysis

4.4
3 681 коментарий
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
3.5 часа курса
О курсе

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

Программа
Introduction
Understand what this course covers and what you'll learn
CFI Intro
Welcome
Table of contents
Instructor biography
Key learning objectives
Excel Layout
Understand how Excel is laid out to maximize your speed and efficiency
Layout overview
Workbooks, worksheets, cells, & formula bar
The ribbon
Excel Settings
Understand how optimize your Excel setting to maximize your speed and efficiency
Settings overview
Требования
  • Excel 2007, 2010, 2013 or 2016 loaded on your computer.
Что Вы изучите?
  • 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
Лекторы
Tim Vipond
Tim Vipond
CEO at Corporate Finance Institute | 350,000+ students

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
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
Рейтинг
4.4
1 947
1 356
356
53
26