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 YouTube Channel:

Please download the practice file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

************* Suggested Books *********

************* My Stuff ****************

[bondniko]

One of the best Sci-Fi movies of the year.

[foyedahmed]

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.

[suki]

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!

[teamtekillya]

For a beginner, you have made this not just interesting but less intimidating and I really appreciate that

[blindshark]

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.

[sunilkumar-xdyn]

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.

[hiteshgrover]

Thank you for the video. It's being an amazing learning session and hands on practice session 🔥🔥

[navedsaiyed]

I don't have any word for appreciation what a great explanation & solution. Hats off Bro

[daliladuf]

Such a great, clear lecture! You are my favourite excel guru. Thank you so much!

[pawansharma-woxh]

The best Excel expert on You tube. Proud on you PK.... Great Job

[Luciano_mp]

Very helpful, good job man. Thank you!👍

[kishorek]

Thankyou, great learning for those who love to learn in hindi, every minute of the tutorial is very useful.

[bilalasathar]

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.

[swapnilsrivastava]

Thank you so much for the lovely video . It helped me a lot

[emjeke]

Such a nice way to understand Power Query Excel.. Thanks PK for sharing this knowledge.

[mowaseef]

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

[hayleybeynon]

Excellent video, exactly what I was looking for! Thank you so much

[mohammedtaha]

I am really very impressed with this dashboard. U have a new fan

[angelar]

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

[joemsgee]

I learned a lot, will try this. Thank you