Common beginner functions: - InfoIndia91

MS Excel Course for Beginner Common beginner functions:

MS Excel Course for Beginner

0% Completed

Module 1: Introduction to Microsoft Excel

What is MS Excel?

Excel ke versions (2016 / 2019 / 2021 / 365)

Workbook aur Worksheet ka concept

Rows, Columns aur Cells

Excel start karna, file open & close karna

Module 2: Excel Interface & Navigation

Ribbon, Tabs aur Groups ka use

Quick Access Toolbar

Name Box aur Formula Bar

Mouse aur Keyboard se navigation

Zoom in / Zoom out

Multiple sheets ke beech move karna

Module 3: Data Entry & Editing

Cell mein data enter karna

Text, Numbers, Dates enter karna

Edit, Clear aur Delete data

AutoFill ka use

Copy, Cut, Paste (Normal & Special Paste)

Module 4: Formatting Cells & Data

Font style, size, color change karna

Bold, Italic, Underline

Cell alignment (Left, Center, Right)

Borders & Fill color

Number formatting (Currency, Percentage, Date)

Module 5: Rows, Columns & Worksheets

Row aur Column insert / delete

Row height & column width adjust karna

Hide & Unhide rows/columns

Worksheet rename, move, copy

New worksheet add karna

Module 6: Basic Formulas

Formula kya hota hai

= sign ka importance

Simple calculations:

Subtraction (-)

Multiplication (*)

Multiple cells ke saath formula use

Common mistakes & error fixing

Module 7: Basic Functions

Functions ka concept

Common beginner functions:

Range selection ka sahi tarika

Module 8: Page Setup & Printing

Page orientation (Portrait / Landscape)

Margins set karna

Header & Footer

Selected area print karna

Module 9: Basic Data Management

Sort data (A–Z, Z–A)

Simple Filter lagana

Freeze Panes (Row / Column lock)

Module 10: Saving, Protecting & Sharing Files

File formats (.xlsx, .xls, .pdf)

Password protect file

File share basics

Announcements Reviews Course Info

SUM

AVERAGE

COUNT

MIN

MAX

Scroll to Top