Quick Excel for Financial Modeling
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Quick Excel for Financial Modeling to your Wishlist.

Add to Wishlist

Quick Excel for Financial Modeling

This course teaches the fundamentals of financially modeling a business using Excel.
New
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5 students enrolled
Last updated 7/2017
English
Price: $75
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Identify a disciplined approach for using Excel to develop financial analysis.
  • Discover how to prepare financial projections of the income statement, balance sheet, and statement of cash flows.
View Curriculum
Requirements
  • Basic proficiency with accounting and Excel.
Description

In this course we learn how to financially model a business using Excel. Financial models underpin strategic and business planning, solicitations for financing, budgeting and forecasting, business valuations, cash budgeting, capital budgeting, and so many other corporate finance purposes. 

We concentrate on the preparation of a financial projection of the income statement, balance sheet and statement of cash flow. We use an approach that keeps model integrity and credibility top of mind throughout development.

Who is the target audience?
  • Anyone interested in finance, accounting, or related fields.
Compare to Other Financial Modeling Courses
Curriculum For This Course
11 Lectures
03:03:38
+
Introduction
9 Lectures 03:03:36


Building a Model Template
12:28

Projecting the Income Statement
13:03

Projecting the Balance Sheet
16:37

Projecting Cash Flows
14:22

Advanced Financial Modeling
13:58

BONUS LESSON: Top 5 Excel Features for Financial Modellers
07:48

Financial Modeling Using Excel Continuous Play
01:31:50
+
Supporting Materials
2 Lectures 00:02
Slides: Financial Modeling Using Excel
00:01

Financial Modeling Using Excel Glossary/Index
00:01
+
Review and Test
0 Lectures 00:00
Review Questions
5 questions

FINAL EXAM
8 questions
About the Instructor
Illumeo Learning
4.4 Average rating
326 Reviews
1,378 Students
242 Courses
Condensed and Efficient Courses for Busy Professionals

Illumeo, incorporated in 2009, is revolutionizing the hide-bound world of corporate learning. Illumeo works with corporate professionals and organizations of all sizes to build the skills and capabilities that help everyone be an expert at their job.

Based in Silicon Valley, CA, Illumeo serves thousands of corporations and corporate professionals across Finance, Accounting, Human Resources, Sales and Marketing. The platform offers assessments, industry-benchmarked competency analyses, hundreds of expert-developed courses, collaborative tools, and the ability for companies to self-publish internal courses that promote institutional knowledge retention and dissemination.

Illumeo is the place for expertise management and we are dedicated to the proposition that everyone can be an expert at their job.

Blair Cook (Illumeo)
4.5 Average rating
49 Reviews
320 Students
21 Courses

A financial executive and corporate director with a broad base of experience working as a financial leader, catalyst, operator and steward in a number of public and private companies operating in a broad array of industries, with a deep background as a financial, consulting, and accounting educator providing professional development services to Big 4 Public Accounting Firms, universities, and professional institutes.

Specialties:Leadership, finance, accounting, mergers and acquisitions, auditing, instructional design, facilitation and instruction, authoring, decision analysis