Welcome! Course Introduction
  • What Does the Course Cover?
  • Bonus Gift Number 1
  • Bonus Gift Number 2
  • Quiz Number 1
A Quick Introduction to the Basics of Excel
  • Overview of Excel 2016
  • The Excel 2016 Ribbon
  • Working with Rows & Columns
  • Data Entry in Excel
  • Introduction to Formatting
  • Creating Formulas in Excel
  • Microsoft Excel at Its Best - Functions
  • Work Efficiently By Using Cut, Copy & Paste
  • Format Cells
  • Pasting Values, Formulas and Formats with Paste Special
  • Quiz Number 2
Excel Best Practices: Useful Tips & Tools
  • This Is How You Can Start Formatting Your Sheets in a Professional Way
  • Fast Scrolling That Would Allow You to Be 3x Faster
  • Fixing Cell References Properly
  • Using the Alt plus Enter combination
  • Learn How to Organize Your Excel Data with Text to Columns
  • Wrapping Text in Excel
  • Create Easily Printable Documents by Using Set Print Area
  • Find and Select Special Types of Cells with Select Special (F5)
  • Learn How to Assign Dynamic Names within a Model
  • Excel Formulas that Make Sense - Named Ranges
  • Completing 33% of the course
  • Introduction to Custom Formatting
  • Assigning Custom Formats to Specific Cells (Ex. Multiples)
  • Execute 50 Commands with a Single Click - Excel Macros
  • Create a Drop-Down List by Using Data Validation
  • Using Custom Sort in Order to Sort Multiple Columns within a Table
  • Create a Great Index Page at the Beginning of Your Financial Models
  • Freeze the Title Row of Your Table - Freeze Panes
  • Excel's "Tell Me" Search Bar
  • Quiz Number 1
Keyboard Shortcuts in Excel
  • Keyboard Shortcuts Save LOTS of time in Excel
Excel 2016 Functions
  • A helpful consideration
  • Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS
  • Key Functions in Excel: SUM, SUMIF, SUMIFS
  • Key Excel Functions: AVERAGE & AVERAGEIF
  • Completing 50% of the course
  • Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
  • Find the Highest and the Lowest Values in a Range: MAX & MIN
  • Include ROUND in Your Financial Models
  • Transferring Data Efficiently: VLOOKUP & HLOOKUP
  • Use INDEX & MATCH as a Substitute of VLOOKUP
  • IFERROR Allows You to Deal Easily with Error Mesages
  • Excel's Dynamic & Interactive Tables: Pivot Tables
  • Create Flexible Financial Models with the CHOOSE Function
  • Find the Result that You Are Looking For with Goal Seek
  • Include Sensitivity Analysis In Your Model Through Data Tables
  • Quiz Number 2
Create Professional Charts in Microsoft Excel 2016
  • Introduction to Charts in Excel 2016
  • Inserting Charts in Excel & Learning About the Various Chart Types
  • Formatting of Excel Charts (1/2)
  • Formatting of Excel Charts (2/2)
  • Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
  • An Easy Way to Create a Treemap
  • Use Sparklines to Show Data Trends
Build a Complete P&L from Scratch
  • Introduction to the Case Study
  • This Is the data that we will use for our Exercise
  • Let's Reorder our Excel sheet and create a clear structure
  • Introducing a Code: The best way to work with large amounts of data
  • Finishing Touches of our Database
  • Using Vlookup in Order to Transfer Data
  • Applying Sumif in Order to Populate the Database with Numbers
  • Demonstrating How Index & Match Can Successfully Replace Vlookup
  • Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
  • Creating the Structure of the P&L Statement
  • Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
  • Populating the P&L sheet with figures
  • How do We Find Mistakes in the easiest way possible?
  • Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
  • Quiz Number 3
  • Course Challenge - Apply Your Skills in Practice
Practical Exercise - SUMIFS
  • Practical Exercise - SUMIFS
  • Completing 100% of the course