Skip to content
TutorPapa
Beginner–IntermediateHindi + English

MS Excel for Jobs – From Basics to Pivot & Dashboards (India)

Job-ready MS Excel in Hindi-English — formulas, VLOOKUP/XLOOKUP, pivot tables, charts aur dashboards, real office examples ke saath.

0.0 (0 ratings) 0 students 4h 10m total 10 lessons

Created by Rajeev Ranjan Jha
Updated Nov 2026

What you'll learn

  • Excel interface, shortcuts, formatting, tables
  • Formulas: SUM, AVERAGE, IF, COUNTIF/SUMIF, VLOOKUP, XLOOKUP
  • Data cleaning: TRIM, Text-to-Columns, Remove Duplicates, Flash Fill
  • Pivot tables & charts
  • Simple MIS dashboard with slicers
  • Salary sheet (PF/ESI basics) & GST-ready invoice/sales tables
  • Top Excel interview questions & practical test prep

Curriculum

1 sections · 10 lessons · 4h 10m

  • Excel Interface, Shortcuts & Formatting Basics Preview20:00
  • Core Formulas: SUM, AVERAGE, MIN/MAX, COUNT 25:00
  • Logic Formulas: IF, Nested IF, COUNTIF, SUMIF 25:00
  • VLOOKUP & XLOOKUP (with HLOOKUP/INDEX-MATCH tip) 30:00
  • Data Cleaning: TRIM, Text-to-Columns, Duplicates, Flash Fill 25:00
  • Pivot Tables in Hindi – Summaries in Minutes 30:00
  • Charts that Bosses Like (Column, Line, Pie, Combo) 20:00
  • Build an MIS Dashboard with Pivot Charts & Slicers 30:00
  • Office Projects: Salary Sheet & GST-Ready Invoice Table 25:00
  • Excel Interview Questions & Practical Test Prep 20:00

About this course

Is course mein aap Excel basics se lekar pivot tables aur dashboards tak seekhenge. SUM/IF/VLOOKUP/XLOOKUP, data cleaning, salary sheet, GST-ready invoice tables aur interview Excel questions — sab Indian office examples ke saath. Data entry, accounts assistant, MIS/back-office jobs aur freshers ke liye perfect.

Requirements

  • Basic computer use. Excel 2016/2019/365 (XLOOKUP needs 365/2021; VLOOKUP alternative shown).
Suitable for
All ages
Version
v1.0 · updated Nov 2026
Content source & licence
Original content by the instructor · All rights reserved

Your instructor

Rajeev Ranjan Jha
Rajeev Ranjan Jha

Social Media · SEO · Prompt Engineering Specialist | TutorPapa

0.0 rating 8 yrs experience Specialist — Digital Marketing / SEO / Prompt Engineering

Experienced in social media growth, SEO strategy, and AI prompt engineering; teaches practical skills for students/professionals online (Hindi + English).

Book a 1:1 demo with Rajeev

Student reviews

0.0

0 ratings

Students also bought