This month, I received a lot of Excel questions. So in this article, we'll tackle random time values, an icon-displaying conditional expression and format, and a quick PivotTable solution. For ...

The PivotTable displays only the top 10 unit price values. You could use the resulting PivotTable as is, but there are a few issues you might want to consider first. Let’s take a look next.

The numeric format shown above will hide literal zeroes and most returned by a formula. When you run into an exception, you can use a conditional format as follows: Select the cells that contain ...

If a value is less than zero, the conditional formatting is applied to that row. Click the "Format" button and apply your preferred formatting. Tabs contain options for numbers, font, border and fill.