InsideEdgeInsideEdge
Download App

Phase 2 · Excel & Spreadsheets

Topics

Google Sheets Essentials

Part of the Data Analyst Roadmap.

Summary

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

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

Previous

Power Query

Next

Data Validation in Spreadsheets

More topics in Excel & Spreadsheets

Excel FundamentalsFormulas & Functions (VLOOKUP, INDEX-MATCH, XLOOKUP)PivotTables & PivotChartsConditional FormattingData Cleaning in ExcelExcel Charts & DashboardsPower QueryData Validation in SpreadsheetsExcel Shortcuts & Productivity
InsideEdge

Stuck on this topic? Ask an Insider

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

Download
InsideEdge