My Skill Lab
Data ScienceBeginner

Google Sheets for Analysts

Formulas, QUERY, pivots, Apps Script and live dashboards.

Taught by Niraj Thapa · Analytics Lead

What you'll learn

  • Structure a spreadsheet with a paste-only raw tab, named ranges, filter views and correct data types
  • Write XLOOKUP, SUMIFS, IFS, REGEXEXTRACT and ARRAYFORMULA formulas that survive new data
  • Use the QUERY function to filter, group, pivot and sort data with SQL-style statements driven by input cells
  • Combine spreadsheets and external sources with IMPORTRANGE, IMPORTDATA and GOOGLEFINANCE
  • Build pivot tables, slicers and charts that match the question being asked
  • Automate cleaning and weekly email reports with Apps Script, then share and protect a live dashboard

About this course

Google Sheets is the default analytics tool in startups and small businesses, and used well it does far more than sums. This beginner course takes you from a tidy data layout to a live dashboard that refreshes itself. You will master the formulas analysts use daily, including XLOOKUP, SUMIFS, ARRAYFORMULA and the QUERY function that lets you write SQL-style queries against any range. You will pull data together with IMPORTRANGE, build pivot tables and charts that answer real questions, and automate repetitive work with Google Apps Script, including scheduled email reports. The final lessons cover sharing, protected ranges, version history and connecting Sheets to Looker Studio. It suits marketers, operations staff, founders, finance assistants and new analysts who need dependable reporting without a data team. No prior formula knowledge is required; if you can enter data in a spreadsheet, you can start. You finish with a working sales dashboard template you can adapt to your own business.

Course content

7 lessons
  1. 1Sheets as an Analyst's WorkbenchLay data out as a proper table, navigate fast, and set up filter views and named ranges before writing a single formula.Preview
  2. 2Core Formulas: Lookups, Conditionals and ArraysXLOOKUP, SUMIFS and COUNTIFS, IFS, text functions and ARRAYFORMULA: the formulas that cover most analyst work.
  3. 3QUERY: SQL Inside Your SpreadsheetFilter, group, sort and pivot any range with the QUERY function's SQL-like language.
  4. 4Bringing Data Together: IMPORTRANGE and Live ImportsPull ranges from other spreadsheets, import CSV and finance data, and understand the limits before a slow sheet surprises you.
  5. 5Pivot Tables and Charts That Answer QuestionsBuild pivots with date grouping and calculated fields, add slicers, and pick the chart that fits the question.
  6. 6Automating With Google Apps ScriptWrite JavaScript that adds menus, custom functions and scheduled jobs such as a weekly emailed report.
  7. 7Live Dashboards, Sharing and GovernanceAssemble a one-screen dashboard, control who can see and change what, and connect Sheets to Looker Studio.