#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

#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