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

5 Excel tricks that you should know to boost productivity & save time at work.

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
===========



⏲ 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

[MyOnlineTrainingHub]

❓What's the Excel task that makes you want to pull your hair out?

[chrisbanks]

It's rare that a tips video has examples on things I do every day for each example, but this is one. Really nice tips for sure, thank you!!

[SantoshKumarPakki-fd]

Thanks for letting us know new concepts..each and every time😊

[sentralorigin]

i wish i forgot how to use Excel so i could learn it all over again with you

[francisaranha]

I absolutely love your videos! Thank you for making life easier. I already knew many of these things, but you have shown me a new way to use them.

[jasongins]

Hi! I recommend disabling the Background Refresh in the query. This will prevent the pivot table from updating until the query is finished, and you will no longer need to hit refresh twice. If you right click on the query, you will find it among the options.

[stevenlagoe]

So clear and easy to follow, as always. 👍👍

[HandelMcHandel]

I had forgotten about Treemaps - thanks for reminding me - great video!

[Adam_K_W]

Thanks for this one! I've not used Tree Maps in the past but I can imagine several scenarios in my various files and reports where they will be very handy!

[merrillmchenry]

Brilliant again! Great job knowing to use the offset formula to do this was/is great! Kudos.

[michaeldavenport]

Outstanding! These are going to make me look like a Rockstar! Thank you for this

[chrism]

Thanks Mynda, this is great (as usual) !

[JonBushell]

Your channel is really great. Thanks. Re looking at all my spreadsheets now.

[ExcelWithChris]

I learn something new EVERY time!! Thanks.

[dholcombpa]

Nice. Thanks for this. I'm hoping the ideas in section 4 will help me with dynamic data in pie charts and the desire to remove blank (or 0% values) from the resulting chart. Can't wait to dig into this.

[patrick.schommer]

The formula to find the last actual value threw me. When choosing the final parameter (1 - Less Than), the tool tip indicates it will find the largest value that is less than or equal to lookup_value. That statement makes it seem like it will find the largest value in column D. The formula works even if the Sep value is less than the largest value.
I put the MATCH part of the formula into Copilot for some help, and it replied MATCH assumes a sorted list when using "1 = Less Than" as the final parameter. This inherent assumption finally made the formula make sense to me.
For you:
a) Do you agree with Copilot on the assumed sorted list assumption for MATCH? This is a very clever trick for finding the latest entry in a list. I like clever.
b) Your videos are excellent and right at or just above my level of Excel understanding. Perfect to improving my skills!

[mraza]

Awesome video, and thanks for teaching us these tips. Helpful stuff. I will definitely look at your paid training content.

[murrayh-c]

Really great tutorial. Can you tell me how you added icons to your slicer please?

[profemanuperez]

Thank you for sharing your great knowledge in Excel. This video is very interesting, as usual. Please, let me ask you something about the last part of it. When you talk about using INDEX(first column of the table, MATCH...) wouldn't be easier to use COUNTA(third column) in the second argument of INDEX instead of the MATCH function?

[ernesttsape]

Thank you so much for sharing this. This is so valuable. May be just one question: What's the difference if I just create a pivotchart from the figure instead of using the OFFSET function? Will this make any difference as the pivotchart will be simpler, faster and will also be dynamic? Thanks in advance for your answer