Pro Tip: Create a shortcut on your Desktop for your most-used folder. Right-click folder → Send to → Desktop (create shortcut).
Remember: Always use "Save As PDF" before sending any document. PDFs preserve your formatting on every device.
Write a formal application for the post of "Computer Operator" to any government office. Include: Your name & address · Date · Recipient details · Subject line · 3-paragraph body · Closing with signature. Apply Heading styles, 1-inch margins, justified text, and export as PDF.
| Formula | What it Does | Example | Result |
|---|---|---|---|
| =SUM(A1:A10) | Adds all values in a range | Total of 10 fees | Rs. 40,000 |
| =AVERAGE(B1:B10) | Calculates the mean value | Average marks of class | 72.5 |
| =COUNT(C1:C20) | Counts cells with numbers | Students who gave test | 18 |
| =IF(D1>=50,"Pass","Fail") | Checks condition, returns text | Pass/Fail by marks | Pass |
| =MAX(E1:E15) | Returns the highest value | Top scorer in class | 98 |
| =MIN(E1:E15) | Returns the lowest value | Lowest score | 41 |
| =VLOOKUP(A1,B:D,2,0) | Looks up value in a table | Find student fee by ID | Rs. 4,000 |
| =CONCATENATE(A1," ",B1) | Joins text from two cells | First + Last name | Ali Ahmed |
| =TODAY() | Returns today's date | Auto-fill today's date | 17-Apr-2025 |
| =COUNTIF(A:A,"Pass") | Counts cells matching criteria | How many students passed | 14 |
Job Tip: In government job computer tests, Excel formula questions are most common. Practice SUM, IF, VLOOKUP, and AVERAGE daily.
CMYK = Print (Cyan, Magenta, Yellow, Black) | RGB = Screen (Red, Green, Blue). Always check mode before starting a project!
When to use which tool: Client wants a logo? → Illustrator. Client wants photo editing or Instagram post? → Photoshop. Client wants a 10-page brochure? → InDesign. Quick social media content in 10 min? → Canva.
Never do this: Don't use clip art, stock icons, or copy another logo. Don't use more than 3 colors. Don't use Papyrus or Comic Sans fonts. Don't add drop shadows to logos.
| Service | Beginner Rate | Mid-Level Rate | Advanced Rate | Platform |
|---|---|---|---|---|
| Simple Logo | $5–$15 | $25–$50 | $75–$200+ | Fiverr |
| Brand Identity Kit | $20–$40 | $75–$150 | $200–$500 | Fiverr/Upwork |
| Social Media Post | $3–$8 | $10–$25 | $30–$60 | Fiverr |
| Monthly SM Package (30 posts) | $50–$80 | $100–$200 | $250–$500 | Direct/Upwork |
| Brochure / Flyer | $10–$20 | $30–$60 | $80–$150 | Fiverr/Upwork |
| Business Card | $5–$10 | $15–$30 | $40–$80 | Fiverr |
Getting Paid: Fiverr pays via Payoneer (linked to JazzCash/Easypaisa/Bank). Upwork via Payoneer or direct bank transfer. Setup Payoneer account before your first order.
Growth Target: Month 1–2: Get 5 reviews. Month 3: Raise prices 30%. Month 6: Apply for Level 1 Seller badge. Month 12: Rs. 50,000–100,000/month target.
AI in Design: Use Midjourney/Adobe Firefly for inspiration and mockup backgrounds. Use ChatGPT to write gig descriptions. AI speeds you up — it does not replace your skills.
Golden Rule of Freelancing: Under-promise and over-deliver. If you can finish in 2 days, tell the client 4 days. Delivering early surprises them positively. Delivering late damages your reputation permanently. Your reputation is your most valuable asset.
| Item | Size (mm) | Size (inches) |
|---|---|---|
| Business Card | 90 × 54 mm | 3.5 × 2" |
| A4 Flyer / Letterhead | 210 × 297 mm | 8.27 × 11.7" |
| A5 Flyer / Brochure | 148 × 210 mm | 5.83 × 8.27" |
| A3 Poster | 297 × 420 mm | 11.7 × 16.5" |
| Banner (Standard) | 3ft × 6ft | 36" × 72" |
| Billboard | 8ft × 4ft | 96" × 48" |
| Wedding Card | 5" × 7" | 127 × 178 mm |
| Envelope (C5) | 162 × 229 mm | 6.4 × 9" |
| Platform | Post | Story/Reel |
|---|---|---|
| 1200 × 630 px | 1080 × 1920 px | |
| 1080 × 1080 px | 1080 × 1920 px | |
| YouTube Thumbnail | 1280 × 720 px | — |
| TikTok Video | 1080 × 1920 px | — |
| LinkedIn Post | 1200 × 628 px | — |
| Twitter/X | 1600 × 900 px | — |
| WhatsApp DP | 500 × 500 px | — |
| Weight (GSM) | Best Used For |
|---|---|
| 70–80 GSM | Letterhead, copy paper, handouts |
| 100–130 GSM | Brochures, flyers, catalogues |
| 250–350 GSM | Business cards, postcards, covers |
| 400+ GSM | Premium invitations, thick cards |