Latest Blog Posts

How to Create a Bar Chart with Standard Deviation in Excel: 4 Methods

Method 1 - Making Data Set with Proper Parameters Create a data set first. Method 2 - Finding Standard Deviation and Mean Select ...

How to Create an Event Calendar in Excel (with Easy Steps)

An Excel Event Calendar is a tool that tracks and schedules events, meetings, and appointments in a calendar format. It can be a useful tool for ...

How to Use IF Statement with Not Equal To Operator in Excel

To illustrate using the IF function with the not equal to operator, let's examine a representative dataset. First Collection and Second Collection ...

How to Set Logarithmic Scale at Horizontal Axis of an Excel Graph

STEP 1 - Prepare the Dataset In this dataset, there is information about the population of humans and African Elephants over a large range of ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo