It may be that you have them disabled due to incorrect downloading. Try to find an office key in BNH software or others that you like and perhaps you will be able to solve the problem.
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!
Hi Vlad, I just wanted to say that I’m super happy a piece of my content directly helped in some actual step in your job application process. Congrats on the job and thanks for watching!
Вітаю! Дуже рада таке читати! Скажи, будь ласка, чи сам навчався? Це були курси чи повністю самостійно дорожня карта? Скільки витратив часу з самого початку? І, якщо можна, скажи будь ласка, як отримав роботу? Як подавався і куди? Я поглибилась в датааналітику, що дуже подобається, але опускаються руки, коли замислююсь про реальність перспектив, мовляв самоучка і т. п. кому потрібно.
Hello! Very good content here in terms of excel skills. However, it would be even more valuable video if you could draw conclusions from numbers, and show the process of writing recommendations because at the end everyone needs concrete recommendation on improvement.
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.
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.
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
I’m glad you like the practical content. The difference between social media data analysis and real data analysis is that in real life, you have one goal, and that is to solve business problems. Not to build the shiniest things. If you do and solve the business problem, that’s fantastic. But if you just build shiny and useless things, that’s just social media data analysis.
Excellent video and information, Mo! I'm glad your channel popped up as suggested. I've subscribed and will check out your courses. I work for the department of the Treasury and this will come in handy! Thanks again!
Can you make a dedicated video on data cleaning where data is really messed up and big in size?? RU-vid really lacks in perfect data cleaning video where all the data cleaning steps are shown.
There's already a million places where you can find the super basic stuff. I want to teach practical, applicable skills and I'm glad this resonates with you.
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!
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.
Hi, would you know how to count the sum of True or False (on checkboxes) within a specified date? Like for instance: On Column A: I have the list of date people registered Column B: is the day their registration should end Column C: is the indication or checkbox, "True" or "Checked" if they have successfully registered and "False" or "Unchecked" if they didn't proceed. Now, I need the summary of how many people successfully registered for each month. Im wondering if you have any tutorial for counting this checkboxes within a month or within specific dates like my example above? Hoping you would notice, i've been watching your tutorials for quite some time and it really helped a lot.
@Mo Chen thanks for the video, i am going for a trainer interview on friday 06/09/2024 and will need you to point me to your tutorials that can help a beginer in excel analysis
You lost me when you said six point ninety one percent. It’s lazy and totally incorrect. If you had 4 decimal places would you say six point nine thousand one hundred? Makes zero sense.
It would be cool to have a playlist of "real business problems solved with only Excel" If you do, please consider the fact that many viewers are using Mac so the Excel should ideally also work for Mac users. Thanks.
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.
Do you have any advice for someone really wanna get into the tech industry and have looked into data analytics and data science but is worried about what jobs will be replaced by Ai?
I recently just learned how to use the pivot tablet and this is a great insight on how to use them in real-time. I'm new to data but I'd love to learn. Curious, do you cleanse the data first before using the pivot table or do you use pivot table to find anomalies for cleaning?
Good question. Data in real-life will never be this clean. I made up this fictitious dataset and I made it clean for this video because I wanted to focus on quick analysis, rather than quick data cleaning. Who knows, maybe I'll make a quick data cleaning video next...
Please make a video on this. I have a sheet which contains data in rows and columns. And there are 4 blank rows after every data row and I want to fill the 1st blank row with the data of sheet 2 and 2nd row with sheet 3 and 3rd row with sheet 4 and 4th row with sheet 5 please make a video it's getting very difficult
I feel you are being arrogant for no reason. For evidence: you called yourself a fool twice if the formula didn’t work, and said "simple equation." I agree that this is basic math and basic skills, but you make it seem as though they are difficult and smart. If you were really smart, you wouldn't show off with simple skills and math. For a while, I thought you were programming one of the learning modules to be used for AI. Stay humble
It looks like you have a simple choice that won't make you say things like that: the unsubscribe button. Maybe you should use it, for it does wonders when you waste your (everybody’s) time making comments like these.
He knows his stuff, but trying to follow him? he's way too quick in showing/explaining what he is doing. so his stuff only good if you are already on his level. especially with all the 'shortcuts' he know/uses.
You don’t have to follow Mo at all. This is just him showing how he uses Excel. As you can see by the title of the video, it’s not a “tutorial for moving averages.” He does that and gives you more tips, like shortcuts. You can see by this entire comment section that people engaged with it. “When everybody says it’s raining and you say it’s sunny, you’ll get wet.”
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.
Thanks for this again Another simple but wonderful resource. I like how you can create these function on-the-go. I know I'd make a lot of mistake before arriving at the formula for MAT if I was in your shoes.
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.
@@mrbartuss1Man, you're just being rude. MO just gave a step-by-step quick analysis approach, and you want him to give you a job in a RU-vid video. Chill out son
@@mrbartuss1 In that case, my man, just soak up all of the information and wait for the next chapters. Your original question basically says that the video is not worth your attention. What if you took this and tried to answer what Mo asked instead? What would you do with the data? That's the only way you'll learn.
