Professional MS Excel Mastery: Syllabus Outline


Excel Syllabus Highlights (Sada aur Professional):

  • Module 1: Basic Foundations – Excel interface, data entry, aur formatting (Hafta 1).
  • Module 2: Essential Math – SUM, AVERAGE, aur basic math operators (+, -, *, /) ka istemal (Hafta 2).
  • Module 3: Data Organization – Sorting, Filtering, aur messy data ko clean karne ki basic techniques (Hafta 3).
  • Module 4: Career & Projects – Basic charts, printing settings, aur freelancing (Data Entry) ka intro (Hafta 4).

Included Practice Tasks:

  1. Inventory Tracker: Multiplication aur Addition formulas ki practice ke liye.
  2. Data Correction: Spaces khatam karne aur formatting theek karne ki activity.
  3. Result Sheet: Percentage aur Total nikalne ka real project.


MS Excel Professional Mastery (Job-Ready Syllabus)

Phase 1: Professional Office Basics

·        Concepts: Excel Interface, Workbook vs Worksheet management, Custom Formatting (Number, Date, Currency).

·        Activity: "The Professional Invoice" – Create a company bill from scratch using borders, colors, and merge & center.

·        Practice Sheet: Data Entry accuracy test with 50+ entries including dates and phone numbers.

Phase 2: Mathematical Logic & Business Math

·        Concepts: AutoSum, Basic Arithmetic (+, -, *, /), Average, Max/Min, and Basic Cell Referencing ($).

·        Activity: "Monthly Household Budget" – Students track income and expenses to see their savings automatically.

·        Project: "Automated Salary Sheet" – Calculate Basic Pay, Allowances, and Deductions for 10 employees.

Phase 3: Data Management & Cleaning

·        Concepts: Sorting (A-Z), Filter (Basic & Text filters), Find & Replace, and Removing Duplicates.

·        Activity: "Messy List Cleanup" – Take a raw CSV list of 100 names and clean the formatting and duplicates.

·        Job Knowledge: Learn how companies use Excel to organize customer contact lists for marketing.

Phase 4: Professional Visualization & Printing

·        Concepts: Inserting Bar and Pie Charts, Page Layout, Print Titles, and Header/Footer settings.

·        Activity: "Sales Growth Chart" – Convert a 12-month sales table into a professional visual graph.

·        Final Project: "Full Academy Management System" – A multi-sheet project including student registration, fees record, and a final summary dashboard.

Phase 5: Freelancing & Career Skills

·        Skills: How to offer "Excel Data Entry" and "PDF to Excel Conversion" services on platforms like Fiverr.

·        Portfolio: Guide students to save their Salary Sheet and Business Budget as "Work Samples" to show clients.

Practice Sheets for Students

1.     Task 1 (Calculation): Create a "School Result Card" where entering marks automatically updates the Total and Percentage.

2.     Task 2 (Organization): A "Store Inventory" list where students must filter items that are "Out of Stock."

3.     Task 3 (Formatting): A "Price List" that must be formatted professionally for printing on a single page.


Practice Sheet 1: School Result Card (Auto-Calculation)

Is sheet ka maqsad students ko SUM aur Percentage ka formula sikhana hai.

Roll No

Student Name

English (100)

Math (100)

Urdu (100)

Total Marks

Percentage

101

Ali Ahmed

85

92

78

=SUM(C2:E2)

=(F2/300)*100

102

Sara Khan

70

65

88

Calculate

Calculate

103

Usman Zia

45

55

60

Calculate

Calculate
  • Student Task: Sirf marks enter karein, Total aur Percentage khud-ba-khud nikalni chahiye.

Practice Sheet 2: Store Inventory (Filtering & Status)

Is sheet se students Data Filtering aur Conditional Formatting seekhain gay.

Item ID

Item Name

Category

Stock Quantity

Unit Price

Total Value

Status

P-001

Keyboard

Hardware

15

1200

=D2*E2

In Stock

P-002

USB Drive

Storage

0

800

0

Out of Stock

P-003

Mouse

Hardware

5

500

2500

In Stock

P-004

Monitor

Hardware

0

15000

0

Out of Stock
  • Student Task:
    1. Total Value ka formula lagayein (Quantity x Price).
    2. Filter on karke sirf wo items dikhayein jo "Out of Stock" hain.

Practice Sheet 3: Professional Price List (Formatting & Printing)

Is sheet mein focus calculation par nahi balkay Layout aur Design par hai.

CATEGORY

PRODUCT DESCRIPTION

WARRANTY

PRICE (PKR)

Laptops

Core i5 12th Gen / 8GB RAM

1 Year

145,000

Laptops

Core i7 13th Gen / 16GB RAM

1 Year

210,000

Accessories

Wireless Mouse & Keyboard

6 Months

4,500

Accessories

HD Web Camera 1080p

6 Months

3,200
  • Student Task:
    1. Headings ko Bold karein aur Background Color dain.
    2. Currency format (PKR) lagayein.
    3. Page Setup mein ja kar isay "Landscape" mode mein set karein taake ye print par bilkul center mein aaye.


Fiverr Mastery: Students Ghar Bethay Freelancing Se Paisay Kaisay Kamayein?

 

JOB:

Excel mein job aur freelancing ka kaam bilkul waisa hi professional hona chahiye jaisay hum ne Adobe Illustrator aur MS Word ke liye plan kiya tha. Excel ki market mein demand bohat zyada hai kyunke har business ko data manage karna hota hai.

Excel ke liye career guide aur freelancing ki mukammal details niche di gayi hain:

1. Excel Freelancing: Fiverr aur Upwork par Kaam

Aap apne students ko in specific services (Gigs) par focus karwayein:

  • Data Entry & Formatting: Raw data ko saaf suthra aur organize karna.
  • PDF to Excel Conversion: Bank statements ya invoices ko Excel sheet mein convert karna.
  • Excel Automation: Buttons aur asaan formulas ke zariye kaam ko automate karna.
  • Dashboards & Visualization: Data ko charts aur graphs mein badalna taake client ko samajh aa sakay.

Tip for Students: Fiverr par gig banate waqt "Data Entry" ke bajaye "Excel Data Cleaning" ya "Financial Dashboards" jaise keywords use karein, is se jaldi order milte hain.

2. Job Roles: Excel Seekh Kar Kahan Apply Karein?

Excel seekhne ke baad students in posts ke liye apply kar sakte hain:

  • Data Entry Operator: Har choti-bari company mein record rakhne ke liye.
  • MIS Executive (Management Information System): Reports banane aur data maintain karne ke liye.
  • Accounts Assistant: Salary sheets aur basic accounting handle karne ke liye.
  • Virtual Assistant: Foreign clients ke liye online data manage karna.

3. Job Apply Karte Waqt Kya Karein? (The Portfolio)

Jaisay hum ne graphic design mein portfolio banaya tha, Excel mein bhi zaroori hai:

  • Sample Work: Students apni banai hui "Salary Sheet," "Inventory Tracker," aur "Result Card" ki files aik folder mein rakhein.
  • Clean Sheets: Excel file aisi honi chahiye jo dekhne mein professional lage (Headings bold hon, borders lage hon, aur faltu gridlines hide hon).
  • LinkedIn Profile: Apni profile par "MS Excel Expert" likhein aur apne projects share karein.

4. Interview Ki Tayari: Kya Poocha Jata Hai?

Interviews mein zyada tar ye 3 cheezon ka test liya jata hai:

  1. Data Cleaning: Kya aap duplicate data nikal sakte hain?
  2. Basic Formulas: Kya aapko SUM, AVERAGE, aur IF functions ka pata hai?
  3. Shortcuts: Wo check karte hain ke aap mouse zyada use karte hain ya keyboard shortcuts (jaisay Ctrl+C, Ctrl+V, Ctrl+Shift+L filter ke liye).

Aap students ko ye batayein ke Excel sirf software nahi, balkay aik Problem Solving Tool hai. Jo student mushkil data ko asaan bana dega, usay job jaldi milay gi.

 

 Build and Optimize a Professional Behance Portfolio


MS Excel – Behance Project Idea

Excel ka portfolio attractive banane ke liye aapko aisi cheezain shamil karni chahiye jo sirf "Data Entry" nahi balkay "Problem Solving" dikhayein. Jab koi client ya manager aapka portfolio dekhe, to usay samajh aaye ke aap mushkil data ko asaan bana sakte hain.

Excel portion ko behtar banane ke liye aap ye 5 cheezain shamil karein:

1. Professional Dashboard (Visual Summary)

Excel mein aik aisi sheet banayein jahan chart aur graphs lage hon.

·        Kya Dalen: Aik "Sales Report" ya "Student Attendance" ka dashboard.

·        Kyun: Is se pata chalta hai ke aapko data visualize karna aata hai. Jab buttons (Slicers) par click karne se charts badalte hain, to ye bohat professional lagta hai.

2. Automated Salary/Payroll Sheet

Ye har office ki zaroorat hoti hai.

·        Kya Dalen: Aik aisi sheet jis mein Basic Pay daltay hi HRA, Medical Allowance, aur Tax khud-ba-khud calculate ho jayein.

·        Kyun: Is se aapki mathematical logic aur formula mastery (SUM, IF, Percentage) ka saboot milta hai.

3. Inventory Management Tracker

·        Kya Dalen: Aik stock list banayein jahan "Available Stock" khatam hone par cell ka color red ho jaye (Conditional Formatting).

·        Kyun: Is se dikhta hai ke aap business management mein Excel ka istemal jante hain.

4. Data Cleaning Sample (Before & After)

Portfolio mein do screenshots lagayein. Ek "Messy Data" (jis mein faltu spaces aur mistakes hon) aur dusra "Clean Data".

·        Kya Dalen: Customer contact lists ya product lists jo organize ki gayi hon.

·        Kyun: Freelancing mein 70% kaam data cleaning ka hota hai, is liye ye client ko attract karta hai.

5. PDF to Excel Project

·        Kya Dalen: Kisi bank statement ya bill ki PDF se nikaala gaya Excel data.

·        Kyun: Ye Fiverr par sab se zyada bikne wali service hai. Is se sabit hota hai ke aap accurate data entry kar sakte hain.

Portfolio ko Attractive Banane ki Tips:

·        Screenshots: Apni Excel sheets ke saaf suthre screenshots le kar portfolio mein lagayein.

·        Brief Description: Har project ke sath 2 line likhein ke "Is sheet mein maine automated formulas use kiye hain taake waqt bach sakay."

·        No Gridlines: Portfolio ke liye screenshot lete waqt Excel ki gridlines (khane) 'View' menu se hide kar dein, is se sheet software ki tarah lagti hai.

Agar aap ye 5 cheezain apne Excel portion mein shamil karein gi, to aapki academy ke students ko job aur freelancing mein bohat asani hogi.

 

Bilkul, main aapke liye in panchoon (5) portfolio projects ka structure aur data taiyar kar deta hoon. Aap inhein copy karke Excel mein paste karein aur inka professional screenshot le kar portfolio mein lagayein.

1. Professional Dashboard (Sales Report)

Is sheet mein aapko data ke sath Chart insert karna hoga.

Month

Region

Sales (PKR)

Target Met?

January

North

450,000

Yes

February

South

320,000

No

March

East

510,000

Yes

April

West

290,000

No

·        Portfolio Tip: Is data ko select karke Insert > Recommended Charts par jayein aur aik 'Column Chart' banayein. Chart ka title "Monthly Sales Performance" rakhein.

2. Automated Salary/Payroll Sheet

Is mein formulas ka asil khel hai jo aapki logic dikhayega.

Employee Name

Basic Pay

HRA (10%)

Medical (5%)

Gross Salary

Tax (2%)

Net Salary

Ahmed Ali

50,000

=B2*10%

=B2*5%

=SUM(B2:D2)

=E2*2%

=E2-F2

Sana Khan

65,000

Auto

Auto

Auto

Auto

Auto

·        Kyun: Jab aap Basic Pay badlein gay, to baaki saari calculations khud badal jayengi, jo client ko impress karegi.

3. Inventory Management (Conditional Formatting)

Is sheet mein hum "Red Color" alert set karenge.

Item Name

Opening Stock

Sold

Available Stock

Status

Wireless Mouse

50

48

2

Low Stock

USB Cable

100

20

80

In Stock

Keyboard

30

30

0

Out of Stock

·        Portfolio Tip: 'Available Stock' wale column ko select karein. Conditional Formatting > Highlight Cells Rules > Less Than par jayein aur '5' likh kar 'Red Fill' select karein.

4. Data Cleaning (Before & After)

Portfolio mein do chote tables barabar mein banayein.

Table A (Messy Data):

·        ali khan (Faltu spaces)

·        923001234567 (Mix format)

·        lahore (Small letters)

Table B (Clean Data):

·        Ali Khan (Proper casing aur no spaces)

·        +92 300 1234567 (Formatted number)

·        Lahore (Capitalized)

·        Kyun: Ye dikhata hai ke aap mushkil data ko "Clean" aur "Useable" bana sakte hain.

5. PDF to Excel Project

Is mein screenshot aisi lagayein ke ek taraf PDF ho aur dusri taraf Excel.

Date

Description

Ref No.

Debit

Credit

Balance

01-May

Online Transfer

99821

-

15,000

45,000

05-May

ATM Withdrawal

44210

5,000

-

40,000

·        Kyun: Fiverr par clients ko bank statements Excel mein chahiye hoti hain. Ye project aapki accuracy sabit karta hai.

Portfolio Banane Ka Tariqa:

1.     In tamam sheets ko Excel mein banayein.

2.     Excel ki Gridlines hide kar dein (View > Uncheck Gridlines).

3.     Inka saaf screenshot lein.

4.     Aik PDF ya Image banayein jis ka title ho "MS Excel Professional Portfolio - [Your Institute Name]". 


Portfolio ko Attractive Banane ki Tips:

  • Screenshots: Apni Excel sheets ke saaf suthre screenshots le kar portfolio mein lagayein.

  • Brief Description: Har project ke sath 2 line likhein ke "Is sheet mein maine automated formulas use kiye hain taake waqt bach sakay."

  • No Gridlines: Portfolio ke liye screenshot lete waqt Excel ki gridlines (khane) 'View' menu se hide kar dein, is se sheet software ki tarah lagti hai.


Convert EXCEL to PDF

https://www.ilovepdf.com/excel_to_pdf


Convert each PDF page into a JPG

https://www.ilovepdf.com/pdf_to_jpg