Description
Step-by-step directions (83 slides) on how to use conditional formatting and data validation on a sales report. The lesson includes:
- Programming 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.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
Answer keys for everything are included. PowerPoint is fully editable. Screenshots from Microsoft 365.
Click here to purchase the video lesson or pay $2 more to get both versions.
Microsoft Lessons (Word, Excel, PowerPoint)
Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects
Microsoft Excel Lesson 2: Conditional Formatting & Data Validation (PowerPoint)
Highlights
Save even more with bundles
Description
Step-by-step directions (83 slides) on how to use conditional formatting and data validation on a sales report. The lesson includes:
- Programming 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.
- Applying conditional formatting to color-code for best sellers, worst sellers, lowest inventory, and revenue.
- Writing simple formulas to calculate ending inventory and monthly revenue. (click here for a more in-depth formulas lesson)
- Using data validation to create an "Updated By" drop-down menu in their first column.
- Creating a graph in Excel from this data.
- TEST where students are given a new set of data and directions for what sort of calculations they must program the sheet to make.
Answer keys for everything are included. PowerPoint is fully editable. Screenshots from Microsoft 365.
Click here to purchase the video lesson or pay $2 more to get both versions.
Microsoft Lessons (Word, Excel, PowerPoint)
Adobe CC Lessons: Photoshop, Illustrator, InDesign, Premiere Pro, After Effects
