Susan Harkins

When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.

It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.

The concept of hiding information until you’re ready to expose it is easy to represent using two animations in a PowerPoint presentation.

Sparklines are small charts that fit into a single cell in Microsoft Power BI and visually represent a span of time.

Microsoft 365 Office apps base color options on the applied theme, but you can change the theme or add custom colors to color palettes.

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Use a pointing arrow in your Microsoft PowerPoint presentation to gently pull eyes from one point to another.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

There is no COUNTIF function in Microsoft Power BI. If you need to apply that logic, you’ll have to turn to other measures.

Microsoft’s Power BI supplies a default date table that’s adequate for many time grouping requirements. Find out how to know if the Auto date table is adequate when using Power BI.

Multiple daily records for calls into your call center can be reformatted as a single record for each caller.

If you want a hyperlink to always work, use absolute and relative hyperlinks appropriately in a Microsoft Word document.