One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that allows ...

Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...

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 ...

When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand. This is where the data filtering feature of the program can ...

To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your colleagues and clients. Applying an ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Here are a few quick methods of analyzing records to find out what's been paid and how much customers owe. If you work with transaction records, you probably need a way to track what’s outstanding and ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

The general ledger is a vast historical data archive of your company’s financial activities, including revenue, expenses, adjustments, account balances, and often much more. The detailed transactions ...