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

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

Algorithm

Before understanding the Algorithm, let us find  why we need Algorithm.  Algorithm is used to get satisfied result or output from unsatisfied result or state this state is called Problem. We need algorithm to solve the problem of any process. Let us understand algorithm in simple way Suppose we want to bake a delicious cake. We need some raw materials like sugar, flour , water and cooking gas to get desired…

Read More