Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
How to Build a Financial Model in Excel (Part 1)
Play lesson

Financial Modeling Tutorials by CFI - How to Build a Financial Model in Excel (Part 1)

4.0 (2)
20 learners

What you'll learn

This course includes

  • 5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Learn how to build a financial model in Excel with part 1 of our video course! In this course, you will learn to build a financial model from scratch by working in Excel and following along with the video. After completing the course and all quizzes, you will obtain your Financial Modeling Certificate from the Corporate Finance Institute. Enroll in the FULL course to earn your certificate and advance your degree: http://www.corporatefinanceinstitute.com Chapters: 00:00 - Building a Financial Model: Part 1 00:28 - Key Structure for Model Building 01:14 - Modeling Best Practice 02:52 - The Inherent Tension in Model Building 03:55 - Model Inputs 09:40 - Data Validation Exercise 09:57 - Model Processing 11:31 - Model Outputs 13:03 - Protecting a Worksheet 14:59 - Protecting Model Data Exercise 15:17 - A Financial Forecast Modeling Framework 16:49 - Forecasting Revenue 22:31 - Income Statement Forecast Exercise FREE COURSES & CERTIFICATES Enroll in our FREE online courses and earn industry-recognized certificates to advance your career: ► Introduction to Corporate Finance: https://loom.ly/us5oJEw ► Excel Fundamentals: https://loom.ly/4KnYciU ► Accounting Fundamentals: https://loom.ly/xHJgJO4 ► Reading Financial Statements: https://loom.ly/2wrcPw8 ► Fixed Income Fundamentals: https://loom.ly/DZdjDA0 About Corporate Finance Institute: CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the world's top universities, investment banks, accounting firms, and operating companies. By taking our courses, you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical, with step-by-step instructions to help you become a first-class financial analyst. Explore CFI courses: https://courses.corporatefinanceinstitute.com/collections Join us on social media! LinkedIn: https://www.linkedin.com/company/corporate-finance-institute-cfi Facebook: https://www.facebook.com/corporatefinanceinstitute.cfi Instagram: https://www.instagram.com/corporatefinanceinstitute

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere