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

Miss Excel’s Top Productivity Hacks

via LinkedIn Learning

Go to class Write review

Details

Go to class

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

1-2 hours
Sessions

On-Demand

Found in

Overview

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 1105 ratings

Start your review of Miss Excel’s Top Productivity Hacks