Advanced Excel Training Course

[Required] Learn Advanced Excel Formulas and Functions for Financial Analysis
  • 47 Videos
  • 6 Quizzes
  • 1 Survey
  • 1 Text
  • 4 Downloads
  • 1 Exam
  • 3.0 hrs

Course Curriculum

$497.00
Full CFI Program: 25 courses, template library, & Financial Analyst Certification

Course description

Recommended Prerequisites

You are expected to have either completed the stated prerequisite course(s) or possess the equivalent knowledge prior to enroling in this course:

  1. Excel Crash Course
  2. Building a Financial Model in Excel
  3. Scenario & Sensitivity Analysis

Advanced Excel training course overview

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training 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.  By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them.


Advanced Excel Training Course screenshot

 

Content of the advanced Excel course

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 training 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


Advanced Excel tutorial image of course


What am I going to get from this advanced Excel training 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, including beautiful tables, charts, and graphs
  • Easy to follow video-based tutorials and lessons

For further CPE information, please read before purchasing:

https://corporatefinanceinstitute.com/about/cpe-information/

Register now for our Advanced Excel training course and become an Excel power user!  For anyone working in investment banking, equity research, corporate development, financial planning and analysis (FP&A) this class will give you the confidence you need to be a leader in performing financial analysis at your organization.


advanced Excel charts and graphs


Financial modeling & financial analyst training

From beginner to advanced, this advanced Excel modeling course is designed to teach you how to be a complete financial analyst. 

This class is one of the 9 required "Core" courses for CFI's financial analyst training program, which grants the Financial Modeling & Valuation Analyst (FMVA) certification.

Reviews (19)

Advanced Excel

by Tafirenyika Choruwa
The course is comprehensive and touches on important aspects of modeling.

Advanced Excel course

by HARMEET SINGH
It's a really amazing and powerful course helping in building future financial analyst in the industry. Thanks, CFI for providing good knowledge and material which was well-defined and easy to learn!!

Thanks CFI

by KANNY SIBOZA
I appreciate it CFI, I made it, and it was so amazing.

Advanced Excel Formulas Course

by Delbert Adivnovak
These advanced excel formulas and dynamic models were very challenging and exciting. I really learned new things with it even though I am already an advanced excel user

good

by shital trivedi
Excellent

by akanksha sharma
My experience with CFI was amazing I learned lot of new things from the mentor thanxxx for your great help

Fantasmagaria

by Kaushik Agarwal
The course is indeed advanced in nature and harps upon the solidification of basics in order to progress beyond. The instructor was very, very effective in explaining the course material and he allotted proper time to everything. The course was indeed the best I have done till date in CFI.
Read more

Advanced Excel

by Tafirenyika Choruwa
The course is comprehensive and touches on important aspects of modeling.

Advanced Excel course

by HARMEET SINGH
It's a really amazing and powerful course helping in building future financial analyst in the industry. Thanks, CFI for providing good knowledge and material which was well-defined and easy to learn!!

Thanks CFI

by KANNY SIBOZA
I appreciate it CFI, I made it, and it was so amazing.

Advanced Excel Formulas Course

by Delbert Adivnovak
These advanced excel formulas and dynamic models were very challenging and exciting. I really learned new things with it even though I am already an advanced excel user

good

by shital trivedi
Excellent

by akanksha sharma
My experience with CFI was amazing I learned lot of new things from the mentor thanxxx for your great help

Fantasmagaria

by Kaushik Agarwal
The course is indeed advanced in nature and harps upon the solidification of basics in order to progress beyond. The instructor was very, very effective in explaining the course material and he allotted proper time to everything. The course was indeed the best I have done till date in CFI.

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