I've used Microsoft Excel for 15+ years.
Microsoft Excel is amazing tool.
Below are 7 Excel features to boost your productivity:
Microsoft Excel is amazing tool.
Below are 7 Excel features to boost your productivity:
1. VLOOKUP
- allows you to categorize data quickly
- can combine two tables of data
- create pivots from this
- allows you to categorize data quickly
- can combine two tables of data
- create pivots from this
2. SUMIF
- sums categories quickly
- creates data quality checks
- gives data clarity
- sums categories quickly
- creates data quality checks
- gives data clarity
3. Pivot Tables
- summarize 1,000's of data in seconds
- update dashboards quickly
- organize data clearly
- summarize 1,000's of data in seconds
- update dashboards quickly
- organize data clearly
4. IF
- chose certain cells automatically
- simple but powerful
- clean up data
- chose certain cells automatically
- simple but powerful
- clean up data
5. List
- standardize input from others
- use List data with VLOOKUP formula
- categorize data quickly
- standardize input from others
- use List data with VLOOKUP formula
- categorize data quickly
6. GETPIVOTDATA
- links to pivot table data
- updates every time pivot is refreshed
- automates tracking / reporting
- links to pivot table data
- updates every time pivot is refreshed
- automates tracking / reporting
7. SUBTOTAL
- sum only visible cells
- great with filtering data
- doesn't duplicate like SUM would
- sum only visible cells
- great with filtering data
- doesn't duplicate like SUM would
If you enjoyed this thread:
1. Follow me @iamcoriarnold for more of these
2. Share or RT the first tweet to share this thread with your audience
1. Follow me @iamcoriarnold for more of these
2. Share or RT the first tweet to share this thread with your audience
Loading suggestions...