Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to Add or Sum Times Over 24 Hours in Excel?
Have you ever tried adding times in Excel where the total will be more than 24 hours? Then you have a problem where the sum always returns to less than 24 hours even though the sum is greater than 24 hours, and it can lead to wrong solutions. It is so, because in Excel, by default, the time should always be 24 hours. This tutorial helps you understand how you can represent times that are longer than 24 hours. Adding Times Over 24 Here, we will first add the values and then use the format to change the values to ...
Read MoreHow to Add or Subtract Weeks to a Date in Excel?
Making changes to deadlines in Excel is one of the most common tasks performed there. Making the adjustments to the dates manually is a very complex and hectic process. We can make it happen very easily, using the formulas supported by Excel. So, let's see a simple process to add or subtract the number of weeks in the Excel sheet using the formula. Adding Weeks to a Date Here, we will first use the formula to get the first result, then use the auto-fill handler to get all the results. Let's look at a simple procedure for adding weeks to ...
Read MoreHow to Add or Pad Leading Zeros to Numbers or Text in Excel?
The zeros that are added before the numbers that will not change their value are known as "pad leading zeros." These are similar to the leading zeros, but the only difference is that in leading zeros, the zeros are added after the number, and in pad leading zeros, the zeros are added before the number. The dotted line leading the zeros helps the number look clear and neat. If we try to add leading zeros manually, Excel will not allow us to do so. But this tutorial helps you add pad leading zeros. This can be done in three ways: ...
Read MoreHow to Add or Move Data Labels in an Excel Chart?
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 MoreHow to Add Leader Lines to a Doughnut Chart in Excel?
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 MoreHow to Add a Hyperlink to a Specific Part of a Cell in Excel?
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 MoreGolang Program to Calculate Average Using Arrays
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 MoreGolang Program to Multiply to Matrix Using Multi-Dimensional Arrays
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 MoreGolang Program To Find The Transpose Of A Matrix
In this article, we will write a go language program to find the transpose of a matrix. A matrix is a collection of numbers arranged in rows and columns, a two-dimensional array. Transpose of a matrix is defined as a matrix obtained by interchanging the rows and columns of that matrix. Method 1: Find the Transpose of a Matrix using For Loop In this example, we will write a go language program to find the transpose of the matrix using for loops in the main function. Algorithm Step 1 − Import the fmt package. Step 2 − Call the main() ...
Read MoreGolang Program To Display Upper Triangular Matrix
In this article, we will write a go language program to print the upper triangular matrix of any given matrix. Introduction − A square matrix is called an upper triangular matrix if it has zero values below the principal diagonal. A matrix is displayed in its upper triangular form only if it is square. i.e. it must have the same number of rows and columns. The order of a typical upper triangular matrix is N X N. Method 1: Display Upper Triangular Matrix using For Loops In this method, we will write a go language program to display upper ...
Read More