|
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. |
|
udp://tracker.torrent.eu.org:451/announce udp://tracker.tiny-vps.com:6969/announce http://tracker.foreverpirates.co:80/announce udp://tracker.cyberia.is:6969/announce udp://exodus.desync.com:6969/announce udp://explodie.org:6969/announce udp://tracker.opentrackr.org:1337/announce udp://9.rarbg.to:2780/announce udp://tracker.internetwarriors.net:1337/announce udp://ipv4.tracker.harry.lu:80/announce udp://open.stealth.si:80/announce udp://9.rarbg.to:2900/announce udp://9.rarbg.me:2720/announce udp://opentor.org:2710/announce |
