Introduction

i. To list out the commonly used functions in Excel

ii. To know the differences of each functions

iii. To be able to use suitable functions based on needs

Video explanation: to give better view and understanding of the introduction of the main subtopic

intro.mp4

Before going further in this chapter, let’s create a new workbook and at Sheet 1, create the following data table.

Apply basic function to find the total of each item.

Ensure cells E3:E6 is provided with answers before continue. This will be used for the following lessons.

Page updated

Google Sites

Report abuse