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. Our Course of Excel Pivot Tables for Data Analysis: Basic to Advanced: https://www.udemy.com/course/excel-pivot-tables-for-data-analysis-basic-to-advanced/?referralCode=05B51ED7DFE808939FE4 Subscribe our new YouTube Channel: https://www.youtube.com/@UC60elZFeWvA_gbb69nDtaXQ Please download the practice file from below given link: https://www.pk-anexcelexpert.com/fully-automated-excel-dashboard-with-multiple-source-files/ Download our free Excel utility Tool and improve your productivity: https://www.pk-anexcelexpert.com/products/pks-utility-tool-v1-0/ See our Excel Products: https://www.pk-anexcelexpert.com/products/ Visit to learn more: Chart and Visualizations: https://www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/ VBA Course: https://www.pk-anexcelexpert.com/vba/ Download useful Templates: https://www.pk-anexcelexpert.com/category/templates/ Dashboards: https://www.pk-anexcelexpert.com/excel-dashboard/ Watch the best info-graphics and dynamic charts from below link: https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr Learn and free download best excel Dashboard template: https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF Learn Step by Step VBA: https://www.youtube.com/playlist?list=PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH Website: https://WWW.PK-AnExcelExpert.com Facebook: https://www.facebook.com/PKAnExcelExpert Telegram: https://t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w Pinterest: https://www.pinterest.com/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 70-778 (Power BI): https://amzn.to/2GnWYTN ************* My Stuff **************** Mic : https://amzn.to/2TLnF88 Video Editor: https://screencast-o-matic.com/refer/cFe0Q6jzoA