Office 2016–New Chart Types

As a seasoned producer of charts, you have probably wondered why Microsoft has not included certain type of charts that have previously only been available via third-party add-on programs.  Microsoft has heard your calls and added some new and exciting charts to the Office 2016 charting engine.  These charts type are not just available in […]

Apply Two Different Number Formats to a Single Field (Excel Pivot Tables)

There comes a time in every Excel Power User’s life when they must deal with mixed content in a single field.  Examine the following table: The Value field (column E) contains a mixture of sale amounts (values as decimals) and discount rates (percentages.)  If a pivot table is constructed using this data, it can take […]

Automatically Refresh Pivot Tables in Excel

Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most user’s see this as a glaring lack of functionality. There is, however a […]