Data Analysis Essentials in Excel

I cant find the Analyze Data in my home tab

You just got one more subscriber. Thank you sir! I am an accountant and really enjoy the data analysis videos you have made. What advice can you give one who wants to venture into data analysis without having to undergo a degree program?

Hi thanks for this instructive video, i learned alot :) !! while watching this video i realised that i lack interpretation of the results, have you any video on this topic, i don't know how to question my self about the results i'm looking at

Really good approach, thank you.

Your videos are gold!

Thanks for that. I noticed than in the file there is Jenna Silva and Jenna Silva as 2 different salespersons, how to make them as one?

Very informative. I love the way you explain. I am unable add Analyze data button in home tab. Please guide me how to do that.?

I am not getting analyze data button in home tab can anyone helm me regarding this issue

With all due respect, your start table has a flaw - ["Jenna Silva"] instead of "Jenna Silva". End it is ruined all your work for your "manager". Because you have two Jenna's instead of one. So, all your pivot tables are wrong. Excel Power Query Format Trim function does not work and it is sad. Because - "Text.Trim – This basic function removes leading and trailing whitespaces from a given text string." As in ["Jenna Silva"] it is neither leading and trailing whitespaces, there are three excessive spaces in the middle. I could not find an easy way to correct it as I am not Excel pro, so has anybody found a way to fix it? Except manually, of course. OK, found it, in Power Query split this column using "most right" option, format it separately and merge it back.

i am unable to find analyze data?

Never usually comment on videos, but this video has been amazing! have learnt a lot from this video alone. I start a new job next month so brushing up on my skills. Thank you Kenji

Great tutorial.. kenji, thank you

Great love your calm tone😊

Really good explanation in your courses which have been really helpful Just wondering if you have any for the "not for profit" especially the accounting life scenarios

I like cleaning, don't mind analysing, and hate visualizing

What is excel version? How can i get that free , my excel doesn't support some functions

i can't find analyze data icon in my excel why not show

Manager Requirements
- Clean up the data
- Summarize the revenue
- Show revenue by salesperson
- Do we have a male/female breakdown

شکریہ بھائی ❤️ اللہ آپ کو سلامت رکھے 🤍

very helpful, how can I add that "Analyze data" AI to my excel

very resourceful. Thankyou

AMAZING VIDEO

Hey can you do a tutorial with drop down lists where whenever we make a selection it performs an equation respectively.

Can anyone please tell me that how I can install analyze data in excel

Hey Kenji! I couldn't follow the Data Cleaning step of this video on my Mac. I have the latest (full) version of MS Excel. The Excel doesn't show 'From Table/Range' option due to which I am not able to use Power Query. Any suggestions? (Love your content by the way!)

Another great video!! Thanks

One thing i like about your vidoes is that they are short and very informative. I learned Power Bi within 15 minutes from this channel.

I want to send my sincere praise to the course "Essential Excel Skills for Data Analysis." This course is truly outstanding and valuable. It has helped me master essential data analysis skills using Excel effectively. The content is very clear and easy to understand, which has allowed me to make rapid progress. I will continue to apply this knowledge in my work. Thank you for creating this excellent course!

hii,
In my excel there is no analyze data button in home ribbon. how to get that?

Thank you so much Sir!!, my excel have no analyze data option in Home Tab, if you kindly guide me like which version of Microsoft office I have to use , current version is LTCS

Well done, Kenji

i love excel and i love the you have mastered it you are the best bless up

Very good, helpful video for me--thank you!!

Thank you Kenji

Love your videos Kenji

awesome Kenji

Another awesome video. Got a ton out of it.

same thing again and again nothing new

Very helpful Microsoft Excel tutorial, sir, thank you very much

What is the difference between VBA and Power Query?

Hello @kenji Sir there is a duplicate in pivot table where jenna is mentioned twice due to doble space

In Analysis section in pivot table Jenna Silva is doubling and wasn't trimmed as supposed to in Data Cleaning

Which Excel version u r using.
Please Send us the link to download excel.

In my excel i dont have many options

Thanks bro. Can we have a video for making excel or power bi report, dashbord from multiple sources Facebook ADS, Google ADS CRM...

Çok iyi

Thanks 🙏