Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel Crash Course: Master Excel for Financial Analysis

Video Introducing this tutorial

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 fuctions and time periods
Sum, average, sumproduct, median
IF statements
Rounding and absolute fuctions
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


Macros :
Objectives
Recording and using macros to seed up modeling


Wrap Up :
Download completed file and keep practicing