Udemy - Google Sheets Crash Course

Google Sheets Crash Course

https://WebToolTip.com

Published 1/2026
Created by Andrew Williams
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 36 Lectures ( 4h 29m ) | Size: 4.2 GB

Master Google Sheets for data entry, formulas, charts, dashboards, and real‑world business reporting.

What you'll learn
✓ Navigate the Google Sheets interface, menus, toolbars, tabs, and help, and move efficiently between cells, ranges, and multiple sheets.
✓ Structure sheets with clear rows, columns, and layouts by resizing, hiding, and reordering to keep data readable and professional.
✓ Enter text, numbers, dates, and times correctly and write basic formulas so calculations behave reliably instead of as plain text.
✓ Use data validation rules with dropdowns, numeric ranges, and date limits so collaborators enter clean, consistent data in your sheets.
✓ Treat dates and times as numbers, shift them with arithmetic, measure differences, and customise how they are displayed.
✓ Apply formatting like fonts, colors, borders, alignment, wrapping, merging, and conditional formatting to make reports clear.
✓ Use Smart Fill, auto‑complete, and autofill to split, combine, and extend data and formulas quickly and accurately. ​
✓ Build tables with sorting, filtering, and named ranges while avoiding common mistakes that hide or break important data.
✓ Create and debug formulas and functions, interpret common error codes, and apply BODMAS and cell references correctly.
✓ Use math, logical, text, and date functions and combine them into practical formulas for real‑world tasks.
✓ Perform lookups with VLOOKUP, HLOOKUP, INDEX+MATCH, and ARRAYFORMULA plus IFERROR for flexible, robust models.
✓ Summarise data with charts and pivot tables, choosing chart types, styling them, and configuring pivot rows, columns, and filters.
✓ Protect critical ranges and sheets, collaborate safely with sharing roles and version history, and control who can edit what. ​
✓ Configure printing and exports so Sheets printouts and PDFs are legible, scaled, and easy to share or open in Excel and CSV.
✓ Design a Google Sheets dashboard with KPI cards, status breakdowns, charts, and navigation driven by validated data.
✓ Choose between Google Sheets and Excel based on needs in collaboration, automation, file formats, and long‑term flexibility.

Requirements
● A Google account with access to Google Sheets in a web browser.
● A reliable internet connection so Sheets and the course workbook can load and save to the cloud.
● A computer or laptop with a modern browser (Chrome or similar) and basic keyboard/mouse use.
● No prior Google Sheets experience is required; the course starts from opening Sheets and basic navigation.