Top 25+ Excel, Tips and Shortcuts to Boost your Productivity [2021 and beyond]
Use these top 25+ Excel tips and tricks to improve your efficiency and become more productive using #Excel at work.
Updated for 2021!
📃 Resources mentioned in the video:
Effective Charts and Visualizations: https://www.udemy.com/course/effectiv...
Excel Speed Boosters: https://datacycleanalytics.com/work-f...
Deal with Duplicates: https://datacycleanalytics.com/8-cool...
⌚ Timestamps
Use these to jump to any section in the video:
00:10 List Management
06:40 Formatting Tips: Format Painter
08:21 Fill Blanks in Split Second
10:33 Basic Excel Formulas
15:42 Date Functions
18:04 Excel Smart Tables
23:01 Drop-Down (Pick) Lists
27:43 Quick Access Toolbar as a Speed Booster
31:26 The Intelligent Flash Fill
34:08 Combining text -TEXTJOIN, &, CONCAT
36:31 Charting Tips
42:05 Key Keyboard Shortcuts
46:14 Printing Tips
50:11 Paste-Special Features
54:33 Identify and Remove Duplicates
58:52 Analyze and Summarize with Pivot Tables
_____________
Don't miss out on more of these time-saving Excel techniques!
🔔 SUBSCRIBE:
/ @williamthedataprof
_____________
Polish up your charting and data visualization skills. Get this FREE eBook:
https://datacycleanalytics.com/boardr...
🚩 Connect with me on social:
Facebook: / billwilliamsk
LinkedIn [personal]: / william-kiarie
LinkedIn [company]: / data-cycle-analytics-ltd