Stop 02 · Excel & SpreadsheetsTopics · 8/10

Google Sheets Essentials

Part of the Data Analyst Roadmap

In short

Most Excel skills transfer directly, but Sheets adds real-time collaboration, easy sharing, and native integrations (Forms, Apps Script) that make it the default in many startups.

How to learn this

  1. 1Recreate one of your Excel exercises in Google Sheets and note the differences.
  2. 2Learn the Sheets-specific functions: QUERY, IMPORTRANGE, and ARRAYFORMULA.
  3. 3Try a simple Google Apps Script automation (even just recording macros conceptually).

More topics at this stop

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — on the InsideEdge app.

Download
InsideEdge