Essential Excel Skill for Job Hunting

 

Chapter

Video

Material

1

Overview

1.01 Formatting Technique

1.02 Creating Chart

1.03 Using Formula and VLOOKUP

1.04 Data Analysis by Pivot Table

 

Overview

Chapter 1

Chapter 2

Chapter 3

Chapter 4

2

2.01 Sample Question on Formatting

2.02 Sample Question on Charting

2.03 Sample Question on Formula

2.04 Sample Question on Pivot Table

2.05 Other Sample Question

 

Exercise

 

SFQ – HKCC

SFQ - SPEDD