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

[@teamtekillya9420]

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

[@bondniko]

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

[@kavickjiscar3435]

Excellent than others becoz you explain step by step and anyone can understand easily. just keep doing in such a way.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mowaseef9104]

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!

[@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

[@foyedahmed8206]

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.

[@daliladuf]

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

[@PKAnExcelExpert]

Wow, thank you!

[@suki9860]

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!

[@kishorek792]

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

[@PureSoulTalks]

Excellent work! Sir you are the best.

[@PKAnExcelExpert]

Thank you very much!

[@rashidjawed9174]

Great 👍

[@PKAnExcelExpert]

Thanks🙏

[@suchitramaagala3115]

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

[@PKAnExcelExpert]

Glad you liked it

[@nawazkhan411]

Superb sir

[@PKAnExcelExpert]

Thanks

[@navedsaiyed9881]

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

[@letusfindtruth]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@pawansharma-wo3xh]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@esgeorgia1]

I am so glad i opened this video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@msantosh1220]

As always Excel king is back with brand new learning, i never get disappointed while learning through ur channel. Love 4m Mumbai💝

[@PKAnExcelExpert]

Thanks Santosh for your motivational words.

[@royphilip8486]

Excellent presentation. Very well explained.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohammedtaha2856]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AmandaOsuji]

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

[@PKAnExcelExpert]

Glad it was helpful!

[@purushottam1972]

Master blaster. Excellent .

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@GauravValecha-m4u]

Excellent video. Very well explained. Thank you :)

[@PKAnExcelExpert]

Most welcome 🙏

[@vinay3235]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@emjeke]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gmxoneconsultingengineers6544]

Thanks for the good lecture.

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kashinathmedidar6794]

Thank you for your Great effort preparing this video no doubt enjoyed with this video very knowledgeable one.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@skcp151]

Superb

[@josinajoy24]

Thanks for the video. Explained really well

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@munna8747]

Thank you PK, nice explanation

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@9019828585]

World class ! Great depth , let me know you conduct one to one online classes as well .

[@PKAnExcelExpert]

Thanks for your valuable feedback. Will start the online classes soon.

[@astheenlamartin7450]

Great Work Mr. PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdelmortada6706]

Great work thanks a lot for your time sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mraza99]

Nicely done. Good work in explaining this dashboard.

[@PKAnExcelExpert]

Glad you enjoyed it

[@deepaniful]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vijaysahal4556]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deeptinrahul]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback and subscription 👍

[@kgdadhich]

Superb and inspired a lot .... Dear Bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pankajpatel1882]

Nice Video, very helpful. Thank You Very much

[@winniedlaydy1013]

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

[@VentureBI]

Thank you for the great turorial!

[@PKAnExcelExpert]

You're very welcome!

[@virak981]

Very good video. Thanks for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@121simi]

Well done. Very informative.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nureragohae]

Now dashboard look easy thank you sir

[@blindshark4560]

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]

Yes

[@hayleybeynon9579]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Luciano_mp]

Very helpful, good job man. Thank you!👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hiteshgrover9026]

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

[@Deadly_Shadows_]

Nice video. Very helpful. thank you :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mehrotraormudit]

Good, informative instructions and helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shrikantbadge3978]

Amazing

[@PKAnExcelExpert]

Thanks

[@josecarlosconejo5724]

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]

Me too! I get really irritated by having all this stuff in the slicer I don't want.

[@mostfascinatingtop10s99]

Thanks a lot for your nice presentation.

[@PKAnExcelExpert]

Most welcome

[@mostfascinatingtop10s99]

@@PKAnExcelExpert thank so much

[@nasquare256]

very useful video

[@PKAnExcelExpert]

Thanks

[@trantili7094]

thanks so much, very easy understand

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@farimahpouyandeh6669]

Awesome video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@roronoazoro-518]

I will try this tomorrow... I need to create Dashboards for my company.. hopefully this might help 🙏

[@PKAnExcelExpert]

Best of luck!

[@roronoazoro-518]

@@PKAnExcelExpert Thank you :)

[@joemsgee8647]

I learned a lot , will try this. Thank you

[@warigiyatno6764]

Awesome tutorial, PK!

[@silviamaria2907]

You're doing great, Sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harigokul4450]

GOOD WORK KEEP IT UP

[@youtuber8128]

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

[@bzflowerbee]

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

[@PKAnExcelExpert]

You're welcome 😊

[@anglerweekenderrizalzi3419]

thank for the tutorial...

[@PKAnExcelExpert]

Most welcome🙏

[@d.deckert3890]

Top! 👍

[@PKAnExcelExpert]

Thanks

[@shrikantbadge3978]

Thank you

[@PKAnExcelExpert]

You're welcome

[@lolaadeoye3584]

Thank you for sharing

[@iftekharraju318]

Thanks excel guru 💖💖

[@PKAnExcelExpert]

Thanks for watching

[@swapnilsrivastava2039]

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

[@tobayekaina8610]

Awesome. Thanks for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@romlef526]

thank you for this great exercise

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@inderjeetsaini7526]

Awesome. i liked it.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sunilkumar-xd8yn]

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.

[@palashnaphade8163]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheSachauhan]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wangzig9800]

excellent

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SusmitaMelodies]

THANK you ❤️

[@PKAnExcelExpert]

You’re welcome 😊

[@danjarupath]

Excellence with love this vdo !!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Collin-ee6zw]

thank you.. this is awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@molala225]

Very impressive!

[@ashishmohan4707]

Great sir thanks to share with us

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@ashishmohan4707]

@@PKAnExcelExpert welcome sir

[@ashishmohan4707]

@@PKAnExcelExpert hello PK sir few wk ago i sent u one mail still i am waiting ur reply plzz replied

[@tashfeenhasanaghwani7077]

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

[@saravananr9054]

Really interested

[@PKAnExcelExpert]

Thanks

[@premkumar-jl8wy]

Hi very good explanation. Am having a doubt when there is no discount in a quater then sparkline bars are not coming correctly in dashboard help me to correct it pls

[@ashishjadhav5169]

So if we make any changes in the sheet or add more details will this reflect on dashboard

[@VidhiVedika813]

great stuff .... thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SPORTSCIENCEps]

Thank you for uploading it!

[@PKAnExcelExpert]

Welcome

[@kishansingh4103]

Vary vary nice video sir Ek dash board stoc market portfolio ke upper banaye

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try to create such dashboard

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

[@Algoframe]

Thank you

[@PKAnExcelExpert]

Most welcome

[@Dan_De_Man]

At 15:00 what's the difference between close and load and then right click query and create connection. Or in PQ close and load to and create connection

[@toofanfeizi1353]

Hi PK, Can I send some data on spreadsheet and transfer it to one of your beautiful dashboard, let me know if you can help me on this.

[@ramymahfouz1494]

Amazing tutorial and a lot of technics. May I ask the software name that you are using for the screen recording ?

[@PKAnExcelExpert]

Screen-O-Matic

[@ramymahfouz1494]

@@PKAnExcelExpert Thanks A lot

[@ramymahfouz1494]

@@PKAnExcelExpert thanks a lot bro. i have subscript to screen o matic under your refer code for one month :) wants to try it :)

[@shivannahr780]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@massefromla2554]

Expert

[@PKAnExcelExpert]

Thanks

[@juaniglesias6327]

Hi. Great video. But there are few questions and some of them very interesting. Any way to get the answer to them. It's very nice of you but I do realise that you only reply to compliments not to actual enquiry as easy as they may be. The video is easy to follow many thanks!

[@alihegazy1319]

Thanks millioooooooooooooooooooon :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gireshkumar8111]

very useful video and wonderfully explained, but i have some challenges in working on it, as I have 3 different set of sources which are in different format, how to go about, please help

[@PKAnExcelExpert]

You can watch our Power Query related video to learn about the data transformation: kzbin.info/aero/PLbDvAYjpWJ7DYKQqZYiATs-8AmK2UUs-3

[@oruvingal]

Amazing......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@OpulentNotions]

Will this work in different system without that source data folder