Join Aaron Quigley for an in-depth discussion in this video Double-checking values with conditional formatting, part of Office for Students.
As students, it's very easy to use Microsoft…Excel just as a way to organize your data.…For example, here we have a variety of experiments, one…through 16, and the corresponding results or the height in centimeters.…Often I see students type it up into their…Excel spreadsheet, and then that's the end of it.…Here they feel that they've graphically represented their data.…However, using formulas such as conditional formatting will…really allow this data to be visually represented.…Furthermore, as a student, if you're trying to analyze this data in order to…answer questions, some of these visual representations…can make your analysis a lot easier.…
Let's go ahead and dive into using conditional formatting…to make this data a lot more visually appealing.…The first thing I want to do is create a quick way to show which data…points are the highest, and which data…points are the lowest for these particular heights.…To do that, I am going to go and select the data.…I'm then going to come up under the Home tab and click conditional formatting.…
Are you a teacher? Try our companion course, Office for Educators.
- Creating assignment templates
- Tracking changes and adding notes
- Creating bibliographies and citations
- Presenting in PowerPoint with SlideShare
- Using Excel to manage data
- Keeping school and personal email organized in Outlook
- Setting up a calendar
- Using SkyDrive to back up papers and assignments