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, […]
Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work on the sheet simultaneously. In this tutorial, you’ll learn various to insert a timestamp in Google Sheets: Consider Taking a Course The basics of inserting a timestamps are pretty straightforward. But, they are […]
Fun fact, the checkbox is believed to have originated in the Roman empire. It came from the shortening of the word Veritas, meaning truth, to V. The V later evolved to look like the tick we are familiar with today. Checkboxes are a good way to keep track of data. Google Sheets recently added an option […]
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 […]
Google Sheets is an excellent platform with several features for free to small businesses and individuals, which has caused many people to convert from software like Microsoft Excel. Many people use spreadsheets to keep track of their finance, grades, or schedules. Some people use Google Sheets for data analysis, which can help understand patterns that […]
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 […]
There might be times when you want to know what weekday it is on a specific date in Google Sheets For example, you may want to know the weekday on your birthday, or on the first date of the next month. In such cases, you can use the Google Sheets day of week (WEEKDAY) Function. […]
Enjoy our custom-made Google Sheets templates for free via email access
