Excel Crash Course: Master Excel for Financial Analysis

5.0 /5

(1 Rating)

Offered byUDEMY

Excel Crash Course: Master Excel for Financial Analysis
at
UDEMY
Overview

Beginner to Advanced: Learn Excel Shortcuts, Formulas & Functions for Financial Modeling & Corporate Finance

Duration	4 hours
Total fee	₹1,999
Mode of learning	Online
Credential	Certificate

Excel Crash Course: Master Excel for Financial Analysis
at
UDEMY
Highlights

Earn a certificate of completion from Udemy
Learn from 2 downloadable resources
Get full lifetime access of the course material
Comes with 30 days money back guarantee

Excel Crash Course: Master Excel for Financial Analysis
at
UDEMY
Course details

Skills you will learn

Investment banking Excel Conditional Formatting Vlookup Financial modelling Corporate finance

Who should do this course?

For all levels from beginner to advanced

What are the course deliverables?

Perform professional level financial analysis in Excel

More about this course

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
This course is based on first-hand investment banking training programs at global banks
This course starts with the basics and quickly progresses to a level where even experts will learn something new
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

Excel Crash Course: Master Excel for Financial Analysis
at
UDEMY
Curriculum

Introduction

CFI Intro

Welcome

Table of contents

Instructor biography

Key learning objectives

Excel Layout

Layout Overview

Workbooks, worksheets, cells, & formula bar

The ribbon

Excel Settings

Settings overview

Changing your settings

Basic Financial Analysis Setup

Objectives

Format, background, special numbers, column width, freeze panes

Paste special, font colors, format numbers, sum

Percentages, fill right, font colors, borders, view gridlines

Advanced Financial Analysis Setup

Objectives

Structure, organization, duplicate sheets, grouping

Anchoring cells, grouping

Naming cells, tracing precedents & dependents, auditing

Go to special, conditional formatting

Dynamic titles & headers

Basic Functions & Formulas

Objectives

Date functions and time periods

Sum, average, sumproduct, median

IF statements

Rounding and absolute functions

Min, max, small, large

IFerror, find and replace

Advanced Functions & Formulas

Objectives

Scenarios, choose, data validation

Vlookup, hlookup, index, match

Data tables and goal seek

Sumif, countif, if + and

Xirr and xnpv

Charts & Graphs

Objectives

Stacked column and line chart combined

Waterfall chart (Excel 2016)

Column, line, and pie charts

Excel Crash Course: Master Excel for Financial Analysis
at
UDEMY
Faculty details

Scott Powell

Scott Powell is Co-Founder and Chief Creative Officer of the Corporate Finance Institute® (CFI). Now based in Vancouver, Scott spent a significant portion of his career in London, New York and Hong Kong. Scott has a passion for teaching with over 25 years of experience designing and delivering customized learning solutions for firms in the financial services industry including JP Morgan, Deutsche Bank, Bank of America Merrill Lynch, Credit Suisse, and HSBC, to name but a few.