Posted by
Andy Brown
on 01 November 2013
Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!
Posted by
Andy Brown
on 01 November 2013
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
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.
Posted by
Andy Brown
on 13 August 2013
A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!
Posted by
Andy Brown
on 12 August 2013
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Posted by
Michael Allsop
on 24 May 2013
Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.
Posted by
Andy Brown
on 04 April 2013
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Posted by
Michael Allsop
on 17 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Posted by
Andrew Gould
on 28 February 2012
If you've ever been annoyed by somebody else changing parts of your Excel workbooks it's a good idea to learn about protection to prevent them from doing it again!
Posted by
Andrew Gould
on 28 February 2012
If you're constantly frustrated by other people entering the wrong values in your spreadsheets why not learn how to use data validation to prevent them? This blog series explains how you can control what other people can do to your spreadsheet.
Posted by
Andrew Gould
on 27 February 2012
Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!
Posted by
Andrew Gould
on 24 February 2012
Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!
Posted by
Andrew Gould
on 24 February 2012
Constantly formatting cells in the same way can be one of the most tedious and time-consuming tasks in Excel. This blog teaches you how to use styles so that you can quickly apply consistent formatting across a range of cells.
Posted by
Andrew Gould
on 03 October 2011
If you've ever tried to enter fractions in Microsoft Excel you'll probably have become frustrated when Excel insists on converting them into dates! Read this blog to see how to prevent this from happening.
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.
Posted by
Andrew Gould
on 22 August 2011
Did you know that you don't have to use cell references in calculations in Microsoft Excel? You can use range names to create sensible, plain English names to refer to your cells and use those in your formulae instead. Read this blog to find out how.
Posted by
Andrew Gould
on 08 June 2011
Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.