Start typing to search the whole website.

Summit Consulting Ltd
Home
Password Strength Checker Cyber Risk Quick Check Are You Safe Online? Are You Cyber Secure? AML Compliance Quiz Data Privacy and Protection Act Quiz Financial IQ Quiz Culture Audit MS Office & Excel Skills Quiz Risk Management Self-Assessment IFRS 9 Adoption Questionnaire 10-Minute Leadership Presence Self-Assessment Board Diversity Assessment Tool MFA Authentication Quiz Benford Analysis Tool Internal Audit Survey BCP / DR Survey Insurance Fraud Policy Questionnaire Fraud Management Survey Strategy Implementation Effectiveness Survey Boardtool Resources 7 Tools Board Book iShield 360 Project FRONTLINE Report Summit Weekly Newsletters Uganda Banking Report The Human Rights Enforcement Act 2019: A Guide Managing Board Affairs in a New Era Barriers to Effective Strategy Execution 8 Strategies to Overcome Sales Rejections Board Evaluation Tool SummitEthical Board Assessment Tool Board Effectiveness Template Executive Ownership Matrix Chair-CEO Gap Framework The 5-Fit Test for Directors The Promotion Readiness Grid The Accountability Chain The Alignment Grid The Trench Leadership Index The Secretary Power Grid Future Director Matrix Mr Strategy's Compass Card Template Mr Strategy's Culture Health Check Tool The Chair Navigation Compass The Fear Filter Tool Leadership Readiness Assessment Scorecard ERM Accountability Map Template Key Risk Indicator (KRI) Template ICT Asset Register Template Digital Risk Oversight Radar Template Enterprise Risk Management Framework and Internal Audit Program Audit Committee Briefing Report Template Internal Audit Board Briefing Template Fraud Reporting Register Template AI and Machine Learning Risk Governance Assessment Tool Strategic Foresight Audit Tool EXCO Execution Grid SIEM Tool Assessment Criteria Cybersecurity Assessment Tool (ISO 27001 and NIST) iShield 360: Multi-Factor Authentication Tools iShield 360 Cybersecurity Risk Assessment Template iShield 360: DLP System Tool Phishing Awareness Guide Password Security Checklist Black Box Penetration Testing Checklist Penetration Testing Scoping Questionnaire Cyberattack Incident Response Plan (CIRP) Template End-of-session Leadership Transition Evaluation SOC Assessment Survey Cybersecurity Survey Questionnaire IFRS9 Adoption Questionnaire
Insights
Talk to us
+256 782 610333 support@summitcl.com

Welcome back to this, a continuation from the lesson “Sorting a range on multiple columns“.

Sorting data by colour is a great way to make data analysis easier and help the users of your worksheet see the highlights and data trends at a quick glance.

Overview

Sorting data is an integral part of data analysis. You sort data to quickly organize your data and to find the data that you want. Sorting data can help you and other people who use your spreadsheet make more effective decisions based on your data. You can sort data by format, including cell color and font color, whether you have manually or conditionally formatted the cells.

Exercise

To sort data by colour, execute the following steps:

  • Download and extract the contents of the zip archive Sorting by Colour.
  • Open the file “Sorting by Colour.xlsx”
  • Click any single cell inside the data set.

  • On the Data tab, click Sort.

The Sort dialog box appears.

  • Sort by First Name (or any other column), sort on Cell Colour (you can also sort on Font Color and Cell Icon), and select the green colour for the first level.

  • Click ‘Copy Level’ two times and select the other colours.
  • Click OK

Result.

In our next lesson, we shall look at: REVERSING AN EXCEL LIST.

Thanks for the custom.

0 comments

Leave a comment

Keep reading

More from Summit Consulting.