Advisory: CAP 062B This course is the second in a series of Microsoft Excel courses designed to help students learn Excel features that are used in business decisions. Students apply What-IF Analysis such as scenario tables, goal seek, and solver. Students also utilize advanced functions such as VLOOKUP, Nested IF's, Pivot tables and Pivot charts, macros and more. This course is designed for students who are computer literate and have a previous working knowledge of Excel formulas, functions, and charts.