The major topics that will be covered in this course include:
- Using formulas to manipulate and transform data
- Using formulas to summarize data
- Using lookup and reference formulas such as =VLOOKUP
- Using pivot tables
- Understanding Goal Seek
- Using Solver to perform multivariate analysis