Latest Blog Posts

How to Use Power Query Date Functions in Excel (3 Examples)

Consider the dataset below. Some products of an online store, their order, and delivery dates are provided. Example 1 - Getting the Year, ...

How to Perform Pipeline Design Calculations in Excel (2 Examples)

Method 1 - Finding Pipe Diameter for Pipeline Design Calculations Steps: Enter the given data. Use the following formula to find the ...

How to Create an Automatic Schedule Generator in Excel (Easy Steps)

Step 1 - Prepare the Dataset Dataset Selection: Assume we have a dataset named “Project Timeline of ABC Multipurpose Bridge.” However, feel ...

How to Find Average with Blank Cells in Excel: 4 Easy Ways

Method 1 - Use AVERAGEIF Function to Find Average with Blank Cells in Excel Steps: Add a row named Average in row 11. Type the following ...

How to Create Grade Distribution Chart in Excel (2 Examples)

Example 1 - Insert a Pie Chart for Grade Distribution Steps: Insert a column named “Grades”. To find out the grade, select cell D5 and enter ...

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 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 ...

[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 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 ...

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 ...

How to Create A Product Catalog in Excel: 5 Methods

Method 1 - Make the Dataset Ready Collect the information about the mobiles stored in the shop. Collect the images of the mobiles that are ...

How to Check If a Number Is Odd or Even with Excel VBA

In this article, we will demonstrate a step-by-step procedure to check if a number is odd or even with VBA in Excel. We used Office 365, but you may ...

How to Add Standard Deviation Error Bars in Excel: 5 Methods

Method 1 - Input a Dataset with Necessary Components Insert a dataset that will be populated with the necessary components. We have taken a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo