Data Analysis Essentials in Excel

Подписаться 533 тыс.

Просмотров 135 тыс.

50% 1

Learn 3 essential excel skills for data analysis which are data cleaning, analysis, and visualization.
👉 Our Excel for Business Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/64e60c...
In this video you'll learn the essentials of data analysis broken down into data cleaning, data analysis, and data visualization. In the data cleaning section, we'll use Power Query to clean up a raw set of data. This will include changing formats, merging columns, and trimming spaces. Then, in the analysis phase, we'll answer some questions about our data using pivot tables. Finally, in the visualization phase, we'll use conditional formatting, box plots, and scatter plots to visualize the data.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Data Cleaning
3:37 - Analysis
8:40 - Data Visualization

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 99

@KenjiExplains 10 месяцев назад

👉 Find our Excel course here: www.careerprinciples.com/courses/excel-for-business-finance

@AGhosh1888 7 месяцев назад

Kenji, I wanted to ask you, what laptop model do you recommend for people working In FP&A? I have a choice between Microsoft, thinkpad or apple MacBook? I look forward to your reply

@user-gg5pm9ws1o 4 месяца назад

Where are you exactly cause I really liked the teachings

@petermapoma366 8 месяцев назад

I love the way to teacher. A lot of youtubers make excel to be so complicated but you teach with simplicity that even the layman can understand. Thank you so much!

@user-ri3nr1yt8n 9 месяцев назад

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.

@LakechBetiret 4 месяца назад

you have briefly describes pretty the basics of important excel data analysis skills. Very helpful. Thank you. Keep the good job.👍👌

@berbagiilmututorial121 10 месяцев назад

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

@scwyldspirit 10 месяцев назад

Another awesome video. Got a ton out of it.

@madhavinanavati9115 2 месяца назад

superb EXPLAINAION TO LEARNERS...i AM A GREAT FAN ...tHANK YOU IN ABUNDANCE...WANT TO LEARN A LOT

@matildawheatley8982 8 месяцев назад

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

@KenjiExplains 8 месяцев назад

Glad it was helpful! best of luck with the new role :)

@kpopKIDS 8 месяцев назад

@@KenjiExplains HI WHEN I AM MAKING CHANGES AND LOADING THE FILE THE FILE REMAINS THE SAME PLEASE GUIDE

@StepByStepExcelTutorials 5 месяцев назад

Great tips for those getting to grips with FP&A!

@Richkotite1 4 месяца назад

This was really helpful and easy to follow, I got a lot out of it.

@pamela5868 7 месяцев назад

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?

@Anne-lj4ri 8 месяцев назад

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

@kevindaniel7333 10 месяцев назад

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

@akande88 8 месяцев назад

Great tutorial.. kenji, thank you

@camlex6310 9 месяцев назад

Another great video!! Thanks

@adderlyacevedo8232 7 месяцев назад

Your videos are gold!

@user-dm8zs6xq7m 7 месяцев назад

Really good approach, thank you.

@ishasharma0210 Месяц назад

This was great! So helpful! I learnt a lot of new things that put me at ease :)

@sissi7909 7 месяцев назад

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

@FreeKiLLuminati 10 месяцев назад

Love your videos Kenji

@celestinballa6640 9 месяцев назад

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

@zizo8737 8 месяцев назад

Great love your calm tone😊

@SakthivelOrganics 10 месяцев назад

awesome Kenji

@abdulwahabmohammed4357 2 месяца назад

Thank you for your video, i like your teaching approach that is very clear and short video, but i need full course the data cleaning, analysis and visualization. i usually used power bi and excel, and some time google data studio. i'm public health profession. thank you for your regular updates.

@rosaluna5220 10 месяцев назад

Thank you Kenji

@emmanuelanyalemechi6244 9 месяцев назад

Well done, Kenji

@danielgreen6984 9 месяцев назад

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

@MrShoaib82 7 месяцев назад

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.?

@btw_abdu11ah_arain 9 месяцев назад

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

@abduljalil-fz2bx 9 месяцев назад

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

@The_Spontaneous_Adventurer 9 месяцев назад

very resourceful. Thankyou

@KenjiExplains 9 месяцев назад

Glad it was helpful!

@kingbonetti5978 10 месяцев назад

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

@patiencemakadzange1754 5 месяцев назад

Awesome video

@amauryvanlangendonck4631 7 месяцев назад

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?

@carolferro197 5 месяцев назад

Kenji, I do not have the "Analyze Data" tool, and even though I´ve tried to add-in by costumizing the ribbon, It wasn´t possible. Is there sum else I can do? Tks! You have no idea how much your videos have been helping me...100% lifechanger ;)

@oshneythakur2449 9 месяцев назад

AMAZING VIDEO

@KenjiExplains 9 месяцев назад

Glad you think so!

@MBAGirl 4 месяца назад

thanx alott to you

@nishanth4323 10 месяцев назад

Thanks 🙏

@KenjiExplains 10 месяцев назад

You’re welcome 😊

@muhammadhasanraza1606 5 дней назад

amazing

@surajpandey1508 10 месяцев назад

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

@KenjiExplains 10 месяцев назад

Just noticed it thank you for pointing it out

@webserfer2393 10 месяцев назад

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

@KenjiExplains 10 месяцев назад

Just noticed this, thank you for pointing it out

@aduntoridas010 3 месяца назад

@@KenjiExplains Explains why I dont use power query. Can't trust it if it doesn't do the job perfectly.

@VishnuVardhan-sj6nd 9 месяцев назад

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

@afr_afr 7 месяцев назад

same problem! Anybody?

@dakesim 4 месяца назад

same problem :(

@WestCoastKop 4 месяца назад

Hi Vishnu, I had the same issue but I was able to find a work around. From the Data tab, select Get Data(Power Query). Then select "Launch Power Query Editor." Under the Home tab, find the New Query field and select 'Get Data.' Select "Excel Workbook" and choose this workbook. It worked for me, hopefully that answers your question.

@sarabendranathgharai3898 10 месяцев назад

Dear sir,😍 I'm a big admirer of Ur all tutorial videos 👍.Advance #Happy_Teacher's day sir🙏. Ur d best online teacher✌I watch all Ur videos everyday nd it all help me a lot in every aspects.Ur technique of teaching alwys inspire me 2 learn more nd more... I'm not jst a student of Urs but also a great admire.Sir can U please make a video about Ms Word 365 basic 2 advance use purpose . I requested U 2 help me out. I alwys wish 4 Ur great future, health nd properties. Love nd respect🙏 U r doing a great job keep it going🤞 0:44

@sarabendranathgharai3898 9 месяцев назад

Why not U reply me SIR😭😭😭

@willzinner8813 10 месяцев назад

Can you do more video on the visuals?

@KenjiExplains 10 месяцев назад

you mean like a video on data analysis visuals?

@itsFidel 9 месяцев назад

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

@juststudy5836 8 месяцев назад

I think we need latest version of excel for that. Currently I am using free version or cracked version I don't have that either. If it is because of another reason please let me know.I think that is pretty usefull tool.

@janemuller5988 20 дней назад

Are the courses all online and do you supply the courses to people in Australia?

@expertgaming5146 5 месяцев назад

So we can either clean data manually or by using powerquery right ?????

@sonerguney3225 10 месяцев назад

Çok iyi

@therankmaster9279 10 месяцев назад

Can you do videos on how to get into investment banking, updated version

@KenjiExplains 10 месяцев назад

Hey, thanks for the suggestion! tbh I don't think I'll be doing this as there's a lot of good content on it already by people more qualified that me :)

@rajeshkumarjha7306 9 месяцев назад

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

@Rider-jn6zh 10 месяцев назад

Which Excel version u r using. Please Send us the link to download excel. In my excel i dont have many options

@KenjiExplains 10 месяцев назад

microsoft 365. Excel file in the video description

@MoreyW 2 месяца назад

Can't access Data Analysis icon to summarize revenue after following procedures to add it

@budiyuwono7587 4 месяца назад

Hi kenji, just want to ask when using from table/range to fix salesperson name, the spaces between jenna silva name is not fix properly, while using =PROPER formula it's totally fixed. do you know why it's happened ?

@Jakeolivier1 Месяц назад

Why don't you format the revenue value as currency? Is there a technical advantage to this when visualizing data? Or when you transfer it to other apps?

@user-eh4qf8bg6z 6 месяцев назад

How do i download this data for practice?

@satyaranjanparida8065 9 месяцев назад

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

@keifer7813 9 месяцев назад

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

@ruslanazimov8616 9 месяцев назад

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

@chanchalmoolrajani6044 Месяц назад

Hello. I dont have the Analyse data add in in Home ribbon. Please help

@rahatahmad473 2 месяца назад

My scatter diagram trend did not match with your diagram. Mine trend line shows downward trend .Although i followed your steps. Where i went wrong, im not sure. Thank you.

@rahatahmad473 2 месяца назад

I tried again .Now it works. Thank you.

@clemokoye3206 3 месяца назад

How do I install Analyse Data to my excel ribbon. I have tried using add-ins on from the option tab but it is still not working

@laputa4825 10 месяцев назад

What is the difference between VBA and Power Query?

@KenjiExplains 10 месяцев назад

VBA is a programming language so it's primarily for automation, while Power Query is for data transformation (like cleaning up datasets). Many of the Power Query tasks you could automate with VBA (but it obviously takes time and it may be easier/faster to just use power query)

@laputa4825 10 месяцев назад

@@KenjiExplains Do you have any examples of when we would want to use VBA (automation)?

@kyawthiha6429 9 месяцев назад

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

@etc_be_a_62harshshinde66 4 месяца назад

Am not having data analysis button using ai feature in excel how to bring that ?

@heplanglangstang973 5 месяцев назад

7:45 I don't have this data analysis in my ms excel ,how do i add it can you please help ?

@mackyd90 6 месяцев назад

I cant find the Analyze Data in my home tab

@flickhunter8900 4 месяца назад

how to add the "analyze data" AI tool into excel?

@ssrk369 6 месяцев назад

He's a very good player, but some pr intentionally degrade him..if a man stands for himself and give valid points they brand him as misogynist... I'll vote for Dinesh ♥️

@rishabhsingh9902 8 месяцев назад

i am unable to find analyze data?

@rakkeshkannadhanasekar8716 7 месяцев назад

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

@official_jeshua 3 месяца назад

same

@user-pk4le2nk1y 5 месяцев назад

how to make slash atoumatik in date in excel like 02032024 to 02/03/2024

@tnsmlnk2149 5 месяцев назад

ERROR: "JENNA SILVA" // "JENNA SILVA" Obviously, there's an error within the data cleaning. I've noticed it when creating the pivot table. Salesperson "Jenna Silva" has not correctly been cleaned. It appears twice, one is having too many blank spaces within first and last name. What is best practice to solve that?

@inashafi7597 5 месяцев назад

Very nice...but you are too fast..and you need to wait zoom in the instructions

@DWestnik77 8 месяцев назад

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.

@pashahillyard8763 7 месяцев назад

Just split the column into 2 by "space" delimiter, then trim both columns, then merge again. Honestly, this is probably a "best practice" as it likely covers more data-cleaning bases than just this singular issue Edit: my apologies, just now saw the end of your post!