Excel Essentials Course

Ben walks you through his custom cheat C-O-D-E to unlocking your inner Excel ninja. M0: Introduction & Setup – What is Excel, what options should I use, who is Ben, creating your first spreadsheet, and overall course structure. M1: Creativity & Complexity – How to think like a spreadsheet and plan your Excel documents in advance. Early tools for Excel success including Date & Time functions and formatting techniques. M2: Objective & Outputs – Here we focus on thinking about the output of your Excel spreadsheets and what you’re trying to get out of them. Also covers Conditional Formatting, Pivot Tables, Reporting & Math Functions. M3: Data & Drivers – The inputs for your model and how to drive towards the output you want. Also covers Lookup & Reference Functions, Data Validation, and Tables. M4: Error-Proofing & Explanation – Making sure your spreadsheets are bullet-proof and easy to explain to others. Includes Logical Functions, Text Manipulation Functions, and Macros!