- 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
Namita Aggarwal has Published 114 Articles
Namita Aggarwal
6K+ Views
Random data is a type of data generated randomly. For this article, the focus is to generate random date. Random data can be either created in between a specified range or can be generated abstractly to demonstrate some data to the user. In this article, two examples are used to ... Read More
Namita Aggarwal
208 Views
Random data is a type of data generated randomly. For this tutorial the focus is to generate random even and odd numbers. Random data can be used to many purpose such as creating a sample data set, or to evaluate results on the based on the dataset. In this tutorial, ... Read More
Namita Aggarwal
92 Views
Excel is a famous spreadsheet-based tool, used to manipulate and process the available data. For this provided scenario, user need to evaluate the prime number between the two provided numbers. This tutorial includes two examples, first example is based on the user define formula. For this example, user need to ... Read More
Namita Aggarwal
2K+ Views
In this article, the user will learn the process of sorting rows by matching the data with another column. Sorting rows to match the content of another column in Excel can be a powerful technique whenever a user needs to organize and align data efficiently. Whether the user has a ... Read More
Namita Aggarwal
253 Views
Sorting IP addresses from low to high in Excel can be useful for the below-provided reasons: It is useful to identify the network ranges. It allows the identification of the contiguous network ranges. It helps in detecting duplicate ... Read More
Namita Aggarwal
685 Views
Identifying the expired or upcoming dates can be useful for cases such as understanding the project’s last date, the last date for some important activities, and many others. In the food and medicine industry expiration dates are important as companies need to dispose of their products according to the date ... Read More
Namita Aggarwal
3K+ Views
This article illustrates the proper way to identify that the provided string is an uppercase, lower, or proper case. To do so simply use three formulas: upper(), lower(), and proper(). To understand more thoroughly consider the below provided explanation more precisely. This article describes three examples, here each example illustrates ... Read More
Namita Aggarwal
1K+ Views
Sometimes Excel contains data with missing numbers which creates difficulty and inconsistency in the data. Two methods are described in this article to obtain the missing series of numbers. After identification of the missing series, users may fill the gap by using the Autofill method or by utilizing the VBA ... Read More
Namita Aggarwal
88 Views
In this article, users will understand how to identify and select all merger cells in Excel. This article contains three examples, first example is based on the process of using the VBA code, the second process allows user the to find and select a method, and finally, the third option ... Read More
Namita Aggarwal
52 Views
Locking a cell is important. It allows the user to preserve the integrity of certain cells that contain important formulas, data, or formatting. On the other hand, when a cell is unlocked, it means that it can be edited even when the worksheet is locked. This is typically done for ... Read More