benlcollins.com

Website review benlcollins.com

Google Sheets and Apps Script Tutorials and Online Courses

 Generated on March 18 2026 14:17 PM

Old data? UPDATE !

The score is 61/100

SEO Content

Title

Google Sheets and Apps Script Tutorials and Online Courses

Length : 58

Perfect, your title contains between 10 and 70 characters.

Description

Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!

Length : 127

Great, your meta description contains between 70 and 160 characters.

Keywords

Very bad. We haven't found meta keywords on your page. Use this free online meta tags generator to create keywords.

Og Meta Properties

Good, your page take advantage of Og Properties.

Property Content
locale en_US
type website
title Google Sheets and Apps Script Tutorials and Online Courses
description Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!
url https://www.benlcollins.com/
image https://www.benlcollins.com/wp-content/uploads/2025/12/ModernGoogleSheets.jpg

Headings

H1 H2 H3 H4 H5 H6
2 8 33 0 0 0
  • [H1] Modern Google Sheets
  • [H1]
  • [H2] Search
  • [H2] LATEST
  • [H2] Articles:
  • [H2] AI and Spreadsheets
  • [H2] Google Sheets Articles
  • [H2] Apps Script Articles
  • [H2] 🔧 Other Google Tools I Work With
  • [H2] 📚 Other articles
  • [H3] Popular Articles
  • [H3] Sheets Insiders Membership Articles
  • [H3] Working with data in Google Sheets
  • [H3] Formulas in Google Sheets
  • [H3] Formula Challenges in Google Sheets
  • [H3] Getting external data into Google Sheets with formulas
  • [H3] Pivot Tables in Google Sheets
  • [H3] Formatting in Google Sheets
  • [H3] Automation
  • [H3] Data Analysis techniques in Google Sheets
  • [H3] Charting techniques in Google Sheets
  • [H3] Dashboards in Google Sheets
  • [H3] Other articles about Google Sheets
  • [H3] Mathematics in Google Sheets
  • [H3] Exploration With Google Sheets
  • [H3] Other Resources for Google Sheets
  • [H3] Google Sheets Courses
  • [H3] Getting Started Guides for Apps Script
  • [H3] Using Apps Script to automate Google Workspace
  • [H3] Working with external services using Apps Script
  • [H3] D3 and Google Chart API
  • [H3] Other Apps Script Resources
  • [H3] Apps Script Courses
  • [H3] Google Tables
  • [H3] Google BigQuery
  • [H3] Looker (formerly Data Studio) Articles
  • [H3] Google Sites
  • [H3] Annual Reviews
  • [H3] SheetsCon: Online Google Sheets Conference
  • [H3] Google Cloud Next Conference Recaps
  • [H3] Essays
  • [H3] SQL
  • [H3] Excel

Images

We found 6 images on this web page.

1 alt attributes are empty or missing. Add alternative text so that search engines can better understand the content of your images.

Text/HTML Ratio

Ratio : 16%

Good, this page's ratio of text to HTML code is higher than 15, but lower than 25 percent.

Flash

Perfect, no Flash content has been detected on this page.

Iframe

Great, there are no Iframes detected on this page.

URL Rewrite

Good. Your links looks friendly!

Underscores in the URLs

We have detected underscores in your URLs. You should rather use hyphens to optimize your SEO.

In-page links

We found a total of 271 links including 0 link(s) to files

Anchor Type Juice
Skip to content Internal Passing Juice
Home Internal Passing Juice
Courses Internal Passing Juice
Student Login External Passing Juice
Newsletter Internal Passing Juice
Sponsorship Internal Passing Juice
About Internal Passing Juice
Contact Internal Passing Juice
Is Formula Writing Dead? (And why we shouldn’t mourn it) Internal Passing Juice
How to Build a Content Engine with Apps Script, NotebookLM, and a Gemini Gem Internal Passing Juice
2025 In Review And A Look Forward To 2026 Internal Passing Juice
Custom Number Format Color Palette Reference Table Internal Passing Juice
Status Arrows in Google Sheets Internal Passing Juice
Check out Modern Google Sheets Internal Passing Juice
apps script taster course Internal Passing Juice
How to use the AI Function in Google Sheets (with 10 examples) Internal Passing Juice
I Let OpenAI Operator Manage My Google Sheet: Here’s What Happened. Internal Passing Juice
Can AI Studio teach me how to build a pivot table? Internal Passing Juice
AI Experiments: Using Sora AI to Generate Videos Internal Passing Juice
What AI Can Do For You As A Google Sheets User. Is The Hype Justified? Internal Passing Juice
Three Ways To Use AI Tools With Google Sheets Internal Passing Juice
How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses Internal Passing Juice
How to use Google Sheets: A Beginner’s Guide Internal Passing Juice
11 Incredibly Useful URL Tricks for Google Sheets Internal Passing Juice
How to apply conditional formatting across an entire row in Google Sheets Internal Passing Juice
Checklist Template In Google Sheets Internal Passing Juice
Google Sheets Query function: The Most Powerful Function in Google Sheets Internal Passing Juice
Filtering with dates in the QUERY function Internal Passing Juice
When Your Formula Doesn’t Work: Formula Parse Errors in Google Sheets Internal Passing Juice
Google Apps Script: A Beginner’s Guide Internal Passing Juice
Add A Google Sheets Button To Run Scripts Internal Passing Juice
How To Add Subscript and Superscript In Google Sheets Internal Passing Juice
Google Sheets Custom Number Format Internal Passing Juice
How To Use Checkboxes In Google Sheets Internal Passing Juice
Introducing The Sheets Insiders Membership Program Internal Passing Juice
Sheets Insiders 1: Visual Vocabulary Template Internal Passing Juice
The Complete Guide to Tables in Google Sheets Internal Passing Juice
How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another Internal Passing Juice
Slow Google Sheets? Here are 27 ideas to try today Internal Passing Juice
18 best practices for working with data in Google Sheets Internal Passing Juice
How To Copy Only Visible Cells In Google Sheets Internal Passing Juice
How To Create A Select All Checkbox in Google Sheets Internal Passing Juice
How To Mimic Radio Buttons With Formulas and Checkboxes Internal Passing Juice
How To Create A Google Sheets Drop Down Menu Internal Passing Juice
Multiple Selections in Drop Downs in Google Sheets Internal Passing Juice
How to Remove Duplicates in Google Sheets Internal Passing Juice
Unpivot In Google Sheets With Formulas, Or How To Turn Wide Data Into Tall Data Internal Passing Juice
Connected Sheets: Analyze Big Data In Google Sheets Internal Passing Juice
Beyond Sheets: Get Started With Google BigQuery Internal Passing Juice
Get A Unique List Of Items From A Column With Grouped Words Internal Passing Juice
How To Highlight The Top 5 Values In Google Sheets With Formulas Internal Passing Juice
How To Rank Data In Google Sheets With The RANK Function Internal Passing Juice
How To Create Arrays In Google Sheets (a.k.a. Array Literals) Internal Passing Juice
Automatic Data Sharing Across Sheets With IMPORTRANGE and Named Functions Internal Passing Juice
11 New Analytical Functions In Google Sheets For 2023 Internal Passing Juice
New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc. Internal Passing Juice
A Guide To Named Functions In Google Sheets Internal Passing Juice
LAMBDA Function in Google Sheets Internal Passing Juice
XLOOKUP Function in Google Sheets Internal Passing Juice
XMATCH Function in Google Sheets Internal Passing Juice
MAP Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
REDUCE Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
MAKEARRAY Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
SCAN Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
BYROW Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
BYCOL Function in Google Sheets – LAMBDA Helper Function Internal Passing Juice
18 Google Sheets Formula Tips & Techniques You Should Know Internal Passing Juice
Use The Onion Method To Approach Complex Formulas Internal Passing Juice
IF Function in Google Sheets Internal Passing Juice
IFS Function in Google Sheets Internal Passing Juice
IFERROR Function In Google Sheets Internal Passing Juice
FACT Function in Google Sheets (And Why A Shuffled Deck of Cards Is Unique) Internal Passing Juice
REPT Function in Google Sheets Internal Passing Juice
SPLIT Function in Google Sheets Internal Passing Juice
INDIRECT Function in Google Sheets Internal Passing Juice
SUBTOTAL Function in Google Sheets Internal Passing Juice
How to add a total row to a Query Function table in Google Sheets Internal Passing Juice
A Guide To The Google Sheets Filter Function Internal Passing Juice
Advanced Filter Examples in Google Sheets Internal Passing Juice
How does the array formula work in Google Sheets? Internal Passing Juice
Use Array Formulas to auto-fill calculation columns when using Google Forms Internal Passing Juice
How can I combine text and numbers in a cell and keep the number formatting? Internal Passing Juice
How do I get the first and last days of the current month? Internal Passing Juice
How do I get the first and last days of the prior month? Internal Passing Juice
VLOOKUP Function in Google Sheets: The Essential Guide Internal Passing Juice
How do I do a VLOOKUP to the left in Google Sheets? Internal Passing Juice
VLOOKUP in Google Sheets using wildcards for partial matches Internal Passing Juice
Have VLOOKUP Return Multiple Columns in Google Sheets Internal Passing Juice
VLOOKUP Multiple Criteria in Google Sheets Internal Passing Juice
Running Total Array Formulas (using MMULT) Internal Passing Juice
How do I reverse text in a cell in Google Sheets? Internal Passing Juice
Build Numbered Lists With The Amazing SEQUENCE Function Internal Passing Juice
How to create dynamic named ranges in Google Sheets Internal Passing Juice
Help, my formula doesn’t work! (Dealing with errors) Internal Passing Juice
Experiments With Cell Function: Create A Dynamic Table Of Contents In Google Sheets With Formulas Internal Passing Juice
Google Sheets REGEX Formulas Internal Passing Juice
Setting Default Values For Cells In Google Sheets Internal Passing Juice
A Complete Guide To The CHAR Function In Google Sheets Internal Passing Juice
The TRANSPOSE Function in Google Sheets Internal Passing Juice
The FLATTEN Function in Google Sheets Internal Passing Juice
The AND Function in Google Sheets Internal Passing Juice
The OR Function in Google Sheets Internal Passing Juice
The UNIQUE Function in Google Sheets Internal Passing Juice
Google Sheets COUNTIF Function Internal Passing Juice
Google Sheets COUNTIFS Function Internal Passing Juice
How To Use Google Sheets SUMIF Function Internal Passing Juice
Google Sheets SUMIFS Function Internal Passing Juice
How To Use The RANDARRAY Function In Google Sheets Internal Passing Juice
How To Use The RANDBETWEEN Function In Google Sheets Internal Passing Juice
How To Create A Random Number Generator In Google Sheets Internal Passing Juice
SORTN Function In Google Sheets Internal Passing Juice
The LARGE Function in Google Sheets Internal Passing Juice
Use The SWITCH Function to Categorize Data Efficiently Internal Passing Juice
How To Use The Choose Function In Google Sheets Internal Passing Juice
How To Use The TRIM Function In Google Sheets To Clean Your Data Internal Passing Juice
The ROMAN Function in Google Sheets Internal Passing Juice
The LEN Function in Google Sheets Internal Passing Juice
GETPIVOTDATA Function in Google Sheets: How To Extract Data From Pivot Tables Internal Passing Juice
Bullet Chart in Google Sheets with Sparklines and Named Functions Internal Passing Juice
Recursion in Google Sheets with Formulas Internal Passing Juice
Formula Challenge #1: Repeating Images with Array Formulas Internal Passing Juice
Formula Challenge #2: Matching Terms Internal Passing Juice
Formula Challenge #3: Alphabetize Comma-Separated Strings Internal Passing Juice
Formula Challenge #4: Sort A Column By Last Name Internal Passing Juice
Formula Challenge #5: Merge Columns in Google Sheets With Single Range Reference Internal Passing Juice
Formula Challenge #6: Split A String Into Characters And Recombine In Random Order Internal Passing Juice
Formula Challenge #7: Generate A Repeating Sequence Of Numbers Internal Passing Juice
Alexa Rank Tracker in Google Sheets Internal Passing Juice
Using Google Sheets as a basic web scraper Internal Passing Juice
How can I import social media statistics into Google Sheets? Internal Passing Juice
Pivot Tables in Google Sheets: A Beginner’s Guide Internal Passing Juice
Mapping data with Pivot Tables in Google Sheets…yes, really! Internal Passing Juice
Slicers in Google Sheets Internal Passing Juice
How To Merge Cells In Google Sheets And When To Be Careful Internal Passing Juice
Using Text Rotation to Create Custom Table Headers in Google Sheets Internal Passing Juice
How To Wrap Text In Google Sheets Internal Passing Juice
Create Barcodes In Google Sheets In 2 Easy Steps Internal Passing Juice
How To Create QR Codes in Google Sheets Using Formulas Internal Passing Juice
How To Alternate Colors In Google Sheets Internal Passing Juice
The complete guide to simple automation in Google Sheets, using Macros Internal Passing Juice
Goal Seek in Google Sheets Internal Passing Juice
What the world’s richest man can teach us about averages Internal Passing Juice
Radial Bar Charts in Google Sheets Internal Passing Juice
How To Create A Grid Chart In Google Sheets Internal Passing Juice
Creating dynamic charts using Google Sheets drop down menus Internal Passing Juice
Everything you ever wanted to know about Sparklines in Google Sheets Internal Passing Juice
How can I format individual data points in Google Sheets charts? Internal Passing Juice
How to create an annotated line graph in Google Sheets Internal Passing Juice
How to create a funnel chart in Google Sheets Internal Passing Juice
How to create a waterfall chart in Google Sheets Internal Passing Juice
Web traffic chart with dynamic banding in Google Sheets Internal Passing Juice
How do I create a multi-colored line chart in Google Sheets? Internal Passing Juice
How to Create a Scatter Plot in Google Sheets Internal Passing Juice
How to make a Histogram in Google Sheets and overlay a Normal Distribution Curve Internal Passing Juice
Dot Plots in Google Sheets Internal Passing Juice
How To Create A Heat Map In Google Sheets Internal Passing Juice
Formula Pie Charts in Google Sheets Internal Passing Juice
10 techniques for building a Google Sheets dashboard Internal Passing Juice
Dashboard Design Checklist: From a Blank Google Sheet to Business Insights Internal Passing Juice
10 techniques to use when building budget templates in Google Sheets Internal Passing Juice
How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script Internal Passing Juice
Building a dynamic dashboard for a 3-day digital flash sale Internal Passing Juice
Creating a custom Google Analytics report in a Google spreadsheet Internal Passing Juice
Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch Internal Passing Juice
Making Google Sheets look less like… Google Sheets Internal Passing Juice
The Complete Guide to Smart Chips in Google Sheets Internal Passing Juice
How I Built A Glide App And Turned My Google Sheet Into A Simple No-Code App Internal Passing Juice
How we manage our family finances with Google Sheets Internal Passing Juice
Explaining syntax differences in your formulas due to your Google Sheets location Internal Passing Juice
6 Killer Productivity Tips for Google Sheets Internal Passing Juice
Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets Internal Passing Juice
How To Draw The Cantor Set In Google Sheets Internal Passing Juice
PI Function in Google Sheets And Other Fun π Facts Internal Passing Juice
Complex Numbers In Google Sheets Internal Passing Juice
How To Draw The MandelBrot Set In Google Sheets, Using Only Formulas Internal Passing Juice
How To Draw The Sierpiński Triangle In Google Sheets Internal Passing Juice
Recursion and the Fibonacci Sequence Internal Passing Juice
Recursion, Primes and the Sieve of Eratosthenes Internal Passing Juice
Play-It-Through Chess Game in a Single Google Sheets Formula Internal Passing Juice
Etch A Sheet In Google Sheets Internal Passing Juice
Google Sheets Formula Clock Internal Passing Juice
Recreating Visualize Value design work with SPARKLINES External Passing Juice
Google Sheets Advent Calendar Internal Passing Juice
Join The Dots Drawing In Google Sheets Internal Passing Juice
Excel To Sheets External Passing Juice
How To Become A Freelance Google Sheets Developer Internal Passing Juice
Google Sheets Essentials (beginner course) Internal Passing Juice
Data Analysis in Google Sheets Internal Passing Juice
Build Dashboards with Google Sheets Internal Passing Juice
Pivot Tables in Google Sheets Internal Passing Juice
The Google Sheets REGEX Formula Cookbook Internal Passing Juice
Advanced Formulas – 30 Day Challenge Internal Passing Juice
Google Apps Script: A Beginner’s Guide Internal Passing Juice
Repeatable Task: To Script Or Not To Script, That Is The Question Internal Passing Juice
A Guide To The New Google Apps Script IDE Internal Passing Juice
API Tutorial For Beginners With Google Sheets & Apps Script Internal Passing Juice
10 Coding Tips For Beginners With Apps Script Internal Passing Juice
Finding Merged Cells In Your Google Sheet using Apps Script Internal Passing Juice
Sheet Sizer! Build A Tool To Measure Your Google Sheets Size With Apps Script Internal Passing Juice
Radio Buttons in Google Sheets: Only One Checkbox Checked Internal Passing Juice
Google Sheets Sort By Color And Google Sheets Filter By Color Internal Passing Juice
How To Save Data In Google Sheets With Timestamps Using Apps Script Internal Passing Juice
How to set up time-based triggers to run your Apps Script code Internal Passing Juice
How to add a hyperlinked index sheet or sidebar to your large Google Sheet workbooks Internal Passing Juice
How to extract email addresses tagged with a specific Gmail label Internal Passing Juice
Gmail Mail Merge For A Specific Label With Apps Script Internal Passing Juice
How to reply to Google Forms survey responses quickly with Sheets & Apps Script Internal Passing Juice
How to automatically create waterfall charts using Apps Script Internal Passing Juice
How to automatically create funnel charts using Apps Script Internal Passing Juice
One way to animate a chart in Google Sheets Internal Passing Juice
API Authentication Apps Script Reference Internal Passing Juice
How To Build An Automated ConvertKit Report In Google Sheets Using Apps Script Internal Passing Juice
How To Connect To The Teachable API With Apps Script Internal Passing Juice
How To Get Fathom Analytics Data Into Google Sheets, Using Apps Script Internal Passing Juice
Control Your Nest Thermostat And Build A Temperature Logger In Google Sheets Using Apps Script Internal Passing Juice
Sentiment Analysis For Google Tables Using Apps Script Internal Passing Juice
Data Enrichment with the Google Tables Apps Script Bot Internal Passing Juice
How to connect the Strava API with Google Sheets and Data Studio Internal Passing Juice
Google Sheets Slack bot: how to push data from your Google Sheets into the popular messaging app Internal Passing Juice
Connecting to the Crunchbase API with Google Sheets Internal Passing Juice
Google Sheets and Mailchimp integration using Apps Script Internal Passing Juice
Show data from the GitHub API in Google Sheets, using Apps Script and Oauth Internal Passing Juice
Using Slack Slash Commands to Send Data from Slack into Google Sheets External Passing Juice
How to create a Data Studio Community Connector with Apps Script Internal Passing Juice
How To Connect Google Sheets To A Database, Using Apps Script Internal Passing Juice
Google Sheets and D3 charts Internal Passing Juice
Recreating Tufte’s famous temperature chart with the Google Chart API Internal Passing Juice
Animated temperature chart using the Google Chart API Internal Passing Juice
How To Track Link Clicks With Apps Script And Google Sheets Internal Passing Juice
Apps Script V8 Runtime Is Here! What Does That Mean? Internal Passing Juice
apps script External Passing Juice
apps script API External Passing Juice
Apps Script Taster Internal Passing Juice
Beginner Apps Script Internal Passing Juice
Automation With Apps Script Internal Passing Juice
here External Passing Juice
Google Tables: How I Use Google’s New Workflow Tool Internal Passing Juice
An introduction to Data Studio Internal Passing Juice
6 advanced techniques in Data Studio Internal Passing Juice
Community connectors to access any data in Data Studio Internal Passing Juice
Data Studio Connector fields get an update Internal Passing Juice
How to Use Google Sheets in Your Google Sites Internal Passing Juice
2024 In Review And A Look Forward To 2025 Internal Passing Juice
2023 In Review And A Look Forward To 2024 Internal Passing Juice
2022 In Review And A Look Forward To 2023 Internal Passing Juice
2021 In Review And A Look Forward To 2022 Internal Passing Juice
2020 In Review And A Look Forward To 2021 Internal Passing Juice
2019 in review and a look forward to 2020 Internal Passing Juice
2018 in review and a look forward to 2019 Internal Passing Juice
2017 in review and a look forward to 2018 Internal Passing Juice
2016 in review and a look forward to 2017 Internal Passing Juice
2015 in review and a look forward to 2016 Internal Passing Juice
SheetsCon 2020: Lessons Learned Running An Online Conference For 6,700 People Internal Passing Juice
Recap From Google Cloud Next ’19 Conference Internal Passing Juice
Google Next 19 Conference – Live Blog Internal Passing Juice
Recap From Google Cloud Next ’18 Conference Internal Passing Juice
A Behind The Scenes Look At How I Create A Technical Video Course Internal Passing Juice
Three Benefits Of Cohort-Based Courses Internal Passing Juice
5 Insights From Taking A Live Cohort-Based Course (And How I’m Applying Them To My Own) Internal Passing Juice
Create A Student Learning Loop In Your Cohort-Based Course Internal Passing Juice
I Left My Corporate Accounting Job 7 Years Ago. Here’s How I Built A Career As An Educational Entrepreneur Internal Passing Juice
Thoughts on productivity Internal Passing Juice
In Pursuit Of A Dream Internal Passing Juice
If Google Sheets And Microsoft Excel Went For A Drink… Internal Passing Juice
Dream Home Office Setup Internal Passing Juice
Six reasons to start learning SQL Internal Passing Juice
Excel tutorial: build a dynamic bump chart of the English Premier League Internal Passing Juice
Excel tutorial: Building a dynamic, animated dashboard for U.S. political data Internal Passing Juice
Excel-fficiency: 10 tips for boosting productivity in Excel Internal Passing Juice
Privacy Policy Internal Passing Juice
Proudly powered by WordPress External Passing Juice

SEO Keywords

Keywords Cloud

script how sheets data function google formula using create apps

Keywords Consistency

Keyword Content Title Keywords Description Headings
google 232
sheets 205
how 81
function 59
script 47

Usability

Url

Domain : benlcollins.com

Length : 15

Favicon

Great, your website has a favicon.

Printability

We could not find a Print-Friendly CSS.

Language

Good. Your declared language is en.

Dublin Core

This page does not take advantage of Dublin Core.

Document

Doctype

HTML 5

Encoding

Perfect. Your declared charset is UTF-8.

W3C Validity

Errors : 0

Warnings : 0

Email Privacy

Great no email address has been found in plain text!

Deprecated HTML

Great! We haven't found deprecated HTML tags in your HTML.

Speed Tips

Excellent, your website doesn't use nested tables.
Too bad, your website is using inline styles.
Too bad, your website has too many CSS files (more than 4).
Too bad, your website has too many JS files (more than 6).
Perfect, your website takes advantage of gzip.

Mobile

Mobile Optimization

Apple Icon
Meta Viewport Tag
Flash content

Optimization

XML Sitemap

Great, your website has an XML sitemap.

https://www.benlcollins.com/sitemap_index.xml

Robots.txt

https://benlcollins.com/robots.txt

Great, your website has a robots.txt file.

Analytics

Missing

We didn't detect an analytics tool installed on this website.

Web analytics let you measure visitor activity on your website. You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.

PageSpeed Insights

Device
Categories

Free SEO Testing Tool

Free SEO Testing Tool is a free SEO tool which provides you content analysis of the website.