KZhead
Тәжірибелік нұсқаулар және стиль

3 Essential Excel skills for the data analyst

Access Analytic
2024 ж. 15 Мам.
1 486 605 Рет қаралды
Жүктеу

This is my opinion on the 3 key Excel skills a data analyst requires.
Understanding the use of Power Query, Tables and Pivot Tables/Power Pivot is the starting point on your learning journey.
Once you get comfortable with these concepts you will easily migrate to Power BI
Want to learn more about Power Query, DAX and Power BI? Check out my book:
"Power BI for the Excel Analyst"?
Australia: pbi.guide/book/
Amazon: www.amazon.com/Power-BI-Excel...
00:00 Intro
00:41 Tables
05:15 Power Query
12:05 Pivot Tables
13:50 Power Pivot and the Data Model
Here's the file if you want to practice
aasolutions.sharepoint.com/:f...
Connect with me: wyn.bio.link/
Access Analytic Training
accessanalytic.com.au/training

Пікірлер

  • 📖📍Use discount code KZhead15 for 15% off my book "Power BI for the Excel Analyst"? I wrote it for those who love Excel and want to learn Power BI, there's even a whole chapter dedicated to Power Pivot in Excel. pbi.guide/book/ 📍Use KZhead15 for 15% off the book

    @AccessAnalytic@AccessAnalytic8 ай бұрын

  • Calm, controlled presentation with no cursors flying around the screen. He also tells you "why."

    @StopWhining491@StopWhining49110 ай бұрын

    • Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic10 ай бұрын

  • When I am confused about the basic of Power Query, I usually go back to this lecture. Thank you Sir, for simplifying the very complicated topics.

    @SilvestreECamposano@SilvestreECamposano Жыл бұрын

    • You’re welcome. I recommend Master Your Data as a book to get a good understanding of Power Query. Https://pbi.guide/resources/

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • i am getting major "she's a beauty" irwin vibes from this. love it.

    @XianOrtiz7@XianOrtiz7 Жыл бұрын

    • 😀🦘 Cheers

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • After years of using Excel, how am I only learning about Power Query now 😭😭😭😭😭!!! Cleaning data takes up most of my time! This video was brilliant. Thank you 🙏🏾

    @misskaykay1856@misskaykay1856 Жыл бұрын

    • Thanks! Power Query will change your life! Make sure you check out my playlist here kzhead.info/channel/PLlHDyf8d156UFChHzgQIO2cdaNqOS8KX3.html and my friend Oz Du Soleil's channel which is where I learned about Power Query... kzhead.info/channel/PLo4_ndJE07FRhKi5QexHta3jAbTSU1Jiy.html

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Came here for Excel, stayed for the heavy British accent 😅

    @arnaudmanir@arnaudmanir Жыл бұрын

    • 😊🏴󠁧󠁢󠁷󠁬󠁳󠁿🇦🇺

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • The queen's english

      @Dear0705@Dear07055 ай бұрын

    • Not bad for a Welshman in Australia 😆

      @AccessAnalytic@AccessAnalytic5 ай бұрын

  • I love how you explain. Very concise, yet detailed. Excellent!!

    @TheJoshtheboss@TheJoshtheboss Жыл бұрын

    • Glad it was helpful!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Excellent tutorial. Refreshing lack of 'fluff', straight to the point. Thank you!

    @stingaling@stingaling Жыл бұрын

    • Thanks, I appreciate you taking the time to leave the feedback.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Your voice is music to my ears. Every other Excel tutorial I've come across is like nails on a chalkboard. Subscribed!

    @tomalcolm@tomalcolmАй бұрын

    • Thanks for subscribing 😀

      @AccessAnalytic@AccessAnalyticАй бұрын

  • Learnt more about advanced Excel use in 18minutes than I have in the previous year - brilliant!

    @deangawler9727@deangawler9727 Жыл бұрын

    • Glad to help Dean 🙂

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • lol l

      @jcmorgan3305@jcmorgan3305 Жыл бұрын

  • Absolutely brilliant packaging and showcasing of all our favorites! Your reminder is timely and absolutely spot on, Wyn! Thanks!

    @suki9860@suki98608 ай бұрын

    • Thanks for taking the time to leave a kind comment. Much appreciated

      @AccessAnalytic@AccessAnalytic8 ай бұрын

  • Love your teaching mythology, clear and very easy to follow. I'll be reviewing a lot more of your lessons moving forward!

    @Machende100@Machende1006 ай бұрын

    • Great. I hope you enjoy the channel.

      @AccessAnalytic@AccessAnalytic6 ай бұрын

  • The possibility to unpivot other columns is adressing a major obstacle for pivot table application. I was looking for a solution through traditional excel formulae but was completely unaware of this possibility. Thank you so much!

    @verbeeck36@verbeeck36 Жыл бұрын

    • You’re welcome. Unpivot is a joy. Thanks for taking the time to leave a kind comment and letting me know you found it useful

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Power query is the one! I’m not an analyst but helping pull different information in quickly has been a game changer

    @JamesGettingFit@JamesGettingFit2 жыл бұрын

    • Absolutely James !

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • I just wanted to say THANK YOU. This is the first video I've seen that has actually sunk in for me.

    @Shakesbeard89@Shakesbeard89 Жыл бұрын

    • Awesome to hear Moogoats! Thanks for leaving a kind comment.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Great content. You not only have the knowledge of the right skills required for Data Analytics using Excel but you are also an excellent teacher. I'm a fan.

    @abdulwahabfakunle6513@abdulwahabfakunle6513 Жыл бұрын

    • Thanks for taking the time to leave a kind comment , greatly appreciated

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Love how enthusiastic you teach and speak about Data! It motivates me to keep learning! Thanks so much! 🥰

    @pameladelorbe3478@pameladelorbe34782 жыл бұрын

    • That’s fantastic to hear, thanks Pamela

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • Great video, Wyn. I'm slowly building my experience with Power Query. As you say, a lot of people haven't heard of it. In my organisation so many people rely on fiddly manual processes to gather and report on data, which is so prone to error.

    @iankr@iankr2 жыл бұрын

    • Thanks for commenting Ian. Start spreading the word 😀

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • fiddly!

      @davidpearce1583@davidpearce1583 Жыл бұрын

    • No library functionality currently

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • What an excellent way of explaining. Many thanks for this video.

      @regme4life191@regme4life191 Жыл бұрын

  • Love the video! I've used PQ for a few years now and am amazed at how few people realize that it's there. I'm putting together some recommended PQ training for analysts at my company and will definitely include this video! FYI I love your pronunciation of POWA QWEWY :)

    @gjones0316@gjones0316 Жыл бұрын

    • Share the knowledge Gordon!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Awesome. Loved the power query unpivot columns concept. I am beginner in the field of big data analytics. This video helped me a lot. Thanks a Ton !!

    @shrirajdeshpande8125@shrirajdeshpande81252 жыл бұрын

    • Glad to help, I appreciate you letting me know

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • This has transformed my life as a data analyst. Saves so much of time

    @brandonp2530@brandonp2530 Жыл бұрын

    • That’s great to know Brandon!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • this is the most crystal clear presentation tutorial stands out! Amazing

    @JhongskPass@JhongskPass Жыл бұрын

    • Thank you 😀

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Incredible tutorial. Thank you!

    @versai121@versai12126 күн бұрын

    • You’re welcome. Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic26 күн бұрын

  • I like your videos ,and the way you present it, Sir. They are highly educative and remind you of things that are easily forgotten.

    @ozansen_ozibaba@ozansen_ozibaba2 жыл бұрын

    • Thank you Ozan, I’m glad to help

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • Under 20 minutes and you save me many hours of work. Thank you, sir!

    @carstoryteller5855@carstoryteller5855 Жыл бұрын

    • You are most welcome CarStoryTeller

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I just found your video and learned more in the 15 minutes I spent here than I have in a long time! Thank you so much and I look forward to using this information and skills in my next position.

    @annapoundstone2443@annapoundstone24435 ай бұрын

    • Great to hear. Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic5 ай бұрын

  • Wow! Power Query! Mind blown! Brushing up on my rusty-ish excel skills for my job interview. I've added several of your videos to my watch list! Thank you for providing such engaging content!

    @ds5030@ds5030 Жыл бұрын

    • You’re welcome, glad to help, thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks so much, it is one of the most useful 18 minutes of my time for so long already. Much appreciated, Wyn.

    @trangvo219@trangvo2198 ай бұрын

    • You’re welcome. Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic8 ай бұрын

  • I agree with you about these essential skills, Wyn. About Trim, I would suggest applying that step before merging the columns because it seems that in Power Query Trim does not remove multiple spaces in the middle of the string as TRIM does in Excel.

    @CeliaAlvesSolveExcel@CeliaAlvesSolveExcel2 жыл бұрын

    • Excellent point Celia, thanks for pointing that out

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • @@AccessAnalytic it's one of those annoyances of "why is Power Query not working the same way as its corresponding function in Excel?".

      @CeliaAlvesSolveExcel@CeliaAlvesSolveExcel2 жыл бұрын

    • It's the same with VBA's own Trim() function - it doesn't remove multiple internal spaces. You need to call Excel's worksheet TRIM() function via WorksheetFunction.Trim. Which is weird and annoying! I wonder if the two issues are connected?

      @iankr@iankr2 жыл бұрын

  • I subscribed 1 minute into the video. Thank you! This was super helpful and you made it so simple. Thanks a lot!

    @aimaikhile4006@aimaikhile4006 Жыл бұрын

    • Awesome thanks Aima! 😀

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Clear, Concise, well delivered.

    @chinezeobiako1367@chinezeobiako1367 Жыл бұрын

    • Thank you

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Great video : I really liked how you explained everything...and went slowly and methodically...almost as if you were magically intuiting potential questions. Thanks so much. I've subscribed right now. Also: good clear diction👍

    @tyronefrielinghaus3467@tyronefrielinghaus3467 Жыл бұрын

    • Thanks very much Tyrone, and welcome 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Wow I am blown away. I need to get into this more. Thank you.

    @rfdave3980@rfdave3980 Жыл бұрын

    • 😀. It’s core to the corporate reporting our company develops and is the foundation to how Power BI works

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • This guy is awsome!!!!!! Just got a crash course & have learned and retained so much!

    @kimwoods1@kimwoods12 жыл бұрын

    • 😊 glad you found it useful

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • Good information but your energy is off the charts and really helps keep my attention, you are very good at teaching. Thank you!

    @KrypticPatriot@KrypticPatriot Жыл бұрын

    • Thanks for taking the time to let me know. I love this stuff 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I knew some of this, but in 20 minutes I learned so much more, lol. Thanks.

    @michealkinney6205@michealkinney6205 Жыл бұрын

    • Glad to help Micheal

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thank you so much! You are a very professional teacher!

    @wendysiow5217@wendysiow5217 Жыл бұрын

    • Thanks Wendy

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I am an Analyst I love Excel nowadays along with Tableau, Power BI, Sql or any other tools. Its amazing to learn and enhance skill everyday. I am passionate to learn excel advanced features along with Power BI ☺️☺️. Thank you for explaining in detail in this video.

    @deepakgautam8958@deepakgautam89582 жыл бұрын

    • You're welcome Deepak, good luck with the learning journey

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • Deepak can u share your FB account.I am getting prepared for data analyst job.I will share my doubts there

      @harshitraj8479@harshitraj8479 Жыл бұрын

    • Please mujhe bhi data analytic ke liye prepare karna hai to mujhe kuch pata nahi hai. Kuch bata sakte hain kaha se kare plz help me .

      @radha_radha1@radha_radha1 Жыл бұрын

  • Thank you so much! This is the best presentation I've seen. Very much appreciated.

    @kelliecraine3312@kelliecraine3312 Жыл бұрын

    • Thanks very much, I’m grateful you took the time to let me know

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks so much for this video! It was extremely helpful! I feel like my Excel skills has grew profoundly. Appreciate the great work.

    @sjones7333@sjones7333 Жыл бұрын

    • You’re welcome, thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thank you so much for this. You made so simple. I was referred to your video and I am impressed. Thank you

    @rotimioladunni7761@rotimioladunni7761 Жыл бұрын

    • Great to hear Rotimi, please thank the person that referred you for me 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks! I have discovered Power Query already and use it everyday. But I still learned some new tricks in your video such as the Unpivot Other Columns and when to use the Data Model. And yes, not enough people use PQ and the Tables function yet. Will show them this video next time 😀

    @VinnieFarsheds@VinnieFarsheds Жыл бұрын

    • That's great Vincent, thanks for leaving a kind comment.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I have often wondered how a channel like this doesn't have a million subscribers and millions of views! This stuff that you have shared here is very useful! Thanks for sharing tthough!

    @willykitheka7618@willykitheka7618 Жыл бұрын

    • Thanks! Tell others and we'll get there eventually! Coming up to 2 million views in a few weeks!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Such a great overview. Explains it all so well

    @controlsgirl@controlsgirl Жыл бұрын

    • Thank you 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Love your enthusiasm! Great tips!!

    @jaapjonkercom@jaapjonkercom Жыл бұрын

    • Thanks so much Jaap

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • All this functionality is exactly what I would teach a new data analyst. Great Job.

    @im2yz4u17@im2yz4u17 Жыл бұрын

    • Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • ​@@AccessAnalytic Could you please help me know what skills are required to become a data analyst?

      @akashgautam1909@akashgautam1909 Жыл бұрын

    • Logical reasoning, breaking elements down into smaller problems, ability to communicate results simply to decision makers. Good Excel skills ( or some other data analysis tool ) It really depends on what type of data analyst role you want / have. A good understanding of SQL may also be required for certain roles. For me I’ve been fine with Power Query for my data extraction and prep

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Just discovered your channel - very well presented, and incredibly useful tools. Subscribed!

    @Silentstrike46x@Silentstrike46x Жыл бұрын

    • Excellent - welcome!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • So glad to have found your channel. Excellent. Thank you...

    @richardf6932@richardf6932 Жыл бұрын

    • You're welcome Richard (tell all your friends!)

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks so much! Power Query & PowerPivot are going to be so useful; I wish I knew about them years ago!

    @benaycock1646@benaycock1646 Жыл бұрын

    • Yep it’ll change your working life for the better

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I found unpivot other columns last week. Saved me so much time!

    @DaddyBear3000@DaddyBear3000 Жыл бұрын

    • Absolutely K

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Control space. Control space 🤯 I've been highlighting and scrolling my entire life, ooof glad I found this video lol.

    @Theausomecaleb@Theausomecaleb Жыл бұрын

    • 😀.. we’ve all been there

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Such a great video, thank you! I've subscribed - you have an excellent teaching style, easy to understand, relevant material. Great stuff!

    @user-de6nr8ce3s@user-de6nr8ce3s11 ай бұрын

    • Awesome, thank you!

      @AccessAnalytic@AccessAnalytic11 ай бұрын

  • Perfect presentation and guide, thank you for this!

    @iiiprogressive@iiiprogressive Жыл бұрын

    • You’re welcome GS

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • wow, this is the first time I know about Power Query and Data Model in excel and their uses. The way you explain is called true teaching.

    @uzairrehman6193@uzairrehman6193 Жыл бұрын

    • Great, thanks for leaving a comment Uzair

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Super thanks , I have to prepare Monthly Dashboard in my new job asked by my CFO ,never did it before . this is so so helpful ,thanks and love the way you teach.

    @running4fun863@running4fun863 Жыл бұрын

    • Thanks for the kind comment, glad to help

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Excellent video Wyn, you mention all key points from different function of Excel, I learned and understand instantly, Thank you. Had subscribe to your video, will continue learn from you.

    @newbird5944@newbird5944 Жыл бұрын

    • Thanks newbird 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Wow, excellent work and presentation. Thank you so much !

    @sabbangoud5177@sabbangoud5177 Жыл бұрын

    • Thanks for the kind feedback Sabban

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Excellent! Very simple explanation. I will revisit this as I practice power query and data models.

    @BMBlogHost@BMBlogHost16 күн бұрын

    • Thanks, cheers for taking the time to let me know you liked it

      @AccessAnalytic@AccessAnalytic16 күн бұрын

  • You are great! This is also for beginners and not only for pro. Thank you !

    @3zlatnalava@3zlatnalava Жыл бұрын

    • Thank you 😊

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • This is an excellent training video !! thank you very much !!

    @assaparan2214@assaparan22142 ай бұрын

    • You’re very welcome. I appreciate you taking the time to let me know you found it useful

      @AccessAnalytic@AccessAnalytic2 ай бұрын

  • I wish my teachers taught me this work in school. This is so valuable, not only for data analytics but also for any industry or career. Thank you, sir, for teaching new Excel skills to advance in

    @vernoneatwell5449@vernoneatwell54494 ай бұрын

    • You are welcome. Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic4 ай бұрын

  • I never could do pivot tables very well without a lot of correcting afterwards. This is the best tutorial I've seen about Excel for data analysis.

    @Old52Guy@Old52Guy Жыл бұрын

    • Thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • Please, what keys do I press on the keyboard to select two columns at a time in power query editor?

      @user-ou6lh3dw4w@user-ou6lh3dw4w8 ай бұрын

  • I wish I could watch this video years ago!

    @user-ql3rv2fj2d@user-ql3rv2fj2d Жыл бұрын

    • 😀

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I just came across this video, haven't worked with PQs yet. Genius!!!

    @natashataylor9877@natashataylor9877 Жыл бұрын

    • Power Query is awesome!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Amazing, I did not know what powerquery was. So powerful!

    @crispisauce@crispisauce Жыл бұрын

    • Absolutely

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • This was such a helpful video! I'm excited to watch more. Thanks!

    @jenna_eli@jenna_eli9 ай бұрын

    • Thanks for taking the time to leave a kind comment. Hope you find more useful content here

      @AccessAnalytic@AccessAnalytic9 ай бұрын

  • Thank you, good selection of features here!

    @joshuawilliams4191@joshuawilliams41915 ай бұрын

    • Thanks Joshua

      @AccessAnalytic@AccessAnalytic5 ай бұрын

  • Amazing video with crystal clear explanation.

    @mohammedsalah790@mohammedsalah790 Жыл бұрын

    • Thank you 😀

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks for the really useful info. Some of these features are going to help with so many pain points I've had with my excel skills - just the "insert table" is going to make a big difference

    @flipperiflop@flipperiflop5 ай бұрын

    • Glad to help. Thanks for leaving a comment to say it was helpful.

      @AccessAnalytic@AccessAnalytic5 ай бұрын

  • Simple and quik explanation.Easy to understand.

    @vasudevanjayaraman@vasudevanjayaraman Жыл бұрын

    • Thank you

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I'm an old DBA and I'm not easily impressed. With that understanding, I'll say that I'm seriously impressed, not only as a DBA but also as a teacher and presenter. Very, very, well done, good Sir! And those people that only watched the first 18 seconds before they bailed? Even if they already know this, I'm thinking they missed how to present with the proper order of revelation and more.

    @jeffmoden4332@jeffmoden4332 Жыл бұрын

    • Thank you Jeff. Greatly appreciate you taking the time to leave some thoughtful feedback.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • beautiful ❤❤❤❤ THIS IS HOW AN EXCEL VIDEO SHOULD BE SHORT, STRUCTURED, TO THE POINT AND CRISP ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

    @cpsbhati@cpsbhati4 ай бұрын

    • Thank you so much, greatly appreciated 😁

      @AccessAnalytic@AccessAnalytic4 ай бұрын

  • Thank you for sharing your knowledge!

    @gcasaril@gcasaril Жыл бұрын

    • You are most welcome. Thank you for commenting

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I remember discovering power query by accident a year and half ago. I was trying to combine multiple source workbook to make a pivot table. My life has never been the same.

    @alex626ification@alex626ification Жыл бұрын

    • Absolutely Alex!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Good list. Pivot Tables are so essential. I agree that more people should use Power Query, but I've made too much money creating tools that do exactly what Pivot Tables are designed to do. I would have rather empowered those folks. Overall, excellent summary of the features. You even got a little into the data models. 👏🏼👏🏼👏🏼👏🏼👏🏼

    @OzduSoleilDATA@OzduSoleilDATA2 жыл бұрын

    • Cheers Oz

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • Excel on fire if you feel confident in your excel skills where should one apply. If they don't have the work experience.

      @rickeyjones729@rickeyjones7292 жыл бұрын

    • @@rickeyjones729 To a data analyst job? They are in demand so even with no experience you will probably get some responses, you will almost certainly be required to do a excel test or two for them though

      @Honking_Goose@Honking_Goose Жыл бұрын

  • Fantastic! This is going to save me tons of time! Thank you!

    @teejnar1971@teejnar1971 Жыл бұрын

    • You’re welcome Ranjit, thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Excellent video with clear concise explanations. On;y just came across this channel and finding it super useful for learning the basics of power query👍

    @ROBROB301@ROBROB301 Жыл бұрын

    • Thanks for letting me know you're finding it useful Robert. My goal is to tell as many people as possible about Power Query - it's awesome!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Amazing. Simply loved it the way the presented. Awesome, Thank you!

    @nandra8053@nandra80532 жыл бұрын

    • Thank you, I appreciate you taking the time to leave a kind comment.

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • @@AccessAnalytic Congratulations for first 10K. I hope, it soon becomes 100K; then 1M and so on.

      @nandra8053@nandra80532 жыл бұрын

    • Thanks very much

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

    • classroom theory end practice room speak utility commonication software quality basic simbol year 2022 / 2023 sys data com master motivation.com🏛🌍🌎🌏

      @rudiansyahsyah9738@rudiansyahsyah9738 Жыл бұрын

    • L LP l👍

      @cashewcampbell2406@cashewcampbell2406 Жыл бұрын

  • so practical that anybody can apply what they learn from this lecture right away.

    @09tgfl81@09tgfl819 ай бұрын

    • Thank you

      @AccessAnalytic@AccessAnalytic9 ай бұрын

  • This was extremely helpful. Thank you.

    @SuchiSumanasekara@SuchiSumanasekara9 күн бұрын

    • You’re welcome.

      @AccessAnalytic@AccessAnalytic8 күн бұрын

  • This is very good! Seeing the stuff I really need to know. Thank you very much! :)

    @JennTheWriter@JennTheWriter Жыл бұрын

    • You’re welcome Jennifer. I hope some of the other videos can help you on your learning journey

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I love the way you teach very clear , Thanks

    @elliberjohncaridad7452@elliberjohncaridad7452 Жыл бұрын

    • Thank you 😊

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Very good explanation. I’m learning excel now and after watching how you clean the data in power query I was thinking all the formula that I have to use to clean the data, way easier power query

    @ninas.2724@ninas.2724 Жыл бұрын

    • Absolutely Nina. It completely changed how I use Excel

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Great video and presentation. I think I learned the most in the shortest time of any video presentation.

    @Blue-Kayak@Blue-Kayak Жыл бұрын

    • Thanks for taking the time to let me know it was useful. Much appreciated Jerry

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Lol I love your charisma! I relate to the excitement you have for auto updating formulas in tables so much 🤣

    @elisabethschlarb3059@elisabethschlarb3059 Жыл бұрын

    • Thanks for the kind comment Elisabeth.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I just love this video...So well explained!!

    @muhammadzubairkhan3136@muhammadzubairkhan3136 Жыл бұрын

    • Thank you, I appreciate you taking the time to let me know you found it useful

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Thanks, helpful. Brief and informative.

    @JamboRiffs@JamboRiffs Жыл бұрын

    • Cheers JamboRiffs 😁

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • This is exactly the vid I wanted. Thanks!

    @yellowbearworks2535@yellowbearworks2535 Жыл бұрын

    • No worries. You’re welcome

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Hello, greetings from Argentina, your video helped me understand more about the concepts since I am just starting out and like everyone else at the beginning, I am just starting out with MS EXcel.

    @user-oo5ct9tb2b@user-oo5ct9tb2b2 ай бұрын

    • I’m glad it helps. It’s a never ending learning journey. I’m still learning after 27 years!

      @AccessAnalytic@AccessAnalytic2 ай бұрын

  • This was awesome, I thought I was reasonably competent in Excel but I didn't know any of these features existed 😅! Thanks for sharing these, I'll be keeping an eye out for your upcoming courses!

    @bernicesmith8793@bernicesmith8793 Жыл бұрын

    • Ditto

      @chrisgoes9610@chrisgoes9610 Жыл бұрын

    • Great! It’s truly transformative technology

      @AccessAnalytic@AccessAnalytic Жыл бұрын

    • 😃

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Perfect, and thank you for sharing.

    @MohamedHassan-qz5uh@MohamedHassan-qz5uh Жыл бұрын

    • My pleasure!

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Why did I missed this channel until these days😢 Excellent and pleasant teaching step by step clearly. 😊😊

    @uchiha_sasuke_48@uchiha_sasuke_489 ай бұрын

    • Thank you for the kind comment and welcome to the channel 😀

      @AccessAnalytic@AccessAnalytic9 ай бұрын

  • Amazing, very helpful. Stay blessed.

    @wajahatrasheed1173@wajahatrasheed11732 жыл бұрын

    • You’re welcome Wajahat

      @AccessAnalytic@AccessAnalytic2 жыл бұрын

  • I enjoyed watching this, thanks young much.

    @timothyntwa7112@timothyntwa7112 Жыл бұрын

    • You’re welcome, thanks for taking the time to leave a kind comment

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • thanks team, very simple and easy to follow

    @PhuongNguyen-lx7wc@PhuongNguyen-lx7wc Жыл бұрын

    • You’re welcome Phuong

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Wow then more wow. That is super helpfull and is going to save a pile if work Been using excel for years but never knew this was possible. Brilliant video, really well presented in an easy to understand way. Really grateful for you sharing this.

    @Chef-1707@Chef-1707 Жыл бұрын

    • Thanks for taking the time to leave a kind comment Chef 1707. 😀

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Great videos, both informative and inspiring.

    @aaroacademy@aaroacademy Жыл бұрын

    • That’s fantastic to hear, thank you.

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Agreed totally. Always work with tables and bring them backstage with Power Query for transformation, should be the default way to use Excel.

    @timpanister73@timpanister73 Жыл бұрын

    • Definitely Jenny

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • Wow! I am impressed. Thank you for making this video.

    @thanomphan@thanomphan Жыл бұрын

    • You're welcome Pat 🙂

      @AccessAnalytic@AccessAnalytic Жыл бұрын

  • I wish I saw this years ago. Thank you. Legend.

    @MrPrescamacho@MrPrescamacho Жыл бұрын

    • You’re welcome. Cheers.

      @AccessAnalytic@AccessAnalytic Жыл бұрын
KZhead