#TipTuesday: Using VLOOKUP

Learn how to use the VLOOKUP function to cross-reference data in this week’s Happy Computers Summer School time saving two minute video! The VLOOKUP function, or Vertical Look Up, is an easy way to show and automatically fill in the information you need. In our example above, Nicky will show you how to use this useful tool toRead more

#TipTuesday: Create a Pivot Table

Learn how to create a Pivot Table in this week’s Happy Computers Summer School time saving two minute video! Pivot Tables are a fantastic way to easily sort and analyse your data in Excel. It’s a quick way to see the full picture, as well as being a more attractive way to present a lot of data andRead more

#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