The Online Teacher Resource

Email Newsletter

Lesson Plan : Excel - Special Formatting

Teacher Name:
 Aaron Anckaert
Grade:
 College/University
Subject:
 Other

Topic:
 Excel: Conditional Formatting and Format Painter tool
Content:
 Excel, Formatting, Conditional Formatting, Format Painter tool.
Goals:
 know how to apply Conditional formatting to a spreadsheet and how to use the format painter tool.
Objectives:
 Apply conditional formatting and copy it using the format painter
Materials:
 Podium computer with excel and powerpoint
Introduction:
 Conditional formatting and format painter tool in excel. Show a document with and without conditional formatting.
Development:
 Assumed knowledge: Formulas and basic formatting Show what conditional formatting is and when to use it. Show how to apply conditional formatting with an example. Copy the conditional formatting and basic formatting with the format painter tool.
Practice:
 
Accommodations:
 
Checking For Understanding:
 
Closure:
 Increases readability and ease of understanding trends in a collection of data in excel. Your boss and coworkers will love this if you do it correctly.
Evaluation:
 
Teacher Reflections:
 

Create New Lesson Plan Lesson Plan Center