Hi, I want to learn excel for the purpose of creating a cabinet calculator and estimation- that is, the quantity and cost. I want to automate the process. Do you have a course for my request?
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
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.
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.
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?
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" 🤗
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 :)
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
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?
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.
🔥Take our Data Analyst Program Now! www.careerprinciples.com/career-track/the-data-analyst-program
Alt + = didn't work in my laptop it gives me a sum() function
Is this data analysis course self places
Hi, I want to learn excel for the purpose of creating a cabinet calculator and estimation- that is, the quantity and cost.
I want to automate the process.
Do you have a course for my request?
I'm usually pretty confident I already have decent knowledge of Excel... until Kenji drops a new video 😅 Thank you for sharing those tips!
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
thanks!
wow! so am i! i'm in indonesia and it worked like you told with alt+ arrow down. Thanks!
For shortcut number 7 automatic dropdown, the shortcut key is alt + down arrow instead of alt + = like I mention. Apologies for the mistake!
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.
I’m only half way through and I would love a part 2
Cool video. Could you perhaps link your current setup?
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.
@kenji it should be Ctrl + F1
clipboard is so simple yet never heard of it lol thanks as alwasy
Yes!! Glad it was useful
Brilliant and all under 15 Mins
Thanks man, learned a few new things!
Didn't know about the Subtotal, Thanks a lot sir
HI Kenji thanks for sharing the tricks , those are really help in real time
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
I didn‘t know most of them. Thanks for sharing. Great content and communicarion.
Glad you enjoyed! thanks for watching :)
Descriptive statistics is value add
Great suggestions as always, thanks Kenji
Glad you like them! thanks for letting me know :)
Subtotals Rock!!!
Nice one Mr. Kenji even though I often use 90% of this hint already😀
Good job!
Awesome, you know a lot already ! :)
Thank you, Kenji.
I'm very excited about part 2 sir
I can't see 'Data analysis' regarding #8 - any add-in missing ?
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?
thank you and yes we want Awesome Time Saving Hacks in Excel (2)
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" 🤗
You're right I said that by mistake! Thanks for pointing it out :)
which tool you are using to record the videos and for video editing which tool you are using
Brilliant! Thank you Kenji!
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 :)
Your vidoes are awesome
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
THANK YOU
Great tricks!! Thank you
yes need 2nd part
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?
Bonus hacks in windows is Ctrl +F1
👏 Thanks very useful 🌹🌹
Glad it was helpful!
Good job Kenji,
Do you offer Certificate?
Hi there, the courses do offer a certificate. You can learn more about them here: www.careerprinciples.com/all-courses
Please can I get the link to the data analysis full course
Here you go: www.careerprinciples.com/career-track/the-data-analyst-program
Your courses are good, but the prices are heavy in most of them. Udemy becomes the option for most of us.
Yeah 😅
How much does it cost
7:35 What if you need the median?
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...
The actual short cut to get the drop-down list is ALT + Down Arrow key
Whi new excel has a clipboard! 😮
why dont i have that data analysis section on my data tab?
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.
Hi thanks for your message. Please reach out to info@careerprinciples.com for queries related to career principles
Go to cell!😮😅
As usual 🎉
Let's go! Thanks for always supporting :)
I can't add navigation in view ribbon.
For the 7, Alt + = it give me =Sum()...
Hey yes I left a comment already that I made a mistake should have said Alt + down arrow instead of alt + = my apologies!
why i can't download the excel file?
hey it's working fine. Check your email once you fill your details
@@KenjiExplains i don't receive any email :/ is there something wrong with my settings?
sheet 7, autodrop down is not working.
It's alt down arrow made a mistake my apologies!
Great tricks!! Thank you