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
@PETERSSEBUFU-y4y7 ай бұрын
Where are you exactly cause I really liked the teachings
@johnnieiminabo442813 күн бұрын
Hi Kenji, I love the way you teach, so simple to understand. Short, but very informative. I am currently glued to your channel. Thank you so much for doing this.
@Richkotite17 ай бұрын
This was really helpful and easy to follow, I got a lot out of it.
@myle52243 ай бұрын
Love the way you explained verything so detailed. Thanks a lot
@abdulwahabmohammed43575 ай бұрын
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 Жыл бұрын
Thank you Kenji
@oshneythakur2449 Жыл бұрын
AMAZING VIDEO
@KenjiExplains Жыл бұрын
Glad you think so!
@celestinballa6640 Жыл бұрын
i love excel and i love the you have mastered it you are the best bless up
@petermapoma366 Жыл бұрын
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!
@muhammadhasanraza16063 ай бұрын
amazing
@Anne-lj4ri Жыл бұрын
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
@abduljalil-fz2bx Жыл бұрын
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
@rajeshkumarjha7306 Жыл бұрын
Can anyone please tell me that how I can install analyze data in excel
@kingbonetti5978 Жыл бұрын
Thanks bro. Can we have a video for making excel or power bi report, dashbord from multiple sources Facebook ADS, Google ADS CRM...
@MBAGirl7 ай бұрын
thanx alott to you
@budiyuwono75877 ай бұрын
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 ?
@mackyd909 ай бұрын
I cant find the Analyze Data in my home tab
@etc_be_a_62harshshinde667 ай бұрын
Am not having data analysis button using ai feature in excel how to bring that ?
@MensahAlgebra9 ай бұрын
How do i download this data for practice?
@rishabhsingh990211 ай бұрын
i am unable to find analyze data?
@rakkeshkannadhanasekar871611 ай бұрын
I am not getting analyze data button in home tab can anyone helm me regarding this issue
@official_jeshua6 ай бұрын
same
@inashafi75978 ай бұрын
Very nice...but you are too fast..and you need to wait zoom in the instructions
@DWestnik7711 ай бұрын
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.
@pashahillyard876310 ай бұрын
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!
@neyonondela Жыл бұрын
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.
@berbagiilmututorial121 Жыл бұрын
Very helpful Microsoft Excel tutorial, sir, thank you very much
@LakechBetiret7 ай бұрын
you have briefly describes pretty the basics of important excel data analysis skills. Very helpful. Thank you. Keep the good job.👍👌
@tnsmlnk21498 ай бұрын
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?
@MoreyW5 ай бұрын
Can't access Data Analysis icon to summarize revenue after following procedures to add it
@Jakeolivier14 ай бұрын
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?
@VishnuVardhan-sj6nd Жыл бұрын
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_afr11 ай бұрын
same problem! Anybody?
@dakesim7 ай бұрын
same problem :(
@WestCoastKop7 ай бұрын
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.
@madhavinanavati91155 ай бұрын
superb EXPLAINAION TO LEARNERS...i AM A GREAT FAN ...tHANK YOU IN ABUNDANCE...WANT TO LEARN A LOT
@ericaunzo7172 ай бұрын
Hello Sir. How can I add the AI tool Analyze Data Plug in to the Home Ribbon?
@clemokoye32066 ай бұрын
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
@matildawheatley898211 ай бұрын
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
@KenjiExplains11 ай бұрын
Glad it was helpful! best of luck with the new role :)
@kpopKIDS11 ай бұрын
@@KenjiExplains HI WHEN I AM MAKING CHANGES AND LOADING THE FILE THE FILE REMAINS THE SAME PLEASE GUIDE
@junettepena552 ай бұрын
Hi I don't have the Analyze data tab to my HOME tab ribbon how can I add it?
@amauryvanlangendonck463110 ай бұрын
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?
@he_is_vinАй бұрын
How do you install the AI tool for Analyze data onto your excel?
@chanchalmoolrajani60444 ай бұрын
Hello. I dont have the Analyse data add in in Home ribbon. Please help
@suleimanmuhammedhady1198Ай бұрын
I have an issue after I cleaned my data and made necessary corrections a new set of data came in how do I add this new data set
@janemuller59883 ай бұрын
Are the courses all online and do you supply the courses to people in Australia?
@surajpandey1508 Жыл бұрын
Hello @kenji Sir there is a duplicate in pivot table where jenna is mentioned twice due to doble space
@KenjiExplains Жыл бұрын
Just noticed it thank you for pointing it out
@rahatahmad4735 ай бұрын
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.
@rahatahmad4735 ай бұрын
I tried again .Now it works. Thank you.
@rashmimishra21772 ай бұрын
thank you kenji , can you make video for tealeau
@StepByStepExcelTutorials8 ай бұрын
Great tips for those getting to grips with FP&A!
@pamela586810 ай бұрын
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?
@flickhunter89007 ай бұрын
how to add the "analyze data" AI tool into excel?
@scwyldspirit Жыл бұрын
Another awesome video. Got a ton out of it.
@danielgreen6984 Жыл бұрын
Hey can you do a tutorial with drop down lists where whenever we make a selection it performs an equation respectively.
@SakthivelOrganics Жыл бұрын
awesome Kenji
@Upbeat2312 ай бұрын
Why can't I download the file from description
@KenjiExplains2 ай бұрын
hey did you check your email for the file? All is working correctly
@EverestTourism8 ай бұрын
how to make slash atoumatik in date in excel like 02032024 to 02/03/2024
@consciouslynatural12762 ай бұрын
=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2)) This returns the date in UK format dd/mm/yyyy as i assumed that is the format, as it is not clear from the example (and I’m in the UK 😊) and I am referencing the original format in cell A1. If it is in the USA format you will need to swap the formula around a bit, but you should get the same answer. Hope it works for you. 👍🏽
@kevindaniel7333 Жыл бұрын
Very good, helpful video for me--thank you!!
@Rider-jn6zh Жыл бұрын
Which Excel version u r using. Please Send us the link to download excel. In my excel i dont have many options
@KenjiExplains Жыл бұрын
microsoft 365. Excel file in the video description
@carolferro1978 ай бұрын
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 ;)
@ssrk3699 ай бұрын
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 ♥️
@webserfer2393 Жыл бұрын
In Analysis section in pivot table Jenna Silva is doubling and wasn't trimmed as supposed to in Data Cleaning
@KenjiExplains Жыл бұрын
Just noticed this, thank you for pointing it out
@aduntoridas0106 ай бұрын
@@KenjiExplains Explains why I dont use power query. Can't trust it if it doesn't do the job perfectly.
@mulukendesalegn-v7k10 ай бұрын
Really good approach, thank you.
@itsFidel Жыл бұрын
very helpful, how can I add that "Analyze data" AI to my excel
@juststudy583611 ай бұрын
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.
@paulagyin185311 күн бұрын
Oh shit
@expertgaming51468 ай бұрын
So we can either clean data manually or by using powerquery right ?????
@ruslanazimov8616 Жыл бұрын
What is excel version? How can i get that free , my excel doesn't support some functions
@MrShoaib8210 ай бұрын
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.?
@akande8811 ай бұрын
Great tutorial.. kenji, thank you
@zizo873711 ай бұрын
Great love your calm tone😊
@sissi790910 ай бұрын
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
@heplanglangstang9738 ай бұрын
7:45 I don't have this data analysis in my ms excel ,how do i add it can you please help ?
@Reactionz.34022 ай бұрын
Powerful knowledge with simplicity.
@ishasharma02104 ай бұрын
This was great! So helpful! I learnt a lot of new things that put me at ease :)
@abdu11ah_playss Жыл бұрын
شکریہ بھائی ❤️ اللہ آپ کو سلامت رکھے 🤍
@adderlyacevedo823210 ай бұрын
Your videos are gold!
@satyaranjanparida8065 Жыл бұрын
hii, In my excel there is no analyze data button in home ribbon. how to get that?
@FreeKiLLuminati Жыл бұрын
Love your videos Kenji
@keifer7813 Жыл бұрын
I like cleaning, don't mind analysing, and hate visualizing
@kyawthiha6429 Жыл бұрын
i can't find analyze data icon in my excel why not show
@sonerguney3225 Жыл бұрын
Çok iyi
@patiencemakadzange17548 ай бұрын
Awesome video
@camlex6310 Жыл бұрын
Another great video!! Thanks
@emmanuelanyalemechi6244 Жыл бұрын
Well done, Kenji
@farooqtahir538 Жыл бұрын
same thing again and again nothing new
@Mrwisterks11 ай бұрын
Yep, easy money
@The_Spontaneous_Adventurer Жыл бұрын
very resourceful. Thankyou
@KenjiExplains Жыл бұрын
Glad it was helpful!
@willzinner8813 Жыл бұрын
Can you do more video on the visuals?
@KenjiExplains Жыл бұрын
you mean like a video on data analysis visuals?
@sarabendranathgharai3898 Жыл бұрын
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 Жыл бұрын
Why not U reply me SIR😭😭😭
@TheRealMinuteMarket Жыл бұрын
Can you do videos on how to get into investment banking, updated version
@KenjiExplains Жыл бұрын
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 :)
@nishanth4323 Жыл бұрын
Thanks 🙏
@KenjiExplains Жыл бұрын
You’re welcome 😊
@laputa4825 Жыл бұрын
What is the difference between VBA and Power Query?
@KenjiExplains Жыл бұрын
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 Жыл бұрын
@@KenjiExplains Do you have any examples of when we would want to use VBA (automation)?