Miss Excel’s Top Productivity Hacks
1h 8mIntermediate2022-03-03
Authors
Kat Norton
Microsoft MVP | Chief Excel Officer at Miss Excel
Course details
Want to become an Excel power user? Follow along with Excel MVP Kat Norton, a.k.a. Miss Excel, as she introduces you to her favorite productivity hacks for cleaning, analyzing, and formatting data in Excel. These tips and tricks can save you hours each week and help you do more with your data. Kat covers the hottest topics in Excel including the new XLOOKUP function, dropdown menus, Flash Fill, and more.
Skills covered
SpreadsheetsMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Let's get productive - Excel
1. Cleaning Data
- 02 - Meet Flash Fill - The superhero of Excel
- 03 - Text to columns - The CSV file connoisseur
- 04 - Go To Special - The blank-removing remedy
- 05 - The Excel glue stick - &, CONCATENATE, and TEXTJOIN
- 06 - LEFT and FIND - The Excel power couple
- 07 - Ctrl + enter - The missing heading magician
2. Analyzing Data
- 08 - Meet XLOOKUP - The new Microsoft lookup function
- 09 - INDEX and MATCH - The perfect pair
- 10 - Meet the new FILTER function
- 11 - The perfect pair - PivotTables and PowerPoint
- 12 - Meet SUM's supervisor - The SUMIF function
- 13 - Why you need absolute referencing
- 14 - PivotTable grouping tool - The summarizing savant
3. Formatting Data
- 15 - Drop it like it's hot with dropdown menus
- 16 - Input messages - The art of leaving notes tastefully
- 17 - PSA - Cells can format themselves with conditional formatting
- 18 - Rebranding secret weapon - Find and Replace by color
- 19 - Grab your jacket, we are freezing our panes
- 20 - Copy and paste visible cells only (not ones you've hidden)
Conclusion
- 21 - Using Excel on the daily