Advanced Excel

How to Calculate Exponential Moving Average in Excel

Exponential Moving Average is widely used for forecasting future data and smoothening stock price movement. If you want to know what an exponential ...

How to Calculate Weighted Average in Excel Pivot Table

In this article, I will discuss how to calculate weighted average in Excel Pivot Table. Finding weighted average in Pivot Table is a bit complex. ...

How to Use Excel INDIRECT Range (8 Easiest Ways)

The INDIRECT function (a Lookup & Reference function) is used to return the reference specified by the text string. This function is used to get ...

How to Use Indirect Address in Excel (12 Examples)

In this article, you will get to know some of the examples of indirect address in Excel. By using an indirect address, you will be able to refer to ...

How to Remove 0 from Excel (7 Methods)

In this article, I will discuss how to remove zeros (0) from Excel. Often, when we work with spreadsheets not prepared by us, we face different types ...

How to Use Nested VLOOKUP in Excel (3 Criteria)

The VLOOKUP function is one of Microsoft Excel’s most powerful, flexible, and extremely useful functions to search and retrieve values – either ...

VBA to Check If Font Color is Red Then Return Results in Excel

Implementing VBA macro is the most effective, quickest, and safest method to run any operation in Excel. In this article, we will show you if the ...

How to Remove Format As Table In Excel

In this article, we will discuss how to remove format as the table in Excel. Often, while working in Excel, we apply different types of styles and ...

Statistical Comparison of Two Data Sets Excel

In this article, I will discuss the statistical comparison of two data sets in Excel. At times, while working with spreadsheets, we have to compare ...

How to Change Text Color with Formula in Excel (2 Methods)

Changing text color is a very important task in Excel. It helps in many ways to highlight and analyze data. We can do it manually but there is no ...

How to Remove First 3 Characters in Excel (4 Methods)

While you are working with unstructured raw data you may often need to extract relevant information from it. Sometimes you need to remove first, ...

VBA to Use Range Based on Column Number in Excel (4 Methods)

In this article, you will learn how to use Range to do different tasks in Excel based on the column number with VBA. Download Workbook You ...

How Excel Remove Named Range (4 Quick Methods)

In Microsoft Excel, named range can make your spreadsheets dynamic and faster to update. You can easily remove or delete unwanted Named Ranges by ...

How to Remove Letters from Cell in Excel (10 Methods)

In this article, you will learn how to remove letters from a cell in Excel. Download Workbook You can download the free practice Excel ...

VBA to Remove Formulas in Excel Keeping Values and Formatting

In this article, I’ll show you how you can remove formulas from a worksheet in Excel keeping the values and formatting with VBA. First, you’ll learn ...

ExcelDemy
Logo