5 Excel Tricks for Self-Updating Spreadsheets (Files Included) @MyOnlineTrainingHub
5 Excel Tricks for Self-Updating Spreadsheets (Files Included)  @MyOnlineTrainingHub
Uploaded August 2024 | Updated November 2026, 4 days ago
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: myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy

💬 EXCEL QUESTIONS: Get help on our Excel Forum: 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
5 Excel Tricks for Self-Updating Spreadsheets (Files Included)Every Excel Person Needs to See This!Automatic Shift Calendar in Excel for Any Year (Free Template)The Mistake Almost EVERY Excel User Makes (Free File)Lock Structured References in Excel Tables (No More Formula Errors)The AI Skill Thats About to Change Finance JobsThe Excel Wildcard Tricks That Separate Beginners from Advanced UsersExcel Fun - Emojis in Sheet Tabs!  #excel #exceltipsExcel Tricks to Save 95% of Your Time on Boring TasksThe Best AI Finance Tool Experts Will Ever Need (Free File)How to Create a QR Code in Excel for Every Need (FREE File)Python Pros Won’t Like This… But It’s Faster for Data Cleaning (Real Project)
MyOnlineTrainingHub |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER