Text for a week in Excel
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.
(more…)Adding columns to slicers in Excel
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.
(more…)Percentage Area Chart in Excel
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.
(more…)