Recommended Prep Courses

These preparatory courses are optional, but we recommend you to complete the stated prep course(s) or possess the equivalent knowledge prior to enrolling in this course:

  1. Excel Crash Course
  2. Building a 3 Statement Financial Model
  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:

  • 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:


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.

What You'll Learn


Advanced Excel Training Course

$97.00 Enroll Now Free Preview

Approx 6.5 hrs to complete


From $847.00
FMVA Full Immersion
Buy Now
From $497.00
FMVA Self Study
Buy Now

Path to Certification

Prerequisite Courses

8 courses from beginner to intermediate level.


Core Courses

11 courses from beginner to intermediate level.


Elective Courses

Take 3 out of 10 courses at an advanced level.


Get Certified

Submit your FMVA®️ checklist and order your certificate.


Join Our Community

Get access to the Global Corporate Finance Society.


How the Certification Works

FMVA® Financial Analyst Certification courses are offered 100% online, allowing you the flexibility to start the financial analyst program anytime and learn when it’s most convenient for you.
Students must complete all core and elective courses (14 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified FMVA Certification will be emailed to you.

What Our Students Say

Dans Jurcāns
Experienced users will indeed learn a lot
I consider myself an experienced Excel user, but this course covers advanced techniques by combining functions you wouldn't even imagine can fit together. Worth it for the dynamic charts alone!
Macdonald Ossuetta
Fantastic knowledge
What a great course. A must for anyone looking to have an advanced level in Excel.
Gulshat Uspanova
Advanced Excel formulas
This course helped me a lot in financial modeling at my job! Thank you
Matt Logan
Definitely worth taking
I would recommend this course to all levels of Excel Users (from beginner to advanced). You will definitely learn some valuable things.
See More
Apurba Roy
This is wonderful to complete the advanced excel formulas course. It's a great experience going through complex formulas and dynamic charts. I feel confident and it will help in solving complex problem and world class presentation. Thank you CFI!
Mohamad Jihad Abdel Ghani
Amazing excel function learnings
This course provides very practical application of the various advance functions of excel in order to make world class financial models.
Marcelo Campero
As a CFA and FRM charterholder, I can say that this course has an absolute hands-on approach and should be mandatory to any finance professional looking to complement his/her financial skills. The video lectures are very well structured and the instructors deliver in such an easy way to understand. I would highly recommend!
Very Informative and engagive course enjoyed every bit of it. I Highly recommend the course
Mosammat Nurunnahar
Fantastic Course. Thank you so much Tim Vipond and CFI Team
Oluwatomisin Adigun
It was really educative and broaden my horizon on more excel functions. I will be applying what i have learnt to my job.
I would recommend everyone to take this advanced excel module. Very helpful to learn some advanced functions and it delivered more than I expected.
Mehrdad Ansari
As always, this course is five stars too.
Dinesh Bhandari
This course has been designed to make it understand for 1st time excel user.
Masood ur Rehman
I learned very important concepts in easy-to-follow way. I wish Macros section was covered more extensively. Other than that, being able to build dynamic models is extremely valuable. I intend to take learning from this course and immediately apply to the next assignment I have at work. I have already been able to impress my higher-ups by applying dynamic modelling techniques learned through FMVA program.
Omar Poventud Miranda
Best Excel course ever! Combined with the Dashboards and Data Visualization course (required for FMVA Certification) will take your career to another level. I considered myself an Excel "expert" but I know now I am an expert. Looking forward to applied some Excel knowledge.
Very insightful and instructive. Highly recommend for any Finance Professional who wants to be topnotch in his/her profession
This course, like many of the CFI courses, helped cut down my time on having to re-adjust models to cater for varying time periods. If you want to create really dynamic models, this is the course for you! Make sure you do the core courses first though.
Abhinav Anand
Thank You
Kai Yee See
Very engaging and awesome. All of these were very much needed in my finance career. Thumbs up!
Pamela Isidori
I have learned a lot from this program. I really enjoyed all this information.
Bryce Nie
Best course out of the entire CFI program
Kudzi Samushonga CPA, CA MBA
This is an excellent course for someone who wants to go into advanced excel, but I personally think it should be an elective rather than a core course so that it doesn't hold back someone who doesn't have the inclination to study excel at such an advanced level from completing the FMVA certification.
Idriss Malike Ngari Ontsilambissa
one word: INCREDIBLE. 5 stars.
Tafirenyika Choruwa
The course is comprehensive and touches on important aspects of modeling.
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!!
I appreciate it CFI, I made it, and it was so amazing.
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
shital trivedi
akanksha sharma
My experience with CFI was amazing I learned lot of new things from the mentor thanxxx for your great help
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.
Constantine Burrell
This is a great course. The Instructor makes the course so simple to understand.
Bienvenido Jesus B. Castro Jr., CPA, FMVA
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 !
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.

Frequently Asked Questions

Can I download the Excel files and financial modeling templates?
How long do I have to complete the courses?
Are CFI courses verified?
Are there any additional fees or costs?
What currency are your courses priced in?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
More Questions?

FMVA® Financial Analyst Certification

Become a Financial Modeling and Valuation Analyst (FMVA)® by completing all required courses in accounting, finance, modeling, Excel, presentations, and strategy. From beginner to advanced courses you will have the complete training you need to become a world-class financial analyst.


From $847.00
FMVA Full Immersion
Buy Now
From $497.00
FMVA Self Study
Buy Now