👉 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program
@harish7041Ай бұрын
Can you slove my issue in live
@Aamir_UpdatesАй бұрын
KENJI HELPING ME ALOT..... THANKS KENJI... YOU ARE IN FACT GOLD MEDALIST IN EXCEL OLYMPICS...
@willzinner8813Ай бұрын
thanks as always
@KenjiExplainsАй бұрын
Thank you!!
@flightforge3015 күн бұрын
thanks Kenji..straighforward and Ive learned a lot
@sophykeo9639Ай бұрын
table method is so easy & interesting
@nevermind6282Ай бұрын
Thanks Kenji, Awesome tutorial as always. Could you please make one video for large CSV files data cleaning.
@nishanth4323Ай бұрын
As always new learning from video's thanks 🙏🏻
@albedoguardian875Ай бұрын
when Kenji post you watch and bookmark
@davidcolson7400Ай бұрын
True story. I have a whole file of his videos.
@sivareddy3745Ай бұрын
Hi Kenji thanks to your tricks. It is Very Useful.
@nafihuppalaАй бұрын
Keep up the smile always...❤ Thanks a lot for all these knowledge sharing Sir...❤
@camlex6310Ай бұрын
Really helpful technique!!
@salmanakhtar4669Ай бұрын
7:15, kenji can we use xlookup for the same? Like we used it before in your previous video of xlookup
@tere627926 күн бұрын
hi kenji, thanks a lot. ur explaining is crystal clear n brilliant delivered 👏👏 btw do u have any tricks to process data more than 800k rows? i had many data that have to process with many formula n sheets. but its usually run slow n not responding.. 😢
@kemtemartchirouesylvestreАй бұрын
Give me three excel files . I would like to write a project. You're really amazing. From Africa
@anhiekim411711 күн бұрын
Thanks a lot for your video! I have one question, I follow your Table Trick to link data from Table Worksheet A to Worksheet B. But when I close Workshet A, the data in Worksheet B show #Ref, and sometime it doesn't update data. Please help me more on it? Thanks.
@25363971Ай бұрын
Very useful 🎉
@imadanow218 күн бұрын
What version of Excell software you're using in this video? thanks a lot.
@gregasimciczorz387727 күн бұрын
Thank you for your video. Just quick question. Does it work also between excel files, that are synchronized on Google drive? I have some files on my PC in the Google Drive folder. And it seems that they are not updated, unless I open each file separately.
@yehuditmahalal2070Ай бұрын
I love your super professional videos! thank you! which tools do you use for recording and editing?
@aniekwenachigbo946226 күн бұрын
Can this work in two workbooks in different computers after sharing the document? It didn't work on my end though
@eto5609Ай бұрын
Nice one.
@motopelamohapi4152Ай бұрын
Kenji 🤝🏿
@darkh0stАй бұрын
Is it possible to automate this across multiple sheets to transfer to a single sheet? Background. Have a template sheet that is copied over to be used for multiple classes throughout the year.
@leonardoamber2289Ай бұрын
*SEARCH*
@leonardoamber2289Ай бұрын
*DONALD NATHAN SCOTT.*
@user-sx5og1nj4iАй бұрын
What formula shold we use if we want to repeat the same word multiple times but vertically
@PavanKumar-xd3wgАй бұрын
How to maintain the formatting? While replicating the data from Sheet1 to Sheet2 (Without using tables)
@nickmaxwell614112 күн бұрын
Is it possible to open SPSS data in excel?
@eddiemendez4766Ай бұрын
Why not use ifblank instead
@Martins-TheAnalystАй бұрын
awesome
@mdmahtabuddin972126 күн бұрын
Bro You just give me a massive data analysis Idea. Now I'm going to find - "Combine dirty Data from another multiple Excel workbooks by using Power Quarry in Pivot Table format". if you find the solution. plz let me know.
@jeffreygan702819 күн бұрын
must all the linked files be in the same folder? and if i need to move the folder to another location (e.g. D:\ to E:\), will it still work?
@Leghar17 күн бұрын
With the formulas it should be fine. With power query you would need to change the path in the source step.
@bobbygoud551829 күн бұрын
A simple copy paste works too
@eddiemendez4766Ай бұрын
Have used linking data between files and then others would either rename the original file or move its location thereby breaking the link between the files
@srikanthgali8991Ай бұрын
where is = data formula available is in 365excel
@harish7041Ай бұрын
How to ignore empty cell while checking grater than value , and how to write code for check c2 coloum is some condition and d2 is Some function if both true we should get our condition
@apoe5029Ай бұрын
chatgpt is free
@Dimpalrajkumar21 күн бұрын
These days I am seeing lot of ads!
@KenjiExplains21 күн бұрын
Hey I only add one add per video which is 1 minute long for videos ranging from 10-20 minutes I think it's a reasonable ratio. You get to watch it for free, download the file and even skip through the video if you're not interested.