NA Function

### How to Use Conditional Formatting in Data Labels in Excel

In this article, we will show 3 examples of how to use conditional formatting in data labels in Excel. In these methods, users can apply conditions ...

### How to Skip Data Points in an Excel Graph (with Easy Steps)

Excel is a great tool for showing data in various charts and graphs. These features of Excel help to visualize numerical data. But, sometimes, users ...

### How to Calculate Moving Range in Excel (4 Simple Methods)

While working in Microsoft Excel sometimes we need to calculate moving range in excel. It is also known as the moving average. Today in this article, ...

### How to Hide Zero Values in Excel Chart (5 Easy Ways)

Zero values often create difficulties while visualizing data in a chart. They even lead to mistakes in data interpretation. Thus, hiding the zero ...

### How to Ignore Blank Cells with Formulas in Excel Chart

Sometimes we have some blank cells in our dataset. When we plot them in an Excel chart, we can’t get the desired chart for these blank cells. In that ...

### How to Hide Zero Data Labels in Excel Chart (4 Easy Ways)

Sometimes you have some zero values in our dataset. When you plot that dataset in a chart, it will show zero data labels in the chart which is quite ...

### How to Create Monthly Trend Chart in Excel (4 Easy Ways)

A trend chart is a chart that shows the general pattern of data over time. The trendline is used to represent the future of the data. In Microsoft ...

### How to Color Excel Bubble Chart Based on Value (2 Easy Methods)

In this tutorial, you will learn some valuable techniques to color your Excel Bubble Chart based on its value in the dataset. Because complex ...

### How to Change Bar Chart Color Based on Category in Excel (3 Methods)

The article will show you how to change the Bar Chart color based on the category in Excel. The application of this can help you to visualize certain ...

### How to Remove Zero Data Labels in Excel Graph (3 Easy Ways)

If you are looking for ways to remove zero data labels in an Excel graph, this article is for you. So, let’s start with the main article to know ...

### How to Create Excel Scatter Plot Color by Group (3 Suitable Ways)

In our daily life, we often feel the necessity to create Excel scatter plots in Microsoft Excel. We can do the job in many ways. In this article, we ...

### How to Remove Outliers in Excel Scatter Plot (3 Easy Methods)

Sometimes in our dataset, there may remain some outliers. That means, some values get much deviated from most of the other values. While making ...

### How to Remove Outliers in Excel (3 Ways)

Finding outliers and removing them is a very common task to analyze data in statistics, data mining, machine learning etc. There are so many ways ...

### How to Calculate Moving Average in Excel (4 Examples)

The Moving Average is also known as the Rolling Average or Running Average in Excel. In this article, we will show you how to calculate the moving ...

### How to Use VLOOKUP with COUNTIF (3 Easy Ways)

In this article, we will use the VLOOKUP function with the COUNTIF function in Excel. VLOOKUP and COUNTIF are mostly used and powerful functions in ...

Advanced Excel Exercises with Solutions PDF