Advanced Excel Skills € 193.60 | € 193.60 (Members)
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.

Progress

0.00 %

Passed 0 out of 17 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  

Home

Financial Functions and Goal Seek Prof. H. Zhang

Exercise File (Size: 16.80KB)  
Financial Functions and Goal Seek 1 (Length: 0:02:30 Currently at 0:00:00) Test  
Financial Functions and Goal Seek 2 (Length: 0:05:44 Currently at 0:00:00) Test  
Financial Functions and Goal Seek 3 (Length: 0:12:21 Currently at 0:00:00) Test  
Financial Functions and Goal Seek 4 (Length: 0:02:56 Currently at 0:00:00) Test  
Financial Functions and Goal Seek 5 (Length: 0:04:12 Currently at 0:00:00) Test  
Financial Functions and Goal Seek 6 (Length: 0:06:03 Currently at 0:00:00) Test  

Home

Excel Solver Prof. H. Zhang

Data File (Size: 9.81KB)  
Excel - Solver (Length: 0:14:54 Currently at 0:00:00) Test  

Home

VBA Prof. H. Zhang

VBA Part 01 (Length: 0:10:08 Currently at 0:00:00) Test  
VBA Part 02 (Length: 0:14:55 Currently at 0:00:00) Test  
VBA Part 03 (Length: 0:19:24 Currently at 0:00:00) Test  
VBA Part 04 (Length: 0:12:09 Currently at 0:00:00) Test  
VBA Part 05 (Length: 0:13:44 Currently at 0:00:00) Test  

Home

Nonlinear Optimization (Coming Soon) Prof. H. Zhang

Exercises (Coming Soon) Prof. H. Zhang

Pick up from where you left.