- 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](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
1K+ Views
In the article, the user will understand the process of highlighting the rows that contain date-type data within the Google sheet. There are several features available in the Google sheet such as conditional formatting, cell formatting, and many other features by using which users can perform the same required tasks. ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
961 Views
Excel is a famous spreadsheet-based tool, used to manipulate and process available data. For this provided scenario, the user needs sample string data, to check the presence of the required string. To solve the provided problem statement, the user needs to create a formula by using the search function. The ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
1K+ Views
This article briefs learners about the way to generate the same or the first day of the next month from the provided date in Excel. This article contains a stepwise explanation for both the discussed practices. The first example allows the learner to obtain the same-day date of the next ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
619 Views
Calculating the subtotal of an invoice is an important component of an invoice. It allows the user to understand the total amount after putting in the total invoice amount. In this article, the learner is guided through the process of generating a subtotal of the provided invoice number. For example, ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
3K+ Views
Excel spreadsheet store data in table format. Every Excel sheet is made up of rows and columns. Rows are the horizontal record fields available in the Excel sheet. On the other hand, columns are the vertical record fields available in the Excel sheet. Row address values are represented by using ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
18K+ Views
This article briefs learners about the way to generate the month-from-week number and year in Excel. This article describes two strategies to achieve the required task. The first example guides the learner to use the predefined methods, in the form of user-defined formulas. The second method guides the learner about ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
274 Views
A workbook is a type of document used to organize and manage data or information in a structured format. MS Excel is also an example of a workbook. It is categorized as a software application used to process and manipulate data. This tutorial provides two examples to obtain the current ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
2K+ Views
End of month date means that end date of a provided month. For example if the provided data is “04-apr-2023”, then the last date of month will be “31-apr-2023”. This article focusses on using the predefined method to generate formula to obtain the last month date. Second example of the ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
1K+ Views
Random values are used to obtain results. These results can be used to perform simulations, to understand the pattern of different system components. It is useful when users require a large data set to evaluate some common feature. Generating random yes or no can be useful for pole or opinion-related ... Read More
![Namita Aggarwal](https://www.tutorialspoint.com/assets/profiles/640588/profile/60_610176-1681714605.jpg)
Namita Aggarwal
638 Views
This tutorial is designed to help learners to understand the technique to generate random weekday or weekend date in excel. In this tutorial, the user will understand three possible methods to perform this task. First method is based on using predefined formula, to generate random date. Second method allow user ... Read More