Advanced Excel Formulas Course

Learn Advanced Excel Formulas and Functions for Financial Analysis
  • 46 Videos
  • 2 Quizzes
  • 4 Downloads
  • 3.0 hrs

Course Curriculum

$347.00
Full Access Bundle: 21 courses & certificates at $2,000+ value

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





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


Reviews (12)

Great training

by Constantine Burrell
This is a great course. The Instructor makes the course so simple to understand.

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 !
Read more

by Raunak Rajan

by Deepak Gangurde

Great training

by Constantine Burrell
This is a great course. The Instructor makes the course so simple to understand.

Awesome and very helpful

by Aniket Gund

by Mohd Faris Mohamad Bashaabidin

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