I’m here to discuss how to use VLOOKUP from another sheet in Google Sheets. My goal: Help you increase your productivity with some simple automation. After all, that’s why I love the VLOOKUP function. Below, I’ll break down the syntax and include screenshots for step-by-step instructions on how to use it. Here’s my guide on […]
If you are given a spreadsheet with numbers, it will be easy to pull off some of the formulas required to properly calculate whatever it is that you are trying to analyze. On the other hand, the “text” format of those numbers can make it very difficult and sometimes even impossible to pull these same […]
Wondering how to use Google Sheets to compare two columns? I love how easy Google Sheets makes streamlining data, especially when I remember how complicated manual tasks used to be! With the right formulas, Google Sheets automates the process, returning results almost instantaneously. My tutorial will show you how to compare two columns in Google […]
Histograms are an incredibly useful way to show how data distributes into groups in a larger range. A histogram sorts data into “buckets” of closely related values instead of by unique values. Google Sheets features an easy-to-use, built-in histogram graphing tool. Instead of listing how many times someone scored a given percentage on a test, […]
Sorting by color in Google Sheets is just a few mouse clicks or screen taps away. Google added this capability to the Sheets app in March of 2020. You can use the color sorting to arrange cells by both fill (background) and text color. Enabling the Sort by Color functionality Google Sheets enables the color […]
How to Make a Pie Chart in Google Sheets – Step-by-Step Video Tutorial: How to make a pie chart in Google Sheets? Pie charts are a great way to visually represent data because they are easy to create and analyze. You can create your own pie chart on Google Sheets very easily. Google Sheets also […]
Spreadsheets these days are all about automating as many of your tasks as possible. Imagine a scenario where you have to process an order, create an invoice, and then email the invoice to concerned parties while updating all necessary order details to a spreadsheet. Believe it or not, it’s actually possible to do all this […]
If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data or modify it easily. One of the common tasks that many people need to do is capitalize the first letter (alphabet) in Google Sheets. In this tutorial, I will show […]
Are you looking for a Google Sheets remove last character step-by-step guide? When working with data in Google Sheets, sometimes you must remove the last character from a string (or remove the last 2 or 3 or 5 characters). This can easily be done using some basic formulas in Google Sheets. In this tutorial, I […]
Looking for a leave tracker Google Sheet template that can track the leave of your employees or students? You’re in the right place. In this post, I am sharing one of my best templates – the employee vacation tracker template in Google Sheets (you can also use this as an employee paid time off tracking […]
Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According to Wikipedia – a sparkline is a small graphic designed to give a quick representation of numerical or statistical information within […]
Are you wondering how to remove gridlines in Google Sheets? Just like most of the spreadsheet tools, Google Sheets has gridlines around the cells. But what are gridlines? Gridlines help to make your data look more clear by distinguishing the different cells in the worksheet. They are used to connect the worksheet’s rows and columns, […]
Enjoy our custom-made Google Sheets templates for free via email access
