Excel vs Playwright — What to Learn First

# Excel — essential formulas for beginners

SUM(A1:A10)                        # Add a range
AVERAGE(A1:A10)                    # Average
COUNTIF(B1:B100, "Delhi")          # Count matching cells
SUMIF(B1:B100, "Delhi", C1:C100)   # Sum matching rows
VLOOKUP(D2, A2:B100, 2, FALSE)     # Lookup value
IF(C2 > 1000, "High", "Low")       # Conditional
Pivot Table                        # Group & summarise
Chart                              # Visualise data

# No programming required — click, drag, done.

Why Excel is popular:
- Used by 750M+ people worldwide
- Zero setup — works on any computer
- Easy to learn (hours, not weeks)
- Powerful for data analysis
- Universally accepted in business
- Bridges non-technical and technical teams
- Foundation for data analyst roles

It's the "gateway tool" for data careers.

# Playwright — Python example
# Log in to a site and check the dashboard loaded.

from playwright.sync_api import sync_playwright

with sync_playwright() as p:
    browser = p.chromium.launch(headless=False)
    page = browser.new_page()
    page.goto("https://example.com/login")

    page.fill("#username", "demo_user")
    page.fill("#password", "demo_pass")
    page.click("button[type=submit]")

    page.wait_for_selector(".dashboard")
    assert "Welcome" in page.text_content(".dashboard")

    browser.close()

Why Playwright is popular:
- Maintained by Microsoft
- Cross-browser (Chrome, Firefox, WebKit)
- Fast, modern API
- Auto-waits — less flaky than Selenium
- Great for E2E testing
- Strong for scraping JS-heavy sites
- Works with pytest, Jest, etc.

Note: Playwright is a *coding* tool —
not a first tool for absolute beginners.

Before Excel:
□ None — open it and start
□ Basic typing / mouse skills
□ (Optional) spreadsheet shortcuts

Before Playwright:
□ Python or JavaScript fundamentals
□ HTML + CSS basics
□ Async patterns (async/await)
□ Browser dev tools
□ Command line basics
□ (Recommended) pytest or Jest

Time to learn (realistic estimates):

Excel:
- Basics: 1–2 weeks
- Comfortable with formulas: 3–4 weeks
- Advanced (pivots, charts): 2 months

Playwright:
- Setup + first script: 2–3 weeks
  (if you already know Python/JS)
- Job-ready test suite: 2–3 months
- From absolute zero (learn Python first): 4–6 months

Rule of thumb:
Excel is the easiest starting point.
Playwright requires a language first.

Excel career paths:
□ Data Analyst
□ Business Analyst
□ Financial Analyst
□ Operations Analyst
□ MIS Executive
□ Marketing / HR Analyst
□ Excel → SQL → Python → Analytics

Playwright career paths:
□ QA Automation Engineer
□ SDET (Software Development Engineer in Test)
□ Test Automation Engineer
□ Web Scraping Developer
□ RPA Developer
□ Playwright → Cypress → Selenium (knowledge)
□ Automation → DevOps / QA Lead

Salary ranges in India (2026):

Excel / Data Analyst:
- Fresher:    ₹3–5 LPA
- Mid:        ₹5–10 LPA
- Senior:     ₹10–18+ LPA

QA Automation (Playwright):
- Fresher:    ₹4–6 LPA
- Mid:        ₹7–14 LPA
- Senior:     ₹14–25+ LPA

Note: Both paths pay well. Automation
testing typically pays higher at senior
levels because it requires coding + testing
+ CI/CD skills.

Skills tracker:

Excel:
□ Formulas (SUM, VLOOKUP, IF)
□ Pivot tables
□ Charts & dashboards
□ Data cleaning
□ (Optional) Power Query / VBA

Playwright:
□ Python or JS
□ HTML selectors
□ Playwright basics (page, locators)
□ Assertions + waits
□ pytest / Jest
□ CI integration (GitHub Actions)
□ Cross-browser testing

Best path for analytics:
□ Excel → SQL → Python → Dashboards

Best path for automation:
□ Python/JS → Playwright → CI/CD → SDET