I'm grateful for your excellent tutorials. I have a question: How do you handle a folder containing multiple workbooks, where each workbook has several worksheets?
I've used data from the web successfully. What do you do when the data is on several different pages and you have to click Next to get to it. Is it possible to import several pages at once?
@@KenjiExplains I disagree with you, because the video uses a folder with monthly files. But, since you decided not to make the data available, I can't force you to do so. I'm just sorry. 🤗
I was expecting a solution other than using Power Query. I have inherited files from my manager with the model and calculations built in. If I try to import data using Power Query, I will have to build the model all over again.
🚀 FREE 50 Excel Hacks Template from Hubspot: clickhubspot.com/093k
Great trick!! Thanks Kenji
never thought of this but actually useful thanks
Glad to hear it!
Thanks, really helpful ❤
I am super excited to purchase your career track in future Inshallah Allah sir appreciate your hard work and consistently effort
Thank you! :)
I'm grateful for your excellent tutorials.
I have a question:
How do you handle a folder containing multiple workbooks, where each workbook has several worksheets?
I've used data from the web successfully. What do you do when the data is on several different pages and you have to click Next to get to it. Is it possible to import several pages at once?
There is no practice file, How to practice and learning SIR, Tell me
Dear Kenji,
The link to download the video's excel file is missing. 🤗
Hey didn’t create one this time as there’s not much to download. I’d suggest replicating these steps with your own excel files for this video!
@@KenjiExplains I disagree with you, because the video uses a folder with monthly files. But, since you decided not to make the data available, I can't force you to do so. I'm just sorry. 🤗
👍
Can you share MIS EXECUTIVE excel task videos 😅
I was expecting a solution other than using Power Query. I have inherited files from my manager with the model and calculations built in. If I try to import data using Power Query, I will have to build the model all over again.
Still waiting for Python video