Overview
-
Learn Miss Excel’s favorite productivity hacks for cleaning, analyzing, and formatting data in Microsoft Excel.
Syllabus
-
Introduction
- Let's get productive: Excel
- Meet Flash Fill: The superhero of Excel
- Text to columns: The CSV file connoisseur
- Go To Special: The blank-removing remedy
- The Excel glue stick: &, CONCATENATE, and TEXTJOIN
- LEFT and FIND: The Excel power couple
- Ctrl + enter: The missing heading magician
- Meet XLOOKUP: The new Microsoft lookup function
- INDEX and MATCH: The perfect pair
- Meet the new FILTER function
- The perfect pair: PivotTables and PowerPoint
- Meet SUM's supervisor: The SUMIF function
- Why you need absolute referencing
- PivotTable grouping tool: The summarizing savant
- Drop it like it's hot with dropdown menus
- Input messages: The art of leaving notes tastefully
- PSA: Cells can format themselves with conditional formatting
- Rebranding secret weapon: Find and Replace by color
- Grab your jacket, we are freezing our panes
- Copy and paste visible cells only (not ones you've hidden)
- Using Excel on the daily
