🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance
@williamchurch7115 ай бұрын
I really want to attend this course are there any promo codes out there?
@Sylvestre5552 ай бұрын
grea
@LivingGuy4845 ай бұрын
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
@PareshGujarati5 ай бұрын
Wow. Learned many things in a single short video... Thanks
@AbdullahAbrar-sc1pw5 ай бұрын
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!
@KenjiExplains5 ай бұрын
Thank you! Made a 1st video on that last week: kzbin.info/www/bejne/rZ7MdZd4fJKshpY
@AbdullahAbrar-sc1pw5 ай бұрын
@@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!
@AbdullahAbrar-sc1pw5 ай бұрын
@@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!
@quiloplays6985 ай бұрын
Short and simple but very informative. Thank you very much!
@KenjiExplains5 ай бұрын
Glad it was helpful!
@thebytelife5 ай бұрын
Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest KZbin video here! kzbin.info/www/bejne/iZbGknumoNWnb6c
@rupalthakur10465 ай бұрын
How to get the data analysis ribbon in MS excel 2021 plus version
@DanielNotates5 ай бұрын
Thanks, grouping pivot function super helpful
@ahmedshahzad94025 ай бұрын
Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.
@thebytelife5 ай бұрын
Are you looking to learn some basic python skills for data analytics? Check out my newest KZbin video here! kzbin.info/www/bejne/iZbGknumoNWnb6c
@MeGaurav-u7t5 ай бұрын
Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.
@doyimega5 ай бұрын
thank you so much kenji vey clean calm and amazing explanation
@KenjiExplains5 ай бұрын
You're very welcome!
@edilvaplanas85315 ай бұрын
Super helpful ❤❤ Thank you so much Kenji Explains 😊
@arnoldmacatangay37425 ай бұрын
I suggest to use power query when cleaning data
@anditopan5143 ай бұрын
wow that full information insight, Thnks kenji
@ItsLrenzo2 ай бұрын
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.
@SUPAPEL5 ай бұрын
Amazing intro !! Thank you
@gadgetgemsonlineАй бұрын
You could have add country also it the slice filter
@willzinner88135 ай бұрын
short but great thank you
@KenjiExplains5 ай бұрын
Glad you liked it!
@MDCRITICA5 ай бұрын
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.
@KenjiExplains5 ай бұрын
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
@Singhsushma985 ай бұрын
Thanks It Is really helpful. Thank You
@alivevideos4 ай бұрын
Thank you so much ❤❤❤
@manhtuannguyen75125 ай бұрын
Thank you very much. It is greatful
@KenjiExplains5 ай бұрын
I'm glad you like it!
@camlex63105 ай бұрын
Really helpful!!
@pluto_dp5 ай бұрын
Very valuable video
@Nxomirblx24 күн бұрын
I'm not able to perform group age in pivot
@RalfHeid5 ай бұрын
Great Tipx, thank you very much
@KenjiExplains5 ай бұрын
Glad it was helpful!
@michealoladeji53162 ай бұрын
Can you please share the datasheet
@desilvakts20715 ай бұрын
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.
@owolabiademola24405 ай бұрын
HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.
@sorin-gabrielailenei15585 ай бұрын
Super, ultra, mega cool!
@geramilmingoc825218 күн бұрын
Cannot GROUP the age..what is wrong with the data?
@essietakpan6000Ай бұрын
please, why is the screen blurred at the anlysis phase. i couldn't see anything. can anyone help.
@kashifbhatti72875 ай бұрын
Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).
@KenjiExplains5 ай бұрын
next week hopefully :)
@kashifbhatti72875 ай бұрын
@@KenjiExplains thank you. :)
@mayuronce5 ай бұрын
Great job
@NPRD15 ай бұрын
How to save these dashboards if we want to send them to someone as pdf or a sheet?
@nasralfy61045 ай бұрын
اكثر من رائع
@Nazaref5 ай бұрын
gracias senor
@amirhussain57455 ай бұрын
How to subtract multiple cells from one cell in excel?
@Just_girl_therapy5 ай бұрын
AWESOME
@BillahaMdMasum5 ай бұрын
a good one.
@CaribouDataScience5 ай бұрын
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.
@Alphapowermind5 ай бұрын
Super❤
@essietakpan6000Ай бұрын
i still can't drag the age.
@preetshah37935 ай бұрын
Make more videos on sql
@KenjiExplains5 ай бұрын
coming next week :)
@erdooabanyi51662 ай бұрын
How can I get the dataset for this project
@essietakpan6000Ай бұрын
it's in the description
@unique_properties1845 ай бұрын
I can't see the dataset
@KenjiExplains5 ай бұрын
its in the video description :)
@abdullahiabdulkadirsh.moha96987 сағат бұрын
thanks, I learned From you A lot of excel knowledge
@essietakpan6000Ай бұрын
when i drag the date, current date and birth date disappears
@UtkarshKumar-mp2ls5 ай бұрын
Always here
@KenjiExplains5 ай бұрын
Thank you!! Means a lot :)
@Sylvestre5552 ай бұрын
please link of this file
@KenjiExplains2 ай бұрын
in the video description
@UXDesigner-b5rАй бұрын
@@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.
@prashantabhowmik76704 ай бұрын
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?
@andreamedrano7824 ай бұрын
I do not have the Data Analysis tab. How can I add it? I could not find it.
@ChillWithUche3 ай бұрын
Same here,i dont no how to add the ribbon
@jonathanojesebholo57922 ай бұрын
Go to excel options and then click on add-on
@Jabbar_funАй бұрын
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
@akramali65745 ай бұрын
❤
@khanyanqundwana75265 ай бұрын
Don't do process capability etc
@Anubis1010-tx1ev5 ай бұрын
What is the point of doing this kind of simple analysis that can be done by even toddlers 😂
@shamisomaisiri9117Ай бұрын
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.
@Umah.752 ай бұрын
بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟ بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤ اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤