Skip to content

Google Sheets Nerd

  • Home
  • Latest
  • About
  • Contact
Google Sheets Nerd

Latest Google Sheets Tips and Tricks

How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)
Charts

How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)

Bysnadmin December 31, 2021April 9, 2022

How to make stacked bar totals in Google Sheets.

Read More How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)Continue

Build An API in Google Sheets and Google Apps Script
Google Apps Script

Build An API in Google Sheets and Google Apps Script

Bysnadmin December 28, 2021December 31, 2021

How to build a whole API in Google Sheets, sourcing data from a Google sheet you write, and retrieving it via HTTP Get.

Read More Build An API in Google Sheets and Google Apps ScriptContinue

How to use Google Sheets as JSON Database  for Web Apps
Google Apps Script

How to use Google Sheets as JSON Database for Web Apps

Bysnadmin December 27, 2021December 31, 2021

How to use Google Sheets as the back-end database for a web application, producing JSON.

Read More How to use Google Sheets as JSON Database for Web AppsContinue

How to create Dynamic Arrays in Google Sheets with Concatenate, Split and Transpose
Formulas for Google Sheets and Excel (from beginner to advanced)

How to create Dynamic Arrays in Google Sheets with Concatenate, Split and Transpose

Bysnadmin December 27, 2021December 31, 2021

How to create dynamical arrays and tables in Google Sheets

Read More How to create Dynamic Arrays in Google Sheets with Concatenate, Split and TransposeContinue

How to Make Tables in Google Sheets — Three Easy Ways
Formulas for Google Sheets and Excel (from beginner to advanced)

How to Make Tables in Google Sheets — Three Easy Ways

Bysnadmin December 27, 2021December 31, 2021

A complete guide to making a table in Google Sheets — three easy ways.

Read More How to Make Tables in Google Sheets — Three Easy WaysContinue

XLOOKUP in Google Sheets — Two Equivalents and Alternatives
Formulas for Google Sheets and Excel (from beginner to advanced)

XLOOKUP in Google Sheets — Two Equivalents and Alternatives

Bysnadmin December 27, 2021December 31, 2021

How to use XLOOKUP in Google Sheets — Equivalents, alternatives, and even improvements…

Read More XLOOKUP in Google Sheets — Two Equivalents and AlternativesContinue

© 2022 Google Sheets Nerd - WordPress Theme by Kadence WP

  • Home
  • Latest
  • About
  • Contact