- Data Entry & Management: Student records, employee attendance, ya products ki list banana.
- Automatic Calculations: Formulas (jaise
SUM,AVERAGE) use karke hazaron numbers ko seconds mein calculate karna. - Financial Accounting: Office budget, monthly expenses, profit/loss statement aur billing system tayyar karna.
- Data Visualization: Charts, Graphs aur Pivot Tables ke zariye data ko khoobsurat visual reports mein badalna.
- Sorting & Filtering: Hazaron rows mein se kisi specific student ya product ka record ek click par dhoondna.
| A | B | C | D | E |
| STUDENT INFORMATION DIRECTORY (Merge A1:E1, Bold, Center) | ||||
| Roll No | Student Name | Course Name | Contact No | City |
| 101 | Ali Khan | MS Office | 0300-1234567 | Karachi |
| 102 | Sara Ahmed | Graphic Design | 0300-2345678 | Lahore |
| 103 | Usman Tariq | Web Development | 0300-3456789 | Islamabad |
| 104 | Ayesha Malik | Digital Marketing | 0300-4567890 | Karachi |
- Class Task:
- Header ko Merge & Center karein aur background color fill karein.
- Data cells ki Alignment ko center karein.
| A | B | C | D | E | F |
| S.No | Employee Name | Day 1 (Mon) | Day 2 (Tue) | Day 3 (Wed) | Day 4 (Thu) |
| 1 | Ahmed Raza | Present | Present | Absent | Present |
| 2 | Fatima Bibi | Present | Present | Present | Leave |
| 3 | Bilal Sheikh | Absent | Present | Present | Present |
- Class Task:
- Column A (S.No) mein
1, 2likh kar neeche tak Auto-fill Drag karwayein. - Headers (Days/Months) par Auto-fill feature test karwayein.
- Text Orientation check karne ke liye header text ko thoda Rotate karwayein.
| A | B | C | D | E |
| Item ID | Item Description | Quantity | Unit Price (PKR) | Status |
| ITM-001 | Wireless Mouse | 15 | 1,500.00 | In Stock |
| ITM-002 | USB Keyboard | 20 | 2,200.00 | In Stock |
| ITM-003 | HD Monitor 22" | 8 | 18,500.00 | Low Stock |
| ITM-004 | USB Flash Drive 32GB | 50 | 1,100.00 | In Stock |
- Class Task:
- Unit Price column ko Number Format se Currency / Accounting (PKR ya Rs) set karein.
- Inventory columns ki width adjust karein taake koi text cut na ho.
| Time / Day | Monday | Tuesday | Wednesday | Thursday |
| 09:00 AM - 10:00 AM | MS Excel | MS Word | MS Excel | MS Word |
| 10:00 AM - 11:00 AM | Graphic Design | Graphic Design | Graphic Design | Graphic Design |
| 11:00 AM - 11:30 AM | TEA BREAK (Merge B4:E4, Center) | |||
| 11:30 AM - 12:30 PM | InPage Typing | InPage Typing | InPage Typing | InPage Typing |
- Class Task:
- Tea Break row ko Merge & Center karein.
- Cell content ko Drag & Drop (Mouse se move) karke doosre cell mein shift karna seekhein.
- 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:
- Inventory Tracker:
Multiplication aur Addition formulas ki practice ke liye.
- Data Correction:
Spaces khatam karne aur formatting theek karne ki activity.
- 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:
- Total Value ka formula lagayein (Quantity x Price).
- 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:
- Headings ko Bold karein
aur Background Color dain.
- Currency format (PKR) lagayein.
- 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:
- Data Cleaning:
Kya aap duplicate data nikal sakte hain?
- Basic Formulas: Kya aapko SUM, AVERAGE, aur IF functions ka pata hai?
- 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 |
|
|
|
|
|
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