Hai Mike, how are you? I am from Kuala Lumpur Malaysia.. First time writing to you.. Thank you very much for your guidance.. I have learn a lot and it helps significantly in my line of work as certified accountant. I developed my own accounting solution using most of the power query tools to transform business transactions data into automated journal entry and thus generating accounting ledger which automatically calculates account ledger balance and thus generating trial balance... Just my question is, how to assess on computer workstation specification in dealing with large business data Is there any ways of data file organisation OR better Power Query tools which has more efficient in terms of data processing or I should upgrade to i6 processor? If you are okay, can you shoot me an email at azlanm03@yahoo.com Then I can explain further the issues of data processing time Thank you very much Mike
I do not know the answer to this question. You might try posting a question to this form: www.mrexcel.com/forum/index.php and click on BI section. Or search for Microsoft Power BI Forums.
The last 13 minutes or so of the video is worth watching multiple times. Your definition of what a pivot table is makes what's happening under the covers so much more understandable. I don't think I've ever seen a pivot table described like that but it makes you appreciate that they are so much more than just summary reports.
brianxyz, I have defined PivotTables like that for the past 10 years. In all my Highline Class I have posted over the last 10 years (Excel Basics, Highline Class, Statistics Class and more) I have defined it that way. If you are a student in my classes you get multiple quiz and test problems that ask the definition. The good news is, that as a teacher, I repeat, repeat, repeat all the import things many times, so viewers can eventually find the useful details about Excel somewhere among the 3000+ videos : ) The bad news is that PivotTables have been partially defined as Summary Reports for the past 30 years. One time about 15 years ago, I was in an interview and they asked the final question (that was supposed to trip up the potential candidate): "What is a PivotTable?" I of course answered in full detail: "Summary report that makes calculations with conditions or criteria with row and column criteria...." The interviewer looked at me like a confused dog and asked: "what do you mean calculations with criteria?" I looked back like an even more confused dog and explained to the interviewer that each cell was a separate calculation with multiple criteria... As you say, brianxyz: "pivot table described ... are so much more than just summary reports". Yes they are: they are THE great Data Analysis tool ever invented. BTW, Microsoft did not invent the PivotTable. It was Lotus 123 that introduced a separate tool called Lotus Improv created by lead programmer Pito Salas back in 1989.
Just read up on Lotus Improv on Wikipedia. Very interesting history and a great example of bad marketing and/or not knowing how to market a product. Mike, did you ever use this product? What was the performance like? I like your interview story. Was the person impressed enough to give you the job?
Majestic Mike, simply majestic, Mike! You are the Very Best -- bar NONE! :-) This series is compact and action-packed -- makes your the "Jack Bauer" of Excel learning channels here on youTube. It is very nice to see that you in your typical super-efficient way are integrating everything we've learned in the myriad of EMT videos on these subjects: just wonderful. Oh, and those visuals,... those visuals, OMG! They make it so easy to understand and follow the reasoning. Just perfect! In consequence: your power style for explaining things is so good that it makes watching other channels into an unbearably inefficient waste of time -- they're just not as action-packed as your videos. So in conclusion: to those wanting to learn these Power Tools: don't waste your time on other channels: you've got your one-stop-shop for Excel right here! Enjoy!
There are Series of Phrases given, In every phrase there is one color basis on color in phrase I have to lookup its assigned to whom basis on other table. how will i do this
Even though the user interface is different in some of the MSPTDA classes, the foundation of data analysis with MS tools learned in this free class is still rock solid good four years on : )
I think you just have to turn off the enable background refresh on the query connection. What it does is that it will refresh the query in the background and that means multitasking the other refresh like pivot when the query hasn't completely loaded all data to pass on to the pivot. This is completely helping me in my job. I am so grateful to Mike and his tutorials. I hope you help a lot more people. Just amazing!
I was confused about what to do during the lock down in India because of COVID19. Now I started following this course and I think I can meaningfully spend the balance lock down period to learn so many new concepts. I really like your systematic approach and minute things like naming the sheets etc., Great man! I create Excel tutorials in my mother tongue Tamil and I really like your video editing style also. Zooming into the window wherever required!
Mike, I love the way you put the chapter markers - I could quickly scan them and know whether I need to watch any part or not. For this video, I just quickly went to minute 10:01 to check out the option about not changing data types and skipped the rest of the video as I knew all the other content. Very good time-saver.
Brilliant video and resources. Filtering the files to include in the folder path is a game changer! Literally hours of my working week have bene saved! Thank you.
You are welcome TRUE Poet Artist and Master of Power Query Bill Szysz !!!!! Hey, maybe you can answer the questions from Matt Schoular and Bart Titulaer below!?!?! I did not know the answer...
I am as new to this stuff as they come. I only know what these videos teach. Other than that, consider me a soccer mom. My point is that at first I was gonna just thumbs up the comment. For me to do a double take and realize that I am about to give a thumbs up to a comment which happens to be from Bill Sycz, means I have been watching these videos. And now for the icing. These two men still. Still consider each other as brilliant. It was difficult to not become emotional for them and for myself for recognizing this as well. When it comes to this stuff, I may as well be from Australia, ( the land down under). 🙂. So I would imagine that it has that widespread effect on others. Much respect, Guys. Pooowwwer Quuueeerry. It used to feel like 👿. Now it feels like 😎. You are at the slicer part, Mike. 🤔 I gotta go. Gotta rewind.
Thank you, Mike it's a very smart video of Power Query. This video could save me more than 5 h/week at my previous job (the slicers from the second part of the video are BRILLIANT ). Currently, I'm between the jobs but I'm happy to learn from one of the best teachers of Excel.
Thank you for your kind words! The good news is that even though you are between jobs, your next boss in your next job can NOT wait to have you as an employee with your new Excel Skills!
Well... RRR, I have used many visuals in past videos too, but yes, for this series I want the communication to be as efficient as possible, so I will then have to use lots of efficiently fun visuals! Thank your for your consistent support : )
Thanks for this amazing video. I am literally using the entire MSPTDA playlist to educate myself on Power Tools. I also find very useful the homework files. I am doing them diligently :)
That is why I post - to educate for free : ) For each video you learn from, just click thumbs up, leave a comment if you want, and tell all your friends about excelisfun : )
Great tutorial Mike. This example of having several excel files in a folder and incrementally increase the number of files does indeed have a great relevance out there in the business. Sometimes ERPs produce these incremental files based on timestamp considerations. And thanks for the files, I followed each step along with you.
Yes, providing the files to follow along and the practice homework problems is very important for learning : ) Glad the videos are great for you, Giuseppe! Thanks for the support : )
I have seen some of your videos and they all are amazing. I have read you want us to pay you back just with our comments and likes. I think you deserve so much more but at least, you will always have my comments. THANK YOU SO MUCH!!!
Yes, 1877Pegasus, that is all I charge: a comment and thumbs up on each vid. That makes us a Team, i make and post and you can comment and thumbs up : )
Great 30 minutes time spent learning more about PowerQuery! This is a good refresher on how to work with multiple workbooks and appending into a single table. Must know concept for Excel experts! Thanks for putting this together; on to video MSPTDA05 :)
Another great one, Mike! I liked learning about the Query default settings (auto-change-type) and Pivot Table defaults. With each of these PQ adventures, I am feeling more comfortable, beginning to grasp what is going on. I feel I am at the cusp of the very familiar transition where a new technology doesn't just seem like voodoo, really working only for the gurus teaching it.
Glad it is helping! Many more videos to come. Be sure to help support this free resource with those Thumbs Ups, Comments when you are inspired and tell all your friends : )
Hai Leila, how are you? I am quite a fan of your videos and hoping that we can be collaborator between us I studies extensively on Microsoft Power Tools and am hoping that maybe I can refer to you on personal basis if you are okay pls shoot me an email at azlanm03@yahoo.com If you read my comment reply above to MIke, I am heavy user of Microsoft Power Query developing journal entry tables to generate accounting ledger for my work purpose The thing that I am yet to really explore is Microsoft Power BI and I have checked your videos and woww.. there is a lot to learn on presentation skills Anyway, thank you for your for videos .. it does enlightened me
Thanks man. So loading from excel is an easy example. What would be more challenging is loading from text file and doing all the code to make it a table like excel. Inspired from your example, I have made my way to solve the situation I have. great video man.
Thank you very much. God Bless. The course is beautiful. Now I'm in the middle of lecture 004. Very understandable lectures flow, Attached xls and summary in pdf make it very comprehensive.
Guess what? I did skip the Netflix session and just followed the #03 tutorial. Thanks for that one too. Oh yes, another thing. I just got your book Ctrl+Shift+Enter this week. And am happy to have seen in this video, what you describe as the golden rule :-). Looking forward to more.
Wow, never knew (a) that I could updated the default PivotTable layout or (b) that Data Model PivotTables inherently avoid having to update the number format of output fields... amazing.
i always use VBA in this situation .. but most power point of this method is if you add file to this folder .. just refresh connection :) thanks for this very cool series.
Yes, Microsoft really hit a home-run with Power Query and the new Power Tools! No need for VBA here. You are welcome for the very cool series, Mohamed!!!!
Thanks you for the kind words, Hope! I am glad that you like the free resources : ) Thanks for the support on each video with your comments, Thumbs ups and a Sub : )
Awesome! Yes, the homework is usually quite fun. Wait until you get to my favorite homework below video MSPTDA 8.5 : ) Thanks for your consistent support, Peter.
@@excelisfun3903 thank you for the response Actually I am considering change my job right now I have fully confidence that I can get a good job when I finish your class!!
I like the rule filtering at 15.14. I use this for error catching input files. I rely on multi-user generated input files so this helps make sure the data in is sound.
Hi Mike, Thanks a lot for the video. Actually I have seen this example in one of your Power Query series, but this video is go into another level. I like the way you explain details of each step, and building a picture to illustrate a concept. It made me clearly understand. Furthermore, you also gave a pdf file which it contained every techniques of the video. You're amazing! P.S. Another option to refresh both Table (linked to Power Query) and Pivot Table (linked to the Table) at the same time is using Ctrl+Alt+F5. However, it will be good if the Refresh All button can do ^___^
I am glad that the pictures help to illustrate the concepts!!! If you like the pictures to help tell the story, there is much more to come in this class, especially with DAX Formulas. Thanks for the refresh tip, but I thought I did show that in this video... Maybe it was video 03. Thank you for your support, Nattawut, with your comment, Thumbs up, Subscription, and pleas etll all your friends about the fun pictures and Excel cool tricks : )
I shared your video last week and the feedback was good. Lots of Likes & Shares. You can see it from this URL facebook.com/reportingengineer/posts/2159495010960272 Thanks again for the video. I'm a big fan of you. If you have a chance to visit Thailand, please give me buy you lunch(s) ^___^
Thanks for watching, Wajdi!!! I won't stop if you keep click that Thumbs Up and leave on comment on each video because then we are both addicted : ) This series will continue for about nine months with one or two videos each week : )
Please make a playlist for the Microsoft DA-100 Exam and you will be officially the best Excel & Power BI youtube channel of all time. You are already my choice for study, thanks a lot for the amazing knowledge you give for free!
ALWAYSSSSS Greattttt videossss..... never tired of watching ur videos..... Also, lately I have been doing lots of Rstudio..... for machine learning and other cool stuff...
Yes, Power Query is the best thing Microsoft has invented since the PivotTable!!! Glad the extra files are fun too. Thanks for the support, Excel.i Adam : )
Mike, you can actually just click “data > refresh all” twice and it will refresh pivot tables and charts the 2nd refresh. That way you don’t have to go to pivot tables and charts and right click refresh.
I love it too !!!! It takes so long top make a video with Excel files, pdf notes, homework and all... So it will be about 4 days. Thanks you for the support, Karl - it really helps in keeping to make videos : )
I just wanted to add this comment. Some of your followers, do not use an English version of Excel and because of this, some transformation steps cause errors (Text to Currency or Decimal) because, for example, the character used for the decimal is not the same (comma in French and point in English). I suggest you add a topic (or step) in the pdf to indicate how to set the "Query Regional Settings" to make Power Query recognize the source data format in the appropriate way.
One more video completed in this series. I am sure no book is going to be so comprehensive. Mike Girvin you are the master. This video was even better. I am sure this has solved the problems of many people who have problems with so many workbooks where they need to combine the data and perform analysis on it. Your video series keeps getting better and better every time i move ahead. Looking forward to your training videos. Thanks a ton. Just one last thing, how is geographical data such as country name, state name and city name or zip code managed in Power BI, I have used Tableau and Tableau has a dedicated Geographical data type. Is there anything similar to that in Power BI.
Anyone please help! When I try to do the step at 14:00 I keep getting this error: "Feedback Type: Frown (Error) Error Message: Value cannot be null. Parameter name: key Stack Trace: Microsoft.Mashup.Evaluator.Interface.ErrorException: Value cannot be null. Parameter name: key ---> System.ArgumentNullException: Value cannot be null. Parameter name: key ---> System.ArgumentNullException: Value cannot be null. ...and a lot of lines go on and on below" Has anyone had to deal with this? Many thanks!
Yes!!!! That is why I post all the videos and files and notes, so you can come back to them any time. Thank you for your comments each time you watch, hamed!!!!
Homework practice problems are now listed below video. pdf notes are there too.
is worth it to do the hw practice problems, so thank you Mike for posting them :)
You are welcome! Practice makes perfect : )
Hai Mike, how are you?
I am from Kuala Lumpur Malaysia..
First time writing to you..
Thank you very much for your guidance.. I have learn a lot and it helps significantly in my line of work as certified accountant.
I developed my own accounting solution using most of the power query tools to transform business transactions data into automated journal entry and thus generating accounting ledger which automatically calculates account ledger balance and thus generating trial balance...
Just my question is, how to assess on computer workstation specification in dealing with large business data
Is there any ways of data file organisation OR better Power Query tools which has more efficient in terms of data processing or I should upgrade to i6 processor?
If you are okay, can you shoot me an email at azlanm03@yahoo.com
Then I can explain further the issues of data processing time
Thank you very much Mike
I do not know the answer to this question. You might try posting a question to this form: www.mrexcel.com/forum/index.php and click on BI section. Or search for Microsoft Power BI Forums.
Thanks mike
Thank you so much, for the content Professor Girvin. I have studied E-DAB and am now at MSPTDA 04.
Yes!!!! I am glad you will study both : )
Remove columns and order them at the same time was the most impressive skill I saw in this video
Glad it helped!!!
The last 13 minutes or so of the video is worth watching multiple times. Your definition of what a pivot table is makes what's happening under the covers so much more understandable. I don't think I've ever seen a pivot table described like that but it makes you appreciate that they are so much more than just summary reports.
brianxyz, I have defined PivotTables like that for the past 10 years. In all my Highline Class I have posted over the last 10 years (Excel Basics, Highline Class, Statistics Class and more) I have defined it that way. If you are a student in my classes you get multiple quiz and test problems that ask the definition. The good news is, that as a teacher, I repeat, repeat, repeat all the import things many times, so viewers can eventually find the useful details about Excel somewhere among the 3000+ videos : ) The bad news is that PivotTables have been partially defined as Summary Reports for the past 30 years. One time about 15 years ago, I was in an interview and they asked the final question (that was supposed to trip up the potential candidate): "What is a PivotTable?" I of course answered in full detail: "Summary report that makes calculations with conditions or criteria with row and column criteria...." The interviewer looked at me like a confused dog and asked: "what do you mean calculations with criteria?" I looked back like an even more confused dog and explained to the interviewer that each cell was a separate calculation with multiple criteria...
As you say, brianxyz: "pivot table described ... are so much more than just summary reports". Yes they are: they are THE great Data Analysis tool ever invented. BTW, Microsoft did not invent the PivotTable. It was Lotus 123 that introduced a separate tool called Lotus Improv created by lead programmer Pito Salas back in 1989.
Just read up on Lotus Improv on Wikipedia. Very interesting history and a great example of bad marketing and/or not knowing how to market a product. Mike, did you ever use this product? What was the performance like?
I like your interview story. Was the person impressed enough to give you the job?
ExcelIsFun good one mike
I've worked through this several times and love the use of Excel.Workbook and the extraction of what's needed. Simply brilliant.
You are welcome, william!!!!
Majestic Mike, simply majestic, Mike! You are the Very Best -- bar NONE! :-)
This series is compact and action-packed -- makes your the "Jack Bauer" of Excel learning channels here on youTube.
It is very nice to see that you in your typical super-efficient way are integrating everything we've learned in the myriad of EMT videos on these subjects: just wonderful. Oh, and those visuals,... those visuals, OMG! They make it so easy to understand and follow the reasoning. Just perfect!
In consequence: your power style for explaining things is so good that it makes watching other channels into an unbearably inefficient waste of time -- they're just not as action-packed as your videos.
So in conclusion: to those wanting to learn these Power Tools: don't waste your time on other channels: you've got your one-stop-shop for Excel right here! Enjoy!
Thanks for the very kind words about the content I make! Your support means a lot and helps me to keep making more fun visuals and all : )
There are Series of Phrases given, In every phrase there is one color basis on color in phrase I have to lookup its assigned to whom basis on other table. how will i do this
Thanks Mike for such an amazing video! 4 years passed by but it never gets old :)
Even though the user interface is different in some of the MSPTDA classes, the foundation of data analysis with MS tools learned in this free class is still rock solid good four years on : )
I think you just have to turn off the enable background refresh on the query connection. What it does is that it will refresh the query in the background and that means multitasking the other refresh like pivot when the query hasn't completely loaded all data to pass on to the pivot.
This is completely helping me in my job. I am so grateful to Mike and his tutorials. I hope you help a lot more people. Just amazing!
You are welcome, Red!!!! Thanks for your support with your comment, thumbs up and your Sub : )
❤️😍love your teaching style
: ) : )
I could spend a week learning excel from you and still continue to be amazed.
Glad all the materials help, Yashvardhan!!! Thanks for your support : )
I watched several videos on power query but non of them clear my concept. Your video is indeed helpful. Thanks sir
You are welcome, AFZAL!! I am glad that the resources that I post can help. Thanks for your support with your comment, thumbs up and your Sub : )
I was confused about what to do during the lock down in India because of COVID19. Now I started following this course and I think I can meaningfully spend the balance lock down period to learn so many new concepts. I really like your systematic approach and minute things like naming the sheets etc., Great man! I create Excel tutorials in my mother tongue Tamil and I really like your video editing style also. Zooming into the window wherever required!
I am so glad that I can help during this diffident time in our world history. Thanks for your comment, thumbs up and of course your Sub : )
I have just completed the first four videos. You are doing a terrific job Mike.
Glad you enjoy the class, Denis!!!
Mike, I love the way you put the chapter markers - I could quickly scan them and know whether I need to watch any part or not. For this video, I just quickly went to minute 10:01 to check out the option about not changing data types and skipped the rest of the video as I knew all the other content. Very good time-saver.
Brilliant video and resources. Filtering the files to include in the folder path is a game changer! Literally hours of my working week have bene saved! Thank you.
Yes!!!!! I love to hear that there are game changer tips for your work, Holly!!!
Brilliant. This is the most comprehensive explanation on this topic I have ever seen.
Thanks MASTER Mike!!!!
You are welcome TRUE Poet Artist and Master of Power Query Bill Szysz !!!!! Hey, maybe you can answer the questions from Matt Schoular and Bart Titulaer below!?!?! I did not know the answer...
BTW, I learned it all from you : ) So I am the one that must thank you : ) : ) : )
We all learn from each other :-)) So, i also thank you :-))))
Go Team!!!!
I am as new to this stuff as they come. I only know what these videos teach. Other than that, consider me a soccer mom. My point is that at first I was gonna just thumbs up the comment. For me to do a double take and realize that I am about to give a thumbs up to a comment which happens to be from Bill Sycz, means I have been watching these videos. And now for the icing. These two men still. Still consider each other as brilliant. It was difficult to not become emotional for them and for myself for recognizing this as well. When it comes to this stuff, I may as well be from Australia, ( the land down under). 🙂. So I would imagine that it has that widespread effect on others. Much respect, Guys. Pooowwwer Quuueeerry. It used to feel like 👿. Now it feels like 😎. You are at the slicer part, Mike. 🤔 I gotta go. Gotta rewind.
Thank you, Mike it's a very smart video of Power Query. This video could save me more than 5 h/week at my previous job (the slicers from the second part of the video are BRILLIANT ). Currently, I'm between the jobs but I'm happy to learn from one of the best teachers of Excel.
Thank you for your kind words! The good news is that even though you are between jobs, your next boss in your next job can NOT wait to have you as an employee with your new Excel Skills!
I never thought of a pivot table like this! Your definition made me rethink. Thanks as usual Mike.
You are welcome, Timmy!!!!!
So, lately you are using many visual images for better understanding.... thats totally AWESOMEEEE
Well... RRR, I have used many visuals in past videos too, but yes, for this series I want the communication to be as efficient as possible, so I will then have to use lots of efficiently fun visuals! Thank your for your consistent support : )
Thanks for this amazing video. I am literally using the entire MSPTDA playlist to educate myself on Power Tools. I also find very useful the homework files. I am doing them diligently :)
That is why I post - to educate for free : )
For each video you learn from, just click thumbs up, leave a comment if you want, and tell all your friends about excelisfun : )
Great tutorial Mike. This example of having several excel files in a folder and incrementally increase the number of files does indeed have a great relevance out there in the business. Sometimes ERPs produce these incremental files based on timestamp considerations. And thanks for the files, I followed each step along with you.
Yes, providing the files to follow along and the practice homework problems is very important for learning : ) Glad the videos are great for you, Giuseppe! Thanks for the support : )
I have seen some of your videos and they all are amazing. I have read you want us to pay you back just with our comments and likes. I think you deserve so much more but at least, you will always have my comments. THANK YOU SO MUCH!!!
Yes, 1877Pegasus, that is all I charge: a comment and thumbs up on each vid. That makes us a Team, i make and post and you can comment and thumbs up : )
Great 30 minutes time spent learning more about PowerQuery! This is a good refresher on how to work with multiple workbooks and appending into a single table. Must know concept for Excel experts! Thanks for putting this together; on to video MSPTDA05 :)
You are welcome, Tom R!!! Thanks for your support : )
dear Mr. Mike to be honest you are unconditional in excel thank you so much.
You are welcome so much, Ismail!!!! Thanks for the unconditional support : )
Loved this one too. Thanks Mike.
Love is good : )
One of the best video to insert file name and tab name as columns in the database
Another great one, Mike! I liked learning about the Query default settings (auto-change-type) and Pivot Table defaults. With each of these PQ adventures, I am feeling more comfortable, beginning to grasp what is going on. I feel I am at the cusp of the very familiar transition where a new technology doesn't just seem like voodoo, really working only for the gurus teaching it.
Glad it is helping! Many more videos to come. Be sure to help support this free resource with those Thumbs Ups, Comments when you are inspired and tell all your friends : )
You have cleared my concept thankyou so much to design video in such a beautiful way. Each and every point is crystal clear.
dude, you are my hero!! I love your style of teaching. Thank you so much for the effort.
Yes!!!!! We are a Team: I make and post, you watch, learn and comment & Thumbs Up : )
Thank you for all the practice files! Great video on Power Query :)
You are welcome for the files and Power Query Fun : )
Hai Leila, how are you?
I am quite a fan of your videos and hoping that we can be collaborator between us
I studies extensively on Microsoft Power Tools and am hoping that maybe I can refer to you on personal basis
if you are okay pls shoot me an email at azlanm03@yahoo.com
If you read my comment reply above to MIke, I am heavy user of Microsoft Power Query developing journal entry tables to generate accounting ledger for my work purpose
The thing that I am yet to really explore is Microsoft Power BI and I have checked your videos and woww.. there is a lot to learn on presentation skills
Anyway, thank you for your for videos .. it does enlightened me
Why you not added this technique in your Udemy course
Thanks man. So loading from excel is an easy example. What would be more challenging is loading from text file and doing all the code to make it a table like excel.
Inspired from your example, I have made my way to solve the situation I have. great video man.
Mike, thank you for a fantastic tutorial. You hit all the topics I needed and I loved following your time-saving best practices.
You are welcome, I am happy to help, Vikram!!!!
Thanks is not enough. Really appreciate your devoted hard work for people.
You are welcome, Amena!!!
Top Gun!! Your teaching makes it so simple, so easy to follow...Thx a lot...
Glad it helps and is simple : )
Thank you very much. God Bless. The course is beautiful. Now I'm in the middle of
lecture 004. Very understandable lectures flow, Attached xls and summary in pdf
make it very comprehensive.
You are welcome for the full free course, Boris! Thanks for helping me with your comments and thumbs ups on each video and of course your Sub : )
Your videos are great, excellent pace, and very informative!
Glad they help you, Artemas !!
Guess what? I did skip the Netflix session and just followed the #03 tutorial. Thanks for that one too. Oh yes, another thing. I just got your book Ctrl+Shift+Enter this week. And am happy to have seen in this video, what you describe as the golden rule :-). Looking forward to more.
Thanks for buying the book - it is s great formula book. Lots more fun to come! Thanks for your support, Giuseppe!
Such passionate teaching! Thanks Mike :)
You are welcome!
Thanks a lot (from France) for this great video, and the incredible work you have done
Wow, never knew (a) that I could updated the default PivotTable layout or (b) that Data Model PivotTables inherently avoid having to update the number format of output fields... amazing.
Amazing..... I am a newbie to excel and the videos are simple & gripping..... superb
I am glad that they help, harifitfun!!!!
This was absolutely great! The visuals, homework problems, and pdfs to go along with videos are simply amazing! Thank you so much!
You are absolute Excel Ninja & Guru... Really amazing videos. I would like to thank you for your kind efforts.
Astonishingly well made video. Absolute summit!
Glad you like it!
Just as expected. This is just amazing. Everthing clearly explained!
Glad there is clarity, Elcidio : )
wonderful videos..best channel for Excel undoubtedly...Great work Mike
Glad all my videos help, Simple Solutions!!!!
i always use VBA in this situation .. but most power point of this method is if you add file to this folder .. just refresh connection :)
thanks for this very cool series.
Yes, Microsoft really hit a home-run with Power Query and the new Power Tools! No need for VBA here. You are welcome for the very cool series, Mohamed!!!!
You are the BEST TEACHER EVER!
Thanks you for the kind words, Hope! I am glad that you like the free resources : ) Thanks for the support on each video with your comments, Thumbs ups and a Sub : )
Mike, thank you very much for so structured materials.
You are welcome for the structured materials! Thanks for your support with comments and thumbs ups : )
Hi Mike- nice video again. The documents and working files your provide are really helpful - thanks! Off to try the homework.
Awesome! Yes, the homework is usually quite fun. Wait until you get to my favorite homework below video MSPTDA 8.5 : ) Thanks for your consistent support, Peter.
Thank you Mike, complete, clear and easy to follow explanation.
You are welcome, enrique!!! Thank you for your support : )
Content explanation is awesome, I can't wait to try the exercise to apply same as a trial.
Thank you Mike.
I love these MSPDA videos! I'm learning alot. Thanks ExcelIsFun!
You are welcome for the MSPTDA videos, Chris Miller!!!! Thank you for your support with your comment, Thumbs Up and Sub : )
Who else still watching in 2023 ... Let's Master Power Query from Mike
Yes!!!!! Power Query is great in any year : ) : )
me
Another great video! I'm glad on the Pivot Table Tabular format selection default capability in O365!
Yes, Office 365 is the only Excel to have : ) Thanks for your support, Teammate!
does someone still see the video in 2021??? it's really a good series on excel I like it so much thank you!!
Yes, this is still a useful class!!!
@@excelisfun3903 thank you for the response
Actually I am considering change my job right now I have fully confidence that I can get a good job when I finish your class!!
@@Pudding5034 That is great : ) Thanks for your support with your thumbs ups and comments for the free classes : )
I like the rule filtering at 15.14. I use this for error catching input files. I rely on multi-user generated input files so this helps make sure the data in is sound.
And homework! Masterpiece :) Thank you, Mike!
You are welcome, Teammate Malina : )
Nice Video. *Excel.Workbook* function - superhero in this video. thanks Mike !!!
Yes, indeed!!!!
Mike, on a 28:05 moment you could also click Refresh All twice and that would work too. Thanks for the great video!
Cool, thanks for the tip, Alexandr!!! Thanks for watching and for your support : )
Thanks. Its great learning source with homework to practice or revise the topics. 👍
Hi Mike,
Thanks a lot for the video.
Actually I have seen this example in one of your Power Query series, but this video is go into another level. I like the way you explain details of each step, and building a picture to illustrate a concept. It made me clearly understand.
Furthermore, you also gave a pdf file which it contained every techniques of the video. You're amazing!
P.S. Another option to refresh both Table (linked to Power Query) and Pivot Table (linked to the Table) at the same time is using Ctrl+Alt+F5. However, it will be good if the Refresh All button can do ^___^
I am glad that the pictures help to illustrate the concepts!!! If you like the pictures to help tell the story, there is much more to come in this class, especially with DAX Formulas. Thanks for the refresh tip, but I thought I did show that in this video... Maybe it was video 03. Thank you for your support, Nattawut, with your comment, Thumbs up, Subscription, and pleas etll all your friends about the fun pictures and Excel cool tricks : )
I shared your video last week and the feedback was good. Lots of Likes & Shares. You can see it from this URL
facebook.com/reportingengineer/posts/2159495010960272
Thanks again for the video. I'm a big fan of you.
If you have a chance to visit Thailand, please give me buy you lunch(s) ^___^
Thanks for your support! There are many more videos in this series, and over the next nine months I will post about 1 - 2 videos a week : )
I'm looking forward to seeing videos of this series. It's amazing and so fun. ^__^
(Actually, all of your videos are fun)
I become addicted to your videos ;) please do not stop!otherwise I will ... :p
Many thanks Mike
Thanks for watching, Wajdi!!! I won't stop if you keep click that Thumbs Up and leave on comment on each video because then we are both addicted : ) This series will continue for about nine months with one or two videos each week : )
Please make a playlist for the Microsoft DA-100 Exam and you will be officially the best Excel & Power BI youtube channel of all time. You are already my choice for study, thanks a lot for the amazing knowledge you give for free!
You are the king of Excel
I am just a guy having fun with excel! You are great to help me with the support of your comment, Thumbs Up and Sub : )
Great lesson. Thank you Mike!
Many thanks, Mike.
Many you are welcomes, Ian!!!!
ALWAYSSSSS Greattttt videossss..... never tired of watching ur videos.....
Also, lately I have been doing lots of Rstudio..... for machine learning and other cool stuff...
Glad the videos help, RRR!!!! Thanks for your support... I have never tried Rstudio... I guess it is because I spend all my time producing videos...
Ya.... I have come long way majorly contributed by YOUR videos.... your works is of highest level....
Load data from folder is amazing Power Query tool
and extra files you gave just magnificent 🏆👍😊👍🏆
Yes, Power Query is the best thing Microsoft has invented since the PivotTable!!! Glad the extra files are fun too. Thanks for the support, Excel.i Adam : )
Mike, you can actually just click “data > refresh all” twice and it will refresh pivot tables and charts the 2nd refresh.
That way you don’t have to go to pivot tables and charts and right click refresh.
Great tip, canefan17!!!!
Wow... That was amazing 😍, need to learn more n more
Thanks a lot sir.....
You are welcome!
Excelisfun, for me, is the best place raleted with Excel. Congratulatins and thank you very much.
Glad the web site helps! Thanks for the support, Sergio, with your comments, Thumbs Ups and Sub : ) Many more videos to come.
I just love the function excel.workbook. Great video can’t wait for next week
I love it too !!!! It takes so long top make a video with Excel files, pdf notes, homework and all... So it will be about 4 days. Thanks you for the support, Karl - it really helps in keeping to make videos : )
Great video Mike. Thanks for the tip on the pivot table tabular default settings....
You are welcome, for the video and Default Settings for PivotTable! Thanks for the support : ) : )
Hello Mike, this episode is very interesting, I just learned one or two tips that were unknown to me.
Thank you for sharing
I just wanted to add this comment. Some of your followers, do not use an English version of Excel and because of this, some transformation steps cause errors (Text to Currency or Decimal) because, for example, the character used for the decimal is not the same (comma in French and point in English). I suggest you add a topic (or step) in the pdf to indicate how to set the "Query Regional Settings" to make Power Query recognize the source data format in the appropriate way.
different way of teaching 👍👍👍👍👍👍
Glad you like that different way, vijay!!! Thank you for your consistent support : )
Power Query fireworks. Great video. Thanks for posting.
You are welcome, Tim!!! Thanks for your support!!
simply lovely!!
One more video completed in this series. I am sure no book is going to be so comprehensive. Mike Girvin you are the master. This video was even better. I am sure this has solved the problems of many people who have problems with so many workbooks where they need to combine the data and perform analysis on it. Your video series keeps getting better and better every time i move ahead. Looking forward to your training videos. Thanks a ton. Just one last thing, how is geographical data such as country name, state name and city name or zip code managed in Power BI, I have used Tableau and Tableau has a dedicated Geographical data type. Is there anything similar to that in Power BI.
Amazing Video thank you. I was wondering how import from a folder and take hidden sheets from the excel files in power query?
Anyone please help!
When I try to do the step at 14:00 I keep getting this error:
"Feedback Type:
Frown (Error)
Error Message:
Value cannot be null.
Parameter name: key
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Value cannot be null.
Parameter name: key ---> System.ArgumentNullException: Value cannot be null.
Parameter name: key ---> System.ArgumentNullException: Value cannot be null.
...and a lot of lines go on and on below"
Has anyone had to deal with this? Many thanks!
You are awesome, as always! Please keep up doing humanity good :) be blessed.
Thanks Mike. Adapting your O365 to my Excel 2013 is fun.
Yes, there is quite a difference in the versions. You, my friend, should just get O365 ; )
Your videos are everything. Thank you for your hard work!
Glad it is "everything" for you, aduck24!!! Thanks for the support on each video with your comments, Thumbs Ups and Sub : )
Perfect video that I was looking, thanks🙏
🤯I'll have to watch this one again to grasp all that. Thanks💜
That is what is so good about video teaching: the rewind button : ) Thanks for your consistent support and purple hearts!
you are the best mate......
Thanks for your kind words : ) : )
Amaaaaazinggg videooooo oooon paaawer queeryyy!! 👍🏻
Liked the video first, commented next and now i will watch ha!
Thank you very much for your support - it does help me to keep going with the long hours of creating fun content : )
ExcelIsFun Hey Mike when do we see more ExceisFun vs Mr Excel videos? It has been a couple of months now.
P.s - love that Spiderman kind of intro
I am not sure when more Duels happen. Mr Excel is in the middle of a huge book project right now : ) Soon, I hope.
Just Great! Cannot wait for next lecture!!
Just Thanks, Wonjin!!!! Thank you for your support : )
Mike, another incredible video! Happy Independence Day!
You are welcome, Chris!!!! Thanks for watching on July 4th : )
Greate Video, Thanks a lot, After 1 years I am watching again it
Yes!!!! That is why I post all the videos and files and notes, so you can come back to them any time. Thank you for your comments each time you watch, hamed!!!!
@@excelisfun
Thank you again, 1 year ago that was my first and important tutorial in Data Science
@@hamednouri4574 Yes!!! I love to hear that.
Thanks very much. Another brilliant video.
I really got a lot out of that video. playlist has 161....great!...and thanks!
Glad to hear that, Stephen! Thanks for the support with your comments and thumbs ups : )
Thank you very much sir! I am learning a lot from you!
Glad that you are learning a lot, especially the Excel.Workbook function to go and get objects from an Excel File : )
Exactly! I don't feel I waste a minute when going through your videos! Such rich content! Amazing!
@@871340730 Yes!!!!
Wonderful Mike, thanks for the video.
You are welcome for the wonderful, Ahmed : )
Powerful stuff. Super video Mike!!
Thank you, DRSteele : ) Glad you like it !!!
WOW SIR GREAT ONE
Glad you like it, Lear More!!! Thanks for your support, Teammate!
Sir, my respect. Thanks for this data.
Thanks, it's a great Video. i have learn alot
Thank you! How did you put that SharePoint Folder Option at 7:21? Thanks