Blogs from Wise Owl on Excel functions in Excel

A blog showing how to use the SUMPRODUCT function

Posted by Andy Brown on 01 November 2013

The SUMPRODUCT function is one of the hardest ones to understand in Excel, but it's also pretty useful. This blog gives clear examples of how to use SUMPRODUCT for conditional sums, weighted averages and the like.

Rounding numbers in Excel

Posted by Michael Allsop on 23 October 2012

Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!

10 Excel Quick Tips

Posted by Andrew Gould on 02 December 2011

Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!

Using the VLOOKUP Function in Excel to Calculate Exam Grades

Posted by Andrew Gould on 22 August 2011

The VLOOKUP function in Excel is perfect for categorising a continuous range of numbers. This topical example shows you how to calculate an exam grade based on a numerical score.