A QR code, short for a Short Response code, is a kind of complex matrix barcode that can be read by a QR scanner in a smartphone or other device to convey information. It can include login information, statistical data, instructions, and much more. Google sheets allow you to create and store QR codes quickly […]
How to Create a QR Code in Google Sheets Read More »
Simple bar charts are the most common when it comes to data visualization. However, scatterplots can be a very crucial method when it comes to data presentation. A scatterplot can be defined that shows 2-dimensional space values using coordinates. It is very important because it shows you the relationship between two variables the trend and
How to make a scatter plot on google sheets Read More »
Cells are the individual boxes within a row or a column in google sheets. The cells might need to be added especially when one needs to add some data that could have been left out accidentally. Therefore I will use the windows chrome version of the google sheets to explain how you can add cells
How to Add Cells in google sheets Read More »
Using google sheets poses a challenge. While you may think that there is an icon for selecting the bullet points, there is no such icon. However several options exist regarding the addition of bullet points in the excel google sheet. You may copy bullets of your choice and paste them in the google sheet cells.
How to add Bullet Points in google sheets Read More »
Google sheets menu does not contain the bullet list. However, this does not mean that we cannot use bullet points in presentations using google sheets. There is a way of adding bullet points. In this article, I will explain how you can insert bullet points using the CHAR function. Steps to add bullet points in
How to add Bullet Points in Google Sheets Read More »
If you like collecting, representing, and analyzing data then you must know that drawing scatterplots is very beneficial. However, most people find it hard to make a scatter plot and find a line of best fit when it comes to google sheets and Excel. But I like using google sheets since it has many more
How to make a scatter plot with a line of best fit in google sheets Read More »
Sometimes when you are dealing with so many numbers in a spreadsheet, you may want the negative number to stand out. Luckily there are so many ways that you can use to show negative numbers in red when it comes to google sheets. We are going to cover two of the easiest methods, i.e. custom
How to make negative numbers red in google sheets Read More »
The two of the most common thing you will do in Google Sheets are to find the sum and average of sets of value. Type an equal sign, And the function you use to find the sum is the sum, Followed by a left parenthesis, and then all you need to do is select the
How to add numbers in google sheets Read More »
Working with google sheets sometimes requires one to create a dropdown list of items where one can choose from. These items can be numbers, list of items, or even data. The cell where the drop-down appears shows an arrow pointing downwards. In this article, I will give a detailed step by step explanation on how
How to add drop-down in google sheets Read More »
