@@aniljaggarwal60thank you. Yes, it is true that each video contains a gift of knowledge and a lot of time for preparation. I am giving back to the community a bit of what I received from other Excel experts and content creators. Most of what I learned was from them. I also offer a paid course. Courses offer structure and a wider picture of what we can achieve with Excel.
Hi Celia. What a great tip! It is easy to look past the parameters, even when they are right there in plain sight. Thanks for the heads up on this useful technique. Thumbs up!!
Perfect. I love the way you are teaching us the M language slowly, carefully and with empathy so we will stick with it and reach out to learn more. Thanks again.
Wow - delay Types and use first row as headers in the Excel.Workbook step. So useful. Too bad MS help can't be easier to read. Great job clarifying the jargon
This tip is specifically for the function Excel.Workbook that is used to connect to Excel workbooks and not to PDF files. You can use Data > Get Data > From File > From PDF (this connector may not be available for all the Excel subscription types.)
You are sacrificing all the knowledgeable treasure of Excel on the world, in return you will get the love and respect of the world.
I am not sacrificing anything. The world will be better if now people know more Excel.
@@CeliaAlvesSolveExcel sacrificing means you are giving free of cost it's a good thinkings
@@aniljaggarwal60thank you. Yes, it is true that each video contains a gift of knowledge and a lot of time for preparation. I am giving back to the community a bit of what I received from other Excel experts and content creators. Most of what I learned was from them.
I also offer a paid course. Courses offer structure and a wider picture of what we can achieve with Excel.
Hi Celia. What a great tip! It is easy to look past the parameters, even when they are right there in plain sight. Thanks for the heads up on this useful technique. Thumbs up!!
My pleasure, Wayne! Glad that you found it helpful! ;-)
Thank you, Celia - this is a great tip! It's good that you can understand Microsoft's support guidance - it's very often a mystery to me!!
Ian, Microsoft's documentation is not always easy to understand or helpful at all, but the more you use it, the more value you can get from it.
Amazing, Celia!!!!!!!!!!!!!!!!!!!!!!!
Obrigada, Hugo! Feliz que seja útil. 😉
❤️❤️you Teach very easily.... For this REASON i like you
Thank you so much 😀
@@CeliaAlvesSolveExcel You are most welcome mam❤️❤️
I will be using this tip today. Thanks, Celia!
Awesome!
It's so practice... Thanks for sharing with us Celia!!! Awesome...
You're welcome, Wellington! So nice to see all the data aligning correctly just by changing one word, right? :)
Very useful ! Thank you!!!
Glad it was helpful!
Perfect. I love the way you are teaching us the M language slowly, carefully and with empathy so we will stick with it and reach out to learn more. Thanks again.
Thank you! 😃
Wow - delay Types and use first row as headers in the Excel.Workbook step. So useful. Too bad MS help can't be easier to read. Great job clarifying the jargon
Thanks, Gráinne! The pearls they hide from us... ;-)
Wow, that's a great trick. Which made the work very easy.
One little word only, had all that power! :)
The wealth of knowledge in the world, which you are sacrificing on the people of the world, is a manifestation of your wonderful generosity.
@@aniljaggarwal60 🙏
Good tip
Glad you liked it
Mam can you explain final account..
Sukhlani, can you please explain your question? I am not sure what you need.
@@CeliaAlvesSolveExcel mam can you give your contact number. shall i will send you question..
thanks it's interessant but i tried it with file pdf but with no result is there a way to do it?
This tip is specifically for the function Excel.Workbook that is used to connect to Excel workbooks and not to PDF files.
You can use Data > Get Data > From File > From PDF (this connector may not be available for all the Excel subscription types.)
mam can explain some trick of excel
What kind of tricks are you looking for?