This is how I ACTUALLY analyze data using Excel

preview_player
Показать описание


┋Professional Certificates┋

┋Timestamps┋

00:00 The data analysis exercise
03:44 Suppliers, Brands, Categories
05:22 Year on Year Growth
08:40 Market Share
12:13 YTD Profit and Moving Annual Total Profit

Thanks so much for taking a little time out of your day to watch this!
Рекомендации по теме
Комментарии
Автор

Hi, mate! My name's Vlad. I'm from Ukraine. Three months ago, I became a data analyst. This is my first job as an analyst. You mentioned Tableau in this video, and I just want to say that a few months ago I watched your video wheere you bilt a dashboard. I learned a lot from that tutorial and it actually helped me to nail the test task for my current job. Just wanted to say thank you for these tutorials. Keep going!

HorbachenkoVlad
Автор

I watch a truly embarrassing amount of excel/data analysis videos and you/this one stood out immediately. You have a great style and approach. Short and sweet, and I already picked up a couple of tips I'll be able to use immediately.

loose.electricity
Автор

I love people who are fast at teaching like you and it makes me become more busy and occupied and i learn quick

uchindamiphiri
Автор

Not a data analyst but my approach for quick data work in excel to answer some questions is practically identical. Nice!

vipersorc
Автор

Your teaching is quick but very good. I know nothing of data analytics but I understood what you did, except for the formulas. So obviously I need to go back and learn how they work. I just wanted to let you know that I enjoyed watching your video and learned a lot from it. Thank you.

debrawest
Автор

This is gem. Clear and to the point explanation. But I don’t get the part 14:52. If I found your video earlier, I would have passed my interview. It’s not related to data analysts but the test given in the interview was similar. Keep up!

himawarisunflower
Автор

Wonderful video. Refreshing to find something that is not based on BLING and "look-how-complex-i-can-make-stuff-up", but down to the core point. My MO is identical; good information doesnt need complex optics. also THANK YOU i have not heard of the CTRL+Drag-Option to duplicate sheets. I will duplicate the ** out of excel from now on :D

AJ-fdyj
Автор

Okay, I have to say this. I've just started learning Data Analytics & completed the Excel, but didn't actually know how to start from, and this video definitely hel;ped me. Thank you so much.

homelander
Автор

Yho bro, 10 minutes into your presentation I am already hooked, you have amazing way of simplifying content and making it easy to follow. Big up to you, you gained yourself a fan for life, as I indulge for more.

kometsikhotlele
Автор

Thank you for doing such interesting lessons. They are always useful to me!

ElinorLane
Автор

Thank you Mo! I work in the same field and you inspire me to be a better professional at what I do. I'm also passing along your videos to my sons, so they'll get to improve their work strategies.

quirogan
Автор

It was a very interesting video. It’s valuable to see how you approach an analysis. Thanks for the free content!

jeff_tech
Автор

Wanting to break into data analytics as a job, so this video was great! Thank you!

TheCraftyboy
Автор

This is great sharing MO, thanks a lot!

jimmycabutotan
Автор

Well detailed, I have been using Excel for several tasks, glad to watch this

Tobiluminous
Автор

YO YOU ARE SO GOOD TRADER AND EXPERINCED IN TRADING, I WATCH YOUR ALL VIDEOS AND EVERY DAY I LEARN SOME THING NEW ABOUT TRADING FROM YOU️

EugeneWashington-yj
Автор

This is good to learn dynamic tables and compare data, thx for share this knowledge!

Shinya-Arai
Автор

I feel like the double-click on columns to resize them to fit your data is such a well-known hack... so dang, why didn't I know you can double click on rows in the same way?? lol Great video start to finish. the MAT toward the end was especially helpful.

jhadinger
Автор

This was a very good learning experience. Thank you so much!

albertocustodiojr.
Автор

You're amazing man. Thank you for all the tips!

martinng