Excel

  • DATEDIF function in Excel

    I was recently asked a question about Excel, which led me to discovering an Excel function I never knew existed, and would probably have never found by accident (certainly not by clicking on the Fx button or seeing it listed...

  • Using SUBTOTAL in Excel

    Hi again, This blog looks at the Excel function SUBTOTAL and how you might find it useful: The SUBTOTAL function has two parts within the brackets: the second part is the easy bit - the range of cells you're using; the...

  • Sorting in Excel

    The other day, when I was showing the basics of creating a worksheet in Excel, I was asked  a really good question - one that made me think “I’m sure you must be able to!” and “Why have I not heard (or...

  • Merging dates from Excel into Word

    If you mail merge Excel files into Word documents, you may find this blog very useful.  Someone recently raised the issue of the format of a date merged from an Excel file into a Word document. The problem is that...