Introduction to Google Sheets: basics and first steps

These materials are for those starting with Google Sheets. A computer, a browser, and basic user skills are sufficient.

Introduction to Google Sheets: who it suits and who it does not

Who it suits

• Office staff needing basic spreadsheets for daily tasks.
• Students and learners using a spreadsheet editor for projects.
• Entrepreneurs and managers keeping records in cloud Spreadsheet tools.
• Junior analysts preparing data and simple calculations.

Who it does not suit

• Those seeking advanced topics: macros, Apps Script, or BI platforms.
• Users who strictly require local files without cloud services.
• Those looking for a statistics or programming course instead of Google Sheets fundamentals.

Problem → outcome in Google Sheets

Typical challenges

• Unstructured, messy data.
• Manual calculations and formula errors.
• Difficulty with sorting, filtering, and formatting.
• Inconvenient collaboration and version control.

What changes after covering the Google Sheets basics

• Structured sheets, ranges, and data types.
• Core formulas and functions: SUM, AVERAGE, COUNT, MIN/MAX.
• Sorting, filters, and conditional formatting for clarity.
• Shared access, comments, version history, and range protection.

Comparison with alternatives: Google Sheets vs other spreadsheet editors

Google Sheets (online spreadsheet editor)

• Runs in a browser, no installation required.
• Real-time co-editing and commenting.
• Autosave and change history.

Excel / LibreOffice Calc (desktop editors)

• Full offline mode without internet connection.
• Extended local capabilities, including VBA/macros.
• Dependent on software installation and updates.

Outcomes from working through the Google Sheets materials

Skills and actions

• Creating, formatting, and validating data in spreadsheets.
• Using basic formulas and relative/absolute references.
• Sorting, filtering, and conditional formatting for analysis.
• Configuring shared access, comments, and range protection.