The tools that are used to represent the set of data in a pictorial form that will help us understand the data better are known as charts in Excel. They can also be called graphs. There are various kinds of graphs based on their structure and their uses. The small numerical number that can be used to show the value of a component of a graph is known as a "Data label." Data labels help the user analyse the graph in a better way. This tutorial helps the Excel user know how to add or move data labels in Excel. ... Read More
Analysing doughnut charts could be a complex process if there are no leader lines for the data. The line that connects the data label and its associated data is known as the "Leader line." Although using a leader line is not the default in Excel, we can add leader lines to the doughnut chart using this simple process. In this tutorial, we will discuss how we can add leader lines to a doughnut chart in Excel. Adding Leader Lines to a Doughnut Chart Here we will first create a doughnut chart, convert it into a pie chart, and then ... Read More
When we collect raw data in Excel, there is a chance that we will find duplicate data, which will affect or be redundant with our analysis. If the same data is present in Excel two or more times, then it can be called duplicate data. When we collect the names of all the people in a group, there is a possibility that we have written a person's name twice. Adding a unique ID to each piece of data allows us to detect and remove duplicates. In this tutorial, let us see a simple process to know how we can add ... Read More
When we create a hyperlink in Excel, the whole cell will work as a hyperlink. There is no way we can make the part of the cell work as a hyperlink. But I will explain a simple trick to see that a hyperlink is created for part of a cell. On a website, a hyperlink (or link) is an item like a word or button that points to another location. When you click on a link, the link will take you to the target of the link, which may be a webpage, document, or other online content. Websites use hyperlinks ... Read More
In this tutorial, we will write a go language program to remove duplicate elements from an array. By removing the duplicate entries, we mean that we wish to remove a value repeating multiple times. In this tutorial, we are using examples of an array of integers as well as an array of strings. Method 1: Remove Duplicate Values from an Array using an External Function The following code illustrates how we can remove duplicate values from an array of integers using a user-defined function. Algorithm Step 1 − First, we need to import the fmt package. Step 2 − ... Read More
In this tutorial, we will see to write a go language program to calculate the average of numbers using arrays. We are creating two programs in this example. In the first method, we are using a user-defined function to calculate the average while in the second one we are using an internal go function to find the same. Method 1: Calculate the Average of Numbers using Arrays In this method, we will create a separate function and pass the array to it. The function accepts the array as an argument and then after calculating the average it returns the ... Read More
In this tutorial, we will write a go language program to multiply two matrices by passing them to a function. In order to achieve this result, we will use both single dimension and multi-dimensional matrices. The difference between a single-dimension array and a multidimensional matrix is that the former has the same order while the latter has a different order of rows and columns. Method 1: Multiply Two Matrices of the Same Order by Passing them to a Function In this method, we will see to multiply two matrices of the same order bypassing the matrix to a user-defined function ... Read More
In this tutorial, we will write a go language program to multiply two matrices. The difference between a single-dimensional array and a multi-dimensional array is that the former holds an attribute while the latter holds another array on the index. Additionally, every element of a multidimensional array will have the same data type. Method 1: Multiply Two Matrices using Multi-Dimensional Arrays in the Main Function In this method, we will write a golang program to multiply two Multi-dimensional matrices using for loops in the main() function. Algorithm Step 1 − Import the fmt package. Step 2 − Now, ... Read More
Insertion sort is defined as an In-Place Algorithm and it is declared as a stable algorithm. The idea of sorting an array in ascending or descending order by swapping an element can be used to implement Insertion Sort. For instance, if the array contains only one item in the list, then it is considered sorted. Otherwise, we consider that a certain portion of the list of elements is sorted while other is unsorted. Proceeding with this assumption, we traverse through the unsorted list, picking one element at a time. Syntax rand.Seed(value) Rand.Seed() function is used to generate random ... Read More
In this tutorial, we will write a go language program to iterate over each element of the array. An array is a data structure that is used to store data at contiguous memory locations. There are many methods to iterate over an array. The simplest one is to use a for loop. Here, we will see how we can iterate over the integer and string types of arrays using various methods in go. Method 1: Iterate over the Array using For Loop In this method, we will write a go language program to iterate over the array using for loops. ... Read More
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP