Miss Excel’s Top Productivity Hacks
- Offered byLinkedin Learning
Miss Excel’s Top Productivity Hacks at Linkedin Learning Overview
Duration | 1 hour |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Miss Excel’s Top Productivity Hacks at Linkedin Learning Highlights
- Earn a sharable certificate
Miss Excel’s Top Productivity Hacks at Linkedin Learning Course details
- The course introduces learner to her favorite productivity hacks for cleaning, analyzing, and formatting data in Excel
- These tips and tricks can save learner hours each week and help learner do more with data
- Course covers the hottest topics in Excel including the new XLOOKUP function, dropdown menus, Flash Fill, and more
Miss Excel’s Top Productivity Hacks at Linkedin Learning Curriculum
Introduction
Let's get productive: Excel
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
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
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
Miss Excel’s Top Productivity Hacks at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?