Welcome! Course Introduction
  • What Does the Course Cover?
  • Everything We Will Learn Has a Practical Application
  • The Best Way to Take This Course
  • Download All Course Materials and FAQ
Microsoft Excel - Quick Introduction
  • Microsoft Excel: The World's #1 Office Software
  • Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
  • Data Entry Techniques in Excel
  • How to Make Your Spreadsheets Look Professional
  • Data Entry Techniques in Excel
  • Inserting, Deleting, and Modifying Rows & Columns
  • Inserting, Deleting, and Modifying Rows & Columns
  • Excel Formulas for Beginners
  • Excel Formulas for Beginners
  • A Beginner's Introduction to Excel Functions
  • Format Cells
  • Work Efficiently by Using Cut, Copy, and Paste
  • Work Efficiently by Using Cut, Copy, and Paste
  • Pasting Values, Formulas and Formats with Paste Special
Microsoft Excel - Useful Tools
  • Inserting a Line Break with Alt + Enter
  • Do More with Your Sales Data with Excel's Text to Columns Feature
  • Do More with Your Sales Data with Excel's Text to Columns Feature
  • Create Easily Printable Excel Documents
  • How to Wrap Text in Excel and Adjust a Cell's Size
  • Insert Hyperlinks into Excel Spreadsheets
  • Using Excel's Freeze Panes to Handle Large Datasets
  • Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
  • A Quick Introduction to Excel's Pivot Tables
Microsoft Excel - Best Practices That Will Make a Difference
  • Initial Formatting Is Key for Creating Professional-looking Spreadsheets
  • Macros Are a Great Timesaver! Here's Why.
  • How to Use the Same Macro On Multiple Workbooks
  • Macros Are a Great Timesaver! Here's Why.
  • The Secret to Faster Scrolling in Excel
  • Be even quicker: F5 + Enter
  • FAQ: F5 + Enter didn't work for me
  • The Secret to Faster Scrolling in Excel
  • Using Absolute and Relative Cell References
  • Using Absolute and Relative Cell References
  • Find and Select Cells That Meet Specific Conditions
  • Find and Select Cells That Meet Specific Conditions
  • How to Create Dynamic Names in Excel Spreadsheets
  • How to Create Dynamic Names in Excel Spreadsheets
  • Using Named Ranges to Make Formulas More Readable
  • Introduction to Custom Formatting in Excel
  • Custom Number Formatting
  • How to Add a Drop-down List in Excel
  • Using Custom-sort to Sort Multiple Columns Within a Table
  • Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
  • Multiply by 1
  • Find and Replace - References
  • FAQ: Why Do We Replace External References and How Does This Help Us?
  • Find and Replace - Formatting
  • Green References
  • Beauty Saving - The Professional Way of Saving Files
  • The Power of F2
  • Conditional Formatting
  • Quiz Number 1
Microsoft Excel - Beginner, Intermediate & Advanced Functions
  • Key Excel Functions: IF
  • Enlarge the Formula Bar
  • Key Excel Functions: SUM, SUMIF, SUMIFS
  • A Helpful Consideration
  • Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
  • Key Excel Functions: AVERAGE & AVERAGEIF
  • Key Excel Functions: Average & Averageif
  • Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
  • Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE, &
  • Working with Text in Excel
  • Find the Highest and Lowest Values in a Range: Max & Min
  • = and + are Interchangeable When You Start Typing a Formula
  • Use ROUND in Your Financial Models
  • Excel's Lookup Functions: VLOOKUP & HLOOKUP Made Easy
  • INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
  • INDEX, MATCH, and Their Combination - The Perfect Substitute of VLOOKUP
  • Using Excel's IFERROR Function to Trap Spreadsheet Errors
  • A Useful Tool for Financial Analysis - The RANK Function
  • Create Flexible Financial Models with CHOOSE
  • Goal Seek Will Help You Find the Result You Are Looking For
  • Goal Seek Will Help You Find the Result You Are Looking For
  • Perform Sensitivity Analysis with Excel's Data Tables Functionality
  • Perform Sensitivity Analysis with Excel's Data Tables Functionality
  • Quiz Number 2
Microsoft Excel - Financial Functions in Excel
  • Discounting Cash Flows in Microsoft Excel
  • Calculating Internal Rate of Return (IRR) in Excel
  • Using the PMT Function to Create a Complete Loan Schedule
  • Date Functions in Excel
Microsoft Excel - Practical Exercise "Build a P&L From Scratch"
  • Introduction to the Case Study
  • What You Will See Next
  • Understand Your Data Source Before You Start Working on It
  • Ordering the Source Worksheet
  • Creating a Code: The Best Way to Organize Your Data and Work Efficiently with It
  • Learn How to Create a Database
  • Using Lookup Functions (VLOOKUP) to Fill the Database Sheet
  • Using SUMIF to Complete the Database Sheet
  • FAQ: Why Net income should be 0?