Beginner to Pro in Excel: Financial Modeling and Valuation
![](https://img-b.udemycdn.com/user/100x100/8280056_7887_3.jpg)
- Description
- Curriculum
- FAQ
- Reviews
*Updated for November 2023*
Do you want to learn how to use Excel in a real working environment?
Are you about to graduate from a university and look for your first job?
Are you a young professional looking to establish yourself in your new position?
Would you like to become your team’s go-to person for financial modeling in Excel?
Join over 200,000+ successful students taking this course.
Your instructor possesses the following extensive experience in financial modeling:
Financial advisory unit of a top-tier consulting firm
Experience in M&A transactions executed in the UK, Italy, Germany, Switzerland, and Poland
Employed in the in-house Mergers & Acquisitions department of a large multinational corporation
A financial advisor in multiple M&A deals ranging from €2 million to €5 billion
Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, and more.
Learn the subtleties of financial modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues with this course today.
A comprehensive guide to financial modeling in Excel:
Become an Excel expert
Build sound financial models in Excel
Gain an in-depth understanding of the mechanics of company valuation
Create professionally formatted files
Demonstrate superior Excel skills at work
Prepare before employment in investment banking, financial advisory, corporate finance, or consulting
What We Offer:
Well-designed and easy-to-understand materials
Detailed explanations with comprehensible case studies based on real situations
Downloadable course materials
Regular course updates
Professional chart examples used by major banks and consulting firms.
Real-life, step-by-step examples
Upon completing this course, you’ll be able to do the following:
Work comfortably with Microsoft Excel and many of its advanced features
Become a the top Excel users on your team
Perform regular tasks quicker
Develop a P&L statement from a raw data extraction
Build a cash flow statement
Value a company
Produce a valuation model from scratch
Create a model with multiple scenarios
Design professional and advanced charts
Acquire Excel proficiency by learning advanced functions, pivot tables, visualizations, and Excel features
About the course:
Unconditional 30-day money-back guarantee
No significant previous experience necessary to understand the course and benefit
Unlimited lifetime access to all course materials
Emphasis on learning by doing
Take your Microsoft Excel and financial modeling skills to the next level
Make an investment that is rewarded in career prospects, positive feedback, and personal growth.
This course is suitable for graduates aspiring to become investment bankers as it includes a well-structured DCF model with its theoretical concepts. Moreover, it motivates you to be more confident with daily tasks and gives you the edge over other candidates vying for a full-time position.
People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.
Take advantage of this opportunity to acquire the skills that will advance your career and get an edge over other candidates. Don’t risk your future success.
-
6Introduction to ExcelVideo lesson
-
7Overview of ExcelVideo lesson
-
8Overview of ExcelQuiz
-
9The Excel ribbonVideo lesson
-
10Basic operations with rows and columnsVideo lesson
-
11Data entry in ExcelVideo lesson
-
12Introduction to formattingVideo lesson
-
13Rows and columnsQuiz
-
14Introduction to Excel formulasVideo lesson
-
15Introduction to Excel formulasQuiz
-
16Introduction to Excel functionsVideo lesson
-
17Cut, copy, & pasteVideo lesson
-
18Cut, copy, & pasteQuiz
-
19Paste specialVideo lesson
-
20Format cellsVideo lesson
-
21Basic operations in Excel - 38 pagesText lesson
This opening section will take you through the basics of Excel. An easy-to-understand introduction that will bring you up to speed in no time.
Some of the topics and concepts discussed in this lesson:
·Row and Column references
·Name box
·Formula bar
·The Ribbon
·Format cells
·Basic operations in Excel: Copy, Paste, Paste Special, Cut, Undo, Redo
-
23Excel best practices - Welcome lectureVideo lesson
-
24Initial formatting of Excel sheets for a professional layoutVideo lesson
-
25Fast scrolling through Excel sheetsVideo lesson
-
26Fast scrolling through Excel sheetsQuiz
-
27Be even quicker: F5 + EnterVideo lesson
-
28Fixing cell referencesVideo lesson
-
29Introduction to fixing of cell referencesQuiz
-
30Alt + EnterVideo lesson
-
31Organize your data with text to columnsVideo lesson
-
32Learn how to organize your data with text to columnsQuiz
-
33The wrap text buttonVideo lesson
-
34Set print areaVideo lesson
-
35Custom sort helps you sort multiple columns in Excel tablesVideo lesson
-
36Create drop-down lists with data validationVideo lesson
-
37Find and select special types of cells with Select special (F5)Video lesson
-
38Select SpecialQuiz
-
39Assign dynamic names in a financial modelVideo lesson
-
40Assigning dynamic namesQuiz
-
41Define a named range in ExcelVideo lesson
-
42Create a great Index page at the beginning of your models - HyperlinksVideo lesson
-
43Introduction to custom formatting in ExcelVideo lesson
-
44Apply custom formatting in a financial modelVideo lesson
-
45Macros are a great timesaver! Here's why!Video lesson
-
46How to save macros and use them across several workbooksVideo lesson
-
47Excel macros - quizQuiz
-
48Fix the top row of your table with freeze panesVideo lesson
-
49How to search functionalities in ExcelVideo lesson
-
50Filter by color - an excellent toolVideo lesson
-
51Working with conditional formattingVideo lesson
-
52Useful tips and tools for your work in Excel - quizQuiz
-
53A neat trick - Multiply by 1Video lesson
-
54Find and replace - referencesVideo lesson
-
55FAQ: Why do we replace external references and how does this help us?Text lesson
-
56Find and replace - formattingVideo lesson
-
57Removing (automatic) green arrowsVideo lesson
-
58Beauty saving - The professional way of saving filesVideo lesson
-
59Formula auditing with F2Video lesson
-
61Keyboard shortcuts save LOTS of time in ExcelVideo lesson
-
62Keyboard shortcuts in ExcelText lesson
Learning how to use keyboard shortcuts is an essential part of your Microsoft Excel training. The slides in this lesson will enable you to pick up a number of useful keyboard combinations that will dramatically increase the efficiency of your work
-
63Excel's key functions - Welcome lectureVideo lesson
-
64A helpful considerationText lesson
-
65Key functions in Excel: IFVideo lesson
The IF function tests whether a certain condition is true or false. It works in the following way:
1.Excel tests whether the logical test, which is the first argument of the function, is satisfied
2.If the logical test is satisfied, Excel delivers value A (the second argument of the function)
3.If the logical test is not satisfied, Excel delivers value B (the third argument of the function)
-
66Key Excel functions: SUM, SUMIF and SUMIFSVideo lesson
-
67= and + are interchangeable when you start typing a formulaVideo lesson
-
68Key Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFSVideo lesson
-
69Key Excel functions: AVERAGE and AVERAGEIFVideo lesson
-
70Key Excel functions: AVERAGE and AVERAGEIFQuiz
-
71Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEVideo lesson
-
72Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEQuiz
-
73Working with text (continued)Video lesson
-
74Find the minimum or maximum value in a range of cells in ExcelVideo lesson
-
75Include ROUND in your financial modelsVideo lesson
-
76Key Excel functions: VLOOKUP and HLOOKUPVideo lesson
-
77How to enlarge the formula barVideo lesson
-
78INDEX, MATCH and their combination - the perfect substitute for VLOOKUPVideo lesson
-
79A great Excel technique: INDEX, MATCH, MATCHVideo lesson
-
80INDEX, MATCH and their combination - the perfect substitute for VLOOKUPQuiz
-
81XLOOKUP: a solid substitute for VLOOKUP and INDEX&MATCHVideo lesson
-
82Using Excel's IFERROR function to trap spreadsheet errorsVideo lesson
-
83RANK is a valuable tool when using Excel for financial and business analysisVideo lesson
-
84CHOOSE - Learn how to render your models flexibleVideo lesson
-
85Use Goal Seek to find the result that you are looking forVideo lesson
-
86Use Goal Seek in order to find the result that you are looking forQuiz
-
87Include sensitivity analysis in your models through Data TablesVideo lesson
-
88Include sensitivity analysis in your models through Data TablesQuiz
-
89Excel's dynamic and interactive tables: Pivot tablesVideo lesson
-
90Excel's key functions and functionalities made easyQuiz
![5730](https://retail-its.dk/learnhub/wp-content/uploads/sites/3/2023/12/321410_d9c5_4.jpg)