Fully Automated Excel dashboard with multiple source files | No VBA used
#ExcelDashboard #PowerQueryforExcel
In this video, you will learn how to create a fully automated excel dashboard with multiple source files. Source files are excel file and they have multiple worksheets. We have used Power Query to consolidate the data using folder connection. We have made the folder path dynamic connected with the settings sheets.
Subscribe our new KZread Channel:
/ @neotechnavigators
Please download the practice file from below given link:
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Пікірлер: 294
Very logical, smooth flowing, easy-to-learn method followed which absolutely helps anyone to understand what is being done and why. Great presentation! Thanks very much!
I am not a quick learner. But your smooth and easy teaching took me few hours to learn the dashboard creation with Excel Power Query. So grateful to you.
One of the best Sci-Fi movies of the year.
For a beginner, you have made this not just interesting but less intimidating and I really appreciate that
I look forward to hearing from you. Such a great work, following you has augmented my excel skill, making much fun. thanks PK, keep up the good work.
@bebohabasube2103
3 жыл бұрын
Yes
Thank you for the video. It's being an amazing learning session and hands on practice session 🔥🔥
I don't have any word for appreciation what a great explanation & solution. Hats off Bro
Awesome tutorial, PK!
Such a Great video again, thank you so much. Just have one request for one more dashboard in power bi with updated visulization along with case study.
Very helpful, good job man. Thank you!👍
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank you so much for the lovely video . It helped me a lot
Such a great, clear lecture! You are my favourite excel guru. Thank you so much!
@PKAnExcelExpert
2 жыл бұрын
Wow, thank you!
The best Excel expert on You tube. Proud on you PK.... Great Job
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thankyou , great learning for those who love to learn in hindi, every minute of the tutorial is very useful.
Excellent video, exactly what I was looking for! Thank you so much
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
I learned a lot , will try this. Thank you
I am really very impressed with this dashboard. U have a new fan
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Such a nice way to understand Power Query Excel.. Thanks PK for sharing this knowledge.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
@gmxoneconsultingengineers6544
2 жыл бұрын
Thanks for the good lecture.
Thank you @PK An Excel Expert, you have thought me a lot about Excel and VBA. Thank you for your amazing and useful works sir. God bless
@PKAnExcelExpert
Ай бұрын
Most welcome
Very well explained, thanks for such an amazing video. Learned a lot from this video. Power query editor is such a powerful tool in excel.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
This is one of the best videos I have ever seen in areas of Excel learning, thanks a million and I wish you all success
@PKAnExcelExpert
Жыл бұрын
Wow, thank you!
What an amazing tutorial, thanks for sharing! I am subscribing this channel.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback and subscription 👍
Excellent than others becoz you explain step by step and anyone can understand easily. just keep doing in such a way.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Nicely done. Good work in explaining this dashboard.
@PKAnExcelExpert
3 жыл бұрын
Glad you enjoyed it
You're doing great, Sir.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
wow. this is a great one ! I really learned.. Thank you very much.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Thanks for your effort on making this video for all of us 🙏
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thank you for uploading it!
@PKAnExcelExpert
3 жыл бұрын
Welcome
Thank you very much for sharing this. It look so simple.
@PKAnExcelExpert
3 жыл бұрын
You're welcome 😊
thank you for this great exercise
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Very impressive!
Thanks alot... This is so beginner friendly, really appreciate it.
@PKAnExcelExpert
2 жыл бұрын
Glad it was helpful!
You make things look very simple. Thanks so much. I just have one short question for you. I’d like to limit the selection in a slicer to one item. For instance, if a user selects one quarter, I want them not to select another one at the same time (the selection of the other items in the slicer should be FALSE). Could you please show this in one of your next videos?
@SeaOfMadness
2 жыл бұрын
Me too! I get really irritated by having all this stuff in the slicer I don't want.
Superb sir
@PKAnExcelExpert
5 күн бұрын
Thanks
This is great, quiet helpful! How do I ensure that my slicers don't show 'blank' ?
Very neatly explained, thanks for uploading. Looking forward to more such videos.
@PKAnExcelExpert
Жыл бұрын
Glad you liked it
Nice Video, very helpful. Thank You Very much
Excellent guidance. What will be the arrangement for multiple text files rather than Excel files? as this folder arrangement not working on text files.
As always Excel king is back with brand new learning, i never get disappointed while learning through ur channel. Love 4m Mumbai💝
@PKAnExcelExpert
4 жыл бұрын
Thanks Santosh for your motivational words.
Good, informative instructions and helpful
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thank you for the great turorial!
@PKAnExcelExpert
2 жыл бұрын
You're very welcome!
Well done. Very informative.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Excellence with love this vdo !!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
I am working on a dashboard now. This came at the right time. God bless you
Now dashboard look easy thank you sir
Awesome. Thanks for sharing
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Nice video... Thank you soooooo much!!!!!
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Amazing !!!
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanks for the video. Explained really well
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Excellent presentation. Very well explained.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
Very good video. Thanks for sharing.
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Excellent work! Sir you are the best.
@PKAnExcelExpert
2 ай бұрын
Thank you very much!
Great Work Mr. PK
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
great stuff .... thank you
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Superb and inspired a lot .... Dear Bro
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thank you PK, nice explanation
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
thank you.. this is awesome
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Thanks, Sir.
Thank you for sharing
Excellent video. Very well explained. Thank you :)
@PKAnExcelExpert
Жыл бұрын
Most welcome 🙏
Thank you for your Great effort preparing this video no doubt enjoyed with this video very knowledgeable one.
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
thanks so much, very easy understand
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Hi, Thank you very much for reading this comment. This tutorial is very very easy to understand and extremely helpful. I have a query and here is my situation. I have an excel file of size more than thirty MB and it can be accessed using the network and it keeps growing in size, every day. More than five users are actively using the file, on most of the day. Some of my users complain that when the file is opening and saving it is slow due to the network being slow. Hence, I need a solution for this. I have two solutions in my mind. Firstly, create a local file to each remote user and let them add their data and sync with the main file in the network when they close or click a button to update the main file. Secondly, add data to excel file in the network without fully opening the file. Do you have any suggestions? Thank you in advance and have a wonderful day.
Nice video. Very helpful. thank you :)
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Great work thanks a lot for your time sir
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Dear Sir, it is very useful. Thank you so much. May I know if you have a way to pivot columns in each table before combining them? Thank you...
Amazing video,however I’m facing one challenge the number going on pivot is duplicating and I tried to review everything without succeeding to know error,appreciate your advise
Thanks excel guru 💖💖
@PKAnExcelExpert
4 жыл бұрын
Thanks for watching
World class ! Great depth , let me know you conduct one to one online classes as well .
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback. Will start the online classes soon.
thank for the tutorial...
@PKAnExcelExpert
Жыл бұрын
Most welcome🙏
Master blaster. Excellent .
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
Superb
I am so glad i opened this video
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback
PK, what if all your data files are .csv files? What modifications do you need to make to get Excel to read from these files? Also, what do I do if each data file is large? How would I overcome the problem of maxing out the spreadsheet size with so much data? Thanks.
GOOD WORK KEEP IT UP
Sir, you have done great job 🌸🌸🌸🌸🌸🌸🌸🌼🌼🌼🌼🌼. Thanks a lot 💖💖💖💖
@PKAnExcelExpert
2 жыл бұрын
Thanks for your valuable feedback🙏
Very nice
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Amazing......
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
Thanks a lot for your nice presentation.
@PKAnExcelExpert
3 жыл бұрын
Most welcome
@mostfascinatingtop10s99
3 жыл бұрын
@@PKAnExcelExpert thank so much
THANK you ❤️
@PKAnExcelExpert
2 жыл бұрын
You’re welcome 😊
Beautiful....
@PKAnExcelExpert
3 жыл бұрын
Thanks a lot 😊
Amazing
@PKAnExcelExpert
3 ай бұрын
Thanks
Great 👍
@PKAnExcelExpert
Жыл бұрын
Thanks🙏
superb sir 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback
I could use some assistance if anyone knows. I followed the steps in this video and the Dashboard works great. Only problem is now I am pulling my data from a database and want to change my source path to a linked table inside the current workbook. If anyone knows any tips on doing this, I would appreciate it!
Thank you
@PKAnExcelExpert
11 ай бұрын
You're welcome
Awesome. i liked it.
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Top! 👍
@PKAnExcelExpert
2 жыл бұрын
Thanks
Awesome
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback.
Awesome video
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Great sir thanks to share with us
@PKAnExcelExpert
4 жыл бұрын
Thanks for your valuable feedback.
@ashishmohan4707
4 жыл бұрын
@@PKAnExcelExpert welcome sir
@ashishmohan4707
4 жыл бұрын
@@PKAnExcelExpert hello PK sir few wk ago i sent u one mail still i am waiting ur reply plzz replied
excellent
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
very useful video
@PKAnExcelExpert
3 жыл бұрын
Thanks
very nice video sir. really helpful but sir can I make this dashboard from sharepoint links as well?
Thanks millioooooooooooooooooooon :)
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback
Sir thank you. Sir I have three tables and all 3 has different headers, when I m trying to get total in power query, it shows only one tables total for rest tables it shows NULL.Pls help me on it.
Vary vary nice video sir Ek dash board stoc market portfolio ke upper banaye
@PKAnExcelExpert
3 жыл бұрын
Thanks for your valuable feedback. I will try to create such dashboard
For someone this advanced, I can’t believe he didn’t use Format Painter!
Hi PK, Have a query. In case the source data excel file has certain new columns to be added, how can those columns get automatically transferred into the query and the data is visible in the dashboard
thank you so much for this, it was so helpful, but I got an error when creating the pivot chart that says " problems obtaining data " if you have any suggestions to this problem please comment