Miss Excel’s Top Productivity Hacks

Focused View

Kat Norton

1:07:44

0 View

01 - Introduction

01 - Lets get productive Excel.mp4

01:20

02 - 1. Cleaning Data

01 - Meet Flash Fill The superhero of Excel.mp4

02:52

02 - Text to columns The CSV file connoisseur.mp4

02:59

03 - Go To Special The blank-removing remedy.mp4

02:52

04 - The Excel glue stick &, CONCATENATE, and TEXTJOIN.mp4

06:14

05 - LEFT and FIND The Excel power couple.mp4

05:22

06 - Ctrl + enter The missing heading magician.mp4

02:33

03 - 2. Analyzing Data

01 - Meet XLOOKUP The new Microsoft lookup function.mp4

03:05

02 - INDEX and MATCH The perfect pair.mp4

05:07

03 - Meet the new filter function.mp4

03:45

04 - The perfect pair PivotTables and PowerPoint.mp4

04:25

05 - Meet SUMs supervisor The SUMIF function.mp4

03:00

06 - Why you need absolute referencing.mp4

04:46

07 - PivotTable grouping tool The summarizing savant.mp4

02:32

04 - 3. Formatting Data

01 - Drop it like its hot with dropdown menus.mp4

02:35

02 - Input messages The art of leaving notes tastefully.mp4

02:44

03 - PSA Cells can format themselves with conditional formatting.mp4

02:38

04 - Rebranding secret weapon Find and Replace by color.mp4

02:54

05 - Grab your jacket, we are freezing our panes.mp4

01:51

06 - Copy and paste visible cells only (not ones youve hidden).mp4

03:43

05 - Conclusion

01 - Using Excel on the daily.mp4

00:27

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Personal Productivity

Kat Norton

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.