Embedded Files
Data Validation/Conditional Formatting
Data Validation/Conditional Formatting
- How to get a date picker in a Google Sheets cell (Use Technology Better)
- How to Highlight Cells Containing Specific Function (Info Inspired)
- How to Only Allow the Entry of Alphanumerics in a Column (Info Inspired)
- Compare and Highlight Up and Down in Ranking in Google Sheets (Info Inspired)
- How to Use Color Scale Conditional Formatting (Info Inspired)
Formatting
Formatting
- How to Freeze a Row (SupportYourTech.com)
- How to Get Subscript and Superscript Values (Sheetaki)
String Extraction and Manipulation
String Extraction and Manipulation
- Extract, Replace, Match Nth Occurrence of a String or Number (Info Inspired)
Sharing
Sharing
- Google Document URL Tricks (Tony Vincent)
- Share a Single Sheet Tab (eduGOOGdroid)
- How To Share A Link To Old Revision (xFanatical)
- How to Share a Google Docs, Sheets, or Slides File as a Web Page (How To Geek)
Applications
Applications
Collaboration
Collaboration
- Font Formatting in Google Comments (Jake Miller)
- How to collaborate in Google Docs, Sheets, and Slides: 4 tips (Tech Republic)
Data
Data
- Sum Multiple Columns Dynamically Across Rows (Info Inspired)
Web Scraping
Web Scraping
- Using Google Sheets as a basic web scraper (Ben Collins)
- How to Scrape Web Content into Google Sheets (Parsehub)
- Web Scraping With Google Sheets (Hackernoon)
- EASY WEB SCRAPING WITH GOOGLE SHEETS (Simply Python)
- Web Scraping with Google Sheets: The Definitive Guide (this DaveJ)
- Build an E-mail + Phone Number Scraper in 7 Minutes with Google Sheets, Standard Library and Node.js (Keith Horwood)
- Four different functions you can use for web scraping (SeattleDataGuy)
Data Cleanup
Data Cleanup
- How to Remove Duplicates in Google Sheets (Ben Collins)
- How to prepare your data for analysis and charting (Data Wrapper)
- Best Practices for Using Google Sheets in Your Data Project (Matthew Lincoln)
Charts/Graphing/Data Viz
Charts/Graphing/Data Viz
- 🎬 Making live charts in Google Sheets (Chris Betcher)
- How to Make a Line Graph in Google Sheets (iTechGuides)
- Tell compelling stories with your data using Google Sheets (Google)
Filtering Data
Filtering Data
- Filter Google Sheets Data without Changing What Collaborators See (How-To Geek)
- Filter Menu to Filter Max N Values in Google Sheets – Custom Formula (Info Inspired)
Cells/Rows/Sheets/Columns
Cells/Rows/Sheets/Columns
- How To Protect Your Google Sheets (Ubergizmo)
- Extract Every Nth Line from Multi-Line Cells (Info Inspired)
- Find the Last Non-Empty Column in a Row (Info Inspired)
Pivot Tables
Pivot Tables
- Pivot Tables in Google Sheets: A Beginner’s Guide (Ben Collins)
- How to Use Pivot Tables in Google Sheets (Ultimate Guide) - (Andrew Childress)
- Create & use pivot tables (Google Help)
- Customize a pivot table (Google Help)
- How to Make a Pivot Table in Google Sheets (iTechGuides)
- Pivot Table Maps in Google Sheets…yes, really! (Ben Collins)
- Google Sheets pivot tables for marketing data (Analytical Marketer)
- Filter Multiple Values in Pivot Table (Info Inspired)
- How to Filter Top 10 Items in Google Sheets Pivot Table (Info Inspired)
- Extract Total and Grand Total Rows From a Pivot Table (Info Inspired)
Date/Time
Date/Time
- How to Change the Google Sheets Date Format (Support Your Tech)
- Find Missing Sequential Dates in a List (Info Inspired)
- Working with Timezones in Google Sheets and Data Studio (Optimize Smart)
Regular EXpressions - REGEX
Regular EXpressions - REGEX
- How to Use REGEX Formulas in Google Sheets (Distilled.Net)
UX Design
UX Design
- UX design with Google Docs and Sheets (UX Collective)
- Designing in Google Sheets using 4 features (UX Collective)
Dashboards
Dashboards
- 10 Techniques for building a Google Sheets Dashboard (Ben Collins)
- 5 Ways Dashboards Can Improve Team Performance (G2)
- How to power your realtime KPI dashboard from your database without coding (The Startup)
- GA Performance Reporting Dashboard (Analytical Marketer)
- Digital Dashboards: Strategic & Tactical: Best Practices, Tips, Examples (Avinash Kaushik)
- Google Sheets - Dashboard Tutorial - Part 1 - Part 2 - Part 3 📽️ (Learn Google Spreadsheets)
- Track Sales and Leads in Google Sheets and Data Studio Dashboard 📽️ (Hustle Sheets)
Social Media/SEO
Social Media/SEO
- My Top-Secret Social Media Content Creator Hack Using Google Sheets (bulk.ly)
- How to extract domain from URL in Google Sheets (Sheets for Marketers)
Using Sheets With Google Forms
Using Sheets With Google Forms
- How to Save Google Form Responses to Different Sheets Easily (Guiding Tech)
Troubleshooting
Troubleshooting
- Slow Google Sheets? Here are 27 Ideas to Try Today 🐢 (Ben Collins)
- How to Clear the Cache in Google Drive and Docs (Guiding Tech)
- Google Sheets Formula Parse Error – How To Fix (Tech Junkie)
Google Sheets API
Google Sheets API
Sales
Sales
Page updated
Google Sites
Report abuse