ADMISSION SIRF RS 1,000: Har course ki admission fee sirf Rs 1,000 hai — EasyPaisa se jama karein, payment approve hote hi access, koi monthly fee nahi! Certificate ke Rs 1,000 course completion par. ADMISSION SIRF RS 1,000: Har course ki admission fee sirf Rs 1,000 hai — EasyPaisa se jama karein, payment approve hote hi access, koi monthly fee nahi! Certificate ke Rs 1,000 course completion par.
Courses Dekhein
Skills

MS Excel Advanced Skills — Office Jobs Ke Liye Guide

10 Nov 2026 · CMTI Blog

Office me kaam karne wala har shakhs Excel istemal karta hai — lekin basic Excel aur advanced Excel me wohi farq hai jo aik clerk aur aik office manager me hota hai. Agar aap sirf data type karna aur simple sum lagana jante hain, to aap Excel ke sirf 10% istemal kar rahe hain. Advanced Excel seekhna woh skill hai jo aap ki CV ko foran alag kar deti hai, aur office jobs me promotion aur behtar tankhwah ka rasta kholti hai. Is guide me hum samjhayenge ke advanced Excel kya hai, kon se tools seekhne hain, aur in se office me kaam kaise asan hota hai.

CMTI me enroll karne ka tareeqa — 4 asan steps

Samajh na aye to WhatsApp par pooch lein: 0348 8850059

Advanced Excel Kya Hai?

Advanced Excel ka matlab hai ke aap Excel ko sirf table banane ke liye nahi, balkay data ko analyse karne, reports banane aur faislay lene ke liye istemal kar sakte hain. Basic Excel me aap data likhte hain; advanced Excel me aap data se jawab nikalte hain. Misaal ke tor par, aik company ke paas hazaron sales records hain — aik basic user unhe gin nahi sakta, lekin aik advanced user do minute me bata sakta hai ke kon sa product sab se zyada bika, kis sheher me sale kam hui, aur kis mahine me munafa gira.

Ye skill aaj har daftar me chahiye: accounts department, HR, sales, store management, bank, school — har jagah data hota hai aur har jagah koi chahiye jo us data ko samajh sake.

Pivot Tables — Sab Se Taqatwar Tool

Pivot table Excel ka woh tool hai jo hazaron rows ko seconds me summary me badal deta hai. Aap ko har dafa formula likhne ki zaroorat nahi — bas data select karein, pivot table lagayein, aur drag-drop se apni report bana lein.

  • Sales summary — product, sheher ya salesman ke hisaab se kul sale nikalna.
  • Monthly comparison — is mahine ki sale pichle mahine se kitni zyada ya kam hai.
  • Count aur average — kitne customers aye, ausat order kitna tha, sab se bara order kon sa tha.

Jo kaam pehle aik ghanta lagta tha, pivot table usay chand minute ka kar deta hai. Interviews me pivot table ka sawal sab se zyada poocha jata hai — is liye isay pehle seekhna sab se faida-mand hai.

VLOOKUP Aur XLOOKUP — Data Jorna Seekhein

Daftaron me data aksar alag sheets me hota hai: aik sheet me customer ki list, doosri me un ki payment. VLOOKUP aur is ka naya version XLOOKUP aap ko aik sheet se data dhoondh kar doosri sheet me lane deta hai — bina copy-paste ke.

  • VLOOKUP — purana aur mashhoor tareeqa; ab bhi har office me istemal hota hai.
  • XLOOKUP — naya aur asan; dono taraf dhoondh sakta hai aur ghalti hone par apni marzi ka message dikha sakta hai.
  • INDEX + MATCH — jab data ulta ho ya VLOOKUP kaam na kare, to ye combination kaam ata hai.

In functions ko seekhna mushkil lagta hai, lekin aik dafa samajh aa jaye to aap roz ke ghanton ka kaam minute me karne lagte hain.

Dashboards — Report Jo Khud Bolti Ho

Dashboard aik aisi sheet hoti hai jis par manager aik nazar me sab kuch dekh leta hai: kul sale, target poora hua ya nahi, kon si branch peeche hai. Dashboard banane ke liye aap ko chahiye hota hai:

  • Charts — bar chart, line chart aur pie chart se numbers tasveer ban jate hain.
  • Conditional formatting — jo number target se kam ho, woh khud laal ho jaye; jo zyada ho, woh sabz.
  • Slicers aur filters — manager aik click se sirf apni branch ya apna mahina dekh sake.

Aik acha dashboard banane wala employee daftar me woh shakhs ban jata hai jis se har report mangi jati hai — aur yehi pehchan promotion ki bunyad banti hai.

Data Cleaning — Ganda Data Saaf Karna

Asli duniya ka data kabhi saaf nahi hota: naam do tareeqon se likhe hote hain, dates ghalat format me hoti hain, khaali cells hote hain. Advanced Excel me aap seekhte hain ke Text to Columns, TRIM, Remove Duplicates aur Power Query se data ko report ke qabil banaya jaye. Power Query khaas tor par seekhne ke qabil hai — is se aap bar bar ane wale saaf-suthray kaam aik dafa set karke har dafa aik click me kar sakte hain.

Office Jobs Me Advanced Excel Ki Demand

Pakistan me data entry operator, accounts assistant, office assistant, store keeper aur MIS assistant ki har vacancy me "MS Excel" likha hota hai — aur jo candidate pivot table aur VLOOKUP janta ho, woh pehli shortlist me ata hai. Gulf countries me bhi yahi haal hai: wahan ke offices me Excel ki maharat aik basic requirement ban chuki hai. Ye skill aap ko kisi degree ka intezar kiye baghair, kuch hafton ki mehnat se, job market me qabil-e-rozgar bana deti hai.

Practice Plan — Kaise Seekhein?

  1. Roz aik ghanta — pehle do hafte formulas aur functions par lagayein (SUMIF, COUNTIF, IF, VLOOKUP).
  2. Asli data par practice — apne ghar ka kharcha ya kisi dukaan ki sale ka record bana kar us par pivot table lagayein.
  3. Teesre hafte dashboard — aik mukammal monthly report bana kar dekhein, jis me chart aur conditional formatting ho.
  4. Apna sample kaam mehfooz rakhein — interview me apni banayi hui sheet dikhana, certificate se zyada asar karta hai.

Shuruaat Kahan Se Karein?

Agar aap Excel ko basic se advanced tak sahi tartib se seekhna chahte hain, to CMTI ka MS Excel (Complete Course) aap ke liye bana hai — formulas, pivot tables, VLOOKUP, dashboards aur data cleaning, har step Urdu me video lectures ke sath. Account bilkul free hai aur har course ki admission sirf Rs 1,000 hai — koi monthly fee nahi.

Koi sawal hai? Neeche WhatsApp button se hum se seedha pooch sakte hain.

Start Learning Today

Create your free CMTI account and start any course with a one-time admission of just Rs 1,000 — full video lectures in Urdu & Hindi, weekly quizzes and a verified certificate.

See the Microsoft Excel Course Chat on WhatsApp
WhatsApp