Very good
Quick Excel Course for Financial Modeling
This course teaches the fundamentals of financially modeling a business using Excel
Office Productivity,Excel,Microsoft Office
Lectures -13
Resources -4
Duration -1.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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 this course is for:
- Anyone interested in finance, accounting, or related fields.
Goals
What will you learn in this course:
- 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.
Prerequisites
What are the prerequisites for this course?
- Basic proficiency with accounting and Excel.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
8 Lectures
- Course Overview 04:07 04:07
- Planning your Financial Model 09:18 09:18
- Building a Model Template 12:28 12:28
- Projecting the Income Statement 13:03 13:03
- Projecting the Balance Sheet 16:37 16:37
- Projecting Cash Flows 14:22 14:22
- Advanced Financial Modeling 13:58 13:58
- BONUS LESSON: Top 5 Excel Features for Financial Modellers 07:48 07:48
Supporting Materials
4 Lectures
Instructor Details
Blair Cook
Thought Leaders in the Field of Executive FinanceA 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
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
Very good
Good
Good
Very Good
This course is very helpful for me....
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now