Google Sheets Essentials
Check out my brand new beginner’s course: Google Sheets Essentials.
This is a 100% online, on-demand video training course designed specifically to help you boost your spreadsheet skills.
The inaugural edition of SheetsCon — the world’s first dedicated, online Google Sheets conference — took place on the 11th – 12th March 2020.
Watch the replays for free here.
Take a look behind the scenes here.
Weekly Google Sheets Tips
Join our community of over 30,000 Google Sheets aficionados an get an actionable Google Sheets tip every Monday 👍
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.)
As a bonus, you’ll get a free copy of the Spice Up Your Sheet Life ebook, containing the first 100 tips.
Get your Google Sheets Tips and ebook!
Article Directory
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.
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
NEW Connected Sheets: Analyze Big Data 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)
Unpivot In Google Sheets With Formulas, Or How To Turn Wide Data Into Tall Data
Advanced Formula Challenges in Google Sheets
Formula Challenge #1: Repeating Images with Array Formulas
Formula Challenge #2: Matching Terms
Formula Challenge #3: Alphabetize Comma-Separated Strings
NEW Formula Challenge #4: Sort A Column By Last Name
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! 🌎
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
What the world’s richest man can teach us about averages
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?
How to Create a Scatter Plot in Google Sheets
How to make a Histogram in Google Sheets and overlay a Normal Distribution Curve
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
Excel To Sheets — a dedicated resource to help organizations migrate to Google Sheets from Microsoft Excel.
Google Sheets Courses
Data Cleaning in Google Sheets
Data Analysis in Google Sheets
Build Dashboards with 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
Google Sheets Sort By Color And Google Sheets Filter By Color, With Apps Script
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
Gmail Mail Merge For A Specific Label With Apps Script
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
How To Connect Google Sheets To A Database, Using Apps Script
D3 and Google Chart API
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 V8 Runtime Is Here! What Does That Mean?
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
Other articles
Annual Reviews
2019 in review and a look forward to 2020
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
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)