## MS Office & Excel Course in Amritsar & Jalandhar 2026
MS Office remains one of the most-demanded skill sets in Punjab job postings — from bank clerk recruitment to MIS executive positions.
---
Basic MS Office Course (1–2 months, ₹3,000–₹6,000)
MS Word: Document formatting, tables, header/footer, mail merge, track changes, table of contents, footnotes.
MS Excel: Data entry, basic formulas (SUM, AVERAGE, COUNT, IF), cell formatting, charts (bar, pie, line), basic filters and sort.
MS PowerPoint: Slide creation, transitions, animations, slide master, professional presentation design, presenter view.
MS Outlook: Email management, calendar, task management, distribution lists.
---
Advanced Excel Course (2–3 months, ₹5,000–₹12,000)
Lookup functions: VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP (Excel 2021+).
Logic functions: IF, IFS, nested IF, AND/OR, IFERROR, CHOOSE, SWITCH.
Statistical: COUNTIF/COUNTIFS, SUMIF/SUMIFS, AVERAGEIF/AVERAGEIFS.
Dynamic arrays (Excel 2021+): FILTER, SORT, UNIQUE, SEQUENCE.
Pivot Tables: multi-dimensional analysis, slicers, timelines, calculated fields, pivot charts.
Power Query: data cleaning (remove duplicates, fill down, unpivot, merge queries, data type corrections).
Macros + VBA: recording macros, basic automation of repetitive tasks.
Excel Dashboards: interactive reports using slicers + pivot charts + dynamic ranges.
---
Government Certifications
CCC (NIELIT): ₹590 exam fee, monthly exam, lifetime valid. Required for Punjab state government clerk/PSU jobs. Apply at student.nielit.gov.in.
O-Level (NIELIT): 1 year, 4 papers, ~₹15,000 total. Government-recognized diploma equivalent. Eligible for government IT department posts.
MOS Excel Expert (Microsoft/Certiport): ₹3,500–₹5,500 exam fee. International certification. Valued at MNCs and BPOs.
---
Jobs After MS Office Course in Punjab
| Role | Salary | Key Requirement |
|---|---|---|
| Data Entry Operator | ₹8,000–₹14,000 | Basic Excel, fast typing |
| MIS Executive | ₹12,000–₹22,000 | Advanced Excel, Pivot Tables |
| Office Administrator | ₹10,000–₹18,000 | Word, Excel, Outlook |
| Accounts Assistant | ₹10,000–₹16,000 | Excel + basic Tally |
| Bank Clerk (PNB, SBI, Canara) | ₹19,000–₹28,000 (govt pay) | CCC/O-Level + IBPS exam |
| Government Clerk | ₹18,000–₹25,000 (govt pay) | CCC certificate + PSEB exam |
Career upgrade path: Advanced Excel + Power BI = Data Analyst ₹25,000–₹45,000/month local or remote.
Best combination for Punjab finance/accounts: MS Office + Advanced Excel + Tally Prime + CCC certification.
---