My Blog My Blog

How to Make a Histogram on Google Sheets [5 Steps]

Google Sheets
/by
How to Make a Histogram on Google Sheets Google Sheets offers many data visualization tools within its platform, with one of the most popular ones being the histogram. Read more to learn what exactly a histogram is, what it’s used for, and how to make one on Google Sheets. What is a histogram and what is it used for? A histogram is a graphical representation showing the distribution of data points that have been grouped into specific ranges or categories. Say you have a blog and you have blog posts ranging from 1 to 500 words, 500 to 1,000 words, and 1,000 to 2,000 words. You want to analyze which bucket gets the most organic traffic. You can use a histogram to accomplish this. While a histogram looks like a bar chart, the two are not interchangeable. A histogram displays the frequency distribution of variables within a data set. A bar graph, however, serves as a comparison between separate variables. Now that you know how to use it, let’s go over how to make one. How to Make a Histogram on Google Sheets Select your data set. Click on "Insert" then select "Chart." Click the drop-down menu in "Chart Type" then scroll down to the "Other" section. Review your histogram. Edit your chart by clicking on the three dots and then clicking on "Edit chart." Use the chart editor to...

30 Google Sheets Shortcuts Marketers Need to Know

Google Sheets
/by
30 Google Sheets Shortcuts Marketers Need to Know 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 O (Mac) 4. Select row Shift + Space (PC and Mac) 5. Insert rows above Alt + i, then R (PC), Ctrl + Option + i, then R (Mac) 6. Insert rows below Alt + i, then W (PC), Ctrl + Option + i, then B (Mac) 7. Select all Ctrl + A (PC), Command + A (Mac) 8. Fill range Ctrl + Enter (PC), Command + Enter (Mac) 9. Fill down Ctrl + D (PC), Command + D (Mac) 10. Fill right Ctrl + R (PC), Command +...

How to Sort in Google Sheets

Google Sheets
/by
How to Sort in Google Sheets 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 Sheets doesn’t require a paid subscription. The tool is free for anyone with a Google account or Google Workspace account. Many users also find Sheets a more optimal tool for collaborative projects when compared to Excel. So, how do we get started sorting in Google Sheets? Let’s dive in. Sorting by Sheet Vs. Sorting by Range in Google Sheets The latter is especially helpful if your spreadsheet contains multiple tables and you want to organize one table without disrupting the others. For example, the spreadsheet below is...

Formula Parse Errors: What They Are & How to Fix Them

Google Sheets
/by
Formula Parse Errors: What They Are & How to Fix Them 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 marks around text values, putting two operators next to each other without anything in between them Incomplete syntax – E.g. Leaving out a parentheses. Another reason why you may be getting these errors is that you’re trying to use text values where numbers are expected. Let’s dive into the specific types of errors you may encounter: #N/A Error One of the most common errors is the #N/A error. It occurs when a formula can't find what it's looking for. For example, if you're using the VLOOKUP function to...

How to Use the If Function in Google Sheets

Google Sheets
/by
How to Use the If Function in Google Sheets 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 Met." How to Use If Function in Google Sheets When using the if function in Google Sheets, you must use the following syntax: IF(logical_expression, value_if_true,value_if_false) Let’s break down what each one means: Logical expression refers to the condition you’re checking in the function. Value if true is the value the function will return if the logical expression is true. Value if false is the value the function will return if the logical expression is false. To do this, you’ll need to use the following logical...

How-To: Conditional Formatting Based on Another Cell in Google Sheets

Google Sheets
/by
How-To: Conditional Formatting Based on Another Cell in Google Sheets 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 quick performance overview before diving into the details. Here are the steps to set the conditional formatting. 1. Select the cell you want to format, click on "Format" from the navigation bar, then click on "Conditional Formatting." 2. While staying in the "Single color" tab, double-check that the cell under "Apply to range" is the cell you want to format. 3. Set your format rules. It may automatically default to a standard conditional formatting formula. In this case, open the dropdown menu...

How To Create a Google Sheets Drop-down Menu

Google Sheets
/by
How To Create a Google Sheets Drop-down Menu 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 completed. I want to create a drop-down menu so I can easily go in and change the status of the campaign as time goes on. Before going through the steps, it might be helpful to see what a drop-down menu looks like so you can contextually understand each instruction. The gif below shows a final drop-down menu and how it applies to the sample data set. Let’s go over how to add a drop-down list to your Sheet. 1. In the toolbar header, click Data. 2. In the...

20 of the Best Free Google Sheets Templates for 2021

Google Sheets
/by
20 of the Best Free Google Sheets Templates for 2021 Whether your marketing position requires you to send invoices to clients, track website analytics, or create budget and expense reports, you’ve undoubtedly found yourself working with spreadsheets in some form. And if you’re anything like me, those spreadsheets can feel frustratingly tedious when you’re under a time crunch. Fortunately, Google Sheets offers 26 pre-built templates, allowing you to create reports and analyze data in spreadsheets faster and more effectively. Best of all, Google Sheets templates cater to specific categories. For instance, if you click the Paid Traffic Report template, your spreadsheet is already organized into Overview, 12-month Trends, and Medium Breakdown categories. It knows what you need and offers it without any manual input. Here, we'll dive into 20 of the best free Google Sheets templates for any marketing role in 2021, so you can create better spreadsheets while saving valuable time to focus on more important things — like making sense of the data itself. Before we properly delve into the templates, let’s see why Google Sheets is an excellent choice for free templates and how you can find these templates. Why use Google Sheets? Google Sheets is part of Google’s G Suite of software that has over 6 million users. Here are some reasons why you should consider using it too: 1. It's free. Even if you don’t pay for Google’s G Suite, you can still...