IMPORTFEED function in Google Sheets can be used to import the RSS feed in the worksheet. This can be useful if you want to keep track of new blog posts or news items on your favorite website. For example, you can create a list of websites that you want to follow and quickly get the […]
A feature that used to be missing from Google Sheets zooming. Thank heavens they added the ability to Zoom In and Zoom Out in Google Sheets. Now, that we can zoom out in Google Sheets, we can avoid straining our eyes and be able to see better. Of course you can also use the older […]
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.
Heat maps make it easy to spot patterns in your data at a glance. This guide covers how to build four types of heat maps in Google Sheets using conditional formatting, including gradient scales, single-color thresholds, geo charts, and calendar maps.
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 […]
Enjoy our custom-made Google Sheets templates for free via email access
