Spreadsheet

How to Use Image Function in Google Sheets

How to Use Image Function and Vlookup Images in Google Sheets

This Google Sheets tutorial is about Image VLOOKUP and IMAGE function. I haven't shared so far how to use Image function in Google Sheets. You can learn that awesome tips in this tutorial and...
Practical Use of ISBLANK Function in Google Sheets

Practical Use of ISBLANK Function in Google Sheets

ISBLANK and LEN are two functions that I always find useful in some sort of Google Sheets calculations. The function LEN has already found a space on this page. Now learn here how to...
Deduct Lunch Break Time From Total Hours in Google Sheets

How to Deduct Lunch Break Time From Total Hours in Google Sheets

Time calculation is important for preparing payroll, salary slip, hired equipment rental etc. With limited exposure to Time functions you can do this in Google Sheets. As an example learn here how to deduct...
How to Find All Lowest Price Items in Google Sheets

How to Find All Lowest Price Items in Google Sheets

Using SORTN function it's quite easy to find all lowest price items in Google Sheets. just look at the screenshot below. When you have quotes from multiple vendors for different items, you may want to...
Remove Duplicate Rows and Keep The Rows With Max Value

Remove Duplicate Rows and Keep The Rows With Max Value In Google Sheets

I've a table in Google Sheets which is the price list of few fruits items. See that table below. In that table, as you can see, same items repeated multiple times but with different...
How to Use ROWS Function in Google Sheets

How to Use ROWS Function in Google Sheets [Real Life Use]

It's rare to see people using functions like ROWS and COLUMNS in Google Sheets. Just like the function ROW, the function ROWS has also plenty of use. So first learn how to use ROWS...
How to Use Google Sheets Column Function and It's Advanced Use

How to Use Google Sheets Column Function and It’s Advanced Usage

Column function is not simply to find the column number in Google Sheets. It has a great role in formulas. Google Sheets Column function can be a backbone of many complex worksheet formulas. You...
Use of COLUMNS Function in Vlookup in Google Sheets

Use of COLUMNS Function in Vlookup in Google Sheets

There is one main advantage in the use of COLUMNS function in Vlookup in Google Sheets. It brings some dynamism to your Vlookup formula. In concise you can replace the "index" argument in Vlookup...

Google Sheets Formulas

Filter Data for Certain Number of Weeks in Google Sheets Using...

Do you know how to filter data for certain number of weeks in Google Sheets like 1 week, 2 weeks, 3 weeks etc.? If...

Inspiration

15 Inspirational Quotes to Live by This New Year [Picture Quotes]

New year is on our doorstep. Let bygones be bygones. Let's welcome this new year with new dreams and hopes. Get ready to accept new...