Tips for Excel Users
Tip 1 - VLOOKUP and INDEX/MATCH
Tip 2 - SUMIF and SUMIFS
Tip 3 - SUMPRODUCT
Tip 4 - Array Functions
Tip 5 - Tables vs. Ranges
Tip 6 - Filters
Tip 7 - Pivot Tables vs. Other Options
Tip 8 - Conditional Formatting
Tip 9 - RAND
Tip 10 - Solver
Tip 11 - Basic VBA
Tip 12 - Conditional Formatting