Search Results for: charts

New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.

Google announced Named Functions and 9 other new functions on 24th August 2022. The biggest news here is the new feature called Named Functions. Named Functions let you save and name your own custom formulas, built with regular Sheets functions, and then re-use them in other Google Sheet files. It’s a HUGE step toward making … Continue reading New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.

A Guide To Named Functions In Google Sheets

💡 Learn more Learn more about working with Lambda Functions, Named Functions, and X-Functions in the FREE Lambda Functions 10-Day Challenge course Named Functions in Google Sheets let you save and name your own custom formulas and then re-use them in other Google Sheet files. Wow! How exciting is that?!? (Hint: VERY) For example, here … Continue reading A Guide To Named Functions In Google Sheets

Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets

In this post, I want to show you something amazing: how a simple equation — the logistic map — can lead to incredible outcomes, and even to chaos. And we’ll explore this with Google Sheets so you can follow along (please download the template at end of the post). But first, we begin our story … Continue reading Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets

How To Use Checkboxes In Google Sheets

The Google Sheets checkbox is an interactive widget in a cell that can be checked or unchecked. A checkbox in Google Sheets has a value TRUE when checked and FALSE when unchecked. Checkboxes open up all sorts of opportunities to make your Sheets more interactive, which you’ll see further down this post. All the examples … Continue reading How To Use Checkboxes In Google Sheets