Watch Video – How to use Google Sheets’ Split Text to Columns tool Are you wondering how to use Google Sheets’ split text to columns tool? The answer is simple, you can quickly split the contents of a cell (or a range of cells) into columns, using the Split Text to Columns feature. This is …
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 …
Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following, and I see many people migrating from other spreadsheet applications to Google Sheets. The fact that you can use it for free (as it comes with every Google account) is a huge reason for this …
While Microsoft Excel still rules the spreadsheet world, Google Sheets has been slowly making inroads. It has found some loyalists in freelancers, small business owners, and entrepreneurs. While it is still not at a stage where it can crunch data like Excel or automate tasks using VBA, it does have a few advantages over Excel …
Recently, I was working on creating a leave tracker template in Google Sheets. One of the interactive features that I wanted to create was a spin button (or scroll bar) functionality, where the user can simply click on it and the value of a cell change. While it’s easy to insert and use spin buttons …
I am a fan of creating to-do lists and trackers. And Google Sheets is my weapon of choice. Since I have created a lot of these lists and trackers, I decided to merge all my trackers into one single Google Sheets document and then use this master tracker instead. And to do this, I had …
Watch Video – Creating and Using Filter Views in Google Sheets Google Sheets has this amazing functionality to collaborate with other users. However, one issue when multiple people are working with the same file is that when someone changes the data, it gets changed for everyone who is working on that data. Filter Views in …
Inserting Table of Contents can be useful if you have a lot of content and you want to quickly skip to relevant sections. If you have used word processors such as MS Word or Google Docs, you would find an easy way to insert the table of contents. But what if you want to insert …
Watch Video – How to Search in Google Sheets and Highlight Matching Data If you work with huge datasets in Google Sheets, sometimes, it may get difficult to identify some data points. For example, if you have a list of students and their marks, it can take some time to find a student name and …
Do you want to learn how to freeze a row in Google Sheets? You’ve come to the right place! In this detailed guide, I’ll discuss how to freeze and unfreeze rows or columns in Google Sheets with my step-by-step instructions and screenshots. While there are several methods of freezing rows, the quickest and easiest way …
A drop-down list in Google Sheets can be helpful when you want the user to select from pre-defined options. It’s a great way to make the data entry consistent. Watch Video – How to Add Google Sheets Drop-Down List For example, a user from a drop-down list can select easily the country as the US. …
Ready take your Google Sheets skills to the next level? Want to lift your productivity without breaking a sweat?
Sign up for our free newsletter for regular spreadsheet guidance.
Enjoy our custom-made Google Sheets templates for free via email access
