Demo - Overview

This 9-mins. DEMO video will give you a "fast track" overview of relevant Excel techniques:

  • Basic Data Analysis – Sort, Filter & Pivot Table
  • Data Cleaning – Find & Replace, Text To Columns
  • Lookups & Aggregators – Vlookup, Countif, Sumif
  • Logical Statements – IF

NB - These concepts are explained in greater detail in the next few videos.

Please also refer the last lecture if you're a Google Sheet user: "MS Excel vs Google Sheets User Interface"