#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:
   / @neotechnavigators  

Please download the practice file from below given link:
https://www.pkanexcelexpert.com/full...

Download our free Excel utility Tool and improve your productivity:
https://www.pkanexcelexpert.com/prod...

See our Excel Products:
https://www.pkanexcelexpert.com/prod...

Visit to learn more:
Chart and Visualizations: https://www.pkanexcelexpert.com/cate...
VBA Course: https://www.pkanexcelexpert.com/vba/
Download useful Templates: https://www.pkanexcelexpert.com/cate...
Dashboards: https://www.pkanexcelexpert.com/exce...

Watch the best infographics 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:
https://WWW.PKAnExcelExpert.com

Facebook:
  / pkanexcelexpert  

Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5...

Pinterest:
  / pkanexcelexpert  


************ Suggested Books ********
VBA: https://amzn.to/2TMMikX
Excel Dashboard: https://amzn.to/2WZi2Fj
Power Query: https://amzn.to/2Ibd7xR
Power Pivot and Power BI: https://amzn.to/2DCg8BB
Exam Ref 70778 (Power BI): https://amzn.to/2GnWYTN

************ My Stuff ***************
Mic : https://amzn.to/2TLnF88
Video Editor: https://screencastomatic.com/refer/...