Monday, January 10, 2011

Excel 2007 Conditional Formatting

Professional Development Provider SOITA Learning Technologies
Contact Information Bob Stricker
bob@soita.org
150 East Sixth Street
Franklin, OH 45005
United States
Phone: (937) 746-6333 ext. 120
Fax: (937) 746-1029
Program Type Individual Program
Program Rating This program has not yet been evaluated.
Target Audience Education: Technology Director, Teacher
Maximum Number of Participants no maximum
Minimum Number of Participants 1
Primary Disciplines Best Practice, Curriculum, Technology/Information Science
Program Description Do you want to make your Excel data easier to interpret and save time doing it? Use Excel’s conditional formatting feature! Conditional formatting applies a defined format to cells that meet specific criteria. These formats might include a different background color, font color or border. The goal is to make important information stand out so it can be easily found, such as low test scores, high test scores, or amounts over budget. Doing this manually can be time consuming. Conditional formatting automatically updates when a cell meets defined criteria. Learn how to apply conditional formatting to your data.
Program Format • Show examples of conditional formatting
• Demonstrate how to apply conditional formatting to data
• Demonstrate how to edit conditional formatting rules
• Demonstrate how to manage and delete conditional formatting rules
• Discuss conditional formatting applications
Objectives • Learn how to apply conditional formatting to Excel data
• Discover uses for conditional formatting
National Staff Development Council Standards to which this program aligns • Organizes adults into learning communities whose goals are aligned with those of the school and district. (Learning Communities)
• Uses learning strategies appropriate to the intended goal. (Design)
Program Length 50 minutes
Dates/Times

Program DateProgram TimeNetwork TimeRegistration Deadline
All times below are displayed in Eastern Daylight Time, as specified in your profile.
3/15/20111:15 PM - 2:15 PM1:05 PM - 2:15 PM03/09/2011
3/15/20112:35 PM - 3:30 PM2:25 PM - 3:30 PM03/09/2011
3/15/20113:45 PM - 4:45 PM3:35 PM - 4:45 PM03/09/2011

Date/Time Notes This professional development multi-point video conference is offered on March 15, 2011 at 1:15, 2:35, and 4:35 EST
Connection Type(s) Available and Program Fees Cost per Site: $75.00
Cost per Site with Premium Service: $67.50 What's this?
Cancellation Policy We will not charge for programs cancelled due to nature, i.e., snow days. The full fee will be charged to sites that cancel with less than 48 hours notice.
Program is Offered Through Videoconference - H.323 (Polycom, Tandberg, LifeSize, etc...)
Is Recording allowed? No
The Provider broadcasts over IP
Minimum Technology Specifications for sites connecting to this provider Schools are asked to conduct a test connection with SOITA in advance of the site's first scheduled video conference with us. Sites connecting via ISDN should provide their own bridge and dial into SOITA. SOITA's IP address is 216.48.137.41

Request this Program Now