Best 11 Excel Tips You NEED to Know!
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- I go over some of the best Excel tips! Flash fill, dropdowns lists, formatting tricks, inserting rows & columns in your spreadsheet, grouping rows & columns, auto sum, and more!
WHAT TO WATCH NEXT:
5 Things You're Doing WRONG in Excel - • 5 Things You're Doing ...
How to Bring AI INSIDE Excel (New Function) - • Video
NEW Checkboxes are WAY BETTER in Excel (in 5 Minutes) - • Video
How to Automate Excel with Custom GPT Actions (In 5 Minutes) - • How to Automate Excel ...
Excel Course: www.easysheetslearning.com/p/...
FREE Excel shortcuts PDF: linktr.ee/easysheets
Prosper Spark Excel Consulting: www.prosperspark.com/easy-she...
If I remember this right:
- Ctrl Shift 7 creates surrounding borders
- Ctrl Shift 4 (the dollar sign) changes format to currency
- Use the SUBTOTAL function for tables when you need to filter info. The SUM function give you the sum of everything, but the subtotal function will update as you change filters
- Use macros to save time on minute tasks. You can use them to automate stuff like copying over a bunch of data, adding / clearing filters, formatting cells a particular way, going to a specific sheet in the workbook, etc
The possibilities are many
My mind is totally blown, I had no idea f4 repeated the last action!!
Another great video! I knew 3 of the 11 already, so I just learned 8 new things, which rocks. Flash fill, autosum, and move rows will be used every day.
"Just press Enter." What!? 😮 That was a new one for me. Great tips all around. 👍 Thanks for sharing!
"Don't draw QR codes by hand" changed my life
Flash fill saved my life lol, it helps me type less when I'm copying raw data from a PDF
Clear. Clear. Very clear. Easy to follow. Thank you so much.
This is the coolest video on excel tricks! hands down!!
Really nice tips, well presented
Great video bro
❤
Really good tips! 💯 Thanks hottie.
Thanks a lot! You really help me!
Mind blown! Thank you a million times 🎉
Thanks a lot 🙌🙌🙌
The first tip is so useseful!!!
The format painter tip was awesome
Thank you very much🙏❤
Thank you so much
Thanks! I’m still at the general knowledge level and these tips will help me out so much! Q: Is there a quick way to put tabs in alphabetical order? Besides the drag & drop.
Incredible 😮
thanks a big help
❤thank you
Thanks for great learning of magic tricks of Excel. I request to share Excel files for my practice.
I like this video ❤❤❤❤❤
Awesome
thank you
Very useful my g
Excel wizard
How do you use flash fill when there are exceptions. For example: What is some email addresses had a middle initial?
Where is the link for excel shortcut? Thanks
All are new for me
👌
Hey there. I signed up to to get your shortcut PDF file twice now, each time giving my email addresses. The first time was a week ago and the last time was yesterday evening (Jan 23, 2024). I still haven't gotten anything yet. Do you think you can help move the process along?
Hmm, it should have sent it immediately, maybe a technical problem on my end? I'll try to fix it. Did you check spam?
@@easy_sheets Yes. It wasn't there either. Am I the only one having this experience? Thanks.
Love your content, btw!
I'm not sure if you're the only one but I'm guessing not! Thanks for letting me know about it, I think I just fixed it.
But no need to enter your email again, I'll be sending out an email blast to everyone on the list tomorrow with the pdf just in case they missed it too!
Data set link
You would seriously think that after 38 yrs of Excel that MS would make this #@$%!!! program much more user friendly!!
Data set link