Learn how to analyze data with Excel by following these tutorials. You’ll learn how to calculate statistical concepts and work with mathematical functions in Excel.
In this post, you’ll learn how to count unique occurrences in Excel. Being able to count unique occurrences allows you to count how often each value occurs in a given range of data. This can be very helpful in order to be able to understand how often different data occur. For example, you may want …
Being able to count cells between two values in Excel is a valuable skill. For example, you may need to count how often values fall within a given range of values. Similarly, you may want to count how many students fall between two sets of test scores. In this tutorial, you’ll learn how to use …
Being able to count cells that are greater than a particular value in Excel is an important skill. For example, you may need to count how many salespeople met their sales targets. Or perhaps, you may need to track log in attempts that exceed a number on a given day. In this tutorial, you’ll learn how …
How to Count Cells If Greater Than a Particular Value in Excel Read More »
Being able to count cells that are less than a particular value in Excel is an important skill. For example, you may need to count how many sales happened that didn’t meet a particular target. Or perhaps, you need to know how many users haven’t logged on a certain number of times. Thankfully, Excel provides …
How to Count Cells If Less Than a Particular Value in Excel Read More »
Being able to count cells that fall in a date range in Excel is an important skill. In many cases, for example, you’ll need to count how many sales happened over a period of time. Or perhaps, you need to know how often a specific user logged into an application during a specific date range. …
Being able to count values in Excel is an essential skill. In many cases, for example, you’ll need to count how many sales happened over a period of time. Or perhaps, you need to know how often a specific user logged into an application. Thankfully, Excel provides a ton of different ways in which to …
The Excel COUNTIF() function is used to count cells that meet certain criteria. For example, the function can be used to count cells that are larger than a given value or contain a given string of text. However, it can also be used to count cells that aren’t empty. In this tutorial, you’ll learn how …
How to Count Not Blank Cells in Excel with COUNTIF() Read More »
Normalizing is a common task in working with large datasets, especially when working in machine learning, data science, and statistics. It’s also often a misunderstood term. In general, normalization refers to scaling values to fit inside a certain range. In most cases, however, it refers to normalization by way of min-max scaling, which returns a …
The AVERAGE() function in Excel will include zeros in calculating the mean value of a dataset. In some cases, however, you’ll want to exclude these values from your calculation. In this tutorial, you’ll learn how to calculate an average in Excel while excluding 0. Excel makes calculating an average in Excel while excluding zeros easy …
By default, Excel will weigh each value in a dataset the same when calculating an average using the AVERAGE() function. This assumes that each value in a dataset carries an equal weight or has the same level of importance. However, this may not always be what you want. While Excel doesn’t provide a built-in way …
