The ONLY EXCEL PORTFOLIO PROJECT YOU NEED 

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

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.

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

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

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!

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

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!

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.

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

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

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

Nicely explained everything without wasting any time. Thanks Mo

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👍

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 :)

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

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

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.

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!

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.

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

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

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

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

Thank you Mo! My most sophisticated project yet.

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

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

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!

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!

Made my first interactive portfolio project thanks to you!

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.

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

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

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

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

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

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

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

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

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

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

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

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

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.

I practiced with this project and it was actually fun!

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

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

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

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

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

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

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

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

Thanks Bro, god bless u

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

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

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

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

Oh, I just found your exercise files. Thank you.

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

Thanks for your content, can you do more analysis in excel with the new formulas? Thanks again, you're helping me a lot.

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.

Thank You very much. this video really help to learn excel through project

Learned a lot. Thanks

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

I've learned a lot from this. thank you!

hey bro, thanks a bunch for useful prjoect ,I really appriciate it🙌👏

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

Super cool! Thanks so much for your sharing!

Great Stuff! Really Enjoyed

Thank you very much for this wonderful tutorial!

Thank you! This was a great refresher for me🤩.

I watched about 10 minutes of this and it's very good. I know a lot of what you're doing but I'm also learning a lot. Plan on creating this after I finish the last half of my coursera google cert for data analysis. Thanks!

Amazing! Thank you so much for this! I learn best by doing, this is an amazing resource.

Hi Mo, amazing video. How did you end up with just 3 countries? there are lots of countries in our data set.

OMG YOU'RE SO SO SO SO GOOD.

I am going to make this project with you.. Thank you. Please guide me what I can learn and do to start freelancing in data analyst.

This was great, thank you!!

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

Perfect i suggest to make more of these projects like in Excel,Tableau and SQL, for the portfolio i dont know what company look for in an individual for selecting but you can make vidoes that you do on your Job to get insights whats happening in a professional Enviroment , and what kind of portfolio projects should i upload on my website

Very useful video. Thanks for creating this video❤

Thank you so much, you are amazing 😊😊

damn thank you i loved this it took me 3hrs to finish it lol cause I had problems with the $ sign and I keep playing with tools that I didn't know

Hi Mr. Mo, thanks again for this life saving tutorial... Kindly help with the data file you used.. I couldn't find it in the description. Best regards.

Its really so helpful to start with. I just finished the dashboard, I am wandering if I can upload this to my github account or needs to have some changes

Super! so much details

Hi Mo, your contents are so helpful. But can you tell me where should I go to get more excel datasets or projects for me to add to my portfolio?

This was cool and fun to do!

Formula that you have used in the main table, we can simply do all these in power bi right in data modeling right without using any formula?? Just wanted to know your opinion, power bi would be much simple than this.

Great demonstration of Excel peoject. I have one simple question. How to add project like this into your portfolio site? Any suggestions would be appreciated. Thanks

enjoyed the video good work bro loved it

Awsome one mo! thanks a lot..

thanks so much MO for this, could you do the same with SQl and python please? would love to see more projects! :)

You are so inspiring and disciplined. I wish I had all your discipline and the opportunities you had. Sometimes we just get discouraged. We don't even know where and how to start due to so many things to cover since I was very young, I always admired people with continued goals, discipline and hard work. Are you Vietnamese or Chinese. I am trying to guess.

Love this project

dou you guys also having trouble with A-L-0.2 s in index with match part of the video

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 ?

if a comma is not working use a semi colon

You are a life saver.A copact package of all necessary info with shortcuts.I just have one problem.I want to make pivot tables and charts with quantities like pressure and temperature against time and I dont need the aggregation methods of pivots.How can I do this to make dynamic dashboards which are connected to my daily info tables?

Thank you so much this was helpful.i need a file for this dashboard

For anyone who has done this project recently, When Mo groups the 'Order Date' row right after creating the pivot table. How do you group by a specific year?? The software is completely different now.