| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ~Get Your Files Here ! | |||
| 1 - Introduction | |||
| 1. Introduction Course Overview (Description).html | 921.6 B | ||
| 1. Introduction Course Overview.mp4 | 88.3 MB | ||
| 10 - Protection Sharing and Printing | |||
| 11 - Dashboard Project | |||
| 12 - Closing and Next Steps | |||
| 2 - Interface Navigation and Layout | |||
| 3 - Data Types Entry and Validation | |||
| 10. Dates and Times (Description).html | 819.2 B | ||
| 10. Dates and Times.mp4 | 114 MB | ||
| 4 - Formatting and Intelligent Helpers | |||
| 11. Core Formatting Tools (Description).html | 921.6 B | ||
| 11. Core Formatting Tools.mp4 | 231.8 MB | ||
| 12. Wrapping Merging (Description).html | 716.8 B | ||
| 12. Wrapping Merging.mp4 | 153.7 MB | ||
| 13. Smart Fill and Helpers (Description).html | 921.6 B | ||
| 13. Smart Fill and Helpers.mp4 | 188 MB | ||
| 14. Autofill and Series (Description).html | 819.2 B | ||
| 14. Autofill and Series.mp4 | 82.2 MB | ||
| 5 - Tables Filters and Named Ranges | |||
| 15. Sorting and Filtering (Description).html | 819.2 B | ||
| 15. Sorting and Filtering.mp4 | 263 MB | ||
| 16. Named Ranges (Description).html | 819.2 B | ||
| 16. Named Ranges.mp4 | 76.1 MB | ||
| 6 - Formulas Functions and Errors | |||
| 17. Simple Formulas and Errors (Description).html | 921.6 B | ||
| 17. Simple Formulas and Errors.mp4 | 63.5 MB | ||
| 18. Order of Operations (Description).html | 819.2 B | ||
| 18. Order of Operations.mp4 | 33.6 MB | ||
| 19. Absolute v Relative References (Description).html | 716.8 B | ||
| 19. Absolute v Relative References.mp4 | 132.1 MB | ||
| 20. Inserting Editing Deleting Functions (Description).html | 921.6 B | ||
| 20. Inserting Editing Deleting Functions.mp4 | 91.5 MB | ||
| 7 - Essential Functions Toolkit | |||
| 21. Math Functions (Description).html | 819.2 B | ||
| 21. Math Functions.mp4 | 105.9 MB | ||
| 22. Logical Functions (Description).html | 819.2 B | ||
| 22. Logical Functions.mp4 | 235.2 MB | ||
| 23. Text and Date Functions (Description).html | 921.6 B | ||
| 23. Text and Date Functions.mp4 | 179 MB | ||
| 8 - Lookup Reference and Arrays | |||
| 24. Lookup Basics (Description).html | 819.2 B | ||
| 24. Lookup Basics.mp4 | 226.1 MB | ||
| 25. INDEX and MATCH (Description).html | 819.2 B | ||
| 25. INDEX and MATCH.mp4 | 98 MB | ||
| 26. ARRAYFORMULA (Description).html | 716.8 B | ||
| 26. ARRAYFORMULA.mp4 | 71.7 MB | ||
| 9 - Visualisation and Pivot Tables | |||
| 27. Charts from Data (Description).html | 819.2 B | ||
| 27. Charts from Data.mp4 | 106 MB | ||
| 28. Chart Customisation (Description).html | 819.2 B | ||
| 28. Chart Customisation.mp4 | 142.8 MB | ||
| 29. Pivot Table Basics (Description).html | 819.2 B | ||
| 29. Pivot Table Basics.mp4 | 49.8 MB | ||
| 30. Pivot Table Analysis (Description).html | 819.2 B | ||
| 30. Pivot Table Analysis.mp4 | 142.3 MB | ||
| 8. Data Types and Entry (Description).html | 819.2 B | ||
| 8. Data Types and Entry.mp4 | 107.7 MB | ||
| 9. Data Validation Rules (Description).html | 819.2 B | ||
| 9. Data Validation Rules.mp4 | 165.2 MB | ||
| 5. Sheets Interface Basics (Description).html | 819.2 B | ||
| 5. Sheets Interface Basics.mp4 | 100.1 MB | ||
| 6. Navigation and View Controls (Description).html | 921.6 B | ||
| 6. Navigation and View Controls.mp4 | 220.4 MB | ||
| 7. Rows Columns and Layout (Description).html | 921.6 B | ||
| 7. Rows Columns and Layout.mp4 | 143.2 MB | ||
| 35. Wrap Up and Next Steps (Description).html | 921.6 B | ||
| 35. Wrap Up and Next Steps.html | 8.4 KB | ||
| 36. Bonus (Description).html | 614.4 B | ||
| 36. Bonus.html | 5.8 KB | ||
| 33. Preparing Project Data (Description).html | 819.2 B | ||
| 33. Preparing Project Data.mp4 | 53.8 MB | ||
| 34. Dashboard Layout (Description).html | 819.2 B | ||
| 34. Dashboard Layout.mp4 | 280.6 MB | ||
| 31. Protecting Sheets (Description).html | 819.2 B | ||
| 31. Protecting Sheets.mp4 | 112.7 MB | ||
| 32. Printing Setup (Description).html | 819.2 B | ||
| 32. Printing Setup.mp4 | 148.8 MB | ||
| 2. Google Sheets vs Excel (Description).html | 921.6 B | ||
| 2. Google Sheets vs Excel.mp4 | 63.4 MB | ||
| 3. Download the Course Workbook (Description).html | 819.2 B | ||
| 3. Download the Course Workbook.html | 6 KB | ||
| 4. Course Lecture List (Description).html | 716.8 B | ||
| 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 |
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.2 GB | freecoursewb | 1 month | 14 | 4 | |
|
Udemy - Google Stitch Tutorial - Build and UI Design App Course with AI Posted by
freecoursewb in Other
|
3.1 GB | freecoursewb | 1 month | 21 | 7 |
| 1.2 GB | freecoursewb | 1 month | 12 | 3 | |
| 3 GB | freecoursewb | 2 months | 28 | 2 | |
| 712 MB | freecoursewb | 2 months | 18 | 11 |
All Comments