Fully Automated Excel dashboard with multiple source files | No VBA used

Подписаться 272 тыс.

Просмотров 553 тыс.

50% 1

#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 RU-vid 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/...

Опубликовано:

11 апр 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 294

@bondniko 3 года назад

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

@suki9860 2 года назад

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!

@foyedahmed8206 3 года назад

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.

@teamtekillya9420 2 года назад

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

@navedsaiyed9881 3 года назад

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

@kishorek792 2 года назад

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

@blindshark4560 4 года назад

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

@hiteshgrover9026 2 года назад

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

@daliladuf 2 года назад

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

@PKAnExcelExpert 2 года назад

Wow, thank you!

@warigiyatno6764 3 года назад

Awesome tutorial, PK!

@sunilkumar-xd8yn 4 года назад

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.

@swapnilsrivastava2039 4 года назад

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

@mowaseef9104 2 года назад

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 2 года назад

Wow, thank you!

@pawansharma-wo3xh 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@angelar7314 Месяц назад

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

@joemsgee8647 3 года назад

I learned a lot , will try this. Thank you

@Luciano_mp 4 года назад

Very helpful, good job man. Thank you!👍

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@hayleybeynon9579 2 года назад

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

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@mohammedtaha2856 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@bilalasathar 3 года назад

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

@emjeke 4 года назад

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.

@kavickjiscar3435 2 года назад

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

@suchitramaagala3115 Год назад

Very neatly explained, thanks for uploading. Looking forward to more such videos.

@PKAnExcelExpert Год назад

Glad you liked it

@deeptinrahul 3 года назад

What an amazing tutorial, thanks for sharing! I am subscribing this channel.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback and subscription 👍

@mraza99 3 года назад

Nicely done. Good work in explaining this dashboard.

@PKAnExcelExpert 3 года назад

Glad you enjoyed it

@deepaniful 3 года назад

wow. this is a great one ! I really learned.. Thank you very much.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@pankajpatel1882 3 года назад

Nice Video, very helpful. Thank You Very much

@winniedlaydy1013 4 года назад

I am working on a dashboard now. This came at the right time. God bless you

@SPORTSCIENCEps 3 года назад

Thank you for uploading it!

@PKAnExcelExpert 3 года назад

Welcome

@molala225 4 года назад

Very impressive!

@AmandaOsuji 2 года назад

Thanks alot... This is so beginner friendly, really appreciate it.

@PKAnExcelExpert 2 года назад

Glad it was helpful!

@vinay3235 3 года назад

Thanks for your effort on making this video for all of us 🙏

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@bzflowerbee 4 года назад

Thank you very much for sharing this. It look so simple.

@PKAnExcelExpert 4 года назад

You're welcome 😊

@silviamaria2907 4 года назад

You're doing great, Sir.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@VentureBI 2 года назад

Thank you for the great turorial!

@PKAnExcelExpert 2 года назад

You're very welcome!

@romlef526 4 года назад

thank you for this great exercise

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@lolaadeoye3584 2 года назад

Thank you for sharing

@msantosh1220 4 года назад

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.

@mehrotraormudit 3 года назад

Good, informative instructions and helpful

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@nawazkhan411 16 дней назад

Superb sir

@PKAnExcelExpert 16 дней назад

Thanks

@121simi 3 года назад

Well done. Very informative.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@nureragohae 3 года назад

Now dashboard look easy thank you sir

@josinajoy24 2 года назад

Thanks for the video. Explained really well

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@virak981 4 года назад

Very good video. Thanks for sharing.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@user-dq3hq6jl3j Год назад

Excellent video. Very well explained. Thank you :)

@PKAnExcelExpert Год назад

Most welcome 🙏

@tobayekaina8610 4 года назад

Awesome. Thanks for sharing

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@PureSoulTalks 3 месяца назад

Excellent work! Sir you are the best.

@PKAnExcelExpert 3 месяца назад

Thank you very much!

@palashnaphade8163 3 года назад

Nice video... Thank you soooooo much!!!!!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@munna8747 3 года назад

Thank you PK, nice explanation

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@royphilip8486 2 года назад

Excellent presentation. Very well explained.

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@josecarlosconejo5724 4 года назад

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.

@purushottam1972 2 года назад

Master blaster. Excellent .

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@skcp151 Год назад

Superb

@danjarupath 3 года назад

Excellence with love this vdo !!!!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@kashinathmedidar6794 2 года назад

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

@astheenlamartin7450 4 года назад

Great Work Mr. PK

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@Deadly_Shadows_ 3 года назад

Nice video. Very helpful. thank you :)

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@VidhiVedika813 3 года назад

great stuff .... thank you

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@trantili7094 3 года назад

thanks so much, very easy understand

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@virenderjal 4 года назад

Amazing !!!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@Collin-ee6zw 3 года назад

thank you.. this is awesome

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@multipleshotclips9453 4 года назад

Thanks, Sir.

@harigokul4450 3 года назад

GOOD WORK KEEP IT UP

@abdelmortada6706 3 года назад

Great work thanks a lot for your time sir

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@esgeorgia1 2 года назад

I am so glad i opened this video

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@kgdadhich 4 года назад

Superb and inspired a lot .... Dear Bro

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@rashidjawed9174 Год назад

Great 👍

@PKAnExcelExpert Год назад

Thanks🙏

@palesamanana816 3 года назад

This is great, quiet helpful! How do I ensure that my slicers don't show 'blank' ?

@anglerweekenderrizalzi3419 Год назад

thank for the tutorial...

@PKAnExcelExpert Год назад

Most welcome🙏

@letusfindtruth 2 года назад

Sir, you have done great job 🌸🌸🌸🌸🌸🌸🌸🌼🌼🌼🌼🌼. Thanks a lot 💖💖💖💖

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@d.deckert3890 2 года назад

Top! 👍

@PKAnExcelExpert 2 года назад

Thanks

@shrikantbadge3978 3 месяца назад

Amazing

@PKAnExcelExpert 3 месяца назад

Thanks

@SusmitaMelodies 2 года назад

THANK you ❤️

@PKAnExcelExpert 2 года назад

You’re welcome 😊

@tashfeenhasanaghwani7077 4 года назад

Excellent guidance. What will be the arrangement for multiple text files rather than Excel files? as this folder arrangement not working on text files.

@iftekharraju318 4 года назад

Thanks excel guru 💖💖

@PKAnExcelExpert 4 года назад

Thanks for watching

@shrikantbadge3978 11 месяцев назад

Thank you

@PKAnExcelExpert 11 месяцев назад

You're welcome

@inderjeetsaini7526 3 года назад

Awesome. i liked it.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@9019828585 2 года назад

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.

@shivannahr780 4 года назад

Very nice

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@farimahpouyandeh6669 3 года назад

Awesome video

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@sleepingbear7897 Год назад

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...

@vijaysahal4556 4 года назад

superb sir 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@oruvingal 4 года назад

Amazing......

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@mostfascinatingtop10s99 3 года назад

Thanks a lot for your nice presentation.

@PKAnExcelExpert 3 года назад

Most welcome

@mostfascinatingtop10s99 3 года назад

@@PKAnExcelExpert thank so much

@carlosrobertomartinezandra9120 3 года назад

Beautiful....

@PKAnExcelExpert 3 года назад

Thanks a lot 😊

@nasquare256 3 года назад

very useful video

@PKAnExcelExpert 3 года назад

Thanks

@wangzig9800 3 года назад

excellent

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@waseemali433 4 года назад

Awesome

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback.

@musthagmohamed 3 года назад

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.

@barbarasharp306 3 года назад

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.

@alihegazy1319 3 года назад

Thanks millioooooooooooooooooooon :)

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@raafatgh 3 года назад

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

@massefromla2554 2 года назад

Expert

@PKAnExcelExpert 2 года назад

Thanks

@simuislam5752 2 года назад

Thanks

@PKAnExcelExpert 2 года назад

Welcome

@saravananr9054 Год назад

Really interested

@PKAnExcelExpert Год назад

Thanks

@torstenhollerbach 4 года назад

Hey PK. One Question. I rebuild this Folder_Path thing. But when I move the folder in different place, it is not actualizing, except I change the data input for every table. What is the error?

@youtuber8128 Год назад

For someone this advanced, I can’t believe he didn’t use Format Painter!

@ashishmohan4707 4 года назад

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

@TheSachauhan 3 года назад

Nice video

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@hacker123440 4 года назад

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