Google Sheets recently added an option to insert a checkbox in a cell. In this tutorial, I will cover everything you need to know about using checkboxes in Google Sheets, along with some useful examples. Click here to download the example file and follow along (you will have to make a copy to use it). Inserting …
Read moreHow to Insert Checkbox in Google Sheets (with Examples)
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 …
Read moreSparkline in Google Sheets – The Only Guide You Need
Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets. The fact that you can use it for free (as it comes with every Google account) is a huge reason …
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 …
Read more10 Google Sheets Tips that’ll Help You Get Work Done Faster
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 …
Read moreHow to Insert Spin Button in Google Sheets (to change cell values)
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 …
Read moreHow to Copy a Sheet from One Google Sheets to Another
The term data analysis is dreadful for most of us. We equate it with humongous data sets, complex tools, difficult to decipher charts etc. However, it is one skill that we should look to master if we want to succeed in our work. In a 2009 interview Hal Varian, Google’s chief economist stated: [pullquote align=”normal”]But …
Read more4 Steps for Quick and Easy Data Analysis with Google Sheets
Looking for a leave tracker template in Google Sheets that can track leaves of your employees or students? You’re at the right place. In this post, I am sharing one of my best templates – the leave tracker template in Google Sheets. Click here to access the leave tracker template [You will have to make a …
Read moreLeave Tracker Template in Google Sheets (Updated for 2018)
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 …
Read moreHow to Create and Use Filter Views in Google Sheets
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 …