Thank You!

Bottom Line: Learn how to apply conditional formatting to pivot tables so that the formats are dynamically reapplied as the pivot table is changed, filtered, or updated.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container [...]

Bottom Line: Learn how to create simple macro buttons that users can click to instantly add or remove fields to Excel pivot tables.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; l [...]

Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data.  I also share a non-macro solution to update the pivot tables when the file is opened.  Includes video tutorial and Excel file download.Skill Level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overf [...]

Bottom line: Learn how to calculate the average of a daily total amount across month, quarters, years, or even categories with a pivot table.Skill level: Intermediate.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; [...]

Bottom line: Learn how to turn the GETPIVOTDATA formulas on/off when you create a formula that references a cell inside a pivot table.Skill level: Beginner.embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; lef [...]

Bottom line: Learn how to change the date formatting for a grouped field in a pivot table.Skill level: Intermediate[...]