The ONLY EXCEL PORTFOLIO PROJECT YOU NEED

[@fellowlearners]

Thank you, I had to replay everysingle step, felt overwhelmed, then felt like I am a pro after this video. truly appreciate you !

[@user-wp8mk3yg4o]

me too

[@vinil1987]

Recently decided to build a Portfolio , Started with this one .One word "Excellent "

[@covervideo8738]

after 8 month what is with your portfolio? Got a job or something else?

[@emonmondol4901]

@@covervideo8738 what would be a good description or summery for this project in portfolio?

[@DeathAnthem7]

man, i am learning a lot faster with your projects! Courses are nice but this is exactly what I needed. Thank you!

[@mo-chen]

Thanks a lot for the kind words and for watching 😃

[@ontayyyy]

I have to echo this comment! I felt like I learned so much in this video alone about excel! Thank you!

[@yatinshekhar787]

Finally I made my first project🥰🥰 Thanks Mo Chen I will post it into my Linkedin and will definitely tag you🥰🥰

[@duhxdars8667]

Thank you very much for this wonderful tutorial! For someone with a basic understanding of Excel, I think this is the best way to learn about data analysis and how Excel is utilized in the field. This is exactly what I was looking for. More power to you!

[@mo-chen]

I'm glad you liked it! Thanks a lot for watching 😄

[@tonyclinton7588]

Please how did you do the "exact match" function. Am stuck here @@mo-chen

[@kabalayouri419]

This project helped me so much to first get my actual job and then apply it to my current job and i often come back to it ! Thanks man !!!

[@mo-chen]

Amazing!!!

[@incentivemotivation9041]

WHICH JOB ARE YOU IN?

[@kabalayouri419]

@@incentivemotivation9041 business data analyst in a big telecommunication company in France

[@kabalayouri419]

@@incentivemotivation9041 business data analyst in a big telecommunication company in France

[@payafarhadbahman976]

Man, I spent one full day to understand the index match functions you described, and I can finally say I understand and can utilize it well. An added-value video indeed. I'm gonna do the rest. Thanks.

[@linzylee8951]

This video is amazing! I’m so glad I came across it this helped me learn great and useful Excel tips for my work and saved me a ton of time creating charts from the same pivot table with multiple data sources. A typical day without learning this I would spend hours and hours creating multiple charts but now my productivity has increased! Thank you so much, Mo Chen!

[@mo-chen]

I'm so glad you found the video actionable!

[@andrewhting]

Wow Mo...my bro, thank you so much! You're a life saver. My projects are kind of weak in my portfolio and I've been thinking about what I should do about it. What great timing! Your work and generosity is very much appreciated.

[@mo-chen]

Thanks so much for the kind words! Wish you all the best mate 😃

[@pixiediaries3668]

Interesting! To be honest I do not have any idea how to create dashboard and how excel works and etc. but by watching this, I was motivated to learn more about excel and learn more from your tutorials. It was very helpful! Thank you so much! Watchin' from Philippines :)

[@gospelmoto2833]

Indeed! practically helpful. Why didn't I see this one earlier? This deserves more LIKES and SUBS! Many thanks Mo.

[@mo-chen]

Glad it was helpful!

[@Thechanterramarie]

Omg I stubbornly attempted to do this in Google Sheets and let me tell you it was madness 😂😂 but I ended up figured it out and now I feel very accomplished!

[@ichigokurosaki6470]

I'm Struggling so much on google sheets rn, I can't seem to find out a way to edit the pivot table like he did😅 do you have any advice?

[@himanshiaswani5294]

@@ichigokurosaki6470 how to group by year and month on google sheets , i cant seem to do that , only one is getting selected

[@ChabelitaRuales]

Did it in Google Sheets as well until Pivot Tables 😅

[@elghark]

That's actually an added value video! For those who can't change date format: Once cliccked "CTRL+1", BEFORE clicking on "Custom", u need to select "Date" and then "Location" for choosing the English format. Then, u can follow his procedure

[@mo-chen]

I'm glad it actually added value haha. There is a lot of debatable content on YT, that's for sure.

[@dramdan1]

For those who follow try making the following change. In the first Pivot chart have months first and then years. Then you have what type of coffee sales best at a particular month. As a bonus you will have a nice timeline chart.

[@HalpPlsxx01]

MO BACK AT IT AGAIN! LETS GO!!! :D

[@mo-chen]

Thank you for watching 😃

[@AlbouryNdiaye-ro8qz]

Wow Mo! This is a phenomenal tutorial. It blends key basic and advanced Excel concepts. In addition, you took time and effort to explain them clearly. Thank you so much for sharing your knowledge with us. I truly enjoyed this tutorial as well as all the other ones you have posted so far.

[@mo-chen]

Glad it was helpful!

[@TheNisiu]

One of the best Excel data visualization tutorials I've seen hands down.

[@seena1724]

Ctrl+shift+arrow down : block up to the bottom Ctrl+1 : Format cells Ctrl+T : Table Alt+N+V+T : Pivot table

[@expertgaming5146]

we need projects like this with more complicated stuffs, tbh this video really helped me thanks mo

[@OlenaKupko]

It's a completely awesome project. Thanks. I enhanced my skills, especially in terms of styling. I used TEXT function to process "0" values of email addresses instead of IF. Also, I added a slicer with coffee types to have the possibility to analyze total sales more precisely.

[@mo-chen]

Good thinking with the extra slicer!

[@tinaparker9974]

I added the coffee types slicer too !! :)

[@B312XC]

The best tutorial on KZbin. I liked how you explained how to use Index and Match across multiple sheets and fixing columns/rows.

[@mo-chen]

Glad it was helpful!

[@anymjohnson1729]

@@mo-chen I started working with Microsoft Excel in 1996. I worked with it extensively for 5 years, using Pivot Tables, Advanced Formulas, macros, Data Analytics, Chart & Graph Reports, Data Visualization. But little did I know that I was marketable!!! I was taking care of my Special Needs Child for 21 Years and her medical care, So I lost confidence in my ability to work professionally and in my skills, but very recently, I came to discover that people are getting paid to do what I did so long ago!! And they get paid very well!! So I came here to refresh my skills and my memory, kind of to get the hang of it and get familiarized with the key terms used in Excel.

[@marieeyeson9688]

Thank you Mr. Chen. I have been trying to build more data analytics projects and this project has helped me understand features in Excel as well. I have not heard back from some jobs but I will not be discouraged. Thank you!

[@ayushbhardwaj111]

Nicely explained everything without wasting any time. Thanks Mo

[@Adjective69]

Made my first interactive portfolio project thanks to you!

[@dorcasoyibo1141]

I just got your video today and I was able to complete the excel project without any issues. Thank you so much. This has been the most well-explained excel project tutorial so far. Great job👍

[@mo-chen]

I'll take that. Most well explained project on YT. Thanks for watching!

[@molecularptsdneuroscience4123]

This was AMAZING and I learned so much! I will post my work on Linkedin and credit you! Thank you so much!! I hope you do more of these!

[@mo-chen]

Glad you liked it! Will certainly have more of these coming 😃

[@olumayowawilliams7865]

How were you able to download the file? It's not downloading at my end.

[@bhaskarbhardwaj6889]

@@olumayowawilliams7865 hey! I also faced same problem but I have downloaded the whole package i.e zip file and after that I extracted the file and got the data.

[@jessicapierceart]

This was an amazing topic! I learned more from this video than I did from the Excel unit in my current bootcamp! I can't wait to make an interactive dashboard in Excel!

[@mo-chen]

I’m glad you liked this project, thanks so much for watching 😁

[@KannasKaleidoscope]

Excellent presentation Mo. Thoroughly enjoyed it and learnt quite a few Excel tips especially while creating the dashboard. Keep up the good work!

[@sindhujareddy4659]

I recently started watching your videos, and I just want to say they are excellent. I wish I had discovered your channel earlier!😍

[@mo-chen]

Welcome to the channel :)

[@yanpaucon1043]

Thank you, Mo. I have finished the project. You are awesome! ❤🙏😍. More subscribers for you.

[@yadivethfrancis20]

Thank you so much! I learn a lot with your videos at the same time I practice my listening skills😅😊 Greetings from Panama 🇵🇦

[@mo-chen]

Greetings to Panama!

[@AntaraKalele]

Thank you so much for this amazing tutorial! :) Question - Can I add this or a similar dashboard to my portfolio or is this a beginner level project? I would love to see more intermediate and advanced level projects as well!

[@dileriano7529]

Just finished the project. I learned so many things. Thank you!

[@beac5903]

Thank you so much, Mo! Your vids really helped me a lot in landing a job as a data analyst!

[@mo-chen]

I'm so glad to hear this 😁 Congratulations on landing your job as a data analyst! Well done 🎉

[@eslamnasr6325]

THANK YOU. this my first project and i had to search and learn every function you typed and this video was very helpfull to me

[@ArthurRincon]

I started building a Portfolio recently, and this video was really useful, thank you!

[@mo-chen]

Glad it was helpful!

[@ahmedaliiiii]

Amazin Video Mo! I just finished the whole project in one sitting!! We are waiting for more advanced projects and for other tools projects.

[@mo-chen]

I'm glad you liked it, there's definitely more on the way!

[@kelemenaron5905]

Commenting so algorythm recommends this for other junior data analyst. Helpful, simple content.

[@mo-chen]

Thanks! Glad you liked the video!

[@michaelpark5681]

Just followed this start to finish to complete my first dashboard. A really good beginner's guide.

[@mo-chen]

🎉 Getting started is the hardest! Well done!

[@kennymckinney4710]

Thank you Mo! My most sophisticated project yet.

[@mo-chen]

Awesome!

[@Tupagzus]

Thank you so much! Now I had more confidence to work on excel project than before

[@mo-chen]

Fantastic, I’m glad I could help!

[@aditya3david]

I loved this tutorial covers key concepts of xlookup and index match while also creating an interactive dashboard. Totally informative.

[@mo-chen]

I’m so glad you liked it, thanks a lot for watching 😃

[@carrenatieno1736]

Thank you so much for this. I have enjoyed doing it. Although I had some challenges with the timeline, I really loooooovvvved it.

[@rahmadyd]

Finally, i just made it this project, thank u very much for serve this project 🥰

[@cathlinson7327]

Hello Mo. Thank you so much for the video. This video is exactly what I wanted. =) I just downloaded the files and will go through them and practice on my own. I look forward to more videos being released.

[@mo-chen]

I’m glad you like the video, thanks so much for watching 😃

[@HarshitGahlaut-q5y]

Great Stuff! Really Enjoyed

[@mo-chen]

Nice! Thanks for watching 😃

[@Stacy1336]

Amazing tutorial! you are great at explaining and I learnt alot from this. Thank you very much

[@SandipanMajumder-b2r]

thank you so much Mr. Chen for this valuable project keep rocking

[@mo-chen]

I shall keep rocking! I'm glad you liked the project.

[@justoneabdul]

Thank you so much for this project, It helped with Xlookups and index and match concepts.

[@jasneetkaur286]

Such a great video, made Excel learning easy. Motivated to do more Excel Projects.

[@mo-chen]

Glad it was helpful!

[@cesarmunar416]

Quite funny, my first project. Thanks Mo!

[@mo-chen]

Nice work!

[@chenjoya7792]

no hate, at 9:28, you could just leave the "" into the "what to do if not found space of formular"

[@iamdelclem]

Thank you, Mo Chen 😊😊. This is really helpful

[@mo-chen]

Glad it was helpful!

[@haritha3991]

Thank you Mo Chen. Its really helpful

[@mo-chen]

Glad to hear that!

[@nemotheo1629]

thank you so much i loved everything about it can wait to do same to other tasks

[@nsikakthompson6993]

really great, am excited about the xlookup nd match

[@Simran_Warraich_]

This is going to be really useful for me!Thanks Mo for sharing wonderful content. Looking forward to more ✨✨

[@mo-chen]

Thanks so much for the kind words and for watching 😄

[@EricaErica-ey2nb]

I learned too much in this project! Thank you. I would like antoher project portafolio video! You explained so clear!

[@mo-chen]

Please feel free to check out my Portfolio Project Playlist that contains many more guided, end to end projects!

[@davidchen7629]

Thanks so much, i was just thinking about some excel portfolio projects and your video showed up!!!!! 🤣

[@mo-chen]

Great! Thanks so much for watching 😁

[@Chugligang11]

this was great and fun. Thank You!

[@nicoloborgato9714]

Thank you so much Mo! I really like this kind of videos, full of knowledge and interesting inputs, hope there will be more and more!. I'll leave the github links here, I customized the project a bit, but I see it only as a starting point. In the near future I want to continue to improve my skills and always learn new things. I see it as a starting point

[@mo-chen]

I'm glad you like the video! And yes, please do, I'd love to see what you build at the end 😁Thanks a lot for watching!

[@nicoloborgato9714]

@@mo-chen Thank you! I can't past the whole link, I past the second part of it. /Bort439/coffee-sales-xl-mo_chen Thank you again for the support and availability

[@chrisosomo2856]

Thanks a lot for this fantastic project. I am looking forward to applying everything I learnt from this project to my own project

[@mo-chen]

Glad it was helpful!

[@fxrnoosh]

this was so fun doing and learning thank u xxx

[@protocolwonder4558]

Awesome tutorial. Please we need more of this. You making impact.

[@MariaelenaMesisca]

This video is simply excellent, thank you so much for your content

[@mo-chen]

I'm so glad you found it educational!

[@MrWonderninja]

Thank you so much for sharing, I learned quite a bit from this video (especially enjoy all of the hot keys!)

[@Tommy_Hampton]

Well delivered. each step was explained well and also learned shortcut keys.

[@lamiahumayra5635]

where is the link of this data set??

[@mo-chen]

I'm glad you found it useful!

[@shreyastudies4693]

Hey Mo, came across your channel for the first time through this video. Thank you for the wonderful guide, I am looking to make an excel-portfolio and this has been a great starting point. A small feedback, if that's okay: the circular spotlight you were using to probably draw our attention to somewhere on the screen was a little jarring. Maybe it is only me, but the way it made the screen change was difficult on the eye. Perhaps there's a different way to achieve this effect :) Thank you, once again for the awesome video! cheers

[@JamaicanJay]

First project down. Thanks a lot!

[@mo-chen]

Please feel free to check out the portfolio project playlist here kzbin.info/aero/PLodYDTuHA29aa_5UPCNg_g5fyleHxTZPU. There are lots more!

[@JamaicanJay]

@ Will do!

[@DEEJAYNH10]

Thank you for the great projects , was able to learn a lot without a burn out !

[@larspedersen3043]

Thank you so much, Mo!

[@ramirovella6085]

Amazing work and explanation!

[@mo-chen]

Glad you liked it!

[@prathmesh_jadhav8930]

it was wonderful learning experience from this tutorial... Thanks buddy ❤

[@octagonmixltd]

You're amazing. Very informative lesson. Thank you.

[@HuyTran-gl7gw]

i really like this video, I have learned many new things from your video, thank you so much!!!

[@mo-chen]

I’m glad you found the video useful 😄

[@Berrad111]

Hi, I am new to the channel, I will definitely be checking most of your videos!! I do have a question please, where will I a be able to download the set of data you are working with? Thanks in advance!!

[@thespiritledchristian]

Description

[@miltoncastillo8449]

Mister, u ar a living god. Thank you so much. 🎉

[@ryanc816]

Excellent video! I'm going to use this on my LinkedIn.

[@kanishkasingh6533]

Where can i find the raw data?? It's not in the description

[@colombian92317]

Solid video, some of the shortcuts are different because of mac but all in all, really satisfied with this tutorial.

[@mo-chen]

Yes they are a little different but I’m glad you liked it! Thanks a lot for watching 😃

[@binhhuynh9630]

Super cool! Thanks so much for your sharing!

It was very nice practical video for hands on dashboarding

[@mo-chen]

Glad it was helpful!

[@jesperjensen293]

I'm little confused there, my version of Excel wants ; instead of , also in the very first strep with xlookup in the email, I get an value error, even I do exactly as instructed in the video. I noticed I keep getting errors when I type the formulas manually, I have to use the FX option to make it work. any ideas why it's acting like this ?

[@tajudeennate6498]

Check your version, is it 365?

[@setyo1279]

OMG YOU'RE SO SO SO SO GOOD.

[@felipecruz3061]

it is an amazing video..thank you for the content brother

[@mo-chen]

Thanks so much for watching 😁

[@mxrkb10]

Thanks a lot man! I will add this to my portfolio :)

[@mo-chen]

Glad it was helpful!

[@PROJECT.1999]

enjoyed the video good work bro loved it

[@radhwanazeez23]

Definitely, the vedio is enjoyable 😉 ❤. Thanks bro

[@marialaura9493]

This was great, thank you!!

[@mo-chen]

I'm glad you liked it, thanks a lot for watching!

[@AllAboutVintageAndMore]

Learned a lot. Thanks

[@mo-chen]

Glad it was helpful!

[@arthiashok-d1g]

Awsome one mo! thanks a lot..

[@mo-chen]

Glad you liked it 😃

[@dennisr0340]

This was cool and fun to do!

[@abayomijoshua7529]

Thanks so much for this tutorial. Well explained, easy to understand step by step. Pls can I add the coffee sales project to my portfolio?

[@mo-chen]

Yes, of course :)

[@elaymcheaven4111]

I practiced with this project and it was actually fun!

[@mo-chen]

Nice, I'm glad you actually enjoyed it 😃

[@setyo1279]

13:49 omg so i can use either xlookup or index match (but the column names must be the same with the references)

[@inhtaioan4457]

I love index&match cause when you move your column it will never rechange

[@mo-chen]

Exactly, it's so dynamic 😁

[@namo_prami_ulagam]

Thank you Mo Chen. Just now watched fully. I have excel 2019 where there is no XLOOKUP. SO could not complete the project fully. Will try to do with other functions.

[@mo-chen]

You can use VLOOKUP as well :)

[@sabyasachidas4572]

Thank you so much bro for making such a beginner-friendly video🥰 I'll be following your other videos as well. Would you mind making a video on SQL project/ interview questions. It will be very helpful. Thank you in advance.

[@mo-chen]

I'm glad you liked the video! I made a full SQL tutorial recently kzbin.info/www/bejne/g6fGdYBoo7GXsKs. Hope this helps 😁

[@harshagiripragada7435]

This is excellent!!

[@ThenjiNjif]

Thanks for the amazing video👊

[@mo-chen]

Glad you liked it!