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 use Let function in Excel 365?
Excel is a priceless tool when it comes to organizing and analyzing data. The let function is one such function that enables us to carry out calculations based on circumstances. While users mostly rely on it for data analysis and calculations, many overlook an underutilized feature that can greatly enhance readability, productivity, and decision- making capabilities. In this article, we will explore the fundamental concept of the Let function which is available only in Excel 365. Users can specify parameter names to the values through this function, and these parameters will be used in the generated formula much like in ...
Read MoreHow to perform LAMBDA Function in Excel 365?
Introduction Numerous user-friendly functions are introduced in Excel 365 that boost the expert knowledge and improve their productivity. In this article, we will understand the concept of the LAMBDA function in Excel. Before implementing this function, users may either install Office 365 or use the trial version on the web. With the help of the LAMBDA function, users may develop a custom function and regenerate the function across worksheets. The following key points need to be considered while creating the Lambda function − Create the lambda function in the cell. Verify and test the lambda function. Use the Named ...
Read MoreIsomitted function in Excel 365
Introduction In this type of article, we may go to create the data using the LAMBDA() function to check if the value can be absent and it may return true or false. The users have to use the LAMBDA() function that will check the missing value. If the value is not missing, it displays value 0. This method may be completed utilizing a straightforward way within Microsoft Excel 365 by using the LAMBDA function. This function is only not available in the older version of Excel. Isomitted Function The ISOMITTED function is utilized to check if the value is absent, ...
Read MoreHow to create and test the User Defined Function to compute the Area of a Triangle in Excel 365?
Introduction VBA is a crucial component of Microsoft Excel that facilitates users to develop the function and subroutine that can be executed in the Excel worksheet. The value would be retrieved by the user-defined function and given to the specific cells that call it. Users must employ the indentation in the VBA code to enhance the readability of the code. In this article, we will explore the efficient techniques for calculating the area of a triangle and comparing values. Cell formatting is not done by the user-defined function. To Generate the User Defined Function to Compute the Area of the ...
Read MoreHow to merge tables using Inner Join and Left Outer Join in Power BI?
Introduction In this article, we will gain deep insights into Inner Join and Left Outer Join in Power BI. A wide variety of joins, like full join, inner join, and left anti-join are available in Power BI to join tables. The inner join merges two tables and extracts only those records that contain the matching values in the common column of both tables. The left-outer join also matches the common values from the two tables but retrieves all the first table records along with the corresponding records of the matched values from the second table. Implementation of Inner Join in ...
Read MoreRights and Privileges of Advocates
Rights and Privileges of advocates in India are described and protected primarily by the Advocates Act, 1961 and the rules framed by Bar Council of India. The rights and privileges that given to advocates ensure their independency, hone their skills to practice law with confidence, and maintain professional autonomy. However, the Act not only provides rights, but also gives responsibilities and duties, codes of conduct, and ethical responsibility within the legal profession. Rights of Advocates Major rights of an Advocate in India are − Right to Practice The "Right to Practice" is the most fundamental right that granted ...
Read MoreDifference Between Bitcoin and Gold
Introduction For the last few decades, the number of financial products have grown rapidly, creating a pool of opportunities and options for investors to park their money and grow income. Gold and Bitcoin are couple of them in the financial space. They both are entirely two distinct investment avenues in terms of attributes and returns. In this case, it’s like comparing apples with oranges. Speaking practically, both gold and bitcoin can be deemed useless in some cases. For instance, you cannot take gold or bitcoin to any store and use it for making payments on purchases made. Whenever ...
Read MoreWhat is the full form of PO?
What is PO? PO can be expanded as a Post Office and Probationary Officer. In this article, we will discuss about Post Office. The post office is also known as the Department of Posts and has been the backbone of India as it helps in the growth of social and economic development. It performs many tasks like mail delivery, small savings deposits, life insurance under postal life cover, and a lot more services. Currently, there are more than 155, 000 post offices all over India. History of PO Post Office was established in 1854 but it was started as Company ...
Read MoreWhat is the full form of RBL?
What is RBL? RBL can be expanded as Ratnakar Bank Limited. It is a private bank whose presence can be found in many parts of India. It provides the services listed below − Corporate Banking Branch and Business Banking Retail Assets Treasury and Financial Markets Operations Commercial Banking The bank was started in 1943 and now there are many branches available all over India. Here are some more details in the table below. Aspect Details Number of customers 14.31 million Number of Branches 528 Number of Business Correspondent Branches 1, ...
Read MoreWhat is the full form of RTGS?
What is RTGS? RTGS can be expanded as Real-Time Gross Settlement. RTGS is a money transfer system which can be used to transfer money from sender to recipient instantaneously. RTGS is being used successfully in 60 countries and the central bank of a country runs the service. RTGS is used to transfer money of high value and the minimum transfer amount should be ₹2 lakhs. You need to have the IFSC code of the recipient to whom money is to be sent. Other requirements for the recipient include his name, bank branch, account type, and account number. Both sender and recipient banks ...
Read More