Google Sheets Query function: Learn the most powerful function in Sheets
Learn how to use the super-powerful Google Sheets Query function to analyze your data in Google Sheets. Includes template.| www.benlcollins.com
Learn how to use the super-powerful Google Sheets Query function to analyze your data in Google Sheets. Includes template.| www.benlcollins.com
Learn Google Apps Script with this Beginner guide. See how to extend Google Sheets, Google Docs and other Workspace apps with Google Scripts.| www.benlcollins.com
Create your own fully customizable, automated personal finance tool in Google Sheets to track your spending habits and hit your saving goals.| www.benlcollins.com
Slicers in Google Sheets are powerful controls you add to reports to make them interactive, by filtering data in Pivot Tables and Charts.| www.benlcollins.com
Learn how to use Pivot Tables in Google Sheets. Pivot Tables are amazingly powerful and very easy to use once you know how.| www.benlcollins.com
Learn how to use the Google Sheets checkbox to toggle cells checked/unchecked in your Google Sheets and make them more interactive.| www.benlcollins.com
See how to build a dynamic dashboard in Google Sheets, using formulas and data validation methods so charts change dynamically with user input.| www.benlcollins.com
Learn how to create dynamic charts in Google Sheets and bring your data to life, using this data validation trick to create drop down menus.| www.benlcollins.com
Unpivot in Google Sheets with formulas. Transform wide data into tall data, which is better for data analysis. For formula connoisseurs!| www.benlcollins.com
Complete guide to using the AI Function in Google Sheets with 10 real-world examples, including example prompts.| www.benlcollins.com
Learn how to use Smart Chips in Google Sheets to take full control of your data. Smart chips bring extra information to your Sheets.| www.benlcollins.com
Learn how to create a Google Sheets Drop Down Menu and add interactivity to your Sheets. Build better data input systems and dynamic charts.| www.benlcollins.com
The AI Function in Google Sheets brings the power of Gemini AI directly into your cells.| www.benlcollins.com
Did you know that by changing the URL of a Google Sheet we can change how it behaves? In this post, we look at 11 incredibly useful URL Tricks for Google Sheets. For example, we can create a URL that automatically downloads the Sheet as a PDF. Or create a template ready for copying. And … Continue reading 11 Incredibly Useful URL Tricks for Google Sheets The post 11 Incredibly Useful URL Tricks for Google Sheets appeared first on .|
OpenAI recently launched their agent tool called Operator. It’s an AI powered tool that can navigate the web and perform tasks for you using its own browser. It can click, type, scroll, and generally interact with web pages the way you or I would. Naturally, I tested it out with a Google Sheets project to … Continue reading I Let OpenAI Operator Manage My Google Sheet: Here’s What Happened. The post I Let OpenAI Operator Manage My Google Sheet: Here’s What Happened. appeared first on .|
January 2025 Hardly a week passes at the moment without some technology announcement that makes me go “wow!”. This week it’s Google’s AI Studio that has been impressing me, offering a glimpse into what the future of software education could look like. What’s different with this tool is that it lets you share your screen … Continue reading Can AI Studio teach me how to build a pivot table? The post Can AI Studio teach me how to build a pivot table? appeared first on .|
One of my goals this year is to experiment with AI tools and have fun doing it. This is the first in the series, using Open AI’s Sora text-to-video tool to create a fictional advertisement for Polar Explorers back in the polar heyday: The sheer number of daily AI announcements and new tools feels overwhelming … Continue reading AI Experiments: Using Sora AI to Generate Videos The post AI Experiments: Using Sora AI to Generate Videos appeared first on .|
Welcome to Annual Review number 10! Ten! TEN!! Ten years in business. Ten years working for myself. As I write this, I still can’t quite believe that it’s been ten years. In some ways it feels like only yesterday that I was wearing a suit to an office on K-Street in Washington DC, and yet, … Continue reading 2024 In Review And A Look Forward To 2025 The post 2024 In Review And A Look Forward To 2025 appeared first on .|
This is a guest post from Kyle Horst of Kirksville Web Design. Introduction Google Sites is an amazing app for bringing together information across an organization’s Google Workspace domain. However, Google Sites doesn’t natively have a CMS, databases or even a decent option for basic tables. Therefore, Google Sheets is hugely important for building a … Continue reading How to Use Google Sheets in Your Google Sites The post How to Use Google Sheets in Your Google Sites appeared firs...|
30 September 2024 DENIZENS OF THE SHEETS UNIVERSE: I’m launching something special. I’ve been thinking about it for over a year. And today I’m excited to invite you to join the Sheets Insiders membership. In this post, I want to explain what Sheets Insiders is and why I’m launching a membership. What Is Sheets Insiders? … Continue reading Introducing The Sheets Insiders Membership Program The post Introducing The Sheets Insiders Membership Program appeared first on .|
The drop down menu feature in Google Sheets is useful for efficient data entry. It can also be used to create dynamic spreadsheets, for example, dashboards that change based on choices a user makes. At the end of July 2024, Google announced multiple selections in drop downs (scheduled to roll out in late-August/early-September). This is … Continue reading Multiple Selections in Drop Downs in Google Sheets The post Multiple Selections in Drop Downs in Google Sheets appeared first on .|
The GETPIVOTDATA function is used to extract data from a pivot table. Pivot tables are one of the most powerful and useful features in spreadsheets. We use them to summarize our data, by grouping, sorting and filtering it. But pivot tables are dynamic elements. That means they can change size and shape when data is … Continue reading GETPIVOTDATA Function in Google Sheets: How To Extract Data From Pivot Tables The post GETPIVOTDATA Function in Google Sheets: How To Extract Data From Pivot T...|
Learn how to use powerful Tables in Google Sheets. Benefit from built-in data validation, data analysis tools and better formula references.| www.benlcollins.com
