Advanced Excel Formulas Course

Learn Advanced Excel Formulas and Functions for Financial Analysis | taught by Tim Vipond
  • 46 Videos
  • 4 Downloads
  • 3.0 hrs

Course Curriculum

$347.00
FULL ACCESS Bundle - 18 courses and certificates worth over $1,800+ value. Financial modeling, valuation, analysis and more.

Course description

Course Description

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced tutorial will help you become a world class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A.


Content and Overview

This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.

The main formulas & functions covered in this course include:

  • INDEX and MATCH
  • IF with AND / OR
  • OFFSET combined with other functions
  • CHOOSE for creating scenarios
  • INDIRECT combined with other functions
  • XNPV and XIRR
  • CELL, COUNTA and MID functions combined together
  • PMT, IPMT and principal payment calculations

The main types of data analysis in this advanced tutorial include:

  • Data tables
  • Pivot tables
  • Column and line charts
  • Stacked column charts
  • Waterfall charts
  • Gauge charts


What am I going to get from this course?

  • Learn everything you need to be a world class financial analyst
  • Received advanced Excel spreadsheet training
  • Master advanced formulas and functions
  • Create sophisticated outputs for financial analysis, includings beautiful tables, charts and graphs
  • Easy to follow video based tutorials

advanced excel formulas course


excel formulas course


advanced excel tutorial


Register now for our Advanced Excel Formulas Course and become an Excel power user!

Read More

Instructor

Tim Vipond
Tim Vipond
Senior Instructor, Principal, Mathers Pacific Capital

Since 2005 Tim has been an active participant in capital markets across a wide range of industries and transactions including mergers, acquisitions, divestitures, and capital raising totaling more than $3 billion in aggregate value.

Tim has a broad range of experience that includes:

  • Investment banking
  • Wealth management
  • Corporate development
  • Strategy
  • Investor relations
  • Financial planning & analysis (FP&A)

In 2014 Tim founded Mathers Pacific Capital to bridge the gap between theory and practice by offering financial modeling and valuation courses to undergraduate and MBA students. Mathers Pacific also offers transaction advisory services to mid-market private companies and has advised on several M&A transactions, management buyouts, and capital raises.

Tim has an M.B.A. from the Sauder School of Business and a B.A. from Dartmouth College.

Reviews (7)

Advanced Excel Formulas Course

by Bienvenido Jesus B. Castro Jr., CPA
Excellent course! I have learned a lot of ideas and understanding on the excel functions and its combinations, charts along with tips which are also amazing, thanks a lot CFI !

Advanced Excel

by baia ouldsliman
I really appreciated the quality of presentation and information presented. I could easily relate the formulas to analysis that we need to perform. The only issue is the quality of video is bit low as sometimes it was hard to see the formulas but the content was so clear that it did not make an issue for me. Thank you so much for sharing your experience in analysis with us.
Read more

Advanced Excel Formulas Course

by Bienvenido Jesus B. Castro Jr., CPA
Excellent course! I have learned a lot of ideas and understanding on the excel functions and its combinations, charts along with tips which are also amazing, thanks a lot CFI !

by brian millen

by Muhammad Ishaq

by efsi hayati

by Blessing Lawal

Advanced Excel

by baia ouldsliman
I really appreciated the quality of presentation and information presented. I could easily relate the formulas to analysis that we need to perform. The only issue is the quality of video is bit low as sometimes it was hard to see the formulas but the content was so clear that it did not make an issue for me. Thank you so much for sharing your experience in analysis with us.

by Grace Xin