Excel / Google Sheets

Excel dominates: financial modeling, heavy VBA automation, offline work, legacy enterprise systems. Google Sheets wins: real-time collaboration, web accessibility, free tier, API integrations (Zapier, IFTTT). If your team is remote, Sheets. If you're building a financial model in banking, Excel. In 2026, many orgs use both, Sheets for ops/marketing dashboards, Excel for accounting/modeling.

Learn formulas (VLOOKUP→XLOOKUP, INDEX-MATCH for complex lookups). Use Power Query (Excel) or Query function (Sheets) to pull data automatically. Set up pivot tables instead of manual summaries. Add a macro or Apps Script to loop over rows instead of copy-pasting. Example: 3 rows of macro code replaces 200 copy-pastes. Time cost: 30 min to write, savings: 5+ hours/week.

Google Apps Script first. JavaScript syntax is cleaner, Google Sheets is web-native, and you can't crash a browser like you can crash Excel with a bad macro. VBA is more powerful but legacy (C-style syntax, harder to debug). Learn Apps Script for quick wins, then VBA if you work in finance/banking where Excel dominates.

IMPORTRANGE (other Sheets), IMPORTXML/IMPORTHTML (web scraping), Zapier (3rd-party APIs), Coupler.io (AWS/Stripe/Hubspot syncs). Excel: Power Query (load from web, SQL, CSV), or VBA with REST APIs. Apps Script lets you write custom API calls. Example: Coupler.io syncs Stripe data into Sheets every hour, no manual export, dashboard always fresh.

Google Sheets: pivot tables + charts + IMPORTRANGE for multi-sheet data. Excel: Power Pivot + Pivot Charts + scheduled PowerQuery refreshes. Add a macro/Apps Script to trigger imports hourly. Key: use formulas, never static values. If the source data changes, your dashboard updates instantly. Example: Sales dashboard with SUMIFS + pivot tables, updated via Sheets API on every Stripe webhook.

VLOOKUP: lookup in leftmost column, return right column. INDEX-MATCH: lookup anywhere, return any column. XLOOKUP (Excel 365) combines both + handles errors. Examples: VLOOKUP finds an email by name (slow if table is huge, breaks if columns reorder). INDEX-MATCH finds salary by employee ID across 5M rows in 100ms. Use INDEX-MATCH or XLOOKUP for production; VLOOKUP is entry-level.

AI (Copilot in Excel, Sheets AI) writes formulas from plain English + suggests pivots, but still requires a human to validate. Data cleanup, business logic, and error-handling still need humans. Spreadsheet skills = now a 'human-in-the-loop' job: you describe the analysis, AI writes the formula, you verify and ship. Companies hiring data analysts expect Excel + AI literacy in 2026.