Business Insider has an article this week entitled “11 Advanced excel Tricks that will help get you an instant raise at work.” They include:
- Vlookup
- Index/Match
- 3D Sums
- Using a $
- Arrays
- Goal Seeking
- Pivot Tables
We covered most of these in IT 101. Read the article for a great summary of how to use the familiar features, and take a moment over the summer to try out the new ones!