Home
ENG - US Dollar (USD)
Site Language
English
Site Currency
US Dollar (USD)
Search Login Register
Excel Crash Course: Master Excel for Financial Analysis
  • Home
  • Courses
  • Excel Crash Course: Master Excel for Financial Analysis
Finance & Accounting / Money Management

Excel Crash Course: Master Excel for Financial Analysis

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

REVIEW

0.00 (0 Ratings)

ENROLLMENT

0 Students

LEVEL

Beginner 

LANGUAGE

English

TEACHER

Brandt Jacobs
Brandt Jacobs
Originally From: Latvia
Originally From: Latvia
Latvia
Location: Latvia
Excel Crash Course: Master Excel for Financial Analysis
This Course Includes:
  • 3h 41m
  • 40 Lectures
  • 65 Downloadable Assets
  • Full Lifetime Access
  • Access on Mobile and TV
  • Certificate on Completion
Price of Just:

$517

Enroll Now
Add to Favorite List

Overview

What will learners learn in this course?
  • 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
What are the requirements or prerequisites for taking your course?
  • Excel 2007, 2010, 2013 or 2016 loaded on your computer.
Who is the course 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.
Description
Course Tags
Finance & Accounting Financial Modeling & Analysis Excel

Course Content

  • 10 Sections
  • 40 Lectures
  • 3h 41m Total Length
Introduction
06m
5 Lectures

Introduction

CFI Intro
Preview 0:01:00
Welcome
Preview 0:01:00
Table of contents
Preview 0:01:28
Instructor biography
Preview 0:01:00
Key learning objectives
Preview 0:01:49
Layout overview
Preview 0:02:01
Workbooks, worksheets, cells, & formula bar
Preview 0:01:44
The ribbon
Preview 0:09:34
Settings overview
0:01:00
Changing your settings
0:09:04
Objectives
0:01:09
Format, background, special numbers, column width, freeze panes
0:08:53
Paste special, font colors, format numbers, sum
0:07:04
Percentages, fill right, font colors, borders, view gridlines
0:10:08
Objectives
0:01:00
Structure, organization, duplicate sheets, grouping
0:05:54
Anchoring cells, grouping
0:07:30
Naming cells, tracing precedents & dependents, auditing
0:11:16
Go to special, conditional formatting
0:05:48
Dynamic titles & headers
0:04:31
Objectives
0:01:00
Date fuctions and time periods
0:08:39
Sum, average, sumproduct, median
0:06:33
IF statements
0:11:07
Rounding and absolute fuctions
0:04:42
Min, max, small, large
0:04:34
IFerror, find and replace
0:07:16
Objectives
0:01:00
Scenarios, choose, data validation
0:10:35
Vlookup, hlookup, index, match
0:20:13
Data tables and goal seek
0:10:56
Sumif, countif, if + and
0:04:33
Xirr and xnpv
0:05:04
Objectives
0:01:00
Stacked column and line chart combined
0:09:26
Waterfall chart (Excel 2016)
0:08:46
Column, line, and pie charts
0:04:16
Objectives
0:01:00
Recording and using macros to seed up modeling
0:07:17
Download completed file and keep practicing
0:01:00

About Tutor

Brandt Jacobs

Brandt Jacobs
Originally From: Latvia
Originally From: Latvia
Latvia
Location: Latvia

0.00 (0 Reviews)
1 Course
View Profile
Biography

Hello Students! I'm Brandt Jacobs and I belong to Austria. I served as an educational writer for several newspapers across Midwest and East Coast sparked my interest in teaching. I assist students in honing their writing talents and broadening their knowledge of literature. concentrating on the problem areas and helping students in communicating more effectively

Course Ratings & Reviews

0.00
0 Reviews
5
4
3
2
1