Miss Excel’s Top Productivity Hacks

Learn Miss Excel’s favorite productivity hacks for cleaning, analyzing, and formatting data in Microsoft Excel.

Introduction

• Let's get productive: Excel

1. Cleaning Data

• 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

2. Analyzing Data

• 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

3. Formatting Data

• 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)

Conclusion

• Using Excel on the daily