Excel Fundamentals - Formulas for Finance

Subscribe Enroll For Free

Level 2

Approx 3.50h to complete

100% online and self-paced

Subscribe to get access to FMVA® and other programs

From $497/year

Learn More

Overview

Excel Crash Course Description

In this free Excel tutorial, you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This free Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career. Take CFI's Excel Crash Course now to advance your career!

Build a strong foundation in Excel for careers in:

  • Investment banking
  • Private equity
  • Corporate development
  • Equity research
  • Financial Planning & Analysis (FP&A)


Free Excel Crash Course


Excel tutorial on best practices

Learn industry-leading best practices. This free Excel course is based on real investment banking training programs at global banks. The quality of instruction you receive in this course will have you just as sharp as if you took an expensive, live Wall Street course.


Free Excel Course and training Online (screenshot)


Excel tutorial & training details

This free spreadsheet training course starts with the Excel basics and quickly progresses to a more advanced level where even experts will learn something new. We believe it is important to start at the bottom and build a solid base, which is why we review all the foundational skills you need before building more advanced spreadsheets. In this Excel tutorial, you will learn to leave behind the mouse and use keyboard shortcuts to dramatically improve and speed up your spreadsheet building skills.

In the second half of the Excel crash course, you'll notice that the functions and formulas get more sophisticated and the quality of financial analysis and financial modeling become much higher. This half of the course focuses on finance-specific formulas that you would use as an analyst performing financial analysis on the job.


Excel Tutorial and lessons


What am I going to get from this free Excel course?

  • Learn everything you need to know about Excel spreadsheets for a career in corporate finance and investment banking
  • Master keyboard shortcuts, functions, and formulas to save time and speed up your modeling skills
  • Follow industry-leading best practices; simulate on-the-job analyst training
  • Stand out in an interview or move up the ladder at work by dramatically boosting your MS Excel skills and confidence
  • Get an Excel Crash course certificate of completion


Excel course for finance professionals


Who should take this free Excel tutorial?

This free Excel tutorial is perfect for beginners, intermediate, and even advanced users.  The tutorial starts off with the very basics, but the training quickly advances so even power users will learn something new and have a great refresher. Start the Excel Crash Course now!

What You'll Learn

Lesson
Multimedia
Exams
Files

Become a certified Financial Modeling & Valuation Analyst (FMVA)®

Excel Fundamentals - Formulas for Finance is part of the Financial Modeling & Valuation Analyst (FMVA)® certification, which includes 30 courses.

Financial Modeling & Valuation Analyst (FMVA)® Certification
  • Skills Learned Financial Modeling and Valuation, Sensitivity Analysis, Strategy
  • Career Prep Investment Banking and Equity Research, FP&A, Corporate Development

Path To Certification

Prerequisite Courses

7 courses from beginner to intermediate level.

01Optional

Core Courses

11 courses from beginner to intermediate level.

02Required

Elective Courses

Take 3 out of 11 courses at an advanced level.

03Required

Get Certified

Submit your FMVA® checklist and order your certificate.

04Required

Join Our Community

Get access to the Global Corporate Finance Society.

05Optional

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.

The program is a part of the All Access Subscription, which includes all programs and courses.

CFI courses are designed by instructors with over 21 years of financial analyst training experience.

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


All sessions were engaging and educative. One could learn easily through the instructor's guides and teachings.

Blessing Ibi

Appreciation post
The CFI Excel crash course is very insightful and has basic and very important details that will set you in the right path for excel. I particularly enjoyed learning about the shortcut keys. I recommend this course especially for beginners that have no idea what excel is about.

Chidimma Prisca Ogu

Great
Good info and clear teaching

Rudolf Lobo

Excel Crash Course - Spreadsheet Formulas for Finance
Some of the formulas not relevant - min,max,small,large - Other than that Very Good

Peter Marlow

See More

Frequently Asked Questions

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