Getting Started with Google Sheets
- Create a Spreadsheet
- Format Data for Easy Viewing
- Add, Average, and Filter Data with Formulas
- Share, Protect, and Move Data
Spreadsheet CRM
- Build Google Sheets CRM
- Add Form to Spreadsheet
- Create a Contact Management System
- Qualify Contacts with Web Scraping
- Build an Outreach System with Social Media
Write Faster with Spreadsheets
- Maintain an Editorial Calendar
- Build Detailed Outlines
- Import Data from Websites and Feeds
- Identify and Translate Test
- Format Text
- Combine Text from Cells
- Creating Linked Text
- Display Images from a URL
- Create HTML Tables for Blog Posts
- Publish Spreadsheets
Creating a Custom Business Analytics Dashboard with Google Sheets
- Tools to Build a Customisable Dashboard
- Get Data for Dashboard
- Build a Reporting Dashboard in Google Sheets
- Adding Additional Metrics
- Create Spreadsheet Dashboards
Google Sheets Add-Ons to Supercharge your Spreadsheets
- Google Sheets Add-Ons
- Forms
- Data Gathering
- Text Tools
- Formatting
- Number Crunching
- Sharing and Publishing
- Email and Communication
- Build Google Sheets Add-Ons
- Working Offline in Google Sheets
Automate Google Sheets
- Introduction to Google Apps Script
- Building First Script
Google Apps