Excel Fundamentals - Formulas for Finance
Subscribe Enroll For FreeLevel 2
Approx 3.50h to complete
100% online and self-paced
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)
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.
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.
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
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
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.
- 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.
01OptionalCore Courses
11 courses from beginner to intermediate level.
02RequiredElective Courses
Take 3 out of 11 courses at an advanced level.
03RequiredGet 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
What Our Students Say
All sessions were engaging and educative. One could learn easily through the instructor's guides and teachings.
Blessing Ibi
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
Good info and clear teaching
Rudolf Lobo
Some of the formulas not relevant - min,max,small,large - Other than that Very Good