How to Make a Scatter Plot in Excel

How to Make a Scatter Plot in Excel (2024)

Do you have columns of quantitative data in your Excel sheet that only consist of a list of figures? How can you visualize and analyze the relationship between this quantitative data at a glance? Through … Read more

Excel has filtered out the dashes using the SUBSTITUTE function

How to Remove Dashes in Excel (2024)

If you’ve ever worked in an HR role, you know how challenging it can be to maintain a large volume of personal details for multiple employees, including their CNIC numbers, IBANs, Passport numbers, or even … Read more

Strikethrough formatting applied to selected data in a cell

How to Strikethrough in Excel (2024)

Excel is great at number operations and data analytics. However, when it comes to formatting of data, particularly text, you’d find Excel silent about quite a few things. For example, the strikethrough function. Take a … Read more

Averageif in Excel

How To Use AVERAGEIF Function in Excel?

To find the average of only those values that meet a specific criterion, you need to employ the AVERAGEIF function in Excel. Learn all about this function in the article that follows. AVERAGEIF Function The … Read more

Results of AVERAGEA for a defined range of cells containing a text value

How to Calculate Average in Excel?

Excel offers several functions to compute average, and there are many ways how you can calculate it. Let’s dive right into the different methods for average computation in Excel. 1.  AVERAGE Function The most common … Read more