Latest

Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work with the whole column or the cell range you specify. What if we want to give a condition at the same time while doing the addition?  With SUMIF we can

When working with Google Spreadsheets, our tables can have decimals. Working with them is pretty easy in Google Spreadsheets. However, we often want to get rid of them for ease of reading and to avoid image crowding when displaying in graphics. We use the Round function to perform this function.

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs help us a lot for both ease of reading and analysis. Well, imagine that you made these graphs for the rows only, not for the whole table. This is great.

With Google Spreadsheets, we can easily retrieve data from the pages we browse on the internet. We can take data from a second-hand site we look at, examine it, and even show it on a graph. All we need to know here is the function syntax. The IMPORTXML function requires

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data on different pages. You may think of getting data with copy-paste. But this would not be a tiring and continuous practice. We can easily make this application with IMPORTRANGE. If

When working with Google Sheets, we can easily add images to our sheet. We can fit it inside the cell or add it on the page. The syntax is pretty simple. Let's explain the syntax and how the function works through the example below. What is the syntax of the

With the GOOGLEFINANCE function, we can easily transfer our data from the Google finance web application to our worksheet. We can receive real-time foreign exchange and financial information daily, and we can track stocks. In addition, we can get historical securities data, show them with graphics and easily share what