![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
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
Pradeep Kumar has Published 1236 Articles
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
440 Views
In Excel, we average the value based on no conditions. Our requirements are only a list of numbers, and we can calculate the average easily. But have you ever tried to calculate the average based on conditions? We can do this by using the formulas. This tutorial will help you ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
3K+ Views
Consider the following scenario: in a business, you want to know the average sales of weekdays, weekends, and sales on a specific day. This problem can be solved using the formulas provided in Excel. This tutorial will help you understand how we can average based on the day of the ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
5K+ Views
Generally, in Excel, we can calculate the average of a row or column directly by using the average formula. When we calculate the average in Excel, as you can see, the blank cells in the sheet are ignored automatically. But have you ever tried to find the average of cells ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
7K+ Views
A drop-down list is used to choose a single item from the list of data. When we add an item to the source data, we can see that the list will not be updated. A drop-down list is used to select an item from many items, but if we try ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
When we have an existing chart and you need to add new data or update the existing data, this can be done by manually updating the chart, but it can be a time-consuming process. In this tutorial, I will explain the method that saves you time. This tutorial will help ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
299 Views
When we are performing a sum for a single column or row in Excel, we can directly use the formula to do it, but if we are doing the same process for multiple rows or columns at once, we cannot do it using the formulas. We can complete the process ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
3K+ Views
Strikethrough is a type of data used in Excel to indicate that the data present in the cell is an error or that the event has been completed. The strikethrough is also used to represent that the event or process has successfully completed without any errors or mistakes. Strikethrough is ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
When we have a list of dates in an Excel sheet and you want to sort them, we cannot do it using the general method. We can use this special method used in the article to do it. If the dates in the list are sorted, it will help us ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
305 Views
We can sort a list of texts in Google Sheets manually, but it will be a very time-consuming process. Instead, we can use a simple process to do it automatically in Excel. We will be using a direct button present on the data menu in the Excel ribbon. Sorting is ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
576 Views
When we are working with the data related to numerals, it is very important that we always sort the data in order to analyse it better. Sorting can be done in either ascending or descending order. Sorting can help us compare the values and their importance on the sheet. Generally, ... Read More