5 Excel Tricks for Self-Updating Spreadsheets (Files Included)
109.6 هزار بار بازدید -
3 هفته پیش
-
5 Excel tricks that you
5 Excel tricks that you should know to boost productivity & save time at work.
👩🏫 Learn Excel with my courses: bit.ly/selfup24courses
⬇️ Download the example file here and follow along: bit.ly/selfup24file
We’ve all been there. It’s the start of a new month and you’re now faced with the overwhelming task of updating your Excel files and reports. It’s going to take hours if not days to complete. But it doesn’t have to.
In this video, I’m going to show you 5 Excel tricks you can use to automatically perform common tasks like including new items in drop down lists, updating ranges for formulas, PivotTables, and charts, as well as consolidating data and creating dynamic text labels, so you can get your work done 10 times faster.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/excel-newsletter-sign-…
🎯 FOLLOW me on LinkedIn: www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
==============
0:00 Trick №1: Auto-expanding drop-down lists
4:23 Trick №2: One-click data consolidation
8:19 Trick №3: Self-updating formulas & charts
12:09 Trick №4: Auto-adjusting Excel ranges
17:07 If you want to improve your Excel skills
17:48 Trick №5: Dynamic text labels
#Excel #ExcelTricks #ExcelProductivity
3 هفته پیش
در تاریخ 1403/05/30 منتشر شده
است.
109,667
بـار بازدید شده