When working with weeks in Excel you may need to show the start and end date of the week in the same cell. Here’s how you can do that.
Slicers are a great filter interface. Sometimes, due to layout restrictions, you prefer the slicer to go across the sheet rather than down the sheet. Here’s how you do that.
You can use a pie chart to display a percentage, but it wastes a lot of space. An alternative that takes up less space is an area chart.
In this post I finish off the Calendar matrix by adding holidays.