Google Sheets: Complete Course to Master Google Spreadsheet

Create and customize Google Forms within Google Sheets, using drag-and-drop questions, various field types, validation, and color themes, and save responses to a spreadsheet.

Learn how to integrate Google Forms with Google Sheets and connections to over 600 applications using zippier, enabling form data to trigger email, Slack notifications, and database exports.

Add IDs in Google Sheets by using a formula to generate a unique ID column from the name column, using an offset of minus 3 and if logic for blanks.

Use the hyperlink function to create a new link in Google Sheets that connects your sheet to a Google Form, enabling automatic entry of new form responses.

Learn to fetch data into Google Sheets using import functions, including importing from websites, RSS feeds, and other spreadsheets, by identifying structured page data and copying XPath expressions.

Learn how to use conditional formatting in Google Sheets to highlight ranges of cells, apply rules, and customize colors and formulas for clear, actionable data.

Learn to build and manage an editorial calendar in Google Sheets with date and month columns, and use conditional formatting to highlight March and April entries.

Identify the language with a spreadsheet function, translate with Google Translate, format text using trim, upper, lower, proper, left, and right, and combine cells with concatenate and conditional formatting.

Learn to create linked text in Google Sheets using the hyperlink function and to display or insert images into your spreadsheet, including uploading from Drive or camera.

Publish a Google sheet by exporting formats like Excel or PDF, printing, or sharing a public embed link, with access controlled by specific people or anyone with the link.

Learn to build a customizable dashboard in Google Sheets using the Google Analytics add-on to pull data. Create a report and select metrics like users, sessions, and bounce rate.

Run and compare current and previous Google Analytics traffic reports in Google Sheets, showing users, sessions, bounce rate, and session duration; adjust dates and organize results with sheets.

Add additional metrics to your dashboard by creating new reports with dimensions like new users and traffic sources, then visualize and share the results.

Explore popular Google Sheets add-ons for forms and how to manage them. Use copy down to propagate formulas and Flubaroo for scoring, organizing form responses into separate sheets.

Discover essential data-gathering add-ons for Google Sheets, including Import.io, Wolfram, Supermetrics, Blockspring, Wikipedia data, Google Analytics, and email tools to pull, refresh, and analyze web data.

Explore essential text tools and add-ons in Google Sheets, including text analysis, sentiment analysis, translation, mapping addresses with Google Maps, and Autocrat for document automation.

Explore Google Sheets add-ons for formatting to clean up data, remove blanks, deduplicate, find and replace text, and reformat and organize sheets with powerful tools.

Explore Google Sheets add-ons for advanced data analysis, from solver and math functions to predictive analytics and machine learning, enabling data modeling, gap filling, and API-driven predictions.

Install the AppSheet add-on from get add-ons, turn your spreadsheet into an app that runs on any device, and preview, edit, or view the app source.

Explore Google Apps Script for Google Sheets, compare standalone and bound scripts, create your first script, freeze the first row, run it, and authorize the automation.

Learn to set values in a Google Sheets range using Apps Script, including obtaining the active spreadsheet and sheets, constructing a values array, and applying it with setValues.

Learn how to create header names in Google Sheets, freeze the header row, and populate a range with fields like first name, last name, email, phone number, and company.

Learn to send bulk emails from Google Sheets with Apps Script, using a data range, subject, and message, and integrate with Gmail, Office 365, or Zapier and SendGrid.