Day 1

Workbook

Creating a Worksheets

Adding worksheets

Renaming Worksheets

Working with multiple worksheets

Managing Excel Files

Saving a file in a new folder

Rename and Delete file

Open more than one file

Formatting Cells

Simple cell formatting

Formatting Numbers

Formatting Borders and Cells

Fill Handle with numbers and text

Formatting Cell Value and Contents

Edit Cells

Moving and Copying Cells

Text Correction

Proofing Tools

Auto Correct

Find and Replace

Spelling

Working with Rows and Column

Adjusting columns and rows width

Adding deleting  new columns and rows

Freezing rows and columns

Page Layout

Paper Size and orientation

View Worksheet

Borders and Shading

Day 2

Formula

Understanding what a formula is.

Basics of Formulas

Using fill handle with formulas

Using cells from other worksheet inside a formula

Understanding absolute referencing

Editing Formulas

Revise a formula

Edit a formula

Removing formulas

Functions

Calculating the SUM number

Calculating the AVERAGE number

Highest and lowest MAX,MIN number

Counting cells that contain numbers COUNT

Counting cells that match Specific criteria COUNTIF

Counting cells that contain any value COUNTA

Counting the empty Cells COUNT BLACK

VLOOKUP Function

How to use the VLOOKUP Function

SUMIF Function

How to use the SUM IF Function

Using the Quick Function

The IF Statement

How to use the IF statement with texts and calculations

Day 3

Drop Down List

Learn how to create a drop down list

Excel Sort

Simple Sorting

Sorting more than one criteria

Conditional Formatting Excel

The basics of conditional formatting

Removing Clearing the Conditional Formatting

How to copy conditional formatting

Highlight highest and lowest values

Finding Duplicate values

Excel Charts

Creating a new Chart

Adding Chart Titles

Relocating the legend

Adding data labels

Rescaling the Y-axis

Formatting the Chart (colour, background etc.)

Excel Filter

Basic Filtering

Filtering By Numerical Values, texts and dates