Scribd
Upload
151 views25 pages

Advanced Excel Formulas & Functions Course Present

This document outlines an advanced Excel course that teaches powerful functions, formulas, and tools for financial analysis and modeling. The course covers topics like dynamic charts and tables, financial statement formatting, scenario analysis, and macros. The goal is to help analysts in fields like investment banking and corporate finance become more efficient and perform dynamic analysis.

Uploaded by

Precious Obule
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
151 views25 pages

Advanced Excel Formulas & Functions Course Present

This document outlines an advanced Excel course that teaches powerful functions, formulas, and tools for financial analysis and modeling. The course covers topics like dynamic charts and tables, financial statement formatting, scenario analysis, and macros. The goal is to help analysts in fields like investment banking and corporate finance become more efficient and perform dynamic analysis.

Uploaded by

Precious Obule
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 25

Advanced Excel Formulas & Functions

corporatefinanceinstitute.com
Advanced Excel…

Combinations of functions

Dynamic analysis

Scenarios

Dynamic outputs and chart

corporatefinanceinstitute.com
CFI Instructors
Meet the global team of CFI instructors

Tim Vipond Justin Sanders Scott Powell


CEO & Instructor Instructor Director & Instructor
Vancouver London Vancouver

Lisa Dorian Ryan Spendelow


Director & Instructor Instructor
New York Hong Kong

corporatefinanceinstitute.com
Key Learning Objectives

corporatefinanceinstitute.com
Objectives

Dynamic Time Dynamic Dynamic


Periods Financial Financial
Statements Analysis

Dynamic Dynamic Charts Macros


Tables

corporatefinanceinstitute.com
About this course

Designed for financial analysts in investment banking, equity research,


FP&A, corporate development

Teaches Excel 2016, 2013 and 2010

Assumes you know the basics (shortcuts, standard formulas)

Advanced functions and formulas so even experts will learn a lot

corporatefinanceinstitute.com
Template Setup

corporatefinanceinstitute.com
Learning objectives

Dashboard

Dynamic time periods

Summary data

Scenarios

Dynamic calculations/schedules

corporatefinanceinstitute.com
Financial Statements

corporatefinanceinstitute.com
Learning objectives

Financial Conditional Dynamic time


Layout Grouping
calculations formulas periods

corporatefinanceinstitute.com
Financial Analysis

corporatefinanceinstitute.com
Learning objectives

Lookup and data query functions

What-if and goal seek

Sensitivity analysis

Additional useful functions (odds and ends)

corporatefinanceinstitute.com
Output – Tables

corporatefinanceinstitute.com
Learning objectives

Data tables

Pivot tables

Presentation

corporatefinanceinstitute.com
Charts

corporatefinanceinstitute.com
Learning objectives

Single series charts

Multi-series charts

Dynamic charts

corporatefinanceinstitute.com
Dynamic Analysis & Charts

corporatefinanceinstitute.com
corporatefinanceinstitute.com
corporatefinanceinstitute.com
corporatefinanceinstitute.com
Macros

corporatefinanceinstitute.com
Learning objectives

Recording Faster formatting Special buttons


a macro

corporatefinanceinstitute.com
Wrap Up

corporatefinanceinstitute.com
Session objectives

Follow industry best Dramatically speed up


practices your financial modeling

Make your analysis more Be a world class


powerful and dynamic financial analyst

corporatefinanceinstitute.com
Advance
your career
www.corporatefinanceinstitute.com

You might also like