BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Wise Owl blogs written by Michael Allsop
Showing blogs 1-8 (out of 8)
Drop Lines in Excel Charts: Ah, that's what I needed!
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 Michael Allsop on 23 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Highlighting negative columns in Excel charts
Posted by Michael Allsop on 01 October 2012
Ever wondered if you can make negative columns automatically turn red in an Excel chart? Well now you can in Excel 2010!
Importing Bank Holidays into the Outlook Calendar
Posted by Michael Allsop on 03 January 2012
A quick guide to adding public holidays to the Calendar in Outlook 2010.
Using Icon Sets for conditional formatting in Microsoft Excel
Posted by Michael Allsop on 19 October 2011
This article looks at one of the new features in Conditional Formatting in Excel which we can use to make our boring lists more interesting!
Conditional formatting with Data Bars in Microsoft Excel
Posted by Michael Allsop on 19 October 2011
Following on from the article discussing simple conditional formatting in Excel, this blog shows you how to add Data Bars to your lists for that extra bit of pazazz!
How to apply Conditional Formatting in Microsoft Excel
Posted by Michael Allsop on 19 October 2011
This short article looks at the basic settings for creating conditional formatting rules in Excel.
Using sheet codenames in Microsoft Excel VBA
Posted by Michael Allsop on 01 June 2011
Do your macros keep falling over due to users renaming their worksheets in Excel? Read this article to find out if sheet codenames could be the solution you need.