Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Financial Modeling for Beginners in Excel in 120 Minutes!

Name: Financial Modeling for Beginners in Excel in 120 Minutes!
Rating: 4.2 (123 reviews)

Learn & create your first Financial Modeling templates including Revenue, Expense, Profit & Loss & Cashflow!

Created byMyExcelOnline John Michaloudis, Bryan Hong

Last updated 11/2020

English

English [Auto],

What you'll learn

Become more PRODUCTIVE at using Financial Models in Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
We teach you how to create Financial Models with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
Increase your Excel & Financial Modeling SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
One of the most sought after skills in the current market place and one that pays 3x above standard office jobs!
Become a Microsoft Excel Financial Modeling ADVANCED user within HOURS which will get noticed by top management & prospective employers!
Create your own Financial Model from scratch in just 120 minutes!
See how a Financial Model is used with real examples!
Get answers & insights from your financial data FAST!
Personal Excel support from Professional Excel Trainers with 30+ Years of combined Excel Training!
Test your skills with various real life Quizzes & Homework Practice Activities & Assignments!
ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)!

Course content

3 sections • 21 lectures • 2h 1m total length

What We Will Cover in This Course2:38
Learn financial modeling fundamentals from scratch in Excel, covering theory, core Excel concepts, and hands-on creation of a full model with revenue, expenses, profit and loss, and cash flow.
What is a Financial Model4:24
Explore how a financial model remains a simple spreadsheet of inputs, calculations, and outputs built in excel to forecast revenue, expenses, and cash flow.
Financial Model Design7:32
Prioritize the end goal and plan backward, organizing inputs, calculations, and a final summary to tell a clear story of your numbers.
Scenario Analysis2:33
Explore scenario analysis in Excel, using a one-click dropdown to switch between best and worst cases and instantly see recalculated results and a summary page.
Documentation4:59
Learn how to document financial models in Excel with best practices, using text notes, dynamic text formulas, comments, and data validation input messages to guide users and simplify updates.

Relative and Absolute Cell References8:31
Master relative and absolute cell references in Excel to copy formulas, calculate totals with sum, and compute percentages, using F4 to lock references.
IF Formula2:27
Demonstrate how the excel if formula acts as a logical test in financial modeling, returning bonus or no bonus when sales exceed 3000 and applying the logic across a column.
AND Formula3:19
Learn how the and formula yields true only when all conditions are met, using the month formula to check January and sales greater than 1000.
OR Formula2:33
Learn how the Excel or formula evaluates multiple conditions, returning true when any condition is met, with examples using January dates and sales over 1000.
Nested Formulas3:07
Learn to nest formulas in Excel to combine conditions with and and if, awarding a bonus when sales exceed 3000 and region is north, otherwise showing no bonus.
Conditional Formatting3:13
Apply conditional formatting in excel to highlight values greater than a dynamic threshold, using a threshold cell and a yellow format to make key figures stand out.
Data Validation5:02
Explore data validation in Excel, using dropdown lists from a customer table and enforcing rules like sales greater than or equal to zero and year 2000 to 2999.

Inputs and Assumptions8:40
Explore inputs and assumptions for an online bookstore financial model, including seasonality, business days, sales mix, pricing, and fixed and variable costs and tax timing.
Revenue7:22
Learn to model monthly revenue in Excel by calculating books sold per day with seasonality, using absolute references, and totaling revenue from formulas and macros books.
Expenses6:32
Calculate expenses by splitting fixed costs and printing costs, convert fixed costs from yearly to monthly, then compute monthly printing costs from books sold, and sum for total expenses.
Profit and Loss7:21
Explore how to build a profit and loss in Excel by linking revenue and expenses, calculating tax, and deriving profit after tax with dynamic formulas and error checks.
Cashflow10:20
Explore cash flow vs profit and loss, focusing on month-by-month revenue and expenses to operate, including annual and quarterly payments, and tracing a continuous closing balance.
Adding Scenarios14:41
learn to add scenario analysis in Excel using a dropdown for worst, base, and best cases, dynamically updating books per day and software licenses.
Charts5:09
Visualize your financial model with charts in Excel to compare revenue and expenses across months, using stack column and line charts that update automatically and support exploring scenarios.
Conditional Formatting4:49
Apply conditional formatting in Excel to highlight profits relative to a 1500 target, using green for values at least 1500 and red for others, with data bars.
Protect the Workbook6:02
Learn to secure your Excel financial models by encrypting with a password, protecting workbook structure and sheets, selectively allowing edits to specific cells, and using data validation dropdowns.
Upload a Screenshot of Your Financial Model of this Course
Financial Modeling Quiz

Requirements

Excel for Windows 2007, 2010, 2013, 2016, 2019, Office 365 and Excel for Mac 2011 and 2016
No previous Excel experience necessary!
No previous Financial Modeling experience necessary!
This course is also for Microsoft Excel Beginners, Intermediates or Advanced Users
A laptop or desktop to perform the exercises & internet connection

Description

You’re Just Seconds Away From Leveraging Excel & Financial Modeling That Will Make It Possible For YOU To:

Increase your Excel & Financial Modeling SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
Become more PRODUCTIVE at using Financial Models which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
Create Your Own Financial Models with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

*** This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ***

----------------------------------------

If you want to get better at Financial Modeling Using Microsoft Excel so you get a better paying job or just get answers & insights from your data FAST with Financial Models, then you are in the right place!

No matter if you are an Financial Modeling Beginner or NEVER USED EXCEL before, you are sure to benefit from this quick course which goes through the MUST KNOW Financial Model Foundations.

You will be able to master straight away the following (in just 120 minutes):

Everything about Financial Models
Design Principles of Financial Models
Scenario Analysis
Proper Documentation
Excel Core Concepts
Revenue, Expense, Profit & Loss, Cashflow
Financial Model Enhancements

In Just 120 Minutes You Will Walk Away With...

MORE TIME (Who doesn’t want that?)
Create your own Financial Model from scratch in just 120 minutes!
Understand the essence of the Financial Model components, and see them in action!
See how Financial Modeling is used with real examples!
Understand how Revenue, Expense, Profit & Loss and Cashflow are used together!

After this class you will be able to:

Actually SMILE when you start creating Financial Models :-)
Get valuable data insights & answers anytime you want from your data!

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Excel Financial Modeling skills...

…saving HOURS each day, DAYS each week and WEEKS each year…

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft skills and JOB OPPORTUNITIES!

To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including ALL downloadable video tutorials, Exercises, 1-on-1 instructor SUPPORT and Udemy has a refund guarantee!

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Financial Modeling in Excel

Who this course is for:

People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
People who want to change career and apply for a new job
Beginners in Financial Modeling aiming to make sense of their data
If you want to leverage Financial Modeling to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Financial Modeling for Beginners in Excel in 120 Minutes!

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 22min

Core Excel Concepts7 lectures • 28min

Your First Financial Model9 lectures • 1hr 11min

Requirements

Description

Who this course is for: