How to Remove Duplicates Without Any Plugin on Google Doc Spreadsheet

Duplicate contens can be appeared on your data due to typo graphical errors, careless entry or while applying copy and paste. Whatever the reason,...

Add-ons – Another Reason to Try Google Doc Spreadsheet

Google Doc gets add-on support! Get new fonts, style sheets, functions, templates and more additional features in the form of add-ons on Google Doc. Google...

Create Weekly or Monthly Progress Chart in Google Doc Spreadsheet [Ultimate...

Every systematic job will be based on a meticulous job schedule. But to achieve the goal, the schedule is not enough. We must strictly monitor...

Table of Contents – Yup! It’s Possible in Google Sheets

Can I create a Table of Contents in Google Sheets? If this is your question, my answer is "Yes". You can create Table of...

How to Remove Additional, Double or Extra Spaces in Google sheets

You can remove additional, double or extra spaces in Google Sheets with either using a function or a command. The function we can use...

Restrict People from Entering Invalid Data on Google Doc Spreadsheet

In this tutorial I will explain you how to use Data Validation on Google Doc Spreadsheet. It is important to use data validation to...

Convert Date to String Using the Long-winded Approach in Google Sheets

Today I was just about to write a Google Sheet Query function but I soon realised I should first write few other Google sheet...

How to Copy and Paste from Google Sheet to Excel with...

In this post we will check two aspects of the copy and paste formulas between two popular spreadsheet applications - Excel and Google Sheets....

Insert Interactive Tables in WordPress Posts Without Plugin Using Google Sheets

You can add interactive tables in your WordPress posts by using plugin or HTML. But I don't suggest plugins as sometimes it can become...

How to Get Subscript and Superscript Numbers in Google Spreadsheets

I'm back with another unique Google Sheet tutorial. This time we can learn how to use Subscript and Superscript numbers in Google Spreadsheets, a...

Create Gannt Chart Using Formulas in Google Spreadsheet

Earlier I've published few tutorials related to chart preparation in Google Spreadsheets using the Insert menu, Chart. It covered combination charts, line graph, bar...

Split Number to Digits in Google Sheets

You can split numbers to digits in a flash in Google Sheets. MID function is the solution for this. MID is a google sheet...

Simplified the Use of SUMIF function in Google Sheets

Before going to learn the use of SUMIF function in Google Sheets let me tell you one thing. It's a very handy function which...

Placement and Use of Single or Double Dollar Symbols in Formula...

You can often see people use the $ sign in spreadsheet formulas. I also use dollar symbols in formula no matter whether it's Google...

How to Revert Back to a Previous Version of Google Spreadsheet...

Recently I did an experiment with a Google Spreadsheet file. I had created a spreadsheet that can convert any given numbers to equivalent amount...

Amount or Numbers to Words Converter Using Google Sheets

We have created a Numbers or Amount to Words converter in Google Sheets. No scrip or plugin used. It's written using the inbuilt functions...

Auto Populate Information Based on Drop down Selection in Google Sheets

Spreadsheet applications are always enticing me. I know spreadsheets are just like an ocean. It carries hidden gems. You can do lots of things...

Choose Suitable Chart for Your Spreadsheet Data – How To

The story of Charts goes date back to 1786 when William Playfair,a Scottish engineer, invented several diagrams for economic data and it evolved a...

How to Use IFS Logical Function in Google Sheets [Also Nested...

Before learning how to use IFS logical function in Google Sheets, you should know the use of logical function IF. IF logical function helps you to...

How to Add Custom Text to Number that Can be Considered...

Adding text to number is quiet easy with a simple function called CONCATENATE or using the ampersand "&" symbol. I am not going to...

Trending!

Combined Use of IF, AND, OR Logical Functions in Google Doc...

Learn how to use important logical functions IF, AND, OR in Google Doc Spreadsheet. Logical functions are very easy to use if you get...

Social

721FansLike
108FollowersFollow
318FollowersFollow
51SubscribersSubscribe