Udemy - Google Sheets Crash Course
- Category Other
- Type Tutorials
- Language English
- Total size 4.2 GB
- Uploaded By freecoursewb
- Downloads 28
- Last checked 2 hours ago
- Date uploaded 4 hours ago
- Seeders 2
- Leechers 9
Infohash : B9A7EA71C9F18DC8E29E9BF130EF5A1BD141F7BD
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.
Files:
[ WebToolTip.com ] Udemy - Google Sheets Crash Course- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - Introduction
- 1. Introduction Course Overview (Description).html (0.9 KB)
- 1. Introduction Course Overview.mp4 (88.3 MB)
- 2. Google Sheets vs Excel (Description).html (0.9 KB)
- 2. Google Sheets vs Excel.mp4 (63.4 MB)
- 3. Download the Course Workbook (Description).html (0.8 KB)
- 3. Download the Course Workbook.html (6.0 KB)
- 4. Course Lecture List (Description).html (0.7 KB)
- 4. Course Lecture List.html (10.6 KB)
- 4. Course-Outline.pdf (106.4 KB)
- Google Sheets Crash Course MASTER WORKBOOK.xlsx (116.5 KB)
- 31. Protecting Sheets (Description).html (0.8 KB)
- 31. Protecting Sheets.mp4 (112.7 MB)
- 32. Printing Setup (Description).html (0.8 KB)
- 32. Printing Setup.mp4 (148.8 MB)
- 33. Preparing Project Data (Description).html (0.8 KB)
- 33. Preparing Project Data.mp4 (53.8 MB)
- 34. Dashboard Layout (Description).html (0.8 KB)
- 34. Dashboard Layout.mp4 (280.6 MB)
- 35. Wrap Up and Next Steps (Description).html (0.9 KB)
- 35. Wrap Up and Next Steps.html (8.4 KB)
- 36. Bonus (Description).html (0.6 KB)
- 36. Bonus.html (5.8 KB)
- 5. Sheets Interface Basics (Description).html (0.8 KB)
- 5. Sheets Interface Basics.mp4 (100.1 MB)
- 6. Navigation and View Controls (Description).html (0.9 KB)
- 6. Navigation and View Controls.mp4 (220.4 MB)
- 7. Rows Columns and Layout (Description).html (0.9 KB)
- 7. Rows Columns and Layout.mp4 (143.2 MB)
- 10. Dates and Times (Description).html (0.8 KB)
- 10. Dates and Times.mp4 (114.0 MB)
- 8. Data Types and Entry (Description).html (0.8 KB)
- 8. Data Types and Entry.mp4 (107.7 MB)
- 9. Data Validation Rules (Description).html (0.8 KB)
- 9. Data Validation Rules.mp4 (165.2 MB)
- 11. Core Formatting Tools (Description).html (0.9 KB)
- 11. Core Formatting Tools.mp4 (231.8 MB)
- 12. Wrapping Merging (Description).html (0.7 KB)
- 12. Wrapping Merging.mp4 (153.7 MB)
- 13. Smart Fill and Helpers (Description).html (0.9 KB)
- 13. Smart Fill and Helpers.mp4 (188.0 MB)
- 14. Autofill and Series (Description).html (0.8 KB)
- 14. Autofill and Series.mp4 (82.2 MB)
- 15. Sorting and Filtering (Description).html (0.8 KB)
- 15. Sorting and Filtering.mp4 (263.0 MB)
- 16. Named Ranges (Description).html (0.8 KB)
- 16. Named Ranges.mp4 (76.1 MB)
- 17. Simple Formulas and Errors (Description).html (0.9 KB)
- 17. Simple Formulas and Errors.mp4 (63.5 MB)
- 18. Order of Operations (Description).html (0.8 KB)
- 18. Order of Operations.mp4 (33.6 MB)
- 19. Absolute v Relative References (Description).html (0.7 KB)
- 19. Absolute v Relative References.mp4 (132.1 MB)
- 20. Inserting Editing Deleting Functions (Description).html (0.9 KB)
- 20. Inserting Editing Deleting Functions.mp4 (91.5 MB)
- 21. Math Functions (Description).html (0.8 KB)
- 21. Math Functions.mp4 (105.9 MB)
- 22. Logical Functions (Description).html (0.8 KB)
- 22. Logical Functions.mp4 (235.2 MB)
- 23. Text and Date Functions (Description).html (0.9 KB)
- 23. Text and Date Functions.mp4 (179.0 MB)
- 24. Lookup Basics (Description).html (0.8 KB)
- 24. Lookup Basics.mp4 (226.1 MB)
- 25. INDEX and MATCH (Description).html (0.8 KB)
- 25. INDEX and MATCH.mp4 (98.0 MB)
- 26. ARRAYFORMULA (Description).html (0.7 KB)
- 26. ARRAYFORMULA.mp4 (71.7 MB)
- 27. Charts from Data (Description).html (0.8 KB)
- 27. Charts from Data.mp4 (106.0 MB)
- 28. Chart Customisation (Description).html (0.8 KB)
- 28. Chart Customisation.mp4 (142.8 MB)
- 29. Pivot Table Basics (Description).html (0.8 KB)
- 29. Pivot Table Basics.mp4 (49.8 MB)
- 30. Pivot Table Analysis (Description).html (0.8 KB)
- 30. Pivot Table Analysis.mp4 (142.3 MB)
- Bonus Resources.txt (0.1 KB)
There are currently no comments. Feel free to leave one :)
Code:
- 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