Excel 2007 Advanced Formulas
Work with advanced formulas and functions. See how to improve your formulas by applying a higher level of automation to your calculations.
- Working with range names
- DSUM
- IF
- SUMIF
- VLOOKUP
- HLOOKUP
- MATCH
- INDEX
- Hiding columns and rows
- GoalSeek
- Conditional formatting