Excel - Advance Indirect Function with Official table | Xl Studio |
Hi Guys, hope you guys doing well !!
Everyday most of the people works on excel report manually or semi automate the report using VBA Code or using Power Query. In this Video will learn about INDIRECT function which is basic function but very powerful and will combine with Official table to build fully dynamic report without any much efforts or complex functions.
INDIRECT function indirectly refer to the cells, define names and headers in official table.
This video will show you how you can prepare/transform/organize the dataset, the lookup data or mapping table to utilize INDIRECT function with Official Table to build any fully Dynamic reports in Excel
1. Format or prepare the report format
2. Set/Prepare/Format/Organize the Raw Data set or dependent data set
3. Organize the calculation/lookup/mapping data set
4. Apply the INDIRECT or any other functions to build the dynamic report
====================================================
If you like the content please do like the video and please make sure to subscribe and hit the bell icon so you never miss any of the videos
Thank you so much for Watching !!
=======================================================
XL Studio