#TipTuesday: CountIf function

Learn how to use the CountIf function in this week’s Happy Computers Summer School time saving two minute video! CountIf allows you to count all the cells that have a given value. For example, if you wanted to count the number of products sold in a certain colour, or the number of sales in a particularRead more

Excel Hints & Tips – Slicers

Slicers In his blog on Pivot Perfection, Darren showed us how to easily produce a series of Pivot Tables for each category we want to filter on. Slicers make it easy to have one Pivot Table that can switch between different categories. Let’s start with the same data that Darren used: The next step is to addRead more