We all can admit that Microsoft Excel is the best tool in its class, but there are ways to improve it with some cool and free Excel add-ins from the store. Some of these add-ins do basic things, while ...

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...

How to return a column of n consecutive values in Microsoft Excel Your email has been sent The fill handle in Microsoft Excel accommodates most serial list requirements, and it’s one of the first ...

Although Excel 2013 offers many options for performing calculations in new cells using data from existing cells, sometimes you want to work on data in the original cells. As an example, you might have ...

When creating Microsoft Excel formulas, you can generate calculations using specific values—also known as hard-coding—or referencing other cells in the workbook. In this guide, I'll explain why ...

Using just one formula, you can create an entire table, generate a filtered view, calculate a running total, or build a compact list that updates itself every time your data changes. If you’re ready ...

When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...

The needful can be achieved using the COUNTIF function. You could either count the frequency of duplicates in Excel or the order of their occurrence in Excel. Count the frequency of duplicate values ...