Google Docs

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...
COLUMNS Function in Google Sheets

How to Use COLUMNS Function in Google Sheets

COLUMNS and COLUMN are two different functions in Google Sheets. Here I'm simply detailing you how to use COLUMNS function in Google Sheets. But I'll be back with another tutorial where you can learn...
How to Create A Weekly Summary Report in Google Sheets

How to Create A Weekly Summary Report in Google Sheets

Have you ever created a weekly summary report in Google Sheets as shown above? If not get ready! You can learn here how to create a weekly summary report in Google Sheets. It looks...

Google Sheets Formulas

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...

Inspiration

15 Inspiring Quotes by Martial Arts Heroes for Success

Averybody likes to watch martial arts movies. It's sub-genre of action films. Martial Arts heroes like Bruce Lee, Jackie Chan, Van Damme and Jet...