Тёмный

10 Hidden Time Saving Hacks in Excel 

Kenji Explains
Подписаться 598 тыс.
Просмотров 61 тыс.
50% 1

Опубликовано:

 

3 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 71   
@KenjiExplains
@KenjiExplains 4 месяца назад
🔥Take our Data Analyst Program Now! www.careerprinciples.com/career-track/the-data-analyst-program
@harshikasingh1031
@harshikasingh1031 4 месяца назад
Alt + = didn't work in my laptop it gives me a sum() function
@preciouskadiri9506
@preciouskadiri9506 4 месяца назад
Is this data analysis course self places
@Dmytro848
@Dmytro848 4 месяца назад
I'm usually pretty confident I already have decent knowledge of Excel... until Kenji drops a new video 😅 Thank you for sharing those tips!
@KenjiExplains
@KenjiExplains 4 месяца назад
For shortcut number 7 automatic dropdown, the shortcut key is alt + down arrow instead of alt + = like I mention. Apologies for the mistake!
@willzinner8813
@willzinner8813 4 месяца назад
clipboard is so simple yet never heard of it lol thanks as alwasy
@KenjiExplains
@KenjiExplains 4 месяца назад
Yes!! Glad it was useful
@SaskiaJacobsen_Toels-PC
@SaskiaJacobsen_Toels-PC 4 месяца назад
2 saving hacks don't work in my Dutch version. 1. Alt+= means "insert =SUM( in the current cell". Someone else also mentioned this: alt+↓ (arrow down) does work for the list! 2. Pressing F1 means HELP is started. Ctrl+F1 will collapse and expand the ribbon
@rudrashrestha9558
@rudrashrestha9558 4 месяца назад
thanks!
@RifaRif-iz4ir
@RifaRif-iz4ir 3 месяца назад
wow! so am i! i'm in indonesia and it worked like you told with alt+ arrow down. Thanks!
@marilynmvick
@marilynmvick 4 месяца назад
I’m only half way through and I would love a part 2
@endee72
@endee72 19 дней назад
Descriptive statistics is value add
@EffigyOfAdam
@EffigyOfAdam 3 месяца назад
Hi, Kenji! Could you do a video or two on Excel for Education? Specifically, some common situations related to data on student retention at a college or high school? This would be really helpful.
@twiediger
@twiediger 4 месяца назад
I didn‘t know most of them. Thanks for sharing. Great content and communicarion.
@KenjiExplains
@KenjiExplains 4 месяца назад
Glad you enjoyed! thanks for watching :)
@madhavraval238
@madhavraval238 4 месяца назад
Didn't know about the Subtotal, Thanks a lot sir
@JohnGillH
@JohnGillH 2 месяца назад
Thanks man, learned a few new things!
@RaviKanth-m8v
@RaviKanth-m8v 3 месяца назад
HI Kenji thanks for sharing the tricks , those are really help in real time
@UChiiL
@UChiiL 2 месяца назад
Brilliant and all under 15 Mins
@hafedjamil1127
@hafedjamil1127 4 месяца назад
thank you and yes we want Awesome Time Saving Hacks in Excel (2)
@debbielaubscher4983
@debbielaubscher4983 4 месяца назад
Brilliant! Thank you Kenji!
@motopelamohapi4152
@motopelamohapi4152 4 месяца назад
Thank you, Kenji.
@eto5609
@eto5609 4 месяца назад
Nice one Mr. Kenji even though I often use 90% of this hint already😀 Good job!
@KenjiExplains
@KenjiExplains 4 месяца назад
Awesome, you know a lot already ! :)
@brendamg7298
@brendamg7298 4 месяца назад
Great tricks!! Thank you
@pluto_dp
@pluto_dp 4 месяца назад
Great suggestions as always, thanks Kenji
@KenjiExplains
@KenjiExplains 4 месяца назад
Glad you like them! thanks for letting me know :)
@DhananjayaN-yy1mr
@DhananjayaN-yy1mr 3 месяца назад
I'm very excited about part 2 sir
@stoiccoffeecompany-juliopa1171
@stoiccoffeecompany-juliopa1171 2 месяца назад
Subtotals Rock!!!
@JoseAntonioMorato
@JoseAntonioMorato 4 месяца назад
The suggestion to use the "Alt+=" shortcut key to display the available names in Excel in PT-BR does not work, as this shortcut is used to add the listed items. The key set for displaying already listed names is "Alt+Down Arrow" 🤗
@KenjiExplains
@KenjiExplains 4 месяца назад
You're right I said that by mistake! Thanks for pointing it out :)
@kgotlaetsilemodieginyane7491
@kgotlaetsilemodieginyane7491 4 месяца назад
Your courses are good, but the prices are heavy in most of them. Udemy becomes the option for most of us.
@dhilipin5963
@dhilipin5963 4 месяца назад
Yeah 😅
@bhristopher3917
@bhristopher3917 3 месяца назад
How much does it cost
@camlex6310
@camlex6310 4 месяца назад
Great tricks!! Thank you
@MrGauti07
@MrGauti07 Месяц назад
Your vidoes are awesome
@vuphan8154
@vuphan8154 4 месяца назад
THANK YOU
@madhavraval238
@madhavraval238 4 месяца назад
I used "Alt + Down", it worked as in Data Validation's List but it only works for categorical Data and not on the Date and numeric Data
@paskel94
@paskel94 4 месяца назад
Cool video. Could you perhaps link your current setup?
@sanjayaais8495
@sanjayaais8495 3 месяца назад
Thanks Kenji, great stuff to increase productivity. Your videos have been very helpful. Had a small challenge with last tip, F1 returns help menu instead of collapsing ribbon. Tried Fn+F1, it mutes the speaker.
@WeMakePowerApps-com-au
@WeMakePowerApps-com-au 18 дней назад
@kenji it should be Ctrl + F1
@AMVBlitz
@AMVBlitz 4 месяца назад
Bonus hacks in windows is Ctrl +F1
@nihayatsabah3063
@nihayatsabah3063 4 месяца назад
👏 Thanks very useful 🌹🌹
@KenjiExplains
@KenjiExplains 4 месяца назад
Glad it was helpful!
@thinkbyrehan
@thinkbyrehan 4 месяца назад
yes need 2nd part
@eduardmaniago7427
@eduardmaniago7427 2 месяца назад
Hi, Do you have tutorial vid about how to view wide range of data (i.e employee info)? tired of dragging sideways to view all of the info i needed. Hope you notice. TIA
@hiliks50
@hiliks50 9 дней назад
Hi. I searched for the "Navigation" button all over my Excel 2024... even looked for it in the attic.... didn't find it.... on what version r u working that u have it?
@wallywechs4694
@wallywechs4694 4 месяца назад
Good job Kenji, Do you offer Certificate?
@KenjiExplains
@KenjiExplains 4 месяца назад
Hi there, the courses do offer a certificate. You can learn more about them here: www.careerprinciples.com/all-courses
@rasheednayakkan6750
@rasheednayakkan6750 4 месяца назад
F1 - doesn't work me to expand and collapse ribbons.. Anyhow managed to do it with right click.. Awesome session Kenji.. waiting for more short keys :)
@Toommy78
@Toommy78 2 месяца назад
I can't see 'Data analysis' regarding #8 - any add-in missing ?
@RaviKanth-m8v
@RaviKanth-m8v 3 месяца назад
which tool you are using to record the videos and for video editing which tool you are using
@mirrorreflection3479
@mirrorreflection3479 3 месяца назад
How come Alt + = does not give me automatic drop-down list? It returns sum error since my cells above are texts. Please advise why not working...
@jithinsv
@jithinsv 3 месяца назад
Hi I am from India. I am a sales manager and think that your Data Analyst course would be of great help for my Career. But the cost is higher as per our countries conversion rates. Can you support me in some way.
@KenjiExplains
@KenjiExplains 3 месяца назад
Hi thanks for your message. Please reach out to info@careerprinciples.com for queries related to career principles
@shanmugavadivud5
@shanmugavadivud5 4 месяца назад
Thank you 😊 for the useful tips However I noticed tip #7 alt+= works as sum and when I used alt+down arrow, the drop down list appeared. Can you confirm if this is due to excel version?
@preciouskadiri9506
@preciouskadiri9506 4 месяца назад
Please can I get the link to the data analysis full course
@KenjiExplains
@KenjiExplains 4 месяца назад
Here you go: www.careerprinciples.com/career-track/the-data-analyst-program
@shanabenjamin8945
@shanabenjamin8945 4 месяца назад
Whi new excel has a clipboard! 😮
@UtkarshKumar-mp2ls
@UtkarshKumar-mp2ls 4 месяца назад
As usual 🎉
@KenjiExplains
@KenjiExplains 4 месяца назад
Let's go! Thanks for always supporting :)
@sahilchauragade
@sahilchauragade 4 месяца назад
I can't add navigation in view ribbon.
@akhilepeace139
@akhilepeace139 4 месяца назад
why dont i have that data analysis section on my data tab?
@shanabenjamin8945
@shanabenjamin8945 4 месяца назад
Go to cell!😮😅
@KKB-tt4lj
@KKB-tt4lj 4 месяца назад
For the 7, Alt + = it give me =Sum()...
@KenjiExplains
@KenjiExplains 4 месяца назад
Hey yes I left a comment already that I made a mistake should have said Alt + down arrow instead of alt + = my apologies!
@RifaRif-iz4ir
@RifaRif-iz4ir 3 месяца назад
why i can't download the excel file?
@KenjiExplains
@KenjiExplains 3 месяца назад
hey it's working fine. Check your email once you fill your details
@RifaRif-iz4ir
@RifaRif-iz4ir 3 месяца назад
@@KenjiExplains i don't receive any email :/ is there something wrong with my settings?
@usmanmohammed5269
@usmanmohammed5269 4 месяца назад
sheet 7, autodrop down is not working.
@KenjiExplains
@KenjiExplains 4 месяца назад
It's alt down arrow made a mistake my apologies!
Далее
Mastering Excel: Top 10 Formulas You Need to Know
14:30
How to Move Data Automatically Between Excel Files
11:37
How Many Twins Can You Spot?
00:17
Просмотров 11 млн
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
6 COOLEST  Excel formulas in 2024
7:57
Просмотров 7 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
Просмотров 230 тыс.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Try This Instead of the XLOOKUP
10:06
Просмотров 96 тыс.
TOP 10 Excel Formulas to Make You a PRO User
17:00
Просмотров 773 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
The Excel Trick I Use EVERY DAY (and you should too!)
11:21