This is an advanced course in Excel skills, especially for business and finance students. You should subscribe to the introductory course if you have no background in Excel.
The course covers topics such as Excel PivotTable, Dynamic Arrays, Statistical Functions, Simulation, Excel Solver, GoalSeek, DataTable, Simulation and Nonlinear Optimization. The content is been updated frequentyly.
In this part, we discuss Excel PivotTable. We will start by the basic building blocks of using PivotTable. Then we discuss how we can use PivotTable for business analysis.