How to Change the Margins in Google Docs [Step by Step Tutorial]
Watch Video – Change Margins in Google Docs Sometimes, you may want to change the margins in Google Docs to make it more suitable when printed or to suit your project/company guidelines. In this tutorial, I will show you how to quickly change the margins in Google Docs. You can change the margins in Google […]
Continue Reading >>How to Quickly Transpose Data in Google Sheets
While working with data, sometimes you may need to transpose data in Google Sheets. But you don’t need to do this manually. In this tutorial, I will show you two great ways to transpose data in Google Sheets: Using Paste Special. Using Transpose function. Transpose Data Using Paste Special Suppose you have a dataset as […]
Continue Reading >>How to Fill Down in Google Sheets Using Fill Handle
Fill handle in Google Sheets can save you a lot of time when doing data entry or working with data. It works by recognizing a pattern and then 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 A2, you […]
Continue Reading >>Calendar Template in Google Sheets (Monthly and Yearly)
You can easily create a simple static calendar template in Google Sheets. However, you would need to update it every time the month or the year changes. To save you some time (and using the power of Google Sheets), I have created a template that would automatically update the calendar when you change the month […]
Continue Reading >>How to Get the Word Count in Google Docs [in less than 5 seconds]
Google Docs is an amazing word processor tool that allows you to write from anywhere or from any device. I write all my blog posts in Google docs and then move it to WordPress later. Using Google Docs means that I can write using my mobile phone when I am traveling, in a coffee shop, […]
Continue Reading >>The Ultimate Guide to Google Sheets VLOOKUP Function (with Examples)
Google Sheets VLOOKUP 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 to […]
Continue Reading >>Named Ranges in Google Sheets – All You Need to Know
Named Ranges in Google Sheets 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 […]
Continue Reading >>How to Quickly Insert Multiple Rows in Google Sheets
What do you do when you want to insert multiple rows in Google Sheets? Do you insert one row at a time? While this can be a valid way to do this, it is time-consuming and inefficient. Let me show you a faster way to insert multiple rows in Google Sheets. Suppose you have a […]
Continue Reading >>How to Rotate Text in Google Sheets (in less than 5 seconds)
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: Here are the two ways you can rotate text in Google Sheets: Using the Toolbar Using the Format Options Using the Toolbar Here are the steps to rotate […]
Continue Reading >>How to Count Cells If Not Blank in Google Sheets
Sometimes you may have a dataset where some of the cells or rows are blank. In such a case, if you want to count cells that are not blank, then you need to rely on Google Sheets count functions. In this tutorial, I will show you how to count cells if not blank in Google […]
Continue Reading >>