Google Sheets skills
employers test in 2027

Google Sheets is the shared workspace of many Indian startups, agencies and marketing teams: order trackers, hiring pipelines, campaign reports, inventory lists and early dashboards often live there before any BI tool arrives. Because so many people edit the same files, employers value Sheets skill that combines formulas with collaboration discipline.

Sheets-heavy roles cluster in operations, sales ops, marketing and coordination. On AmbitionBox in October 2026, operations analysts in India typically earned ₹5.4–5.9 lakh and MIS analysts ₹4.2–4.7 lakh;⁵⁶ adding SQL and dashboard skills is what moves people into higher-paid analyst roles.

Typical operations analyst pay in India (AmbitionBox, Oct 2026)

₹5.4–5.9 lakh

Growth in operations analyst pay over two years (AmbitionBox)

11%

ARRAYFORMULA can replace thousands of copied formulas

1 formula

The Sheets function that brings SQL thinking to spreadsheets

QUERY

Table: Google Sheets use by role (editorial summary)

"Summarise orders by city and status with QUERY."

=QUERY(Orders!A:F, "select C, D, count(A) where C is not null group by C, D label count(A) 'Orders'", 1). Explain the header argument and why mixed types in a column cause blanks.

"Make a formula apply to every new row automatically."

Wrap it in ARRAYFORMULA with an IF to leave blank rows empty, placed once in the header row.

"Build a central report from five regional sheets."

IMPORTRANGE each region (granting access once), stack with {range1; range2} or QUERY across them, then summarise.

"Stop people typing statuses in different ways."

Data validation dropdown from a list on a settings tab; conditional formatting by status.

"Some people keep deleting formulas."

Protect the formula columns and give edit rights only to input columns; use comments and notes for guidance.

"Find each lead's owner from the team sheet."

XLOOKUP on lead ID (or VLOOKUP with exact match), with a fallback for missing IDs.

"Send a weekly summary automatically."

A simple Apps Script with a time-driven trigger, or an add-on — and note the permissions it needs.

"Excel or Sheets for this task?"

Sheets for collaboration and lighter data; Excel for large datasets, heavy modelling and Power Query.

Table: How spreadsheet work in startups has changed (editorial summary)

• A shared tracker — validation, protected ranges and a live QUERY summary tab.
• A central report built with IMPORTRANGE from two or three source files.
• One automation — a scheduled email or cleanup script.
• A verified Sheets test score to link.

"Google Sheets — QUERY, ARRAYFORMULA, IMPORTRANGE, data validation, protected ranges, Apps Script basics." With outcomes: "Rebuilt the order tracker used by 6 teams with validation and protection; weekly breakages stopped and reporting became live."

AI features in Sheets can suggest formulas and summarise tables, but only well when the sheet is structured: one header row, one data type per column, no merged cells. That makes structure the core skill. The World Economic Forum's 2025 report puts technological literacy among the fastest-growing skills,⁷ and for operations roles it often starts in a well-built spreadsheet.

1. Week 1: Formulas — Lookups, IFs, COUNTIFS/SUMIFS, FILTER, UNIQUE.
2. Week 2: QUERY and ARRAYFORMULA — Ten QUERY summaries; convert copied formulas to arrays.
3. Week 3: Collaboration — Build a protected, validated tracker and a multi-file report with IMPORTRANGE.
4. Week 4: Prove it — Take the Google Sheets for Professionals Certification, then add one Apps Script automation.

Next: SQL Fundamentals to work with bigger data, Excel Fundamentals for Excel-first employers and Data Visualization to present results.

Task: "Summarise orders by city and status, newest data always included."

=QUERY(Orders!A1:F, "select C, D, count(A), sum(F)
                     where C is not null and B >= date '2026-10-01'
                     group by C, D
                     order by count(A) desc
                     label count(A) 'Orders', sum(F) 'Value'", 1)

Column C is city, D is status, A is order ID, B is order date and F is value. Using the open-ended range A1:F means new rows are included automatically. The date 'yyyy-mm-dd' format is required for date comparisons in QUERY, and the final 1 tells Sheets there is one header row. If a city shows blank counts, check for mixed types in that column — QUERY treats the majority type as the column's type.

1. Break-proof tracker — Build a ten-column order or hiring tracker with dropdowns, protected formula columns and conditional formatting; ask a friend to try to break it.
2. QUERY drills — Answer ten questions of one dataset using only QUERY, including dates and GROUP BY.
3. Central report — Create three "regional" files and combine them with IMPORTRANGE into one live summary.
4. Array conversion — Replace a copied-down formula column with a single ARRAYFORMULA that handles blank rows.
5. First automation — Write a small Apps Script that emails a summary every Monday.

Sheets is strongest in startups and fast-moving teams, and it leads naturally into analyst roles as you add SQL. Typical pay on AmbitionBox, October 2026:

Table: Roles that use Google Sheets and their typical pay in India (AmbitionBox, October 2026; indicative)

• Formatting instead of structuring.
• Copying formulas down instead of using arrays.
• No protection in a shared file.
• Mixed types breaking QUERY.
• Over-sharing sensitive data.

Function references are Google Docs Editors Help (QUERY, IMPORTRANGE, ARRAYFORMULA) and Google's Apps Script documentation. Pay figures come from AmbitionBox's operations analyst and MIS analyst pages (read October 2026). Market context comes from the World Economic Forum. Test formats and the history table are editorial summaries. Science of Apps publishes the free certification linked here; it is not affiliated with Google. Last reviewed October 2026.

• QUERY — a Sheets function that runs SQL-like statements on a range.
• ARRAYFORMULA — applies one formula to a whole range at once.
• IMPORTRANGE — imports a range from another Sheets file.
• Data validation — rules that limit what can be entered in a cell, such as a dropdown list.
• Protected range — cells only certain people can edit.
• Apps Script — Google's JavaScript-based automation platform for Workspace.