Learn how to add subtotals to your filtered data in Excel with this quick tutorial. Episode 2563 covers the essentials!

Many of them are backward- and forward-compatible, but check the system requirements before you download anything. Note that newer isn’t always better: Many of the ...

Whenever I manage large databases and projects in Excel, Microsoft’s spreadsheet software can sometimes feel intimidating. It often results in an inefficient and frustrating experience. Then, I ...

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 average unique values in Excel the easy way Your email has been sent If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't ...

Have you ever come across a Wall Street Journal chart and thought, “Wow, I wish I could create something that polished”? Whether you’re preparing for a big presentation, crafting a report, or simply ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

The Solver add-in for Microsoft Excel is one of the most important, so we can understand the frustrations when users cannot get it to work as they hope. In older versions of Excel, folks had to ...