Create a List of Sheet Names using Power Query... With 2 ways Navigation

[@k.b.jayakumar5136]

Hats off Sir. Excellent presentation with very informative content. Thank you very much indeed!

[@Samu-gz3qj]

Finally, I landed a right place to learn excel tricks! Thank you❤❤❤

[@manishpanwar1421]

No one cud explain this before in such manner. Wonderful 🤝🤝

[@Officeinstructor]

Glad you liked my teaching style

[@zuhairalmutawa9941]

Excellent tutorial, Thank you Mr. Nabil.

[@vincysigma]

Waw..Very nice trick. This helped me a lot.. Thank you Sir.

[@Officeinstructor]

I am glad you found it useful ,Vincent. By the way I would like to invite you to join a FREE Excel Master Class that I will be delivering for 90 minutes on 27 January 2021 at 5:30 PM (EST) . It is a Free event but requires registration by clicking on the link : www.meetup.com/MSExcelToronto/events/275407502 Please share this event on your social platforms

[@erikguzik8204]

ok, well I have Office 365, not sure if there have been changes or not, I don't use PQ that often and not familiar with all the ins and outs of it... When I try to do the first step, go to PQ, you now select Get Data, From File, From XL workbook. I select the file name..."Index of Sheet Names with Power Query.xlsx". Then Press IMPORT. I get an error saying "The process cannot access the file {file name} because it is being used by another process" it's like it won't work on open workbooks now????????

[@KhalilYasser]

That's awesome Nabil. In my opinion this is better than using formulas or VBA. Easy and quick steps. Best Regards

[@Officeinstructor]

Totally agree

[@malikastar9265]

Thank you, that was helpful

[@rajiviyer9682]

Thanks a lot for the wonderful explanation Nabil. I have 4 questions: 1) Does Power Query not work on .xlsb extension? 2) How to ensure the Index created with file names update if I add or delete sheets? It's not happening in my file even after I refresh the query. 3) How to ensure the order of the sheet names changes in the Index if I move around the sheets in the workbook? 4) Does this not work if I try to get data from workbook from a file saved in OneDrive? I get the error that the file is already in use.

[@Luciano_mp]

Power Query much easier and practical, thanks for all methods.

[@Officeinstructor]

Luciano, I cannot imagine posting a tutorial without reading your nice comments that I love.... Thank you dear.

[@prasadmds]

🙏 Well Explained 🙏

[@Officeinstructor]

Glad you liked it

[@AjayAnandXLnCAD]

Awesome!

[@GeertDelmulle]

Very finely done! Thank you!

[@Officeinstructor]

Glad you enjoyed it

[@patrickschardt7724]

I’m becoming a huge fan of power query. Normally I like formulas, but you have to use the macro function get workbook. That means I had to save the file as a macro enabled workbook. IT doesn’t always like that

[@Bhavik_Khatri]

Excellent vid!

[@vijaysahal4556]

very useful 👍🏻👍🏻👍🏻👍🏻👍🏻

[@zaighamuddinfarooqui1705]

Awesome. 👌

[@hazemali382]

more than great ♥

[@subhasisg]

Hi, Thanks for such a beautiful tutorial. I am in an additional need. Actually I have a workbook of 50 sheets. In each sheet I want to add a column at the beginning which is the name of the worksheet. Say Sheet 1(named IP1) is having details for an IP Address. In column A I want to add the IP Address (IP1) for all the rows in the sheet. Similarly in sheet IP2, I want to populate the A column with IP2. This way I want to do for all the Sheets with their respective sheet names. Note that Column A is currently not empty. Can you help?

[@Officeinstructor]

Thanks for watching. Unfortunately I cannot answer your question without seeing a sample data. And because KZbin is not intended for this type of support, I recommend posting your question on techcommunity.microsoft.com I'm sure you will get answers. Good luck

[@ahmedkhalifa73]

أشكرك كثيرا على المعلومات الفيمة والممتعة في الوقت نفسه، الطريقة التي أعجبتني وأفضلها هي استعمال الصيغ ، ختى وإن كانت ظريقة Power Query أفضل وأسرع ،إلا أنه تبقى عندي طريقة الصيغ مفضلة عندي أكرر شكري والسلام

[@Officeinstructor]

Thank you Abou Abdel Rahman.... I did not know the name of Power Query in Arabic until you mentioned it... I am very happy to learn it Sorry, I do not have an Arabic keyboard to answer in Arabic... I will have to get one shortly

[@ctdivers557755]

Yes Hats off. Looking forward to more excellent presentation and content. Power Query is much easier. My tabs are dates in text format and I need to convert them into date format. How can I do that? 121020 need to convert to 12/10/20.

[@reng7777]

Hi Mr. Nabil I have a question for you that i have not been able to solved yet in Power Query do yuo have an email where to write it?

[@LotfyKozman]

Thanks so much for using the magic PQ. Please check your LinkedIn inbox.

[@Officeinstructor]

Will do .... we'll Talk very soon

[@SamehRSameh]

Plz record whole tutorial about power query ,power pivot & power Bi

[@Officeinstructor]

Will do shortly

[@SamehRSameh]

@@Officeinstructor Thanks .. All thing concerned data analysis (power query, power pivot and power BI) collected in one playlist

[@alexzz1659]

It works without single quotation.HYPERLINK("#"&[@[Sheet Name]]&"!A1",[@[Sheet Name]])

[@Officeinstructor]

Thank you