5 Excel Tricks for Self-Updating Spreadsheets (Files Included)

5 Excel tricks that you should know to boost productivity & save time at work. 👩‍🏫 Learn Excel with my courses: https://bit.ly/selfup24courses ⬇️ Download the example file here and follow along: https://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: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://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