Microsoft Excel can perform numerous statistical functions, as well as create charts from statistical data. Statistical data includes numeric variables or word variables, also called categorical ...

Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...

The article, How to highlight unique values in Excel, shows two easy ways to apply conditional formatting to unique values or the row that contains a unique value. In this article, we’ll do the same ...

How to extract a list of duplicate values across two columns in Excel Your email has been sent There are a number of ways to highlight duplicate values. Conditional formatting might be the most common ...

There are a few common techniques for performing division in Excel. You can divide numbers directly in a single cell, or use a simple formula to divide the contents of two different cells. You can ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

You can make a bar graph in Excel by first selecting the range of data you want to depict, and then using the dropdown menu to select the desired chart. A bar graph represents the data of an Excel ...