Latest Blog Posts

How to Return TRUE If Cell Contains Text in Excel (8 Easy Ways)

Sometimes we need to determine whether a cell contains text or not. You'll see this in the following example, where we use the ISTEXT function to ...

How to Create Data Validation with Checkbox Control in Excel

Scenario Imagine we have an empty dataset for ABC Company’s sales data. Our objective is to populate this dataset using data validation with ...

How to Use Wildcard with If Statement in Excel (5 Methods)

  Download the Practice Workbook The wildcard in IF Statement.xlsx Why Wildcard with IF Statement Is Not Working Consider the ...

How to Calculate the Upper Control Limit with a Formula in Excel – 4 Steps

The general formula to determine the upper control limit is: UCL = Average + (3*Standard Deviation)   STEP 1-  Enter Sample Data to ...

How to Create a Vacation Calendar in Excel – 8 Steps

Create a vacation calendar from 2021 to 2030 with a button to change the year. Step 1 - Add a Spin Button to Select the Year Look at the following ...

How to Use VBA Intersect Method in Excel (4 Practical Examples)

An intersection occurs when two or more lines or areas cross one another. The resulting shared point or area is known as the intersection point or ...

[Fixed!] Sort Largest to Smallest Not Working in Excel

Reason 1 - Numerical Data Converted into Text Format The issue can occur if the data we are trying to sort is in Text format. We can only sort data ...

How to Show a Cell Only If the Value Is Greater Than 0 in Excel (2 Examples)

Method 1 - Showing Only When the Value Is Greater Than 0 Steps: Go to C5 and enter the following formula: =IF(B5>0,B5,"") Press ...

Excel Queries and Connections Are Not Working: 4 Possible Reasons with Solutions

Method 1 - The Source Has Not Been Saved Properly If you don’t save the source file correctly, the Excel Queries and Connections won’t work ...

How to Use SUMIF and AND Function in Excel (2 Easy Methods)

Consider the following dataset with some order information. We'll use SUMIF with AND to comb through the data. Example 1 - Application of ...

How to Create Cross Join in Excel (3 Simple Ways)

The sample dataset contains the Color and Sizes of a t-shirt. We will Cross Join these tables to get all the available variations of that t-shirt. ...

Insert Drop Down Calendar in Excel Without Date Picker

Step 1 - Prepare Calendar Layout Prepare the layout of the outline of the calendar. Place the date and month on the sheet. The date and ...

How to Calculate Variance and Standard Deviation in Excel

Basics of Variance and Standard Deviation Variance examines how distinct numerical values relate to one another within a data collection. It ...

How to Use IF Function with OR and AND Statement in Excel

Download Practice Workbook IF Function with OR & AND Statements.xlsx Example 1 - Utilize IF Function with OR and AND Statement in ...

How to Do Polynomial Interpolation in Excel (With Easy Steps)

What Is Interpolation? Interpolation means predicting a value between two specific given data points using the dataset. Data can be linear or ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo