OMI STUDENT LEARNING

Excel & Data Work

Learn Microsoft Excel and professional data work step-by-step. Start from Excel basics and gradually learn formulas, data cleaning, charts, dashboards and professional reports.

21

Lessons

Excel

Main Skill

Data

Work Focus

📚 Excel Lessons

Excel ko basic se professional level tak step-by-step seekhein.

LESSON 01

Excel Basics

Excel kya hai, iska use kaha hota hai aur Excel interface ke basic parts ko samjhein.

Start Lesson →
LESSON 02

Excel File & Workbook

Excel file, workbook, worksheet aur multiple sheets ko samjhein.

Start Lesson →
LESSON 03

Rows, Columns & Cells

Rows, columns aur cells ka use aur Excel mein data ki position samjhein.

Start Lesson →
LESSON 04

Data Entry

Excel sheet mein text, numbers aur basic information enter karna seekhein.

Start Lesson →
LESSON 05

Formatting

Data ko clean aur professional banane ke liye formatting ka use seekhein.

Start Lesson →
LESSON 06

Sort & Filter

Large data ko arrange aur required information ko filter karna seekhein.

Start Lesson →
LESSON 07

Basic Formulas

Excel formulas kya hote hain aur calculations ke liye formulas ka use seekhein.

Start Lesson →
LESSON 08

SUM, AVERAGE & COUNT

Important Excel calculation formulas SUM, AVERAGE aur COUNT ko samjhein.

Start Lesson →
LESSON 09

IF Formula

Conditions ke according result show karne ke liye IF formula seekhein.

Start Lesson →
LESSON 10

VLOOKUP & XLOOKUP

Excel mein data search, lookup aur matching karna seekhein.

Start Lesson →
LESSON 11

Data Cleaning

Messy aur incorrect data ko clean aur organized banana seekhein.

Start Lesson →
LESSON 12

Remove Duplicates

Duplicate records ko identify aur remove karna seekhein.

Start Lesson →
LESSON 13

Excel Tables

Normal data ko professional Excel Table mein convert karna seekhein.

Start Lesson →
LESSON 14

Charts

Excel data ko charts aur visual information mein convert karna seekhein.

Start Lesson →
LESSON 15

Sales Data

Sales data ko organize, calculate aur analyze karna seekhein.

Start Lesson →
LESSON 16

Employee Data

Employee records ko professional Excel format mein manage karna seekhein.

Start Lesson →
LESSON 17

Customer & Lead Data

Customer aur lead information ko properly organize karna seekhein.

Start Lesson →
LESSON 18

Excel Dashboard

Professional dashboard aur useful data visuals banana samjhein.

Start Lesson →
LESSON 19

Excel to PDF

Excel report ko PDF format mein export karna seekhein.

Start Lesson →
LESSON 20

Professional Excel Report

Business ke liye professional Excel report banana seekhein.

Start Lesson →
LESSON 21

Complete Excel Project

Excel ke important concepts ko combine karke complete project samjhein.

Start Lesson →