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 by Aarti Kaushik
Page 2 of 6
STOCKHISTORY function in Excel 365
Introduction Excel is a powerful tool for organizing and analyzing data, but manually searching through the history of financial data from different resources can be time-consuming. In this article, we will gain deep insights into the StockHistory function that is available only in Microsoft 365 and returns the array describing the stock history of financial data along with the specific dates that users specified in a range. The benefits of the StockHistory function include time savings, flexibility, comparative analysis, and ...
Read MoreHow to count the number of items through Spin Button in Excel?
Introduction Excel is not limited solely; it empowers efficient collaboration when dealing with large volumes of interconnected data. By utilizing Form Controls and Active X controls functionality, several team members can link the cell reference, and populate the calculation through these interactive controls which ensures the integrity of the entire dataset. Better user interfaces, greater versatility, and improved application structure are also possible. Users may quickly add text boxes, a drop-down menu, a spin button, and ...
Read MorePlot a graph to visualize the death cases of Rajasthan Heat Wave
Introduction Excel is one of the precious tools where various case studies need to be monitored by the data analyst to understand the actual scenarios of the problem, choose the appropriate model, and predict the accurate result of the dataset that is imported into the Excel worksheet. One of the best techniques to visualize the data is to construct an interactive graph in Excel. In this article, we will identify the death cases of the Rajasthan Heat Wave by creating an interactive clustered column chart. Benefits of Developing Graphs in Excel Worksheet Enhanced Data Visibility By developing a 2D/3D graph, ...
Read MoreHow to identify the real roots of a Quadratic Equation in Excel?
Introduction It can be difficult to work with large datasets in Microsoft Excel, especially when you must find accurate values from complex equations. Excel facilitates an excellent technique to speed up this handle and users may create a user-defined function in Visual Basic and invoke it in a specified cell. The UDF is an efficient way to resolve complex mathematical equations. In this article, we will learn how to determine the roots of the quadratic equation through a user-defined function. Use Visual Basic Code to Evaluate the Quadratic Equation’s Root Step 1 Open a desired worksheet and enter the following ...
Read MoreHow 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 MoreTAKE function in Excel 365
Introduction In this article, we will explore the fundamental concept of the take function which is exclusive only in Excel 365. Manually extracting the data of specified columns and rows from the large database is very time consuming and tedious. Take function is an effective way to swiftly extract data in consecutive form from the specified number of rows or columns. It is a simple technique that is particularly useful for cleaning data and retrieving pertinent information from datasets. The take function retrieves row data sequentially either from the beginning or the ending of the table. TAKE function in ...
Read More