The Casual dragging of a sheet to create a new one was such a Flex to me It's not something I might ever need, but just knowing you can do that is cool
Great one brother! Would love to learn some SQL basic to advance type tutorials/projects from a real world point of view and then how to visualize it and gaining insights. Subscribed for the amazing content!
@@KenjiExplains and another thing i, along with many other would love to know is basic case studies and knowledge of business/finance needed to become a great data analyst! Hoping to see that as well!
بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟ بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤ اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤
Hi Kenji! Good material mate. Just asking, is it possible to make it harder? Also, I would like to know your vision of the AI in excel and Data Analysis. I think it makes lots of things you are doing here in 1 sec.
Thank you! As for AI in Excel, I find that the scriptwriting process is quite tedious. Sometimes it does what you want, other times it doesn't so I think that part needs quite a bit of work. Especially when you want it to do very precise things
Whenever I try and using the ceiling function an error? For instance, I enter 68.10 into a cell and when I try an do =CEILING(E17) I get a red box and an error? Any ideas.
Why does it say 'Descriptive Statistics contains non-numeric data' when I select what I want to analyze, but when you select rows with words, the Data Analysis function works perfectly? I'm trying to analyze traffic data, but it takes me a full day or two to do it manually because there are many roads with data to process
Hey!! I have been using MS Excel 2019 version. So when you did the analysis part (descriptive analysis) using the "Analysis" feature it was easy but in my case I didn't have the analysis feature so what should I do ?
You have to enable it yourself first by following these steps: 1- Click on the File menu 2- Click on Options. 3- Click the Add-Ins tab. 4- At the bottom of the window, click the Go... button. 5- Check the box next to Analysis Toolpak. Then click OK.
when I use the data analysis with the highlighted fields it does not give the headings from the first row, any reason why this is happening ? I have selected the headings in first row option too.
I'm not sure if it's me, but your =DATE function might be a little different or the order of the cell within the function, it looks like the months are incredibly high numbers.
@@KenjiExplains When I click on the link, I get a 502 Bad Gateway page. Can you ensure your site/link is up-to-date or provide a new link from google drive? I would love to follow along with your tutorial in real-time. Thank so much.
Good to the options menu, click on add ins, then u click on, data analysis toolpak not the vba, then click on Go, then click on data analysis, and that's all you're welcome
It is done for freshers like me that could not afford varsity and have certificates and need practise. Toddlers dont remain Toddlers but grow and we are not born knowing everything, we start from somewhere and we are not the same.
🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
I really want to attend this course are there any promo codes out there?
grea
The Casual dragging of a sheet to create a new one was such a Flex to me
It's not something I might ever need, but just knowing you can do that is cool
Great one brother! Would love to learn some SQL basic to advance type tutorials/projects from a real world point of view and then how to visualize it and gaining insights. Subscribed for the amazing content!
Thank you! Made a 1st video on that last week: th-cam.com/video/wmiDdBG-yP4/w-d-xo.html
@@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!
@@KenjiExplains and another thing i, along with many other would love to know is basic case studies and knowledge of business/finance needed to become a great data analyst! Hoping to see that as well!
I just shared your channel to my team (DPI Chicago) told my new intern to give you like an sub! you are the man 👑
Thank you!
Short and simple but very informative. Thank you very much!
Glad it was helpful!
Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest TH-cam video here! th-cam.com/video/SecaHpkpt9E/w-d-xo.html
i enjoyed every moment of it. thank you so much
Nice one, simple and clear explanation!
Wow. Learned many things in a single short video... Thanks
Thanks, grouping pivot function super helpful
thank you so much kenji vey clean calm and amazing explanation
You're very welcome!
thanks, I learned From you A lot of excel knowledge
Amazing intro !! Thank you
Very valuable video
Super helpful ❤❤ Thank you so much Kenji Explains 😊
Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.
Are you looking to learn some basic python skills for data analytics? Check out my newest TH-cam video here! th-cam.com/video/SecaHpkpt9E/w-d-xo.html
wow that full information insight, Thnks kenji
Thanks It Is really helpful. Thank You
Super, ultra, mega cool!
Thank you very much. It is greatful
I'm glad you like it!
Great Tipx, thank you very much
Glad it was helpful!
Kenji thank you so much
Really helpful!!
short but great thank you
Glad you liked it!
بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية
انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟
بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤
اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤
Great job
Hi Kenji! Good material mate. Just asking, is it possible to make it harder?
Also, I would like to know your vision of the AI in excel and Data Analysis. I think it makes lots of things you are doing here in 1 sec.
Thank you! As for AI in Excel, I find that the scriptwriting process is quite tedious. Sometimes it does what you want, other times it doesn't so I think that part needs quite a bit of work. Especially when you want it to do very precise things
Thank you so much ❤❤❤
Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.
@KenjiExplains which excel version is this? MINE HAS NO DATA ANALYSIS OPTION
Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).
next week hopefully :)
@@KenjiExplains thank you. :)
Whenever I try and using the ceiling function an error? For instance, I enter 68.10 into a cell and when I try an do =CEILING(E17) I get a red box and an error? Any ideas.
a good one.
gracias senor
Why does it say 'Descriptive Statistics contains non-numeric data' when I select what I want to analyze, but when you select rows with words, the Data Analysis function works perfectly? I'm trying to analyze traffic data, but it takes me a full day or two to do it manually because there are many roads with data to process
Hey!!
I have been using MS Excel 2019 version. So when you did the analysis part (descriptive analysis) using the "Analysis" feature it was easy but in my case I didn't have the analysis feature so what should I do ?
You have to enable it yourself first by following these steps:
1- Click on the File menu
2- Click on Options.
3- Click the Add-Ins tab.
4- At the bottom of the window, click the Go... button.
5- Check the box next to Analysis Toolpak. Then click OK.
How to get the data analysis ribbon in MS excel 2021 plus version
I can't find the link to the dataset
I must say the video is insightful and I would like to practice
In the description of the video
@KenjiExplains Thanks you are amazing dude...
Super❤
AWESOME
I suggest to use power query when cleaning data
HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.
when I use the data analysis with the highlighted fields it does not give the headings from the first row, any reason why this is happening ? I have selected the headings in first row option too.
اكثر من رائع
kindly create a playlist for SQL
New video next week hopefully :)
Data analysis icon is not visible in my data tab
Can you please share the datasheet
Make more videos on sql
coming next week :)
How to save these dashboards if we want to send them to someone as pdf or a sheet?
I'm not sure if it's me, but your =DATE function might be a little different or the order of the cell within the function, it looks like the months are incredibly high numbers.
How can I get the dataset for this project
it's in the description
Always here
Thank you!! Means a lot :)
You could have add country also it the slice filter
please, why is the screen blurred at the anlysis phase. i couldn't see anything. can anyone help.
when i drag the date, current date and birth date disappears
please link of this file
in the video description
@@KenjiExplains When I click on the link, I get a 502 Bad Gateway page. Can you ensure your site/link is up-to-date or provide a new link from google drive? I would love to follow along with your tutorial in real-time. Thank so much.
I can't see the dataset
its in the video description :)
I'm not able to perform group age in pivot
How to subtract multiple cells from one cell in excel?
Why don't I have the Data Analysis tab in my excel? How can I do the analysis manually since I don't have this tab?
I do not have the Data Analysis tab. How can I add it? I could not find it.
Same here,i dont no how to add the ribbon
Go to excel options and then click on add-on
Good to the options menu, click on add ins, then u click on, data analysis toolpak not the vba, then click on Go, then click on data analysis, and that's all you're welcome
Cannot GROUP the age..what is wrong with the data?
❤
i still can't drag the age.
Don't do process capability etc
What is the point of doing this kind of simple analysis that can be done by even toddlers 😂
It is done for freshers like me that could not afford varsity and have certificates and need practise. Toddlers dont remain Toddlers but grow and we are not born knowing everything, we start from somewhere and we are not the same.
❤