Welcome Google Sheets fans!

Articles on: Google Sheets | Apps Script | Data Studio | Other Topics

The goal here is to provide the best online learning resources to help you work with data using G Suite tools, specifically Google Sheets, Apps Script and Data Studio.

Before you start, why not sign up to receive Google Sheets Tips direct to your inbox?

This weekly email is full of exclusive tips, tutorials and special offers on future courses. (Think of it as your Monday morning espresso, in spreadsheet form.)

You’ll be joining a community of over 27,000 data analysts, digital marketers, educators and YOU! 👍

Google Sheets Articles

Getting Started Guide with Google Sheets

How to use Google Sheets: A Beginner’s Guide (a super detailed guide to take you from newbie to ninja in no time!)

Working with data in Google Sheets

Slow Google Sheets? Here are 27 ideas to try today 🐢

18 best practices for working with data in Google Sheets

Introducing the Google Sheets Checkbox and Three Ways You Can Use Them ☑️

How do I create a drop down list in Google Sheets?

How to Remove Duplicates in Google Sheets

Formulas in Google Sheets

18 Google Sheets Formula Tips & Techniques You Should Know

Use The Onion Method To Approach Complex Formulas

Google Sheets Query function: Learn the most powerful function in Google Sheets

Filtering with dates in the QUERY function

How to add a total row to a Query Function table in Google Sheets

How to use the FILTER function to return specific values in a Google Sheet

Advanced Filter Examples in Google Sheets

How does the array formula work in Google Sheets?

Use Array Formulas to auto-fill calculation columns when using Google Forms

How can I combine text and numbers in a cell and keep the number formatting?

How do I get the first and last days of the current month?

How do I get the first and last days of the prior month?

How do I do a VLOOKUP to the left in Google Sheets?

VLOOKUP in Google Sheets using wildcards for partial matches

Have VLOOKUP Return Multiple Columns in Google Sheets

VLOOKUP Multiple Criteria in Google Sheets

Running Total Array Formulas (using MMULT)

How do I reverse text in a cell in Google Sheets?

How to create dynamic named ranges in Google Sheets

Help, my formula doesn’t work! (Dealing with errors)

Google Sheets Formula Clock

Advanced Formula Challenges in Google Sheets

Formula Challenge #1: Repeating Images with Array Formulas

Formula Challenge #2: Matching Terms

Getting external data into Google Sheets with formulas

How can I import social media statistics into Google Sheets?

Using Google Sheets as a basic web scraper

Pivot Tables in Google Sheets

Pivot Tables in Google Sheets: A Beginner’s Guide

Mapping data with Pivot Tables in Google Sheets…yes, really! 🌎

NEW Slicers in Google Sheets

Formatting in Google Sheets

How to apply conditional formatting across an entire row in Google Sheets

How To Make a Table in Google Sheets, and Make It Look Great

Using Text Rotation to Create Custom Table Headers in Google Sheets

Automation

The complete guide to simple automation in Google Sheets, using Macros

Data Analysis techniques in Google Sheets

NEW Goal Seek in Google Sheets

What the world’s richest man can teach us about averages

How to Create a Scatter Plot in Google Sheets

How to make a Histogram in Google Sheets and overlay a Normal Distribution Curve

Charting techniques in Google Sheets

Creating dynamic charts using Google Sheets drop down menus

Everything you ever wanted to know about Sparklines in Google Sheets

How can I format individual data points in Google Sheets charts?

How to create an annotated line graph in Google Sheets

How to create a funnel chart in Google Sheets

How to create a waterfall chart in Google Sheets

Web traffic chart with dynamic banding in Google Sheets

How do I create a multi-colored line chart in Google Sheets?

Dashboards in Google Sheets

10 techniques for building a Google Sheets dashboard

Dashboard Design Checklist: From a Blank Google Sheet to Business Insights (incl. Facebook example)

10 techniques to use when building budget templates in Google Sheets

How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script

How to create CSS pie charts in Geckoboard dashboards with data from Google sheets

Premier League Social Media Dashboard in Google Sheets

Building a dynamic dashboard for a 3-day digital flash sale

Creating a custom Google Analytics report in a Google spreadsheet

Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch

Other articles about Google Sheets

How we manage our family finances with Google Sheets

Explaining syntax differences in your formulas due to your Google Sheets location

6 Killer Productivity Tips for Google Sheets

Other Resources for Google Sheets

Google Sheets Resources

Google Sheets Courses

Data Cleaning in Google Sheets

Data Analysis in Google Sheets

Build Dashboards with Google Sheets

Google Sheets Bootcamp

Pivot Tables in Google Sheets

Extreme Formulas in Google Sheets

Advanced Formulas – 30 Day Challenge (a free course)

Want exclusive weekly tips delivered straight to your inbox?

Sign up for the weekly Google Sheets Tips Email and join over 20,000 data analysts, digital marketers, educators and business owners. You’ll receive exclusive content not found anywhere else on this site! 👍

Apps Script Articles

Getting Started Guides for Apps Script

The complete guide to simple automation in Google Sheets, using Macros

Google Apps Script: A Beginner’s Guide

API Tutorial For Beginners With Google Sheets & Apps Script

10 Coding Tips For Beginners With Apps Script

Add A Google Sheets Button To Run Scripts

Using Apps Script to automate G Suite

Saving data in your Google Sheets with Apps Script

How to set up time-based triggers to run your Apps Script code

How to add a hyperlinked index sheet or sidebar to your large Google Sheet workbooks

How to extract email addresses tagged with a specific Gmail label

How to reply to Google Forms survey responses quickly with Sheets & Apps Script

How to automatically create waterfall charts using Apps Script

How to automatically create funnel charts using Apps Script

One way to animate a chart in Google Sheets

Working with external services using Apps Script

How to connect the Strava API with Google Sheets and Data Studio

Google Sheets Slack bot: how to push data from your Google Sheets into the popular messaging app

Connecting to the Crunchbase API with Google Sheets

Google Sheets and Mailchimp integration using Apps Script

Show data from the GitHub API in Google Sheets, using Apps Script and Oauth

How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script

How to create a Data Studio Community Connector with Apps Script

D3 and Google Chart API

Google Sheets and D3 charts

Multi-series D3 line chart (D3 only)

Creating a dynamic d3 visualization from the GitHub API (D3 only)

Recreating Tufte’s famous temperature chart with the Google Chart API

Animated temperature chart using the Google Chart API

Other Apps Script Resources

Apps Script resources

Check out my apps script and apps script API repositories on GitHub.

Apps Script Courses

Apps Script Blastoff (a free, introductory course)

Want exclusive weekly tips delivered straight to your inbox?

Sign up for the weekly Google Sheets Tips Email and join over 20,000 data analysts, digital marketers, educators and business owners. You’ll receive exclusive content not found anywhere else on this site! 👍

Data Studio Articles

Getting Started Guide for Google Data Studio

An introduction to Data Studio

Intermediate & Advanced articles for Google Data Studio

How to connect the Strava API with Google Sheets and Data Studio

6 advanced techniques in Data Studio

Community connectors to access any data in Data Studio

Data Studio Connector fields get an update

Other resources for Google Data Studio

Data Studio resources

Other articles

Annual Reviews

2018 in review and a look forward to 2019

2017 in review and a look forward to 2018

2016 in review and a look forward to 2017

2015 in review and a look forward to 2016

Google Cloud Next Conference Recaps

Recap From Google Cloud Next ’19 Conference

Google Next 19 Conference – Live Blog

Recap From Google Cloud Next ’18 Conference

Essays

Thoughts on productivity

In Pursuit Of A Dream

If Google Sheets And Microsoft Excel Went For A Drink…

SQL

Six reasons to start learning SQL

Excel

Excel tutorial: build a dynamic bump chart of the English Premier League

Excel tutorial: Building a dynamic, animated dashboard for U.S. political data

Excel-fficiency: 10 tips for boosting productivity in Excel

Other Resources

Data Analytics Resources (Excel, SQL, Tableau, Statistics, Data Viz)