Prefer watching a video tutorial? View our “How to transpose Google Sheets “video here: If you’ve been working hard on a spreadsheet, what if you don’t like the structure of your data? You can flip your rows into columns using the TRANSPOSE Google Sheets formula. With step-by-step tutorials and screenshots, I’ll show you how to […]
Google Sheets fill down can save you a lot of time when doing data entry or working with data. To use the fill handle, Google Sheets recognizes a pattern and allows you to quickly use the pattern to fill down the data. For example, suppose you have 1 in cell A1 and 2 in cell […]
Are you wondering how to use a Google Sheets calendar template? You can easily create a simple Google Sheets calendar template. However, it may not be very efficient because you would also need to update it every month. To save you some time (and using the power of Google Sheets), I have created the following […]
The VLOOKUP Google Sheets function can be used to look for a value in a column and when that value is found, return a value from the same row from a specified column. Now if that description sounds nerdy and difficult, here is another way to understand what this function does. Suppose you have gone […]
Google Sheets named ranges can be used to define a cell or a range of cells and give it a name. Now, instead of using the cell references, you can use the name of the named range in calculations. For example, suppose I have sales transaction data for a store, and I need to calculate metrics […]
Whether you’re completely new to spreadsheets or coming from a different program, you’ve probably wondered how to insert multiple rows in Google Sheets. Luckily, doing so is simple. There are many different methods for inserting multiple rows in Google Sheets. For example, you can insert a single row by selecting a row header, right-clicking, and […]
Google Sheets has some great data formatting tools. One such formatting feature is the ability to rotate text within a cell in Google Sheets. Something as shown below: This article will teach you how to make text vertical in Google Sheets: Using the Toolbar Using the Format Options How to Make Text Vertical in Google Sheets […]
In this tutorial, you will learn how to highlight cells using conditional formatting based on another cell in Google Sheets. This can be done using the custom function option in conditional formatting.
Google Sheets has a number of different ways in which you can visualize and easily analyze your data. One of these ways is a heat map. A heat map is a good visual analysis layer to add to your data set to get some insights quickly. They are also surprisingly easy to create using heat map […]
Prefer watching a video tutorial? View ours here: If you work with Google Sheets, there may be times when you have to convert Excel files to Google Sheets. So can you convert Excel to Google Sheets? Although there’s no method relating to how to save Excel as Google Sheets, there are a couple of methods you […]
Here, I discuss how to create a dependent drop-down list in Google Sheets. This allows you to show a list of options that affects what a user sees on the next menu. Follow along for my step-by-step advice on dependent drop-down lists in Google Sheets. I provide screenshots and practical examples. How to Create a […]
Watch Video – How to Insert an Image in a Cell in Google Sheets Normally, the way people insert an image in a cell in Google Sheets is by going to Insert –> Image and the selecting the image or specifying the URL. The issue with this method is that it treats the image as […]
Enjoy our custom-made Google Sheets templates for free via email access
