- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Aarti Kaushik has Published 75 Articles
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
103 Views
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 ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
374 Views
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 ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
173 Views
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 ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
236 Views
Introduction Numerous built-in options like Inner Join, Full Join, Left Outer join, and so on are embedded to merge and append tables in the Power query editor. In this article, we will discuss Left Anti and Right Anti joins in Power BI. Left anti-join is used to combine tables where ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
193 Views
Introduction When two tables require their common column field values to match, a right outer join is used to combine them, and all the records of the second table are extracted along with their matching field value from the first table. It is just the opposite of another type which ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
527 Views
Introduction Different kinds of joins are available in the Power Query Editor, like Left outer join, Right join, Inner join, and so on. Users may swiftly combine the tables and examine the result by employing these joins. In this article, we will explore the fundamental concepts of Full Outer Join ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
173 Views
Introduction In this article, we will explore creative, efficient techniques that allow us to rapidly locate unique values within various sheets or worksheets. Excel's 365 advanced built-in functions integrated into multiple workbook references ensure flawless consistency as formulas perform checks against each dataset independently before returning results accurately. Unique function ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
155 Views
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 ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
153 Views
Introduction One of the prominent functions introduced in Excel 2021 is the SORT and SORTBY functions that quickly assist users in sorting the dynamic array either in ascending or descending form. These exclusive functions not only enhance organizational productivity but also improve readability when dealing with lengthy text. When dealing ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
292 Views
Introduction In this article, we will understand the concept of the XMATCH function which is simple and easy to use. The XMATCH function is exclusive only to the latest version like Excel 365 or Excel 2021. It would retrieve the specified position of the data in the array. It is ... Read More