Latest Blog Posts

How to Use VBA Evaluate Function in Excel (4 Practical Examples)

In this tutorial, I am going to share with you 4 practical examples of how to use the VBA Evaluate function in Excel. You can easily apply these ...

How to Resize the Chart Plot Area Using VBA in Excel – 3 Steps

Download Practice Workbook Download the practice workbook. Resizing Chart Plot Area Using VBA.xlsm Step 1 - Populate the Dataset The ...

How to Use Macaulay Duration Formula in Excel (2 Easy Methods)

In this article, I will show you how to use the Macaulay Duration formula in Excel. While performing many financial calculations, especially while ...

How to Use Dividend Discount Model Formula in Excel

The Dividend Discount Model Formula determines the stock price based on the probable dividends one will pay. It helps to evaluate a company based on ...

Excel DSUM vs SUMIF Functions (2 Suitable Examples)

We normally need to evaluate the summation of values by criteria. Which is one of the most commonly used functions in the world. So, to carry out ...

How to Create Gaussian Distribution Chart in Excel

Microsoft Office 365 was used to create this article, however you can use other versions according to your preference. If any of the steps don't work ...

Excel VBA to Change Cell Background Color (2 Suitable Examples)

You may change the cell background color easily from the Home tab of the Excel worksheet by changing the Fill Color of a cell. But do you know that ...

[Fixed!] Drop Down List Ignore Blank Not Working in Excel

What Is Drop Down List? A drop-down list allows the user to choose text or numbers from a list rather than typing them into a cell. To insert a ...

How to Turn Off AutoComplete in Excel (3 Easy Approaches)

Excel offers duplicate values from related cells when we start entering data into a cell, and we can take those identical values by pressing Enter at ...

How to Clear Pivot Table Cache Using VBA in Excel

If we delete some data from the source table of a Pivot Table, in the Pivot Table that data will still be available because the deleted cells are ...

Excel Formula for Finding Odd or Even Numbers

In this article, we will show formula for finding odd or even numbers in Excel. We will create Excel formula with common functions like IF, MOD, ...

How to Use Artificial Intelligence in Excel (4 Easy Examples)

Example 1 - Evaluating Intelligence Suggestions with Analysis When you are working with a large dataset and want to insert a chart, the Analyze Data ...

How to Pull Data from a Date Range in Excel: 7 Ways

We'll use a simple sales dataset to demonstrate how you can pull data from a date range. Method 1 - Using the FILTER Function Steps: ...

How to Hide Filter Arrows from Pivot Table in Excel (3 Easy Ways)

When generating a Pivot Table in Excel, various Field Buttons including Filter Arrows appear automatically on the table headers. In this article, we ...

Find Value in Row and Return Column Number Using VBA in Excel

When working with a large number of data in Excel, it may be difficult to locate a value or a piece of data. Using VBA code this difficulty can be ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo