{"id":889,"date":"2012-10-24T10:24:24","date_gmt":"2012-10-24T10:24:24","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=889"},"modified":"2023-12-30T23:12:48","modified_gmt":"2023-12-30T23:12:48","slug":"use-conditional-formatting-to-analyse-data-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/use-conditional-formatting-to-analyse-data-in-excel\/","title":{"rendered":"Use conditional formatting to analyse data in Excel"},"content":{"rendered":"

An experiment using conditional formatting…<\/p>\n

I have a list of fictitious students who have taken an Excel exam this morning. The pass mark was 55, but I want to help the whole group to achieve a Grade B with a pass mark of over 70%.<\/p>\n

I want to be able to find who needs to attend an extra workshop to help boost their skills and get them to 70%. \u00a0I can identify the students quickly by using conditional formatting.<\/p>\n

Here is my list of students and their grades<\/p>\n

\"list-of-students-course-on-excel\"<\/a>
List of students and their exam results.<\/figcaption><\/figure>\n

I want to find all those students whose grades were under 70. \u00a0I select my table, and then, use the Home tab, Conditional Formatting, and select Highlight Cells Rules, then select Less than. \u00a0A dialogue box appears and I need to put in the value. \u00a0I type in 70, as I want to know all the scores below 70, and press ok.<\/p>\n

\"Highlight-results-below-70-course-on-excel\"<\/a>
The dialogue box appears and I can type in the score. Excel will then identify all the results less than that value.<\/figcaption><\/figure>\n

I now know, that out of 15 students, 13 would find a workshop helpful to boost their skills. \u00a0I can now set up the room, and the trainer can target his course on Excel<\/strong> to help the students reach their target score.<\/p>\n

I can use the filter <\/strong>in my table to give the trainer the names of the students for his session.<\/p>\n

I go to the filter arrow on the results column and select filter by colour<\/strong><\/p>\n

\"filter-by-colour-course-on-excel\"<\/a>
Filter by colour – is a quick way for me to create a delegate list for the session.<\/figcaption><\/figure>\n

Here is my workshop attendance list, with the 13 students names.<\/p>\n

\"Final-list-filter-by-colour-course-on-excel\"<\/a>
Here is my final list.<\/figcaption><\/figure>\n

This is a quick way to experiment with analysing data using conditional formatting, and using the filter to pick out the data you want (and hide the data you don’t need at that moment). \u00a0A course on Excel is a convenient way to upgrade your skills and experiment with data before you try it out in the workplace. \u00a0https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

An experiment using conditional formatting… I have a list of fictitious students who have taken an Excel exam this morning. The pass mark was 55, but I want to help the whole group to achieve a Grade B with a pass mark of over 70%. I want to be able to find who needs to […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[109,122,305],"class_list":["post-889","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-conditional-formatting-in-excel","tag-course-on-excel","tag-how-to-use-the-filter-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=889"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/889\/revisions"}],"predecessor-version":[{"id":6746,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/889\/revisions\/6746"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}