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
Microsoft Technologies Articles
Page 103 of 175
How to avoid rounding errors while calculating in Excel?
When you are calculating some formulas in Excel, the result may be incorrect sometimes due of the rounding, and you may be wondering how to avoid making rounding errors while calculating in Excel. Avoid Rounding Errors while Calculating in Excel Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a product, sales and profit list for sample data as shown in the below screenshot for the same. Step 2 In the next step, we are trying to calculate the profit ratio using the below formula. Please checkout this screenshot ...
Read MoreHow to avoid #ref error while deleting the rows in Excel?
Excel will display a notice known as a #REF error (the "ref" stands for reference) if a formula makes reference to a cell that does not now exist. This is typically the result of removing cells that a calculation is referring to. A competent financial analyst will be familiar with locating and correcting #REF problems in Excel, which are discussed in greater detail below. Avoid #ref Error while Deleting the Rows in Excel When you refer a cell to another cell, the cell that you are referring to will display the #REF error if the row that the cell is ...
Read MoreHow to Have a Floating Command Button on a Worksheet in Excel?
Let us assume we have an Active X command on an Excel sheet at one place, and the data in the Excel sheet is in large volumes. If you want to use the active x command, we need to search for it every time. This problem can be solved by making the button floating. This article will help you understand how we can make the button always float in Excel. Floating a Command Button on a Worksheet Here we will first insert a button and then assign a macro to the button to make it always floating. Let us see a ...
Read MoreHow to Average the Absolute Values in Excel?
Sometimes, in Excel, you want to calculate the average of absolute values. If we consider the values as positive, even if they are negative, then they are called the absolute values. The absolute values are always positive. Basically, absolute values are used in calculating distances or inequalities. If we want to calculate the average distance travelled by a delivery person in a day, we can use this process. This tutorial will help you understand how we calculate averages for absolute values in Excel. Average Absolute Values in Excel with Helper Column Here, we will first use the ABS formula and ...
Read MoreHow to Average Filtered Cells/List in Excel?
You could have applied the average function to tables in Excel, but have you ever tried to use the average in filtered cells? When we apply the direct formula to the filtered cells, the result is an error. There is a special method for finding the average for filtered cells. This tutorial will help you understand how we can average filtered cells in Excel. We can complete this process just by using the simple formulas supported by Excel. Average Filtered Cells/List in Excel Here we will first create the table, then insert the slicer and use the SUBTOTAL formula to ...
Read MoreHow to Average Every 5 Rows or Columns in Excel?
Sometimes, when we want to calculate the average of every five objects in Excel, we can directly follow a shortcut, which will be mentioned in this article. This will save you a lot of time compared to calculating the average for every five units using the general method. This tutorial will explain how to average every five rows or columns in Excel. We can complete this process by using the formulas. Average Every 5 Rows in Excel Here we will use the AVERAGE and OFFSET formulas to get our first average and use the autofill handle to get all the ...
Read MoreHow to Average Data Based on Weekday or Weekend in Excel?
Have you ever tried to find the average of values based on the days of the week? Doing it manually can be an awfully long and time-consuming process. We can do it directly by using the formulas supported by Excel. This tutorial will help you understand how we can average data based on weekdays or weekends in Excel. Here, we have two processes: the first is an average based on weekdays, and the other is based on weekends. Average Data Based on Weekday Here we will use the SUM and WEEKDAY formulas to complete our task. Let us see an ...
Read MoreHow to Average Cells Ignoring Error Values in Excel?
You could have always tried to average cells where there are no error values. But have you ever faced a situation where you wanted to average the range of data but were not able to do that because of the presence of error values? This tutorial will help you understand how we can average cells while ignoring error values in Excel. The error can be of any type; for example, it can be a division error or a reference error. We can complete processes directly in Excel using the program's formulas. We can use the array formulas to complete the ...
Read MoreHow to Average Cells Based on Multiple Criteria in Excel?
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 understand how we can average cells based on multiple criteria in Excel. In this tutorial, I will demonstrate two methods for calculating the average in Excel: one using a single criterion and another based on multiple criteria. Average Cells Based on Single Criteria Here we will get the average by ...
Read MoreHow 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 More