Discover what you can learn.
With video courses for work, study and leisure.
Do you want to learn how to use Excel in a real working environment?
Are you about to graduate from university and start looking 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 when it comes to Financial Modeling in Excel?
If you answered yes to any of these, then this is the right course for you!
A comprehensive guide to Financial Modeling in Excel:
By completing this course, you will:
Microsoft Excel: Introduction | 01:39 |
Microsoft Excel: Course Overview | 01:08 |
Overview of Excel 2016 | 03:32 |
Introduction to the Excel Ribbon | 02:43 |
Working with Rows and Columns | 01:44 |
Data Entry in Excel | 03:00 |
Introduction to Formatting | 05:49 |
Creating Formulas in Excel | 02:54 |
Microsoft Excel Functions | 03:41 |
Working with Cut, Copy and Paste | 02:10 |
Pasting Values, Formulas and Formats with Paste Special | 01:16 |
Introduction to Formatting a Sheet | 01:54 |
Tips for Faster Scrolling | 01:36 |
Fixing Cell References Properly | 02:20 |
Using the Alt plus Enter Combination | 00:54 |
How to Organize Excel Data | 01:52 |
Wrapping Text in Excel | 00:43 |
Using Set Print | 01:17 |
Find and Select Special Types of Cells | 01:30 |
How to Assign Dynamic Names within a Model | 01:27 |
Named Ranges | 01:34 |
Assigning Custom Formats to Specific Cells | 01:34 |
Excel Macros | 03:04 |
Create a Drop-Down List | 01:49 |
Sorting Multiple Columns | 01:28 |
Creating a Index Page | 01:16 |
Freeze Panes | 01:12 |
Keyboard Shortcuts | 04:15 |
Key Functions in Excel: COUNT, COUNTA, COUNTIF | 04:06 |
Key Functions in Excel: SUM, SUMIF, SUMIFS | 04:24 |
Key Functions in Excel: AVERAGE and AVERAGEIF | 01:59 |
Working with Text in Excel: LEFT, RIGHT, MID, UPPER | 02:40 |
Find the Highest and the Lowest Values in a Range | 00:52 |
Include ROUND in Financial Models | 01:01 |
Transferring Data Efficiently VLOOKUP and HLOOKUP | 07:47 |
Use INDEX and MATCH as a Substitute of VLOOKUP | 07:27 |
IFERROR to Deal Easily with Error Messages | 01:43 |
Excel's Dynamic and Interactive Tables Pivot Tables | 02:17 |
Create Flexible Financial Models: CHOOSE | 02:24 |
Goal Seek | 02:17 |
Include Sensitivity Analysis Through Data | 04:10 |
Introduction to Charts in Excel | 01:11 |
Inserting Charts | 02:10 |
Formatting a Chart (Part 1) | 02:29 |
Formatting a Chart (Part 2) | 03:09 |
Creating a Bridge Chart | 06:51 |
Creating a Treemap | 01:31 |
Show Data Trends by Using Sparklines | 03:52 |
Introduction to the Profit and Loss Calculation | 00:51 |
Profit and Loss Calculation: Case Study | 01:06 |
Profit and Loss Calculation: Data of the Case Study | 02:42 |
Profit and Loss Calculation: Create a Clear Structure for the Case Study | 02:16 |
Profit and Loss Calculation: Codes for the Case Study | 01:59 |
Profit and Loss Calculation: Databases for the Case Study | 01:58 |
Using Vlookup in Order to Transfer Data | 05:29 |
Applying SUMIF in Order to Populate the Database with Numbers | 04:06 |
Demonstrating How Index and Match Can Successfully Replace VLOOKUP | 03:51 |
Mapping the Items Within a Database | 02:16 |
Mapping Exercise in the Data Sheet | 01:41 |
Creating the Structure of the Profit and Loss Statement | 02:21 |
Formatting Excel Sheets | 03:17 |
Populating the Profit and Loss Sheet with Figures | 02:47 |
Finding Mistakes | 02:14 |
Calculating Year on Year Growth and Percentage Incidence | 03:08 |