In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value. Grouping records by dates or time is easy in Microsoft Excel, but it doesn’t make a great report ...

PivotTables in Microsoft Excel are a great way to get insights from big data sets in just a few seconds. However, most people don't make full use of their capabilities, sticking to their basic ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever. Returning the top or bottom n ...

Most people build a PivotTable, drag a field into Values, get a sum, and walk away. That's fine if all you need is a total, but totals on their own are just numbers sitting there. They don't tell you ...