Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
In this post, we’ll build a named function that creates a miniature bullet chart in Google Sheets, as shown in this GIF: Bullet charts are variations on bar charts that show a primary measure compared to some target value. They’re highly effective because they capture a lot of information in a small, neat design. To … Continue reading Bullet Chart in Google Sheets with Sparklines and Named Functions
In this post, we’ll look at how to create a Google Sheets Drop-Down Menu. Here’s an example of a drop-down menu to record the status of deals in a real estate deal pipeline: Drop-down menus are great for data entry and making your Sheets dynamic. In this post, we’ll explore both of these techniques with … Continue reading How To Create A Google Sheets Drop-Down Menu
This is a guest post from Josh Cottrell-Schloemer. Google Sheets is an incredibly powerful spreadsheet tool for pulling, processing, and presenting data. But many people don’t realize that you can also use it to build interactive dashboards. With a bit of creativity we can go from this: To this: The skills to build this type … Continue reading Making Google Sheets look less like… Google Sheets
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.
💡 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