Mastering Conditional Formatting in Spreadsheets

1. Unit 8: Advanced Analysis Lesson 5 and Lesson 6

2. Introduction Question: • Do you think it is possible to change the color of every other row in a spreadsheet without going line by line? This session will be recorded for educational purposes

3. Session Norms: • But I have two CC sessions at the same time! • Alternate days/weeks • Week 1: • TCH010 – M, W, F • OTH020 – T, Th • Week 2: • TCH010 – T, Th • OTH020 – M, W, F • Need to attend a class and break the schedule? • Just make sure to watch the recording! • Keep on top of assignments and due dates • Just because you miss a session does not mean you get an extension! Be on time Be attentive Be proactive Be respectful

4. Today’s Session Objectives I can define what it means to apply conditional formatting to a spreadsheet I can recognize conditional formatting and summarize the conditions given.

5. Today’s Essential Questions http://4.bp.blogspot.com/--OKzbSdqBp4/UzygxbMNsEI/AAAAAAAAGBs/eJipRVAQ__g/s1600/EQ.JPG What is conditional formatting? How do you create conditional formatting? Why is it beneficial to use conditional formatting?

6. What is Conditional Formatting? • Modifying data in a way that makes it stand out • Under Format or Styles menu • Comparisons • Styles • Often used to point out a difference in value • Can use • Single condition • Value > 60 • Multiple conditions • 100 > Value > 50

7. How to Create Conditional Formatting Microsoft Excel OpenOffice Calc

8. Red/Yellow/Green Method • What does this method indicate? • Remember status! • What conditional formatting rules are used? • Red: • Yellow: • Green:

9. Breakout Rooms: Define the Conditions • View given data set • Spreadsheet format • Decide conditions • Greater than, less than, equal to • Color scheme • Place conditions in table • Move components on board • 5 minutes to complete

10. Example: Define the Conditions Green Greater than or equal to Red $1000 Less than Greater than $2000 $5000 Yellow $4000 Less than or equal to

11. Scenario #1: Define the Conditions Green Greater than or equal to Red 100 Less than Greater than 50 75 Yellow 20 Less than or equal to

12. Scenario #2: Define the Conditions Green Greater than or equal to Red 1/31/2016 Less than Greater than 3/31/2016 Yellow 2/01/2016 1/30/2016 Less than or equal to

13. Scenario #3: Define the Conditions Green Greater than or equal to Red 1.00% Less than Greater than 1.50% 1.50% Yellow .50% .25% Less than or equal to

14. Lesson 8.06: Multiple Worksheets • Why use them? • Break up information • Keeps them in 1 workbook • How to use them? • Add sheets (bottom tabs) • Move information between • Reference 1 sheet to another

15. Using Multiple Worksheets: Benefits and Drawbacks What are some other benefits and drawbacks of using multiple worksheets?

16. Today’s Essential Questions http://4.bp.blogspot.com/--OKzbSdqBp4/UzygxbMNsEI/AAAAAAAAGBs/eJipRVAQ__g/s1600/EQ.JPG What is conditional formatting? How do you create conditional formatting? Why is it beneficial to use conditional formatting?

17. Today’s Session Objectives I can define what it means to apply conditional formatting to a spreadsheet I can recognize conditional formatting and summarize the conditions given.

18. Marching Orders http://www.quickmeme.com/img/25/25e50bde8a680670df78a2a49dc285f3326047dd9cfc804568549ee44b25667f.jpg • 8.04 Graded Assignment • Due Today by 11:59pm • 8.05 Graded Assignment • Due 05/09/16 by 11:59pm • 8.06 Graded Assignment • Due 05/10/16 by 11:59pm • Remember to watch the videos for the assignments! • Monday CC Session • Unit 8 Review