Showing posts with label Google Sheet. Show all posts
Showing posts with label Google Sheet. Show all posts

How to Install Extension in Google Docs Google Sheet

Google docs is an important  word processing platform. Google Docs extension can help you in  your work. You can install Google Docs extension in spreadsheet as well as docs. Google Docs extension written by  Google app script. you can write your own extension.

How to Give Reference Another Sheet in Vlookup Evaluation in Google Sheet

Vlookup is a most useful function of Google sheet  that helps to search and element in a range of column. You can also use vlookup in  Microsoft Excel. but the way of using vlookup by reference in Google sheet and Microsoft Excel might be different. if you are searching  an element within the Sheet vlookup function this is something easier. and the Sintex is following.

How to Auto Replace in Google Docs With Capitalization & Formatting

Suppose you want to replace

YouTube as YouTube
Google Drive as Google Drive
Google docs  inbuilt with auto replacing tool, but it Cannot   capitalize for format your text .There are many addons that is   promising to do this but they are not capable of doing this .If you want to replace and format your text that means replace your text with formatted text then in this should go to manually find this and then replace so this is something lengthy process and it takes. time this task can be simplified by using Google script. but again this is limited to some word that you have put into your script so whenever you want to replace something by some new text formatted you have to put this into a script editor and then this task will be completed accordingly. now to simplify this task I have created a  Google sheet .

How to Apply Vlookup in Google Sheet ?

What Is Vlookup ?


Vlookup is a function of Google Sheet that search   for a value in a range of column of Google sheet. When you want to search for a value in certain range of Google Sheet  and want to return a value in this case vlookup is applicable.You can also use a formula attribute for searching in vlookup.Vlookup  is an important wanted function that most likely to be used when you want to interpret your data in Google Sheet .