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.
Samajh na aye to WhatsApp par pooch lein: 0348 8850059
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 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.
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.
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.
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.
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:
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.
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.
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.
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.
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