Best 11 Excel Tips You NEED to Know!
Vložit
- čas přidán 13. 07. 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...
Mind blown! Thank you a million times 🎉
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
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.
"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.
"Just press Enter." What!? 😮 That was a new one for me. Great tips all around. 👍 Thanks for sharing!
Really nice tips, well presented
Great video bro
❤
Thanks a lot! You really help me!
Really good tips! 💯 Thanks hottie.
The format painter tip was awesome
The first tip is so useseful!!!
My mind is totally blown, I had no idea f4 repeated the last action!!
Thanks a lot 🙌🙌🙌
Thank you very much🙏❤
Thank you so much
Incredible 😮
Thanks for great learning of magic tricks of Excel. I request to share Excel files for my practice.
thanks a big help
❤thank you
Very useful my g
Excel wizard
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.
I like this video ❤❤❤❤❤
thank you
Awesome
How do you use flash fill when there are exceptions. For example: What is some email addresses had a middle initial?
You would seriously think that after 38 yrs of Excel that MS would make this #@$%!!! program much more user friendly!!
👌
All are new for me
Where is the link for excel shortcut? Thanks
Data set link
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