MS Excel Basic Steps for Beginners

 Intro to Excel

Creating New Workbook

Intro to Interface of Excel

Inserting, Renaming & Deleting Worksheets

Move & Copy Worksheets

Printing Workbook

Row, Column, Cell

Inserting & Deleting Row & Column

Deleting Cells

Cell Selection

Fixing Height & Width of Cells

Freezing Row & Column

Hide and Unhide Row & Column

Basics of Entering Data - Part 1

Autofill Data

Duplicate Removal

Merge Text Values of Different Cells

Cell Merge

Data Format

Cell Formatting

Basics of Entering Data - Part 2
Paste optionsCell lockingNaming Ranges
Inserting Objects

Inserting Symbols

Inserting Shapes

Conditional Formatting

Conditional Formatting – Part 1

Conditional Formatting – Part 2

Basic Text Functions

Text Concatenation

Upper Case & Lower Case Text

Date Functions

Day, Month, Year

WeekDay

Realtime Date & Time

Basic Arithmetic Operations

Addition

Subtraction

Division

Multiplication

Arithmetic Operation – Combined

Some Useful Stats Functions

SUM

COUNT

AVERAGE

MIN & MAX

A trick to know

Functions for Finding Data

Vlookup and Hlookup

Index-Match

Data Cleaning & Mining

If error Function

Clean Function

More Cleaning

Trim Function

Substitute Function

Logic Functions

Logic-CountIfs

Logic – Sumifs

Logic – If

Logic – And, Or

Common Data Visualization Methods

Column Chart – Part 1

Column Chart – Part 2

Bar Chart

Pie Chart