Advanced Excel Skills € 193.60 | Subscribe | Redeem Code

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.


0.00 %

Passed 0 out of 4 Tests
Upcoming Deadline

No Upcoming Deadline

Excel PivotTable Prof. H. Zhang

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.

NorthWind (Size: 125.18KB)
Excel - PivotTable Part 1 (Length: 0:15:42 Currently at 0:00:00) Test
Excel - PivotTable Part 2 (Length: 0:11:21 Currently at 0:00:00) Test
Excel - PivotTable Part 3 (Length: 0:08:27 Currently at 0:00:00) Test  


Dynamic Arrays (Coming Soon) Prof. H. Zhang

Statistical Functions (Coming Soon) Prof. H. Zhang

Simulation (Coming Soon) Prof. H. Zhang

Nonlinear Optimization (Coming Soon) Prof. H. Zhang

Exercises (Coming Soon) Prof. H. Zhang

Pick up from where you left.