Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Miss Excel’s Top Productivity Hacks

via LinkedIn Learning

Go to class Write review
Corporate Finance Institute Ad

Master Finance Tools - 35% Off CFI (Code CFI35)

Learn More → Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn Miss Excel’s favorite productivity hacks for cleaning, analyzing, and formatting data in Microsoft Excel.

Syllabus

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

Taught by

Kat Norton

Reviews

4.8 rating at LinkedIn Learning based on 4949 ratings

Start your review of Miss Excel’s Top Productivity Hacks

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.