Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Scatter charts use two columns of data for each point. By default, Excel will use the first column for the X coordinate and the second for the Y coordinate. To add additional data for the Y axis ...

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

While they might look like an advanced feature, it's very easy to add data bars to a spreadsheet in Excel with just a few clicks.