- 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
236 Views
Excel 365 is a powerful tool that offers countless features and works efficiently with dynamic arrays. In the earlier version, manipulating data in a dynamic array sometimes felt time-consuming. However, by leveraging some simple yet effective techniques, you can quickly reduce the size of the dynamic array in Excel and ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
122 Views
Introduction The RANDARRAY function is one of the exclusive functions that is introduced in the latest version of Excel 2021 or Excel 365. It would return an array comprising numbers between 0 and 1. It is one of the quickest techniques to generate random floating numbers or integers ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
220 Views
In this type of article, we may create the data using the MAP() function to make a new type of value or data from the number of columns and rows and returns the array that is based on the mapping every value or data in the function MAP which we ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
131 Views
Introduction In this type of article, we may go to create the data using the Expand() function to copy the selected data that the users have to insert in the expand function in any selected cell. The users have to analyze to expand the selected or created data in any other ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
141 Views
Excel, a powerful spreadsheet tool by Microsoft, offers numerous functionalities that can enhance our data processing tasks. New Dynamic array functions have been introduced in Excel 365 that solve complicated problems and increase your productivity. One such feature is the ability to utilize the ARRAYTOTEXT function. In this article, we ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
140 Views
In this type of article, we may create the data using the DROP() function to identify a number of columns and rows from array that is based on the number in the function DROP which we have to set the identified value. The users would have to analyze DROP() function ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
243 Views
Introduction In today's data-driven world, the ability to swiftly search and retrieve specific information is vital. This is particularly true when dealing with large datasets spread across multiple sheets or worksheets within a file. Manually manipulating the matrix through each sheet can be time-consuming and prone to errors. In this ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
185 Views
The better alternative to VLOOKUP is XLOOKUP which is exclusive to Excel 365. It assists users in looking at the value in one column and extracting the value from different columns that are based on a certain condition. It is one of the most efficient techniques for dealing with error values ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
155 Views
Introduction When working with extensive spreadsheets that comprises numerous columns and rows, finding specific information can become challenging without proper visibility cues. Manipulating large voluminous of unstructured data is very time-consuming for the users. A wide variety of fourteen new Excel functions are introduced in Excel 365 to ease the user's ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
179 Views
When you import the data from another resource, a lot of mistakes are encountered in the dataset which makes it very challenging for the users to manipulate the text therein. In this article, users will learn the concept of TEXTBEFORE, TEXTSPLIT, and TEXTAFTER functions which are exclusive only to Office ... Read More