Import data from one spreadsheet to another spreadsheet in google sheet – importrange()

Hi Readers, As we got some queries from our readers about importing data from one spreadsheet to another spreadsheet. Therefore we will use two important functions IMPORTRANGE() and VLOOKUP().We will understand about our IMPORTRANGE()  in this article. We understand presenting data on conditions basis in our next post. Let us follow below steps to import data from one spreadsheet to another spreadsheet in google sheet. 1.Create a file in google…

Read More

Convert all the contents into the uppercase in Linux Using Shell Program

Hello Readers, I am happy to bring a new article for convert all the contents into the uppercase in Linux using Shell Program. Let’s Go through below code.  

 

Read More

Linux – Find first five lines of a file

Hello readers, Let us find specific number of lines of a file. Use the head command. Command :

-lines is to specific lines of file that you want to read. filename is the name of file which lines you want to read.   Example:

Output : hello world this is first line. hello world this is second line. hello world this is third line. hello world this is…

Read More

Sending email in Gmail

Sending email in Gmail Hello guys,Now-a-days, Email is a great way of connecting with friends and family . We can send email with few clicks using Gmail. So Let us follow the below steps to send your first email to your beloved ones. Step 1-  Go to gmail.com. Step 2– Log into your gmail account . Step 3– Click on compose button . Step 4– Enter the recipient email ID ….

Read More

How web works

Web works A website presents a view of webpage of a site with text , graphical image and animation which requests through web accessing software (Browser). Short story of web A client is a computer , phone or other internet connected devices which sends request to server through browser. A server that stores files , folder and datas of a site,  accepts request from client send back a copy of…

Read More

How to Impress your boss by easy ms excel tricks

Hello tech lovers!  Many professional guys especially fresher are not able to fall good impression before boss or seniors when they do not know the shortcuts of ms excel which save their more time.Therefore, in this tutorial we will discuss about some easy tricks of MS-excel that will make his work easier and faster. 1.  Alt +  = If you do want to write sum formula to find the total…

Read More

The Purpose of special directories in Linux System.

Hello Readers ! Today we are going through brief description for special directories in Linux System which will help you to understand the purpose of directories . /bin : This directory contains executable programs and commands like ls ,pwd in this directory. To minimize the functionality for the purposes of booting and restarting the system. /dev: This directory contains all devices files which are created after installation and  executing /dev…

Read More

Find difference of two date time into hours,minutes,seconds in MS Excel

Hello readers ! Today we are going to learn  how to find difference between two date times  using MS Excel that can be useful for finding the working hours of employee. Let us follow below steps for it. Step 1. Open a new excel file in MS Excel 2007. Step 2. Make two columns with names – start time and end time with value as shown below image . Step…

Read More