- 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
528 Views
Introduction Simpson's Rule is a well-known technique that works wonders for solving complicated mathematical integration equations. The lengthy numerical equation will take a lot of user time and effort if solved manually, increasing the probability of incorrect results. We have a plethora of effective techniques, such as the trapezoid rule ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
719 Views
The filter function is a newly introduced function in Excel 2021 and Excel 365. In this article, we will understand the fundamental concept of the Filter function which is efficient in finding the filtered string presented in the dataset that relies on the specific criteria and extracts only those searched ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
138 Views
Introduction The Excel 365 tool offers several easy-to-use functions that allow you to rapidly evaluate the datasets. In this article, we unravel the concept of BYCOL and BYROWS functions in Excel 365. Few operations are not executed properly while using a dynamic array. Sometimes, users may find it challenging to manipulate ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
217 Views
Introduction When working with large datasets spread across multiple ranges and sheets, it becomes crucial to quickly convert the unstructured data into a 2D form. WRAPROWS and WRAPCOLS functions are exclusive in Excel 365 that transform the 1-D array into a 2-D array. These functions aid users to organize the data ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
262 Views
Microsoft Excel 365 comprises a wide range of new functions to improve users' productivity and efficiency in manipulating data. With big datasets, it takes a lot of time for users to manually transform a 2-D array into a single array. TOCOL and TOROW functions are new inbuilt functions introduced in ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
169 Views
In the area of spreadsheet wizardry, mastering Microsoft Excel’s features can streamline data management and enhance productivity. One commonly sought-after skill is quickly to hide filter arrows/buttons while filtering in excel process crucial for various tasks like invoicing, inventory control, employee identification codes, and more. In this article, the users ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
137 Views
In the article, the users are going to hide the button once printing the worksheet in Microsoft Excel. There are the several features in the excel sheet including conditional formatting, format cells that the users must fill any type of color according to the need. The excel tool is bundled ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
581 Views
When working with large datasets spread across multiple ranges and sheets, it becomes crucial to compute Fourier Analysis manually. It is essential to swiftly compute the discrete function and evaluate the Fourier transform quickly when working with enormous datasets dispersed across several ranges which is possible only through the Data ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
297 Views
In this article, we are going to study Rename and Alias. Both these have their specific role when we talk in terms of DBMS. Renaming and aliases to the elements of the database provide a layer of abstraction and make the attributes of the relation presentable for the viewer. Mostly, ... Read More
![Aarti Kaushik](https://www.tutorialspoint.com/assets/profiles/746298/profile/60_2685203-1697777482.jpeg)
Aarti Kaushik
163 Views
When faced with knowledge gaps, our innate reaction is to utilize search engines as a source of information. This is because we're well aware that the answers to our queries can be found there; the key lies in using accurate keywords for our searches. Both Database Queries and Keyword Queries ... Read More