10 Hidden Time Saving Hacks in Excel
HTML-код
- Опубликовано: 6 июл 2024
- 10 quick and easy time saving hacks in Excel that you literally start using today!
🔥 Take our Data Analyst Program: www.careerprinciples.com/care...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this video we'll go over 10 Excel shortcuts you should know. These are going to be game-changers for your Excel productivity. First, we have the clipboard, to copy and paste multiple values, then we have the go to cell (go to special) so you can navigate to any cell easily. Third, we have the pattern fill to customize the fill down. Fourth, we have the navigation bar to move across different sheets. Fifth are dynamic titles so they updated automatically. Sixth are totals and subtotals for tables, followed by creating automatic dropdowns. Then we have descriptive statistics, section breakdowns (auto outline in Excel) and custom lists so you don't have to remember a full list of values every time. Finally, we'll have a bonus Excel feature.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - 1.Clipboard
1:17 - 2.Go to Cell
2:07 - 3.Pattern Fill
3:08 - 4.Navigation
4:59 - 5.Dynamic Titles
6:19 - 6.Subtotals
8:13 - 7.Automatic Dropdown
9:02 - 8.Descriptive Stats
10:28 - 9.Section Breakdown
11:17 - 10.Custom Lists
12:42 - Bonus
🔥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
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!
clipboard is so simple yet never heard of it lol thanks as alwasy
Yes!! Glad it was useful
I’m only half way through and I would love a part 2
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!
Brilliant! Thank you Kenji!
Thank you, Kenji.
Great tricks!! Thank you
HI Kenji thanks for sharing the tricks , those are really help in real time
Didn't know about the Subtotal, Thanks a lot sir
THANK YOU
I didn‘t know most of them. Thanks for sharing. Great content and communicarion.
Glad you enjoyed! thanks for watching :)
I'm very excited about part 2 sir
thank you and yes we want Awesome Time Saving Hacks in Excel (2)
Great suggestions as always, thanks Kenji
Glad you like them! thanks for letting me know :)
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.
Cool video. Could you perhaps link your current setup?
👏 Thanks very useful 🌹🌹
Glad it was helpful!
yes need 2nd part
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.
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
Nice one Mr. Kenji even though I often use 90% of this hint already😀
Good job!
Awesome, you know a lot already ! :)
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 :)
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
Bonus hacks in windows is Ctrl +F1
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?
which tool you are using to record the videos and for video editing which tool you are using
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 :)
As usual 🎉
Let's go! Thanks for always supporting :)
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
why dont i have that data analysis section on my data tab?
Whi new excel has a clipboard! 😮
I can't add navigation in view ribbon.
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...
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!
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!
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
Great tricks!! Thank you