Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Pradeep Kumar
Page 76 of 104
How to Average a Range of Data Ignoring Zeroes in Excel?
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 excluding zeroes in Excel? This tutorial will help you understand how we can find the average for a range of data by ignoring zeroes in Excel. We can complete this process by using the formulas supported by Excel in an amazingly effortless way. Averaging a Range of Data in Excel ...
Read MoreHow to Auto-Update a Dropdown List in Excel?
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 to add an item to the list, we need to create a new list again. However, there is a way in Excel to auto-update drop-down lists when new data is added to the sheet. This tutorial will help you understand how we can auto-update drop-down lists in Excel. Auto-Update a ...
Read MoreHow to Auto-Update a Chart after Entering New Data in Excel?
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 you understand how we can automatically update a chart after entering new data in Excel. This can be done in two ways: first, by using the tables, and second, by using the dynamic formula. Auto-Update a Chart after Entering New Data Using Tables Here we will convert our data into ...
Read MoreHow to AutoSum Multiple Rows/Columns/Worksheets in Excel?
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 by using the auto function in Excel. This tutorial will help you understand how we can autosum multiple rows, columns, or worksheets in Excel. AutoSum Multiple Rows in Excel Here we will use the autosum function under formulas. Let us see a straightforward process to see how we can autosum ...
Read MoreHow to Auto-Strikethrough Based on Cell Value in Excel?
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 not a default font that we can use directly in Excel, but we can use it by applying an uncomplicated process. We can also add the strikethrough to the cells based on the cell value using conditional formatting. For example, we can add the strikethrough to cells with values greater ...
Read MoreHow to Auto-Sort Date When Date is Entered or Changed in Excel?
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 to analyse our data very clearly. This tutorial will help you understand how you can automatically start the date when a date is entered or changed in Excel. The dates that are newly inserted and updated will also be sorted directly. This can save you a lot of time in ...
Read MoreHow to Auto-Sort Data Alphabetically in Google Sheets?
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 nothing more than arranging the data in an ascending or descending order based on a single column. We will be sorting the data in ascending order in the below process. This tutorial will help you automatically sort data alphabetically in Google Sheets. We can sort any kind of data by ...
Read MoreHow to Auto-Sort Columns by Value in Excel?
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, in Excel, we will sort the data by using the sort function, but if we insert or update a new value in the list, then we need to do the process again. Read this tutorial to learn how you can autosort columns by value in Excel. AutoSort Columns by Value ...
Read MoreHow to Auto-Size a Comment Box to Fit Its Content in Excel?
Have you ever wondered if there is any way in Excel to automatically size the comment box to fit its contents? This is only possible using the VBA application. Using VBA code, we can customise the sheet to automatically fit the size of the comment box to its contents in Excel. This tutorial will help you understand how we can automatically size comment boxes to fit their content in Excel. Auto-Size a Comment Box to Fit Its Content in Excel Here, we will first create a VBA module and then run it to complete our task. Let us see a ...
Read MoreHow to Auto-Select the Text of a Textbox When It is Selected in Excel?
When we are dealing with text boxes, it is very important to update and delete the data inside them, but if it contains a large amount of data, we need to select the data inside the text box and delete it. In this tutorial, I will explain the process for selecting the data in a text box by clicking on it. This tutorial will help you understand how you can autoselect text from a textbox when it is selected in Excel. Auto-Select the Text of a Textbox When It is Selected Here, we will first create a macro and then ...
Read More