Students are given step-by-step directions (33 slides) on how to use conditional formatting on a sales report in Microsoft Excel. They:
- Program a vocabulary study sheet so that a cell turns green when they enter the correct term. This introduces the concept of conditional formatting in Excel.
- Work with a sales report sheet and format it to color-code their best sellers, worst sellers, lowest inventory, and revenue.
- Write simple formulas to calculate their ending inventory and their monthly revenue.
- Use data validation to create an "Updated By" drop-down menu in their first column.
- Create a graph in Excel from this data.
- Complete an assessment where they are given a new set of data and directions for what sort of calculations they must program the sheet to make.
- A rubric is included.
Answer keys included. All screenshots are from Microsoft Excel 2016 (Office 365).
For a more in-depth lesson on formulas, you might want my Microsoft Excel Lesson on Formulas.
More Computer Applications Lessons (Word, Excel, PowerPoint, Video Editing)
Computer Coding Lessons
Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere
Elements and Principles of Design Lessons
Literary Elements Lessons
English Grammar Lessons