Thread
Excel is used by 1.1 billion people in the world.
Impress your boss, grow your career, and improve your money with these 5 features you need to know:
Impress your boss, grow your career, and improve your money with these 5 features you need to know:
1. Double-click on bottom-right square of a formula
- auto-populate your formula down the entire length of the data
- auto-populate your formula down the entire length of the data
2. GETPIVOTDATA
- automatically refreshes as pivot tables are refreshed
- automatically refreshes as pivot tables are refreshed
3. SUBTOTAL v SUM
- SUBTOTAL updates as you filter.
- SUM doesn't.
- SUBTOTAL updates as you filter.
- SUM doesn't.
4. Ctrl + A
- selects all data in a table
- takes less than 2 seconds
- selects all data in a table
- takes less than 2 seconds
5. XLOOKUP
- automate reporting
- combine two data tables in seconds
- create models that do the work for you
- automate reporting
- combine two data tables in seconds
- create models that do the work for you
Learn all these time-saving tricks and many more in this brand new Microsoft Excel course!
40+ formulas
30+ shortcuts
For 48 hours only, get this course for 70% off.
www.udemy.com/course/microsoft-excel-beginner-to-advanced-models-templates/?couponCode=LAUNCHDISCOUNT...
40+ formulas
30+ shortcuts
For 48 hours only, get this course for 70% off.
www.udemy.com/course/microsoft-excel-beginner-to-advanced-models-templates/?couponCode=LAUNCHDISCOUNT...
If you enjoyed this thread:
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
Mentions
See All
Growth Hub @growthhub_
ยท
May 26, 2023
Fantastic thread