Introduction to MS Excel

Workbook, Worksheet, Rows and Columns

Cell Address and Range

Data Entry and Editing

Formatting Cells

Number, Date and Currency Formatting

AutoFill and Flash Fill

Basic Formulas

SUM, AVERAGE, MIN and MAX

COUNT, COUNTA and COUNTBLANK

IF Function

AND and OR Functions

SUMIF and COUNTIF

VLOOKUP and HLOOKUP

XLOOKUP Introduction

CONCAT and TEXT Functions

LEFT, RIGHT and MID

Sort and Filter

Conditional Formatting

Data Validation

Remove Duplicates

Charts and Graphs

Pivot Table Introduction

Page Layout and Printing

Sheet Protection

Salary Sheet Practical

Student Result Sheet Practical

Invoice and Billing Practical

Practical Assignment – Excel Project

Module 5 MCQ Test