#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

#TipTuesday: Conditional formatting

Learn how to use conditional formatting to analyse your data in this week’s Happy Computers Summer School time saving two minute video! Conditional formatting is a great way to quickly see which data matches a certain filter at a glance. For example, you could highlight your biggest sales to make them easily stand out. WantRead 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