The ROMAN function in Google Sheets converts numbers into Roman numerals.
This function is particularly useful for those interested in presenting numbers in a classical style, whether for educational, historical, or aesthetic purposes.
🔗 Grab the template at the bottom of this article.
Although AI has been around for decades, it’s only really been available to the public in its current form for the past year or so. And with the rise of these generative AI tools, like ChatGPT and Google Bard, AI is more accessible than ever.
But where does AI fit with Google Sheets?
And how do we use AI tools with Google Sheets?
In this post we’re going to look at how to use the most popular AI tools with Google Sheets. You’ll see how easy it is get started and learn that AI isn’t rocket science. It’s simply another useful tool that can save you time when you work with Google Sheets.
Specifically, we’ll look at three ways to use AI tools with Google Sheets:
Continue reading Three Ways To Use AI Tools With Google Sheets
This automatic data sharing technique first appeared in my weekly Google Sheets Tip newsletter #269, August 2023.
(Don’t miss out! Join today to get future editions.)
This post showcases a unique use case for Named Functions and IMPORTRANGE.
Suppose you want to include a standardized piece of text on the top of your Sheets, e.g. a legal disclaimer or perhaps your company contact details. Sort of like an email signature, but for your Sheet.
There’s a clever trick you can do with Named Functions and IMPORTRANGE to automate this across all your Sheets.
Continue reading Automatic Data Sharing Across Sheets With IMPORTRANGE and Named Functions
This post was born from my ongoing experimentation/obsession with the SPARKLINE function in Google Sheets.
We’ll see how to create a Join-The-Dots game in Google Sheets using only the built-in formulas, no code.
In this post, we’re going to take a 40,000 ft view of the Artificial Intelligence (AI) landscape and see how you can use it alongside Google Sheets to boost your productivity.
And, at the end of the post, I’ll answer the question about whether I think the AI hype is justified.
Before looking at what AI can do with Google Sheets though, let’s start with a quick AI 101 to ensure we’re up to speed with the lingo.
Continue reading What AI Can Do For You As A Google Sheets User. Is The Hype Justified?
