Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Overview ImageMagick is an open source software suite for image manipulation. We can install it on our system using apt−get and then run commands through its command line interface (CLI). We’ll take a quick peek at some of the most popular methods for manipulating images with ImageMagick. Installation Let’s start by downloading ImageMagick, which we can install using our package manager (e.g., apt). We can also download the binary directly or compile it from the sources. After installing the software, let’s check whether we've successfully installed it by looking at its current status. $ magick -version Version: ImageMagick 7.0.8-13 Q16 ... Read More
Overview You may sometimes want to run several commands sequentially in Linux. To accomplish this, you can use command chaining. For example, if you wanted to download a compressed archive, decompress it, and then remove the resulting archive from disk, you could type these three commands together. Here, we’ll look at some methods for serializing commands using Bash in Linux. Even if they're already running. Inline Command Chaining Bash has great flexibility and powerful features for the end−users. We can create long sequences of instructions to perform any number of tasks. ... Chained operations ... Read More
Maintaining the value of a particular item at every instance of time is a very crucial process if the prices of the item change very frequently. If we want to note the value of an item in particular intervals, then we need to create a list that contains the time with hours/minutes/seconds increment. For example, such a list is quite useful in case of stock prices because they change rapidly. Although we can’t note every value, we can note the value for all particular intervals, like for every 15 minutes, to analyse its change of price. How to Add Time ... Read More
An email address of a person, in most cases, is generally a combination of the first and last name, ending with the host details such as @gmail.com, @yahoo.com, etc. Suppose we have an Excel sheet with two columns containing the first and last names of employees, then we can easily append their email addresses in a third column, by combining the data values of the first two columns. Adding Email Address to a List of Names We can follow a simple process to add email addresses to a list of names. Basically, this process contains two parts, the first step ... Read More
Let's suppose you need to add a particular text string in all the cells of an Excel sheet at the beginning or end of the existing data. It can be a tedious process if you decide to perform this such a task manually. In this tutorial, we will show you a simple method by which you can do it using a formula in Excel. We can add text in beginning or end using the same formula but the process is sequence of the work is different. Let us see the simple process to add text in bigging or end of ... Read More
Suppose you have an Excel sheet with a column of data and you need to add a string of text at a specific position in all the column data. In such cases, you don't have to type the entire data all over again to update the given column data. In this tutorial, we will demonstrate in a few simple steps how you can add the new data in between an existing set of data. Add Text in the Middle of Selected Cells in Excel Suppose we have an Excel sheet with a list of data that starts with the letter ... Read More
Let us assume a situation where we want to calculate the tax you need to pay on your total income. This problem has two steps first we calculate your total income by adding income from all your sources of income and the second step is to multiply it with the percentage of the tax you want to pay. We can solve this whole problem in a single calculation with the help of below information. here first we add the two numbers and multiply using one formula. Adding Two Numbers in Excel and Then Multiplying in One Formula Let us see ... Read More
When we have two separate columns in an Excel sheet which are to be combined, you don't have to create a new column and enter the whole data again. In this tutorial, we will show you two different ways to combine text cells together into one cell. You can either used the Ampersand symbol (&) or the CONCAT function for this purpose. We will take a simple example to demonstrate how it is done. We will take to columns that would contain the "first name" and "last name" of a set of people. Then, we will create a new column ... Read More
Sometime we may want to place a textbox above each bar of a bar graph to provide additional information. Such textboxes help the users understand the graph quickly and analyse the data in a better way. Most of the time, we use such textboxes to highlight the highest and lowest points in a graph, for example, highest and lowest sales numbers. Read through this tutorial to find out how you can follow a simple process to add a textbox above each bar of a bar graph. Adding Text Box To a Chart In Excel Here we will first create a ... Read More
Overview When working with Bash scripts or Unix/Linux command line tools, we often write the same command lines over and over again. Often, these command lines are long and must be repeated multiple times. For instance, when logging into a remote server daily, copying a local folder to the remote server, or searching for hidden files or directories within a directory. You can create aliases using the alias command. In this guide, I will show you how to create an alias that accepts parameters on Linux. This is useful if you want to run a single command repeatedly without having ... Read More