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 – HKCC

SFQ – SPEED