HomeОбразованиеRelated VideosMore From: ExcelIsFun

Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360)

1124 ratings | 117091 views
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to other tables, and then build DAX Calculated Columns & Measures for Gross Profit that can be used in a Dynamic Dashboard with Map, Column Chart, Line Chart, Card and Slicer visualizations. During the whole process we will compare and contrast how the process is similar and different from Excel’s Power Query and Power Pivot DAX. The steps we will see in this video are: 1. (00:17) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard 2. (04:50) Import Multiple Excel Files From Folder 3. (05:44) Name Query 4. (06:02) Transform extension column to lowercase 5. (06:34) Filter Files to only include “.xlsx” file extensions 6. (07:05) Remove Columns 7. (07:18) November 2016 Power Query Update Problem 8. (08:05) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File. 9. (09:40) Delete Content Column 10. (10:41) Filter to only include Excel Sheet Objects 11. (11:06) Filter to exclude sheets that contain the word “Sheet” 12. (11:40) Remove Columns 13. (11:51) Expand Data and Sheet Name Columns 14. (12:06) Change Field Names 15. (12:22) Change Data Types 16. (14:05) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type. 17. (15:59) Remove columns for Amount and Revenue Discount 18. (16:10) Close and Apply to add to Data Model 19. (17:05) Import Excel Manager Table. Change Data Types to Text. Close and Apply 20. (18:10) Create Relationship between Zip Code Columns 21. (19:03) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type. 22. (21:53) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing. 23. (24:28) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing. 24. (25:35) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers) 25. (26:20) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers) 26. (27:15) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage 27. (28:19) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage 28. (28:45) Create Slicer for States. 29. (29:00) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage. 30. (29:57) Summary Learn Power BI Desktop Basics. Introduction to Power BI Desktop. Getting Started with Power BI Desktop. Create Impactful Reports With Power BI Desktop. Microsoft Power BI.
Html code for embedding videos on your blog
Text Comments (145)
cruz cancel (17 days ago)
I tried the if statement to create Sales Type (calculated column) but keep getting an error Sales Type = IF(SalesZipData[Units]<6,"Retail","Wholesale") the syntax for "Retail" is incorrect. Help
Venkatesh Prasad (19 days ago)
Fantastic...great video , very informative and a great vocal style
ExcelIsFun (18 days ago)
Glad you like it, Venkatesh!!! Thank you for your support with your comment, Thumbs Up and Sub : )
Rusa Phillip (23 days ago)
If you updated the files in the folder, will the data in the visualization update automatically ?
ExcelIsFun (23 days ago)
You ahev to click Refresh button : )
Darren Steyn (1 month ago)
THIS REALLY HELPED ME UNDERSTAND POWER BI!!! THANK YOU!!!!!!!!!
ExcelIsFun (1 month ago)
You are welcome, Darren!!!! I am glad that it helped. Thank you for the support with your comment, Thumbs Up and Sub : )
Noemi Roecklinger (1 month ago)
Many thanks for this video, your are so motivating!!!
Pradyuman Singh Negi (1 month ago)
very interesting and and informative video.... keep those comming, Thank you
Ismail Ismaili (2 months ago)
this is amazing really love it thank you so much Mr. Mike
ExcelIsFun (2 months ago)
You are welcome, Ismail Ismaili!!!!
Anil Kishore (3 months ago)
Guess you missed the Dashboard part - Or please correct me if I am wrong
Ivan Shaw (5 months ago)
WHAT AN AWESOME TUTORIAL!
ExcelIsFun (5 months ago)
Glad it helps, Ivan!!!! Than you for the support with your comment, Thumbs Up and Sub... cuz many more vids to come : )
Thuy Nguyen Duong (5 months ago)
Your videos are amazing! I’ve learnt a lot from them. Thank you very much for sharing, Mike :x.
ExcelIsFun (5 months ago)
You are welcome!!! Thanks for the support, Thuy, with your comments, Thumbs Ups and Sub : )
John Borg (6 months ago)
Amazing!!!! I have been going through different Power BI videos to learn more. Amazing what we can get for free from Microsoft. It feels like having the World at my fingertips. :) :)
ExcelIsFun (6 months ago)
Nothing like searching the excelisfun channel to fund useful old posts, right? Thanks as always for the support, John!!!
Eddie Zee (6 months ago)
Hi there, While following through your tutorial I have noticed at 23:04 when you are applying Currency Format I cannot seem to use the Formatting feature as it is disabled for some reason. Is this due to the fact that Microsoft has changed some functionality since the time you recorded your video or perhaps some of my settings are not optimal. Your advice is solicited. Thanks.
Eddie Zee (7 months ago)
Sir you are doing an excellent job here. I checked the site for downloading your training files and was overwhelmed by the amount of stuff you have. I can truly appreciate the time and effort you have spent in this gigantic task. My question for you sir is if someone wants to follow your tutorials both on Excel and Power BI what order should they follow? For instance I attempted to follow along your EMT 1366 ahead of watching the EMT 1360 video and was going nowhere. Once I saw 1360 it makes a lot of sense to me how Data Transformation is performed. I request you indicate some kind of sequence on your web site or with in the YouTube channel suggesting an order in which to follow the trail of your videos. I don't want to sound as if I am complaining. If it was up to me I'd nominate you for sainthood. Thanks again for opening a world of possibilities and opportunities for me.
ExcelIsFun (7 months ago)
I do not know of a good book for Power BI. And I am not a true expert in Power BI, I am an expert in Excel.
Eddie Zee (7 months ago)
Sir, thanks again for your prompt response. I have some questions around 1360 video. The part where you are importing a folder in to Power BI desktop. You have indicated that Headers need to be added when importing a folder. I wonder how will I learn what steps need to be done and in what specific order? I wonder if you can recommend a book or source that can be referenced for these kinds of situations. Thanks again you are a phenomenal resource with an admirable sense of customer service. I wish there were more people like you in my life.
ExcelIsFun (7 months ago)
No, no, all of us humans have a hard time with that. The truth is that I have classes (playlists) that are systematic and complete when you watch the videos in order, like Excel Basics, Excel Advance, Array Formulas; but I have no such playlist for Power Query, PowerPivot, DAX and Power BI Desktop. I am sorry about this - but I am working on it and over the next year these systematic and complete playlists (classes) on the Power BI tools will be released.
Eddie Zee (7 months ago)
Thanks for the feedback. The links for the Playlists are fantastic. However one clarification I need is whether the Playlists are to be followed in the sequence of numbering for the videos or the order as they appear in the Playlist? For instance the Power BI playlist displays the EMT 1366 video on top and I watched it first but was lost. However when I saw 1360 it made a lot more sense. The sequence of following the Playlist is very important for me personally. Some people may be smart enough to follow regardless of the order but I am a bit obtuse that way.
ExcelIsFun (7 months ago)
Thank you for the kind words, Eddie! For Excel, all of the tricks of Excel are presented systematically in the two classes that I teach for free at YouTube: 1) Excel Basics Playlists: https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k 2) Advanced Excel Playlists: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw then if you want Power BI, you can choose from these playlists: 1) Power Query: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK 2) Power BI Desktop: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k_h8ORYyh7waGfuiiufu6H 3) DAX Formulas: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW Also, over the next year, starting in about a month, I will post an entire class playlist of Power BI in a systematic playlist - so watch for that. If the videos help you, please help me by Subscribing and clicking Thumbs Up on every video you watch and leaving comments when so inspired to do so.
Shanchita Rahman (8 months ago)
Excellent video at a glance for power BI beginning.
ExcelIsFun (7 months ago)
Thank you - glad that you liked it! Many more to come - thanks for the support with a Sub, Thumbs Up and your comment : )
Tina Toves (9 months ago)
Thank you! This by far has been the best tutorial I have seen so far!
ExcelIsFun (7 months ago)
Thank you - glad that you liked it! Many more to come - thanks for the support with a Sub, Thumbs Up and your comment : )
faustdw88 (9 months ago)
Great work! Thanks! :)
ExcelIsFun (7 months ago)
Thank you - glad that you liked it! Many more to come - thanks for the support with a Sub, Thumbs Up and your comment : )
Kistna Alper (9 months ago)
Thank you so much - very informative!  Would love to hear more.
ExcelIsFun (7 months ago)
Thank you - glad that you liked it! Many more to come - thanks for the support with a Sub, Thumbs Up and your comment : )
Yves Seybel (10 months ago)
Awesome tutorial - a first for me in Power BI. Very cool. Downloaded your files and followed along :) Same comment as Jian below on ZIP codes populating outside of US. Not sure the map has a country filter. It looks like it can work with Lat/Lon. I tried to load the same data set through PowerQuery and plot on Power Map; the same issue - which is a MS Office bug :)
Gurkaran Singh (10 months ago)
Great tutorial
ExcelIsFun (7 months ago)
Thank you - glad that you liked it! Many more to come - thanks for the support with a Sub, Thumbs Up and your comment : )
Jian Zhou (10 months ago)
Hi Mike, I want to report on the zip code 96907 supposed to be a place in California. Instead bing think it is a place in Mexico. And zip code 98242 it shows Lithuania... anyway to correct this?
Yves Seybel (10 months ago)
I found the same issues on both ZIP codes. This may be a bug on how the map sees ZIP codes. Will need to investigate more on this. The fact there is a state name doesn't seem to impact the map settings. Looks like Microsoft is still debugging Power BI.
Bhushan Chandanshive (10 months ago)
Hi, When I add custom column i got this error "Expression.Error: The name 'True' wasn't recognized. Make sure it's spelled correctly". Please advise.
Tabriz Alikhanov (11 months ago)
Thank you very much for detailed explanation.
Lee Hofweber (11 months ago)
No one teaches Excel better than Mike!
silvia calzada (11 months ago)
When I tried to represent the zip codes in the map is not working.... any idea why?
Azhar Baitham (1 year ago)
Hey! thanks for spreading excel love! I have a hurdle, do we need any specific formatting of the data to import into Power BI. Does it imperative to "Pivot" or format data with any innate excel formats before importing it to BI? Thank u
Sanket Swami (1 year ago)
where i can get the data?>??
R V (1 year ago)
thanks
ATM SHIRAJUL HAQUE (1 year ago)
Mr Mike has become my Excel and Business Intelligence mentor. I owe a lot for his excellent teaching and presentation.
Ack S (1 year ago)
Question, how can Net Revenue be calculated if Amount of Sale & Revenue Discount are removed?
Sunil Viswanathan (1 year ago)
Excellent Video! Gave me an end to end foundation on Power BI!!
justin dao (1 year ago)
This man's vocal cadence makes me happy.
Florencia Mociulsky (1 year ago)
tks!!
Chethan R Nayak (1 year ago)
=Excel.Workbook([Content]),true). Even after entering the right formula I am shown with error after entering this formula while getting excel files from 'Content'. any idea why is this happening?
Idan Edry (1 year ago)
so why not use power pivot?
Eamonn Kelly (1 year ago)
Thanks Mike outstanding presentation
ExcelIsFun (1 year ago)
Glad it helps!
Afzal Khan (1 year ago)
Excellent as usual... This is the Era of Power power and powerrrr.......and we needd moreee power tutorial.... You are the best teacher currently on youtube for everything related to Excel...
ExcelIsFun (1 year ago)
Thank you for your kind words : )
Adan Trotter (1 year ago)
Hello! I need some help with my power bi report and no on at my work is using it. I am the only one. Would you be interested in helping me? thanks!
D Arms (1 year ago)
Mike this was an awesome video training!!! Thanks for referencing PowerBI it's huge time saver.
ExcelIsFun (1 year ago)
You are welcome!
leandro bellini (1 year ago)
Thanks Mike! Excellent video! Regards from Brazil!!
ExcelIsFun (1 year ago)
EXCELlent!!!! Glad it helped : )
Mickael Taieb (1 year ago)
You're the man!
ExcelIsFun (1 year ago)
I am glad that the videos help! Thanks for the Sub, comments and Thumbs Up on each video : )
André Niquet (1 year ago)
You are a hero ... thank you so much for sharing your knowledge. And for a not native English speaker you are very clear ... I have been strugling with formatting a number in a table (no decimals) and found it very frustrating that you cannot change the formatting, Now i realize you have to manage this on a dataset level :) Enjoy your weekend. kind regards from Holland, André
Edwin Weir (1 year ago)
Do you have, or plan on creating, a Power BI tutorial series?
Edwin Weir (1 year ago)
That's awesome news. Your tutorials have greatly helped me expand my abilities with Excel.
ExcelIsFun (1 year ago)
Yes, over the next few months I will create an epic Data Analysis / Power BI free YouTube Video class that will cover Excel Formulas, Standard PivotTables, Power Pivot, Power BI Desktop and DAX in full detail. Keep watch, it should start in about a month.
Mathijs (1 year ago)
Hi Mike,Is it possible to download the data of the querys from power BI?Lets say you have 10 mln records but in the report you see strange data and want to dive into and analyse it.
Carl Turso (1 year ago)
You are the best there is! Thank you.
ExcelIsFun (1 year ago)
I am glad that the videos help! Thanks for your Sub and Likes : )
kaegchaiya (1 year ago)
Wow! This is the best tutorial for learning BI. Keep up the good work.
Z M (1 year ago)
this the best video I've seen on Power BI. Forget about any other places, ExcelsFun is the best place to learn!
Scott Phelps (1 year ago)
Very, very, awesome!  Clear, concise and relatively easy...I like this product. Thanks!
ExcelIsFun (1 year ago)
You are welcome!
Ron Kelley (1 year ago)
The best introduction to the possibilities and use of Power BI that I have ever seen. Thanks.
ExcelIsFun (1 year ago)
Glad you liked it! Thanks for the Sub and Thumbs Up : )
Charles Darwin (1 year ago)
One of the best tutorials ever. Neat, clean, crisp and perfectly paced. Keep it up Mike - a treat to watch!
ExcelIsFun (1 year ago)
I am glad you like it! Thanks for your kind words, Thumbs Up and Sub : )
Roland Kc (1 year ago)
how do we get the search box in a slicer?
Yacine Freifer (1 year ago)
I got an error on the visualisation, i got the map but when selecting gross profit i get the comment: couldnt load the data of this visual SalesZipData Total revenue the function SUm takens an argument that evaluates to numbers or dates and cannot work with the values of type string
ExcelIsFun (1 year ago)
Awesome! I am glad that I built in a rewind/replay button so you could power your way to a success!
Yacine Freifer (1 year ago)
Ahh i did the tutorial again and managed to find my mistake. Untick the prefix and format properly. THank you :)
Erikson Tsang (1 year ago)
thanks for the video. I've been trying to setup percent complete S-curve (x-axis = dates, y-axis=percent %) for the project, which shows the baseline (planned) percent complete vs (actual to-date + forecast). My input source of percent complete is coming from the scheduling software (Primavera P6). I don't see any sample on how to setup an S-curve anywhere. Would you able to help me out on this?? thanks
George Klucsarits (1 year ago)
Great presentation! I've started testing Power BI in a large, corporate environment as we consider replacing/augmenting some other BI tools. This video is a great introduction that I'll be sharing to help introduce new users to the features and functionality. Make sure you're getting these highlighted in the Power BI forum!
ExcelIsFun (1 year ago)
Thank you for the information and for the insight! I will keep making videos and posting : )
George Klucsarits (1 year ago)
I've found the Power BI community that's available through powerbi.microsoft.com to be very helpful. On the homepage, check Learn > Community for some links to discussion and help forums. I think your videos would be an excellent resource to go along with Microsoft's Guided Learning videos. The Microsoft training materials are very good but I found your videos to be a little more helpful in bridging the gap for the end users. Also, a lot of Excel users are familiar with your other lessons and that makes the transition that much easier.Thanks for the other link, too. Please keep up the good work!
ExcelIsFun (1 year ago)
Here is a second Intro Video i did that may help you also: Power BI Desktop: Build Data Model, Get Data, DAX Formulas, Visualizations, Publish 2 Web (EMT 1366) https://www.youtube.com/watch?v=NysWGxZyjSs&t=401s
ExcelIsFun (1 year ago)
I am glad that this video is helpful and that it will help you introduce your co-workers to this tool. When you write; "Make sure you're getting these highlighted in the Power BI forum!" I am not sure what you mean?
sanket sontake (1 year ago)
Hello All!! I am looking for a feature like.. if we select bar chart from slicer then bar chart will b displayed and if we select table then it will display table by hiding bar chart.. Is this possible at this moment? If not then what is alternate option??
picious (1 year ago)
Great Video ,, btw your videos in general helped me a lot !! THANK YOU ....
ExcelIsFun (1 year ago)
You are welcome!
de red (1 year ago)
Hey Mike, great video. Question: if I email the file to my manager does he need to have power BI on his desktop installed?
Forza Algiers (1 year ago)
Great video as usual. Thank you.
ExcelIsFun (1 year ago)
You are welcome!
Jānis Prīdāns (1 year ago)
Perfect, thanks, Mike! Your videos are the best! Up!
ExcelIsFun (1 year ago)
Awesome! I am glad that the videos help : )
M Qasim (1 year ago)
Wow amazing.Great job. thanks for such a nice video.
ExcelIsFun (1 year ago)
You are welcome!
pmsocho (1 year ago)
Wow! Even more amazing than EMT1332! Thanks!
ExcelIsFun (1 year ago)
You are welcome, Rad Excel Teammate!!! : )
Daniel Weikert (1 year ago)
Awesome Video Mike. Your Content is truely an enrichment for all of us. Dax Measures are special. Any Plans to introduce HASONEVALUE, EARLIER, VALUES and other cool functions?
ExcelIsFun (1 year ago)
Yes, in a few months I should start posting a lot about DAX functions.
Andrés Franco (1 year ago)
Excellent, thanks again. Very generous of you. A
ExcelIsFun (1 year ago)
You are welcome!
Manesh Zaveri (1 year ago)
Great video demonstrating the power of BI
ExcelIsFun (1 year ago)
Glad you like it!
Mokhtar Saeed (1 year ago)
Dear , i have report daily basis showing budget & last year and this year daily basis and month to date year to date comparing all can i use power pivot table and power PI to make it i am already make the report using vlookup & sumif & sumifs macro to post date from data entry but i am thinking using power pivot or power query & pivot table
hi i have formula =CONCATENATE("=","VLOO","KUP(D2,A","1:B2,2,0)") or ="="&"VLOO"&"KUP(D2,A"&"1:B2,2,0)" the result is =VLOOKUP(D2,A1:B2,2,0) but it only text ="1"&"+"&"2" or =CONCATENATE("=","1","+","2") the result is =1+2 but it only text so how to convert result to be formula not text
ExcelIsFun very good .. i used vba solution it's very easy :) thanks very much :)
ExcelIsFun thanks on your support i will try it in my sheet and reply you thanks again :)
ExcelIsFun (1 year ago)
Maybe try watching this video I made a long time ago. Watch the part about the EVALUATE Macro 4 function: https://www.youtube.com/watch?v=U3Izea2IlkE
Muhammad Fathy (1 year ago)
Awesome Video Mike, Merry Christmas to you my dear and followed by a Happy New Year
ExcelIsFun (1 year ago)
Thanks for the Thumbs Up and Sub! : )
ExcelIsFun (1 year ago)
Glad you like it! : ) Happy Holidays to you!!!!
Michael, thank you so much for this video and for many other lessons! You have literally discovered the new great world that is like a gift box! that is pretty amazing (c) =) Wish you a Merry Christmas!
ExcelIsFun (1 year ago)
Merry Christmas to you too! Yes, Power BI Desktop is a gift to all of us!!! : )
johandryreyes (1 year ago)
Hi Mike, thank you very much. The video is AMAZING. I'm in Chile and I'd like to apply the map tool with Chilean Cities Zip codes. Is it a data of Zip Codes in Power BI from this country or that tool just apply in the US?
ExcelIsFun (1 year ago)
I do not know. I am just learning Power BI Desktop, but my guess (based on past Excel experiences) is that Microsoft probably has built it as US-centric. However, I do know that it uses BING mapping, so it might accommodate... I also know that Microsoft is working as hard as they can to accommodate the whole world into Power BI Desktop, I just don't know if they are there yet...
Stewart Gartland (1 year ago)
hooooleee doooleeee Mike, that was awesome. I work in ticketing and have just started using this Power suite of tools, I'm so blown away at the power and functionality. It is going to transform the way we report. Thanks heaps for your amazing tuition, you are the best! And have a great festive break😁
ExcelIsFun (1 year ago)
You are welcome! Yes, this new free tool is an all-in-one awesome thing. Once we are all hooked, they will charge us. That said, Excel still can do many, many more things than Power BI Desktop and so will still be with us forever, but for the Data-Driven Dashboards and Reports, this is just amazing.
Miltinho Camo (1 year ago)
Hi Mike... great video... I want to much more about it.... PowerBIisFun... ;D
ExcelIsFun (1 year ago)
You are welcome! More will come. I love it: powerbiisfun because Power BI is FUN!!! Thanks for the Thumbs Up and Sub : )
Anton Eskov (1 year ago)
looks very complex
Anton Eskov (1 year ago)
Could be, I'll send you an example.
ExcelIsFun (1 year ago)
What are the "many-many different formats"? What visualizations do you want? Maybe this will be a good idea for a video.
Anton Eskov (1 year ago)
Hi ExcellsFun and thanks for your reply. I enjoy your videos and picked up many tricks already. I work with clients that provide me with similar data, but in many-many different formats. My goal is to visualize and analyse their data in fastest possible way.
ExcelIsFun (1 year ago)
It is complex, because you have to do many things: Import, Clean and Transform Data, then Build relationship, make DAX Formulas and then build visualization. But for people who do this, what is REALLY amazing is that all of this can be done in 1 tool!!! In that way it is amazing. Here at excelisfun at YouTube, I try to post Excel videos about Basic all the way to complex topics. Hopeful you can find something that is helpful to you. What are you interested in?
LongTimeTTFan (1 year ago)
Thank you, Master Mike. Please take a break. Have a wonderful holiday and a happy New Year.
ExcelIsFun (1 year ago)
You are welcome! Hard to take a break when this is so much fun!!! Thanks for the Thumbs Up and Sub : )
zhoujian zhou (1 year ago)
Thank you Mike for all the great videos in 2016. Wish you a Merry Christmas!
ExcelIsFun (1 year ago)
You are welcome! Happy Holidays! : )
John Sullivan (1 year ago)
Outstanding tutorial! Please create more tutorials for Power BI. It is an awesome tool.
ExcelIsFun (1 year ago)
Glad you like it! More will be coming! Thanks for the Thumbs Up and Sub : )
Victor Friesen (1 year ago)
Thanks for the amazing video Mike. Very interesting. Hope to see more about PowerBi in the future.
ExcelIsFun (1 year ago)
Thanks for the Thumbs Up and Sub : )
ExcelIsFun (1 year ago)
You are welcome!! Yes, there will be more Power BI.
guitarfan1989 (1 year ago)
Thanks for the video, very interested in seeing more PowerBI in the future!
ExcelIsFun (1 year ago)
You are welcome for the video!! Yes, there will be more Power BI.
iqbal mohd (1 year ago)
Amazing video
ExcelIsFun (1 year ago)
Glad you like it! : )
Naif Shaikh (1 year ago)
Will it update on its own when data changes in the original excel files? Very Nice video, as always.
ExcelIsFun (1 year ago)
Click the refresh button and everything will update! : )
Deepak Agrawal (1 year ago)
Excellent video, Mike.
ExcelIsFun (1 year ago)
Glad you like it!!! EXCELlent : )

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.