Lectures

In-class slide decks, reconstructed as notes.

  1. Lec 01: Sorting, Filters & Database Functions

  2. Lec 02: IF Statements & Logical Functions

  3. Lec 03: Calendars & Date Calculations

  4. Lec 05 - Time Functions & Protecting Cells

  5. Lec 08: VBA Macros

  6. Lec_04-Date Functions, Named Ranges & Data Validation

  7. Lec_07-Pivot Tables

  8. Lookups with XLOOKUP and INDEX MATCH