by Ilker | Jan 29, 2019 | Excel Tips & Tricks
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...
by Ilker | Jul 11, 2018 | Excel Tips & Tricks
Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However, they won’t work when have date-time values combined. In this article we will cover grouping dates in Pivot Table. Steps Select a cell in your data Click Pivot Table...