Excel – Conditional Formatting

When

November 7, 2023
11:30 am - 12:15 pm
20 spaces left

Where

Online

Contact details: Paul Atwell @ paul.atwell1@nhs.net

Description

Conditional Formatting is a great way to quickly visualise data in a spreadsheet.  This is for those requiring an understanding of how Conditional Formatting can be applied.

Prerequisites
A good working knowledge of Excel.

Course outline

  • What is Conditional Formatting?
  • Demonstrating preset highlighting rules
    • Highlight Cells Rules
    • Top/Bottom Rules
    • Data Bars
    • Colour Scales
    • Icon Sets
  • Creating a Conditional Formatting rule using a formula
  • Clearing existing rules
  • Highlighting an entire record

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.

Either the booking cut off time has passed, or you are unable to book a place on this event due to security restrictions, please contact NECSU.learning@nhs.net if you believe this to be incorrect.