Hi, I watched your video and then looked up how to use an index/match/index function. It looks like it performs basically the same as an index/match/match function. It’s one of the most powerful functions available in Excel that I use. I think coming up with a good naming convention for your data tables is fairly important as well. So is learning how to anchor a formula built from a table. This allows you to copy formulas over without the references changing when you do. An example of how I name my data tables would be _Tbl_Data_2024. Thanks for putting the video out there. I’m always looking for better ways to do things within Excel.
Apply for a free coaching session: www.johannesnyari.com
Hi, I watched your video and then looked up how to use an index/match/index function. It looks like it performs basically the same as an index/match/match function. It’s one of the most powerful functions available in Excel that I use. I think coming up with a good naming convention for your data tables is fairly important as well. So is learning how to anchor a formula built from a table. This allows you to copy formulas over without the references changing when you do. An example of how I name my data tables would be _Tbl_Data_2024. Thanks for putting the video out there. I’m always looking for better ways to do things within Excel.
Hope you make more videos breaking down each skillset and its subsets.
Awesome work
Yes, definitely in the planning!
Thank you for sharing this data
Insightful. Much Appreciated. Would like more of such content in future
Thanks, I will start posting new videos again soon!
Thank you for the video. How long (on average) does it take to learn Excel's important skills?