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 design a calendar for a web page using jQuery EasyUI?
Calendars are an essential feature in any web application or website that deals with dates and events. A well-designed calendar can help users easily visualize and manage their schedules, while a poorly designed calendar can be frustrating to use and lead to confusion. jQuery EasyUI is a popular JavaScript library that provides a wide range of UI components, including a calendar component that can be easily integrated into web pages. In this article, we will discuss how to design a calendar for a web page using jQuery EasyUI. Methods Step 1: Install jQuery EasyUI The first step is to install ...
Read MoreHow to handle if cell contains a word, then put a text in another cell?
Excel is a famous spreadsheet-based tool, used to manipulate and process available data. For this provided scenario, the user needs sample string data, to check the presence of the required string. To solve the provided problem statement, the user needs to create a formula by using the search function. The search function will allow the user to search some specific data from the provided cell value, and to generate the results according to the presence and absence of data. Example 1: To handle a cell that contains a word, by putting data text in another cell by using the user-defined ...
Read MoreHow to get the same or first day of next month on a given date in Excel?
This article briefs learners about the way to generate the same or the first day of the next month from the provided date in Excel. This article contains a stepwise explanation for both the discussed practices. The first example allows the learner to obtain the same-day date of the next month, this means if they pass “12-03-2023” as input then the generated output will be “12-05-2023”. Next example, allow leaner to get the first day of next month. This simply means if the input date “15-04-2023” then the generated output should be “01-05-2023”. Example 1: To get same day of ...
Read MoreHow to get subtotals based on invoice number in Excel?
Calculating the subtotal of an invoice is an important component of an invoice. It allows the user to understand the total amount after putting in the total invoice amount. In this article, the learner is guided through the process of generating a subtotal of the provided invoice number. For example, if invoice 101 has three entries of 100, 200, and 300, then the calculated subtotal amount will become 600. In this article, the user implements the Subtotal value by using the formula, method. Example 1: To get subtotals based on invoice numbers in Excel by using the formula: Step ...
Read MoreHow to get row or column letter of the current cell in Excel?
Excel spreadsheet store data in table format. Every Excel sheet is made up of rows and columns. Rows are the horizontal record fields available in the Excel sheet. On the other hand, columns are the vertical record fields available in the Excel sheet. Row address values are represented by using numbers. While column data values will be represented by using the alphabet. Since row data is represented by using numbers, therefore, they are required to be get converted into an alphabet value. While column data is already available in the form of letters. Example 1: To get row letter ...
Read MoreHow to get month from week number and year in Excel?
This article briefs learners about the way to generate the month-from-week number and year in Excel. This article describes two strategies to achieve the required task. The first example guides the learner to use the predefined methods, in the form of user-defined formulas. The second method guides the learner about the use of VBA code. Please note that VBA is a programming language that can work only when written properly within a proper format. This article contains stepwise explanations for both the discussed practices. Example 1: To get month from week number and year in Excel by using the formula: ...
Read MoreHow to get the current workbook name in Excel?
A workbook is a type of document used to organize and manage data or information in a structured format. MS Excel is also an example of a workbook. It is categorized as a software application used to process and manipulate data. This tutorial provides two examples to obtain the current workbook name. The first method is based on the use of VBA code. This method allows the user to define a module, to obtain the required output. On the other hand, the second method is based on the use of Kutool plus extension. Example 1 − To obtain the current ...
Read MoreHow to Generate Random Yes or No in Excel?
Random values are used to obtain results. These results can be used to perform simulations, to understand the pattern of different system components. It is useful when users require a large data set to evaluate some common feature. Generating random yes or no can be useful for pole or opinion-related services. This article allows users to use two methods to generate random Yes or No. The first method is based on the use of predefined formulas presented in Excel. On the other hand, the second method is focused on using the kutool to make the work easier. Example 1: To ...
Read MoreFinding the Inverse Hyperbolic Tangent of Specified Number in Golang
In Golang, the math/cmplx package provides functions to calculate various mathematical operations on complex numbers. The inverse hyperbolic tangent function, also known as arctanh, is one of the many functions provided by the package. Inverse hyperbolic tangent function is used to find the angle whose hyperbolic tangent is a given number. This article explains how to find the inverse hyperbolic tangent of a specified number in Golang. Syntax The syntax to find the inverse hyperbolic tangent of a complex number is as follows − func Acctanh(x complex128) complex128 Parameters The Acctanh() function takes a single parameter, a complex number. ...
Read MoreHow to generate random weekday or weekend date in Excel?
This tutorial is designed to help learners to understand the technique to generate random weekday or weekend date in excel. In this tutorial, the user will understand three possible methods to perform this task. First method is based on using predefined formula, to generate random date. Second method allow user to use kutool to generate the random dates, and last method allow user to use the VBA code to generate the date randomly. Same method can be used to generate both weekday and weekend dates. Example 1: Example to generate random weekday date in excel. Step 1: To understand the ...
Read More