Google Sheets Crash Course

Learn Google Sheets step by step and build the practical spreadsheet skills that actually matter in real work, study, and everyday life. This beginner‑friendly Google Sheets course takes you from opening your first spreadsheet to designing clean dashboards, using formulas, charts, and pivot tables with confidence.​

Master the Google Sheets essentials

• Learn how to open Google Sheets, create new spreadsheets, use templates, and organise your files in Google Drive so you always know where your data lives.​

• Navigate the Google Sheets interface confidently, including the menu bar, toolbar icons, sheet tabs, zoom, and help features.​

• Work efficiently with cells and ranges: select ranges, move around quickly, use context menus, and manage multiple sheet tabs within a workbook.​

• Adjust rows and columns like a pro by resizing, auto‑fitting, inserting, deleting, moving, hiding, and unhiding them to keep your layouts clear.​

Clean, structured data entry

• Enter and edit text, numbers, dates, and times correctly so Google Sheets recognises them and your formulas calculate properly.​

• Understand how dates and times are stored as numbers, use TODAY and NOW, add or subtract days, and calculate the number of days between two dates.​

• Use custom date and time formats to match regional preferences or reporting standards without breaking the underlying data.​

Professional formatting and layout

• Apply essential cell formatting: fonts, sizes, colours, borders, alignment, text wrapping, and merged cells to make reports easy to read.​

• Use conditional formatting to highlight key values, trends, thresholds, and issues automatically.​

• Copy formatting quickly with Paint Format and clear messy formatting when you want a fresh start.​

Data validation, accuracy, and protection

• Set up data validation rules with dropdown lists, number ranges, and allowed date windows to prevent incorrect entries and keep data consistent.​

• Choose between soft warnings and hard rejections so collaborators are guided, not frustrated.​

• Protect ranges and entire sheets while leaving input cells editable, and understand how these protections interact with sharing permissions.​

Smart tools for speed

• Use Smart Fill to recognise patterns and automatically clean or split data, such as names, codes, or phone numbers.​

• Split text into columns, recombine values from multiple columns, and use auto‑complete to reduce typing.​

• Master Autofill to quickly extend series of months, days, numbers, dates, and formulas across large ranges.​

Formulas and functions, made simple

• Build simple formulas for addition, subtraction, multiplication, division, and percentages with confidence.​

• Apply the correct order of operations (BODMAS), so complex formulas produce the answers you expect.​

• Understand relative and absolute references, and when to use $A$1 style references so formulas copy correctly.​

• Diagnose and fix common formula errors like DIV0!, REF!, VALUE!, and NAME? instead of getting stuck.​

Essential Google Sheets functions

• Use the most useful math functions such as SUM, AVERAGE, MIN, MAX, and ROUND in real‑world scenarios.​

• Apply logical functions like IF, AND, OR, and IFERROR to build smarter, more robust formulas.​

• Clean data with text functions such as LEFT, RIGHT, MID, LEN, TRIM, LOWER, UPPER, and CONCAT/CONCATENATE.​

• Work with date functions including TODAY, NOW, DATE, DAYS, and DATEDIF to drive schedules, timelines, and reports.​

• Combine functions for powerful solutions, such as threshold checks with summaries, cleaning full names, and flagging recent activity.​

Lookups, named ranges, and tables

• Turn raw ranges into structured tables using sorting, filtering, and named ranges.​

• Sort by one or multiple columns and filter by condition or by values to quickly answer specific questions from your data.​

• Create and manage named ranges so formulas stay readable and easier to maintain.​

• Perform powerful lookups using VLOOKUP and HLOOKUP, and understand their key limitations and best practices.​

• Upgrade to INDEX+MATCH for more flexible, robust lookups that do not break when columns move.​

• Use ARRAYFORMULA to apply formulas across entire ranges and wrap them with IFERROR for cleaner, user‑friendly outputs.​

Charts, pivot tables, and dashboards

• Insert and configure charts in Google Sheets, from basic column and bar charts to line and pie charts.​

• Choose appropriate chart types, set data ranges and series, add titles and axis labels, and customise colours and styles.​

• Understand how charts update automatically when your underlying data changes.​

• Build pivot tables from scratch to summarise sales, counts, averages, and other metrics by categories like region or rep.​

• Change value summaries, format pivot outputs, filter your pivot tables, add columns, and create charts directly from pivots.​

• Put everything together in a practical dashboard project:

  • Prepare a clean source sheet.

  • Build KPI cards (for example, average scores or totals).

  • Add charts showing status or category distributions.

  • Create a Home dashboard sheet with navigation links to supporting sheets.​

Sharing, collaboration, and printing

• Use Google Sheets version history, automatic saving, and sharing options to collaborate safely with teammates.​

• Share with specific people or via links, and choose viewer, commenter, or editor roles appropriately.​

• Configure page setup and printing: choose what to print, control orientation, margins, scaling, gridlines, headers, and repeating titles.​

• Export your spreadsheets as PDF, Excel (XLSX), or CSV so they are easy to share with people outside Google Workspace.​

Designed for real beginners and busy professionals

This course is designed as a Google Sheets crash course that gets you productive fast, focusing on the tools beginners actually use rather than advanced, rarely needed features. Every lesson is built around clear, real‑world tasks with a downloadable practice workbook, so you can always apply each new skill to actual spreadsheet data.​

By the end of the course, you will feel at home in Google Sheets, able to build and maintain reliable spreadsheets, use formulas and functions confidently, create charts and pivot tables, and design simple dashboards that make your data easy to understand.​