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?
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.
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 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!
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.
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!
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
HI Kenji thanks for sharing the tricks , those are really help in real time
I didn‘t know most of them. Thanks for sharing. Great content and communicarion.
Glad you enjoyed! thanks for watching :)
Cool video. Could you perhaps link your current setup?
I’m only half way through and I would love a part 2
Nice one Mr. Kenji even though I often use 90% of this hint already😀
Good job!
Awesome, you know a lot already ! :)
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?
Didn't know about the Subtotal, Thanks a lot sir
Great suggestions as always, thanks Kenji
Glad you like them! thanks for letting me know :)
Thanks man, learned a few new things!
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
thank you and yes we want Awesome Time Saving Hacks in Excel (2)
which tool you are using to record the videos and for video editing which tool you are using
Brilliant! Thank you Kenji!
Brilliant and all under 15 Mins
Great tricks!! Thank you
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 :)
clipboard is so simple yet never heard of it lol thanks as alwasy
Yes!! Glad it was useful
great Sir!!!
Thank you, Kenji.
I'm very excited about part 2 sir
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 :)
👏 Thanks very useful 🌹🌹
Glad it was helpful!
Your vidoes are awesome
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
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
I can't see 'Data analysis' regarding #8 - any add-in missing ?
Descriptive statistics is value add
Subtotals Rock!!!
Please can I get the link to the data analysis full course
Here you go: www.careerprinciples.com/career-track/the-data-analyst-program
7:35 What if you need the median?
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
clipboard using wins+V shortcut
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
why dont i have that data analysis section on my data tab?
As usual 🎉
Let's go! Thanks for always supporting :)
Whi new excel has a clipboard! 😮
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
I can't add navigation in view ribbon.
Go to cell!😮😅
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!
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
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