As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time? Whether you’re experienced with Google Sheets or you’re just getting started, you’ll be happy to know there are many simple and time-saving Google Sheets keyboard shortcuts at your disposal. Keeping track of the numerous keyboard shortcuts may sound daunting but, luckily, I’m here with a list of Google Sheets shortcuts you can bookmark and return to again and again. 30 Google […]

Google Sheets is a great tool for tracking, analyzing, and organizing data for your company or business. While the application is user-friendly, it can be a bit tricky if you’re new to organizing data in a digital spreadsheet. But, don’t worry! Read on for an easy introduction to sorting in Google Sheets. First, know that there are many ways to sort data in Google Sheets. Some of the most common features marketers like you will use when working in Google Sheets are: Pivot tables – Useful for gathering data from a large database What-If analysis – Allows you to experiment […]

You’re working in a spreadsheet and you want to use a function. You write the formula, excited to get the results, then you see “Formula parse error” leaving you feeling confused and a little defeated. Let’s cover what that actually means and what probably lead to that error message. It’s like trying to speak a different language without taking the time to learn it first. The software can kind of make out what you’re saying, but not well enough to give you an accurate result. There are two likely causes for this error: There’s a typo in your formula, or […]

One of the most valuable functions in Google Sheets is the “IF” functions. Imagine you want to be able to quickly scan your spreadsheet and answer some key questions. This function will help you do that. Let’s jump into how it works and see some real-life examples. What does the if function do in Google Sheets? In Google Sheets, the if function allows you to check a condition and return a specific value if it’s TRUE. For instance, say you have three columns in a spreadsheet: channel, target, and profit. You want to know which channels hit a profit higher […]

Conditional formatting is a feature in Google Sheets in which a cell is formatted in a particular way when certain conditions are met. The formatting can include highlighting, bolding, italicizing – just about any visual changes to the cell. Just as it can be done for the cell you’re currently in, conditional formatting can also be set based on conditions met in another cell. Let’s dive into how to create this condition based on multiple criteria. How Conditional Formatting Works To learn how to set conditional formatting, let’s use this workbook as an example. It’s a workbook showing website traffic […]

A lot of the data you enter into your Google Sheets tables may be repetitive, like tracking whether an influencer you’ve reached out to for a partnership has agreed to working with you or not. It can get tedious to go in and type each yes or no as time goes on, which is where a critical tool, the drop-down list, becomes your best friend. In this post, we’ll go over how to add a drop-down list to your own Google Sheets data set to help save time. How to Add a Drop-down List in Google Sheets As mentioned above, a […]

Google Sheets is one of the best tools you can use to store data, track performance metrics, and create dashboards and reports. But while it’s a wondrous tool with countless features and functionalities, it can be hard to grasp for beginners — especially if you need to create a marketing report or dashboard, fast. Not to worry. If you’re looking to get started with Google Sheets, you’re in the right place. In this guide, we’ll be looking at the benefits of Google Sheets and walking you through some of the basics so you can get up to speed quickly and […]