Advanced Microsoft Excel

Chapter	Video	Material
1	Overview 1.01 Status Bar 1.02 Clipboard 1.03 Paste Special 1.04 Fill Series 1.05 Format Cell 1.06 Alignment 1.07 Find and Replace 1.08 Conditional Format 1.09 Print Exercise 1	Outline Lecture Note 1 Exercise 1 Source File 1
2	2.01 Form 2.02 Remove Duplicate 2.03 Filtering 2.04 Sorting 2.05 Subtotal 2.06 Data Validation Exercise 2	Lecture Note 2 Exercise 2 Source File 2
3	3.01 Creating Simple Chart 3.02 Creating Combination Chart 3.03 Scatter Chart 3.04 Area Chart 3.05 Stock Chart 3.06 Bubble Chart 3.07 Pie Chart Exercise 3	Lecture Note 3 Exercise 3 Source File 3
4	4.01 Understand Reference 4.02 Name Manager 4.03 Mathematical Function 4.04 Rounding Function 4.05 String Function 4.06 Date Function 4.07 VLOOKUP 4.08 Trace Dependent Exercise 4	Lecture Note 4 Exercise 4 Source File 4
5	5.01 Data Table 5.02 Scenario Manager 5.03 Goal Seek 5.04 Solver 5.05 Consolidation 5.06 Pivot Table Exercise 5	Lecture Note 5 Exercise 5 Source File 5 SFQ – SPEED