Latest Blog Posts

[Fixed] Excel Compatibility Mode Not Responding

In this article, we will learn what to do if compatibility mode is not responding in Excel. Compatibility mode is a very important mode in Excel. We ...

How to Generate All Possible Combinations of a Set of Numbers in Excel (3 Methods)

Dataset Overview Let’s assume we have a dataset, namely Unique House Number of USA. Method 1 - Using Excel Formula This method involves ...

How to Create a Spin Button with VBA in Excel – 3 Methods

The sample dataset showcases a House Rent Calculator. It has information on Monthly Rent, Community Bill and Council Tax. To get the Total ...

How to Insert WordArt in Excel (2 Simple Methods)

In this tutorial, I am going to share with you 2 simple methods to insert WordArt in Excel. You can easily apply these methods in any set of data to ...

How to Make a Checklist in Excel Without Developer Tab

To make a list updated in an Excel worksheet, generally, we use a checkbox. In this article, using a checkbox we are going to check or uncheck a ...

How to Calculate 2 Sigma in Excel – 2 Methods

What Is the 2 Sigma? Sigma refers to the Population Standard Deviation. The formula is: Sigma = √(x-µ)2/N N = Population Size µ = ...

How to Graph Uncertainty in Excel (2 Easy Ways)

The following dataset has columns labeled Sales, Profit, and Uncertainty of Profit. We will create a chart now that compares the number of sales to ...

How to Draw Circle in Excel (4 Simple Methods)

The sample dataset that represents circular components and values. We will use these number values to draw a circle in Excel. Method 1 - ...

How to Create Dynamic Tooltip in Excel (with Easy Steps)

Step 1 - Use Formula to Fetch Data from Another Sheet In a new worksheet, create a data table with columns L No and Name. In the first column, ...

How to Calculate Skewness in Excel (2 Effective Methods)

Skewness is a basic statistical concept. Sometimes, you may need to calculate the skewness in Excel. So, if you are looking for how to calculate the ...

How to Get Excel VBA Combobox with RowSource Named Range

The sample dataset has three columns, Name, ID, and Contact Number. The dataset ranges from B4 to D10. Step 1 - Creating a ListBox ...

How to Get All Combinations of 2 Columns in Excel (4 Easy Ways)

Method 1 - Using Excel Power Query Editor to Combine 2 Columns Steps: Select cell B5 in the Gender column. Go to the Insert tab. Select ...

How to Add Cell Tooltip in Excel (3 Easy Methods)

Consider a worksheet where we have a list of grocery items. In this list, in one column, we have the item name. In another column, the price per unit ...

How to Use Truncate in Excel VBA  (3 Effective Ways)

Method 1 - User-Defined Function to Truncate Text Steps: Create an organized dataset. We have a dataset with football players’ full names. We ...

How to Insert Clipart in Excel (4 Easy Ways)

Inserting pictures, clipart, and other kinds of images into an Excel workbook can enhance visual appeal and help convey the idea more clearly. In ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo