Posted by
Andrew Gould on 24 February 2012 | no comments
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 31 October 2011 | no comments
When you enter dates into cells in Microsoft Excel you're initially limited to a short list of fairly boring formats. Using custom date formats means that you can display your dates in almost any way you like!
Posted by
Michael Allsop on 19 October 2011 | no comments
This article looks at one of the new features in Conditional Formatting in Excel 2007/2010 which we can use to make our boring lists more interesting!
Posted by
Michael Allsop on 19 October 2011 | no comments
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!
Posted by
Michael Allsop on 19 October 2011 | no comments
This short article looks at the basic settings for creating conditional formatting rules in Excel.
Posted by
Andrew Gould on 03 October 2011 | 1 comment
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 19 September 2011 | no comments
Have you ever been asked to reproduce your company's brand colours in your latest PowerPoint presentation, or wanted to use your corporate font colours in your latest Word report? This blog will show you how to pick your colours accurately in any of the standard Microsoft Office applications.