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 calculate the employee tenure in months or years in Excel?
When discussing the employment of any worker, the word Tenure will come up more frequently in discussion. The length of time that an individual has worked for one particular employer is referred to as their tenure. Simply said, an employee's length of service is what is meant by the term "tenure." Excel can be of assistance to us when it comes to calculating tenure or the average tenure of an employee. If you are the one in charge of people tracking in our company or department, you could be wondering if you can use Excel to determine the number ...
Read MoreHow to calculate the cumulative sum / running total of a column in Excel?
The calculation of the cumulative or running total is used to watch the summation of numbers which is updated every time when a new number is entered into the sequence in an excel sheet. In this tutorial, you will learn how to calculate the cumulative or running total of a column in an Excel sheet. Calculating the Cumulative Sum of a Column in an Excel Sheet Using the formulas, you can get the cumulative total or running total of a column in a Microsoft excel sheet. Kindly follow the below steps to understand this clearly. Step 1 Open a Microsoft ...
Read MoreHow to calculate the bond price in Excel?
In this tutorial, we will demonstrate how you can calculate the price of a zero coupon bond, the price of an annual coupon bond, and the price of the semi-annual coupon bond in an Excel sheet. Calculating the Price of a Zero Coupon Bond in Excel Consider an example, there is a 10 years bond and the value is 5000, and the rate of interest is 7.5 %. Before the maturity date, the bondholder cannot get any coupon. You can calculate the price of the zero bonds using the formula. Step 1 Open an Excel sheet and enter the data ...
Read MoreHow to calculate the average rate of change in Excel?
If you want to calculate the average speed and how much time you will spend going from one place and another by bicycle, then you need to know the average speed when you drive a bike. For an instance, consider you have recorded the time and distance at the time of traveling, now with that data, you can calculate the average bicycle speed – the average rate of change in an Excel sheet. Follow the steps given below to calculate the average rate of change in an Excel sheet. Step 1 Open a Microsoft excel sheet and enter the ...
Read MoreHow to calculate the average in a column based on criteria in another column in Excel?
It is quite easy to find the average in a column based on the criteria in another column in an Excel sheet. In this tutorial, we will show how you can do it in just two simple steps. Step 1 Open a Microsoft excel sheet, and enter the data as per your wish below I have considered this data as shown in the below screenshot for your reference. Here the excel contains the date, region and the values for the sales. Step 2 Now you need to select a blank cell in an excel sheet and enter the below ...
Read MoreHow to calculate the absolute difference between two values/times in Excel?
The usage of absolute numbers to distinguish between occurrences like "Decline, " "Boost, " and "Payment, " among other things, is rather prevalent among users. When just the difference between the two numbers is required or requested in a spreadsheet, the Excel absolute difference between the two values is provided. The ABS function in Excel will return the absolute value of any difference or number that is provided. To calculate the absolute difference between two values, we may make use of a variety of different formulae, including IF, MAX, and MIN, as well as a VBA Custom Function. In layman's ...
Read MoreHow to calculate standard deviation in Excel?
A number's standard deviation gives you an idea of how much it deviates from the average of all the values in the sample. The fact that each of the numbers is identical to the others indicates that there is no variance. As a direct consequence of this, the numbers have just a standard deviation that is equal to zero. The STDEV function has been around for a very long time. The new STEDV.S function, which is included in Microsoft Excel and provides the same exact result, is the one that the software company advises using. We can compute the standard ...
Read MoreHow to cancel XMLHttpRequest in AJAX?
We will use the "abort()" method to cancel the XMLHttpRequest. This will stop the current request from continuing to execute. In the future, we will make sure to properly cancel any requests that are no longer needed to optimize performance. Let us first understand what XML HttpRequest is. XMLHttpRequest is a JavaScript object that allows web developers to make HTTP requests to a server without reloading the entire page. It is often used for creating dynamic and interactive web applications. The API can be used to retrieve data in different formats such as text, XML, and JSON. XMLHttpRequest is supported ...
Read MoreHow to add default vertical scaling to a text canvas using Fabric.js?
We can add default vertical scaling to a text canvas using Fabric.js by first creating a text object and then setting the "scaleY" property to the desired scaling value. Additionally, we can use the "setCoords()" method to update the object's coordinates to reflect the scaling change. Before diving into the approach let’s just have a quick look what Fabric.js is − What is Fabric.js? Fabric.js is a JavaScript library for creating and manipulating HTML5 canvas elements. It allows developers to create and manipulate canvas elements using an object-oriented API, making it easy to add, edit, and delete shapes, text, images, ...
Read MoreHow to add code input in React.js?
We can add code input in React.js by creating a component that renders an input field and handles user input. To do this, we can use the built-in React hooks such as useState to manage the input value and handle changes. Additionally, we can also use event handlers to handle user input and update the input value accordingly. Let us first understand what ReactJS and analyze the use of React Hook “useState” as it will be used inside the code. ReactJS React is a JavaScript library for building user interfaces. It makes it easy to create interactive UIs. Design simple ...
Read More