Master Excel functions that return dynamic references to automate updates.
👩🏫 Advanced Excel Formulas course: https://bit.ly/reference25course
⬇️ Download the example file here and follow along: https://bit.ly/reference25file
Imagine this: you’ve built a nice Excel report, everything looks great. Then you add data for the next month, but your charts and formulas don’t automatically update. So, you spend time manually editing the chart and formula to include the new data.
Sound familiar? It doesn’t have to be that way because Excel can automatically adjust your charts and formulas whenever new data is added.
There are two ways we can achieve this.
With Excel Tables, we can add a new row of data, and you can see the chart and formula automatically include it. However, the problem with tables is they don’t work with dynamic array formulas that spill, and you can only use their structured references on whole columns, which won’t work if you require a specific range of cells.
And this is where Excel’s functions that return references come in handy.
In this video, I’ll show you the functions that return dynamic references, so your spreadsheets update themselves: no mistakes, no wasted time. Including some exciting new functions.
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 Function №1
4:59 Function №2
6:41 Function №3
8:09 Function №4
9:38 Function №5
10:11 Function №6
11:57 More functions
#Excel #ExcelFunctions #ExcelFormulas