Basic Excel – Excel in Colour: looking at spreadsheets and their increasing use of colour

It seems to us that as Microsoft update their versions i.e. 2010, 2013 and 365 that the use of colour in Excel in particular is increasing. This article is meant to give you an idea of where you can make an impact in Excel using some of these new features.

Sorting

You can now sort by cell colour or font colour. Simply go to the Data tab, Sort button and add levels choosing not values to sort by but by a type of colour

Conditional formatting

By selecting a range of cells you can apply again cell or font colour to these based upon certain criteria e.g. greater than, between, less than or even on a formula to colour code the whole row. Home Tab, Conditional formatting button allows for this and also allows Data Bars and icon sets too!

Charts

Clearly charting by nature will be colourful but did you know that in the recent versions of Excel you can chart in at least 4 different ways:

  • By using the QA (Quick Analysis button) at the bottom of your selected range is quick to choose a chart which suits
  • By Using Sparklines you can create a chart in a cell
  • By using the ever popular F11 key
  • By using Insert Recommended Charts

Pivot Charts

Again these are simple to create and with them you get a Pivot Table too! Use the Insert Tab and Pivot Charts. Try using the new Timeline and Data slicer for ease of use for filtering your data on the Pivot Chart or Table.

One last thing for you experts or lovers of Excel; we launched this summer to good feedback our new Excel Master Class course. It’s for those who’ve attended either or both of our Intermediate or Advanced courses.

If you and your colleagues are interested in any of our courses mentioned above, or even going back to our Basic Excel course, then please contact us in the usual way at johnlegge@jplcomputer.co.uk or see our web site for details

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy