Excel Crash Course- Master Excel for Financial Analysis

Excel Crash Course: Master Excel for Financial Analysis, available at $84.99, has an average rating of 4.59, with 40 lectures, based on 15069 reviews, and has 48963 subscribers.

You will learn about 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 This course is ideal for individuals who are This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters. or The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more. It is particularly useful for This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters. or The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more.

Enroll now: Excel Crash Course: Master Excel for Financial Analysis

Summary

Title: Excel Crash Course: Master Excel for Financial Analysis

Price: $84.99

Average Rating: 4.59

Number of Lectures: 40

Number of Published Lectures: 40

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: CFI Intro

Lecture 2: Welcome

Lecture 3: Table of contents

Lecture 4: Instructor biography

Lecture 5: Key learning objectives

Chapter 2: Excel Layout

Lecture 1: Layout overview

Lecture 2: Workbooks, worksheets, cells, & formula bar

Lecture 3: The ribbon

Chapter 3: Excel Settings

Lecture 1: Settings overview

Lecture 2: Changing your settings

Chapter 4: Basic Financial Analysis Setup

Lecture 1: Objectives

Lecture 2: Format, background, special numbers, column width, freeze panes

Lecture 3: Paste special, font colors, format numbers, sum

Lecture 4: Percentages, fill right, font colors, borders, view gridlines

Chapter 5: Advanced Financial Analysis Setup

Lecture 1: Objectives

Lecture 2: Structure, organization, duplicate sheets, grouping

Lecture 3: Anchoring cells, grouping

Lecture 4: Naming cells, tracing precedents & dependents, auditing

Lecture 5: Go to special, conditional formatting

Lecture 6: Dynamic titles & headers

Chapter 6: Basic Functions & Formulas

Lecture 1: Objectives

Lecture 2: Date fuctions and time periods

Lecture 3: Sum, average, sumproduct, median

Lecture 4: IF statements

Lecture 5: Rounding and absolute fuctions

Lecture 6: Min, max, small, large

Lecture 7: IFerror, find and replace

Chapter 7: Advanced Functions & Formulas

Lecture 1: Objectives

Lecture 2: Scenarios, choose, data validation

Lecture 3: Vlookup, hlookup, index, match

Lecture 4: Data tables and goal seek

Lecture 5: Sumif, countif, if + and

Lecture 6: Xirr and xnpv

Chapter 8: Charts & Graphs

Lecture 1: Objectives

Lecture 2: Stacked column and line chart combined

Lecture 3: Waterfall chart (Excel 2016)

Lecture 4: Column, line, and pie charts

Chapter 9: Macros

Lecture 1: Objectives

Lecture 2: Recording and using macros to seed up modeling

Chapter 10: Wrap Up

Lecture 1: Download completed file and keep practicing

Instructors

Scott Powell
Corporate Finance Institute

Rating Distribution

1 stars: 60 votes

2 stars: 135 votes

3 stars: 1187 votes

4 stars: 5466 votes

5 stars: 8221 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!