Tag google sheets

December 14, 2023

5 Excel and Google Sheets tricks every SEO should know

By Nikki L in Marketing Tag excel, google sheets, seo

by Maria Georgieva for Search Engine Land Amid the popularity of generative AI tools, spreadsheets are still essential tools for marketing analytics. When it comes to organizing, cleaning, and analyzing data, Microsoft Excel and Google Sheets have stood the test of time. All the famous SEO tools export most of their data in CSV format. And while you can use genAI for data analysis, often you’ll still need a good old spreadsheet to get started. So let’s dive back into the basics and see how you can make your life as an SEO and digital marketer easier with these five tips to…

June 23, 2023

How to Use The Query Function in Google Sheets

By Nikki L in Information Technology Tag analyze data, data analysis, google sheets, manipulate data, query function

by Scott Weiss for HubSpot The query function is so helpful because it can replace the work of many other commands and replicate the functionality of pivot tables (a table that lets you group, compare, and summarize larger data sets). A query may seem complicated or overwhelming if you’re unfamiliar with Google Sheet functions. However, this is not the case, and you can start using the query function right now to filter and quickly look up data in your preferred format. Table of Contents What is a query in Google Sheets? What syntax should I understand to use the query function? How…