- 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
1K+ Views
Excel is a popular spreadsheet software that allows users to develop, organize and analyze data, by using different available options such as tables, charts, and graphs. The most common benefit of using the chart is that it allows the user to analyze data easily, compare data becomes easy, and make ... Read More
Namita Aggarwal
1K+ Views
An Excel spreadsheet is a combination of rows and columns. Rows are the horizontal lines, on the other hand, groups are the vertical column of the worksheet. This article contains two examples. The first example is based on the use of a name box, and the second example is based ... Read More
Namita Aggarwal
860 Views
Moving to the previous and last sheet is required when the user wants to search for any data or is willing to understand the data written on the previous and last sheet. Reconciling data from all sheets is good as it allows the user to use the whole data to ... Read More
Namita Aggarwal
4K+ Views
In this article, the user will learn how to obtain week start and end date based on a specific date in Excel. The two examples are depicted in this article. Both examples are based on the starting and end date of the provided week. The first example uses a formula ... Read More
Namita Aggarwal
297 Views
ABS in Excel stands for "Absolute Value". This function takes only one argument, as a cell reference or number directly, and then determines the required absolute value. This article guides learners about the process to generate the opposite of an ABS value in Excel by using the formula, and VBA ... Read More
Namita Aggarwal
367 Views
In this article, the user will learn the process of obtaining the name of the next sheet, by using the VBA code in Excel. This article briefs users about the method to open the code area. Write the developed code in the code area, and finally, call the code to ... Read More
Namita Aggarwal
278 Views
In this article, the user will learn the method to generate random positive numbers without duplicate values in Excel. This article briefs learners on two strategies to perform this same task. The first example uses VBA code to generate unique random numbers, while the second example will perform the same ... Read More
Namita Aggarwal
2K+ Views
Random data can be identified as random values, used to obtain some results. It can be used to perform simulations, to understand the pattern of different system components. It is useful when a user requires a large data set to evaluate some common feature. This article allows the user to ... Read More
Namita Aggarwal
2K+ Views
Permutation can be defined as the arrangement of objects in a specific order. In this article, the user would understand the method of generating the permutation by using the VBA code. To do so, the user needs to open the code editor for VBA and after that simply click on ... Read More
Namita Aggarwal
5K+ Views
This article describes the user with 3 possible ways to generate the possible combination of 3 or more available columns in Excel. The first example is based on using the user-defined formula, to generate the possible combination. The second example is based on the method to use the VBA code, ... Read More
To Continue Learning Please Login
Login with Google