10 Awesome Time Saving Hacks in Excel
13:35
Best New Excel Features for 2024
10:24
Пікірлер
@dilipkrishna5559
@dilipkrishna5559 12 сағат бұрын
Thanks for the wonderful video brother! Expecting a unique SQL and POWER BI end to end project from your channel
@brianteague5878
@brianteague5878 13 сағат бұрын
Thank You Kenji! Your tutorials and instructions are easy to follow.
@HariKenyuk
@HariKenyuk 14 сағат бұрын
Thanks LAB 4 this
@kumarkanishk6007
@kumarkanishk6007 14 сағат бұрын
Hey Kenji, when I am making sensitivity table, for some unknown reason my middle figure is not as the calculated implied price. Can you help?
@Geometryatyourfingrrtips
@Geometryatyourfingrrtips 15 сағат бұрын
Please make a video how I total only negative numbers in excel while i use subtotal among negative and positive numbers.
@Geometryatyourfingrrtips
@Geometryatyourfingrrtips 15 сағат бұрын
Love from India, Bro! Every video is knowledgable and exciting. Only you tube video watched many but never bored.
@antoniiocaluso1071
@antoniiocaluso1071 17 сағат бұрын
your Channel's content is AMAZING! thank you!! sub'd/liked
@WeiyingChen-fu4xd
@WeiyingChen-fu4xd 17 сағат бұрын
How to get groupby and pivotby function in Excel? I have subscribed MS 365.
@liquidapathy82
@liquidapathy82 19 сағат бұрын
One of the best informative excel videos I’ve seen in years.
@md.nuralammiah9587
@md.nuralammiah9587 19 сағат бұрын
Very informative tutorial!
@sonyfebrian1267
@sonyfebrian1267 19 сағат бұрын
is that microsoft 365, because i didn't see data types (geography)???
@MrAqadii
@MrAqadii 21 сағат бұрын
Thank you
@KenjiExplains
@KenjiExplains 20 сағат бұрын
You're welcome!
@josesosa5058
@josesosa5058 21 сағат бұрын
Level 1 done hahaha i need to try other video level 2.. thanks!!!!!
@kameshsharma5164
@kameshsharma5164 22 сағат бұрын
Very educative video Sir can you please share which software do you use for video editing Please Share
@cliffordabere1790
@cliffordabere1790 22 сағат бұрын
HOW CAN YOU GET THE LEANING SOURCES WITHOUT THE URL?????
@Rufus-OG
@Rufus-OG 23 сағат бұрын
Groupby is not available in Excel365. Great tutorials but it’s important that you provide guidance on functions we can actually use.
@auraveenley.8743
@auraveenley.8743 Күн бұрын
Yes sweet lemonade
@mukeshsaxena8062
@mukeshsaxena8062 Күн бұрын
I enrolleed but no one called me … so I have been chalwateen
@vikashgarg1269
@vikashgarg1269 Күн бұрын
Can you tell me how to merge different Excel sheet into one sheet
@KenjiExplains
@KenjiExplains Күн бұрын
I have a video on that in the channel. Please check it out!
@vikashgarg1269
@vikashgarg1269 Күн бұрын
@@KenjiExplains ok
@JusticeFinance
@JusticeFinance Күн бұрын
Great video, however it seems at 30:18, you calculated interest expense incorrectly.
@Masoom36
@Masoom36 Күн бұрын
So glad I stayed until the end for the Spreadsheet Compare!!
@KenjiExplains
@KenjiExplains 20 сағат бұрын
Awesome :)
@osiomogieasekome8799
@osiomogieasekome8799 Күн бұрын
Why is the datedif formula hidden?
@KenjiExplains
@KenjiExplains 20 сағат бұрын
Not sure tbh!
@arnonomdo1341
@arnonomdo1341 Күн бұрын
2:36 The function is DATE DIF ?
@geekatari4391
@geekatari4391 Күн бұрын
=DATEDIF(), no spaces.
@albedoguardian875
@albedoguardian875 Күн бұрын
When Kenji posts, you watch. Simple. Best Xcel Channel ❤
@jumpferjoy1st
@jumpferjoy1st Күн бұрын
First tip given is bloody long winded. There is a far quicker way. So gave up bothering after that.
@turistsinucigas
@turistsinucigas Күн бұрын
GROUPBY is only on Microsoft 365 Insiders, unfortunately. any workaround?
@markpodesta4605
@markpodesta4605 Күн бұрын
Thank you Kenji. Very useful!
@KenjiExplains
@KenjiExplains 20 сағат бұрын
Thanks for wawtching :)
@mugerwaferryl213
@mugerwaferryl213 Күн бұрын
Mr. Kenji am so inspired by your educative videos, thanks again please. could you be knowing any way how i can update my windows without a PK( PRODUCT KEY)? thanks
@nishanth4323
@nishanth4323 Күн бұрын
Thanks 🙏🏻
@KenjiExplains
@KenjiExplains 20 сағат бұрын
You’re welcome 😊
@ParthAnand-zc7en
@ParthAnand-zc7en Күн бұрын
Love your teaching Kenji, I request you to kindly make some more videos on SQL and Power BI, your excel tutorials has really increased my confidence in Excel
@sb47820
@sb47820 Күн бұрын
We want more videos on excel business charts like those used in Economic Times. A seperate playlist for those business charts would be very much helpful.
@TheWantedKenobi
@TheWantedKenobi Күн бұрын
“We want”? He’s already doing so much. The least you can do is ask nicely or end with a thank you.
@colorfulfahim
@colorfulfahim Күн бұрын
love your teaching style Kenji...
@KenjiExplains
@KenjiExplains Күн бұрын
Thank you!!!
@willzinner8813
@willzinner8813 Күн бұрын
can you do a part 2 with more formulas for each group?
@KenjiExplains
@KenjiExplains Күн бұрын
Thanks for the suggestion, I'll keep it noted :)
@KenjiExplains
@KenjiExplains Күн бұрын
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/asb
@UtkarshKumar-mp2ls
@UtkarshKumar-mp2ls Күн бұрын
As usual
@KenjiExplains
@KenjiExplains Күн бұрын
Let's go! Thanks for watching always :)
@pluto_dp
@pluto_dp Күн бұрын
Omg, wish I watched this couple years ago
@mannymany4423
@mannymany4423 Күн бұрын
I use VBA to update pivot tables automatically when source data has changed.
@Roman_93
@Roman_93 Күн бұрын
How did we get proper dates out of random numbers, for example, how did it convert 45095 into 18.06.2023 (the first row in the table)?
@sweetbird019
@sweetbird019 Күн бұрын
I still feel pivot table is easier than groupbu or pivot by
@Theo-dp9ul
@Theo-dp9ul Күн бұрын
In the var. % why did u subtract D8/C8-1 ?? Can somebody explain please?
@kapilanawarathne5746
@kapilanawarathne5746 Күн бұрын
in which version onwards this formula is available?
@user-od5fq9kq8e
@user-od5fq9kq8e Күн бұрын
@Kenji Explains, Insightful way and nicely explained the IF, SUMIF Conditions with perfect examples 👌
@shivtejlakkakula6864
@shivtejlakkakula6864 Күн бұрын
Hi Kenji I come from a multicultural background as well speaking Telegu as my first language at home when I was born in the US and then learned English but I don't know how to read and write Telegu. I was thinking of including this in my cover letter, but I don't know if I should because I am not fluent in Telegu like you are in Japanese and Spanish. What do you recommend?
@pastorjoe6751
@pastorjoe6751 Күн бұрын
How can I learn the full course
@rahulpotnis8527
@rahulpotnis8527 Күн бұрын
For sum, if you click Alt & equal sign twice, the sum comes up. No need to hit enter then.
@r1cer825
@r1cer825 2 күн бұрын
This is one of the best, or the best tutorial I have ever seen for that kind of stuff... great job. You're really informing and smooth.... great job.... thx for that. was looking for such a video for a long time...
@user-cf5yp1dd7x
@user-cf5yp1dd7x 2 күн бұрын
Your tutorials are great! Thanks Curious, how would you connect the 3 dynamic financial statements to different scenarios analysis with an existing small business and 3 years of historical data? Would you be able to do a tutorial on 3 connected dynamic financial statements for an existing small business (less than $1M revenue) with multiple debt assumptions?
@rexbk
@rexbk 2 күн бұрын
Fantastic. Thanks, Kenji!
@ulchhunly8435
@ulchhunly8435 2 күн бұрын
Can you make a video how to copy and paste data without go to hiden row ?
@VR-ie8xy
@VR-ie8xy 2 күн бұрын
But when i need slisers?