Microsoft provided an update during this week's Build Conference event for developers regarding custom functions for Excel and related capabilities.

You can create many types of groupings using the GROUPBY function, which is excellent for data analysis. It serves as a great alternative to traditional PivotTables.

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

The first step in creating a powerful PivotTable is to gather your data from various sources. Excel provides the flexibility to pull data from different worksheets, databases, or even external files.

Q: My Excel 2013 PivotTables sometimes default to using the COUNT function instead of the SUM function. Is there a setting adjustment that will always make SUM the default PivotTable result? A: When ...