Advanced Excel - Business (Face-to-Face)

Working with advanced formulas; Using names and decision-making functions; Creating nested functions; Using financial functions; Lookups and data tables; Using MATCH and INDEX; Advanced List Management; Creating subtotals; Validating cell entries; Working with PivotTables and PivotCharts; Using analytical options; Working with Goal Seek and Solver; Running and recording a macro.

** Students should be readily familiar with the keyboard and comfortable navigating the computer environment.