Latest

When working with Google Sheets, we may want to import tables or lists from the pages we browse the internet on our own. No need to bother with copy-paste. Because format it again is a waste of time. We can easily do this with IMPORTHTML. It is a very useful

We can combine the dates written separately as the month, year, day in Google Spreadsheets, rotate the instant date, and find out x date is which day in the date. We will examine many more functional features like this one by one. The date format with Google Sheets uses the

When working with Google Sheets, we may sometimes need to search within the table. We may need repetitive data. For example, we may want to know how many of x items in the sales table were sold. Fortunately, it's pretty easy to do in Google Sheets. With COUNTIF, we can

We may be working with very large worksheets in Google Sheets. There may be missing data in our table. Or we can have a painting that we fill out when it happens. For example, it can be a table that we fill as we make sales and add as we

When working with Google Sheets, we may wonder how many cells with numerical data we have. Let's get the products sold and the selling price. Since there will be numbers for the products sold, we can easily learn how many products are sold. It's pretty easy to count cells containing

One of the functions that we use frequently in daily life is averaging. Especially if we are dealing with sales data, it has many uses such as average daily sales, average discount applied. While working with Google Spreadsheets, we can write the function manually as well as access it with