excel Archive

  • TweetHow to use AND, OR and NOT in an Excel IF function…

    Microsoft Excel IF function

    TweetHow to use AND, OR and NOT in an Excel IF function…

    Continue Reading...

  • TweetI just had a rather strange problem with Microsoft Excel 2010. When opening the workbook nothing appeared on the screen: Evidently something had loaded since the formula bar contained data […]

    Restoring missing Microsoft Excel workbook windows

    TweetI just had a rather strange problem with Microsoft Excel 2010. When opening the workbook nothing appeared on the screen: Evidently something had loaded since the formula bar contained data […]

    Continue Reading...

  • TweetShort version: Review tab – Show comments Arrange comments on page Page setup – Sheet tab – Comments at end of sheet Long version on the Office Online Help.

    Printing comments in Excel 2010

    TweetShort version: Review tab – Show comments Arrange comments on page Page setup – Sheet tab – Comments at end of sheet Long version on the Office Online Help.

    Continue Reading...

  • TweetI often have the need to match something like a student’s mark to a grade which lies within a boundary. For example a grade ‘A’ might cover marks in the […]

    Microsoft Excel VLookups

    TweetI often have the need to match something like a student’s mark to a grade which lies within a boundary. For example a grade ‘A’ might cover marks in the […]

    Continue Reading...