Google Sheets
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 Sheets Keyboard Shortcuts 1. Select column Ctrl + Space (PC and Mac) 2. Insert columns to the left Alt + i, then C (PC), Ctrl + Options + i, then C (Mac) 3. Insert columns to the right Alt + i, then O (PC), Ctrl + Option + i, then…
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 with different scenarios for values and formulas to understand possible outcomes Charts – A simple way to visualize data in the form of a graph, diagram, or table While these features can also be found in Microsoft Excel, Google Sheets may be the better option for you. Unlike Excel, Google…
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 the order of operations is unclear. We’ll go over some examples of each so that you can identify and fix them in your own formulas. Common Formula Parse Errors Usually, a formula parse error happens because of: Incorrect syntax – E.g.: Typing =+ instead of =, forgetting to put quotation…
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 than the target. You can use the IF function to do so – the formula logic would look like this: If the target is higher than the profit, it will return “YES.” If not, it will return a “NO.” You can then track that data in another column titled “Goal…
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 year over year from Q4 2020 to Q4 2021, with the page views along with the year-over-year percentage change. Here’s what we want to accomplish here: When the percentage change is positive YoY, the cell turns green. When it’s negative, the cell turns red. This makes it easy to get…
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 drop-down list can help you easily change elements of a cell when the content is repetitive. The example data set for this walkthrough (as shown in the image below) is tracking the progress of marketing campaigns on different channels and the stage they’re in; not yet started, in progress, or…
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 efficiently. Benefits of Google Sheets for Marketing Saying that marketers are data-centric people is an understatement. Between return on investment, cost per acquisition, and more, they’re always looking at different metrics and reporting on progress. It can be tricky to keep all of those numbers straight, though. That’s where spreadsheets…
Google Sheets templates help you create better spreadsheets while saving you valuable time. A template knows what you need and offers it without any manual input, giving you the ability to focus on more important things — such as making sense of the data itself. In this post, we’ll cover every template you’ll ever need to easily and efficiently use Google Sheets for business, including templates for project management, reporting, people management, and customer tracking. You’ll learn: 1. Why you should use Google Sheets templates for business; 2. Step-by-step instruction on how to find the built-in Google Sheets templates; 3. A roundup of additional Google Sheets templates for any marketing role, including: Templates for Finances Templates for Reporting and Analytics Templates for Customers Templates for Project Management Templates to Help Lead a Team Let’s get started. Why use Google Sheets templates for business? Google Sheets templates are a fantastic business…