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
Golang Program To Determine If a Given Matrix is a Sparse Matrix
In this tutorial, we will write a go language program to determine whether a given matrix is sparce or not. A square matrix is called a sparse matrix if the number of zeroes present in the matrix are more than the non-zero elements in the matrix. Golang Program to Check if a Matrix is Sparce In this example, we will write a Golang program to check the sparce matrix. We will use for loops along with if conditions to achieve the result in the main section of the program. Algorithm Step 1 − First, we need to import the fmt ...
Read MoreGolang Program To Get The Last Item From The Array
In this tutorial, we will write a go language program to get the last item from an array. An array is a data structure that is used to store elements in contiguous memory locations. In this article, we will write two programs to store the first element in the array. In the first program, we will use the concept of indexing and in the second we will use the for loops to get the required result. Method 1: Get the Last Item from the Array of Integers in the Main In this method, we will write a golang program ...
Read MoreGolang Program to Calculate Difference Between Two Time Periods
In this tutorial, we will write a golang programs to calculate the difference between two time periods given in the following programs. To get the time difference between two time periods we can either use a library function or can create a separate user-defined function to achieve the results. Method 1: Calculate the Difference between Two Time Periods using Internal Function In this method, we will write a go language program to find the difference between time periods using pre-defined functions in go programming language. Syntax func (t Time) Sub(u Time) Duration The sub() function in go is ...
Read MoreGolang Program To Append An Element Into An Array
In this tutorial, we will write a go language program to iterate over an array. An array is a data structure, which is used to store data at contiguous memory locations. There are many methods to append an element in an array. We shall discuss them in this program Example 1: Add Values to an Array of Strings in the Main() Function In this example, we will write a go language program to add values to an array of strings in the main() function. We will first initialize an array of strings of specific size and then add values ...
Read MoreHow to Auto-Insert Rows Based on Cell Values in Excel?
Let us assume we have a situation where we want to insert a row below or above a specified value. This process can’t be done by default in Excel, so we will be using the help of the VBA application to complete our process. Read this tutorial to learn how you can autoinsert rows in Excel based on cell values. If we try to complete this task manually, it can be a time-consuming process, as inserting a new row is a multi-step process. AutoInsert Rows in Excel Based on Cell Values Here we will first insert a VBA module and ...
Read MoreHow to Auto-Increment Cell Value in Excel after Each Printing?
Let us assume we have an Excel sheet that needs to be printed multiple times, and you want to know how many times the sheet is printed. There is no way in which we can solve this in Excel, but this can be solved using the VBA application. Read this tutorial to learn how you can automatically increment cell values in Excel after each printing. Auto-Increment Cell Value after Each Printing Here we will first insert a VBA module and then run it to complete its task. Let us see a simple process to understand how we can increment cell ...
Read MoreHow to Auto-Highlight the Row and Column of an Active Cell in Excel?
When we have a large amount of data on a single visible sheet, we can have the problem of straining our eyes to see the selected value clearly, which leads to a value misreading. But we can solve this problem by highlighting the row and column of active cells with different colours. This tutorial will help you understand how we can automatically highlight rows and columns of active cells in Excel. Auto-Highlight Row and Column of an Active Cell Here we will insert VBA code for the sheet, and then every time we select a cell, the row and column ...
Read MoreHow to Auto-Fit Row Height of Merged Cells in Excel?
We can see that if we try to fit a large amount of data into one cell, the data will now be displayed if we move to another cell; the only way to solve this problem is to increase the row height of the cell. For only one cell, we can adjust the height of the row by using the command "Alt + Enter", but when we try to merge the cells of different heights, we can face the same problem; we can’t use the command. Read this tutorial to learn how you can solve this problem, i.e., how to autofit the ...
Read MoreHow to Auto-Hide Columns if There are Blank Cells in a Column in Excel?
Sometimes, when we delete data from multiple columns in Excel, we even need to delete the empty columns. But in Excel, deletion of multiple columns at once isn’t possible, and deleting columns individually can take a lot of time. We can solve this problem by hiding the empty columns in Excel. Read this tutorial to learn how you can automatically hide columns if there are blank cells in a column. AutoHide Columns if There are Blank Cells Here we will first insert VBA code for the sheet, then double-click on any cell to complete our task. Let us see ...
Read MoreHow to Auto-Fit Column Width in Excel?
Adjusting the width of each column in Excel is one of the most frequently used processes. When we use formats like date, we can see that the width of the cell is automatically fitted, but this does not always happen. When the width of the cells is not enough to display the data, then a series of "#" symbols will be displayed in the cell. This problem can be solved using the auto-fit function. Read this tutorial to learn how you can autofit column width in Excel. AutoFit Column Width in Excel Here, we'll use three simple shortcuts to complete our ...
Read More