In addition to using formulas, understanding how to format and filter data are powerful skills that will help you interpret data. Data validation will make your data cleaner and easier to use.
In addition to using formulas, understanding how to format and filter data are powerful skills that will help you interpret data. Data validation will make your data cleaner and easier to use.
Click on the links for written directions with screenshots and videos on using these strategies.
Conditional Formating
Filtering Data
Data Validation
V LOOKUP
Practice Activities
1. Conditional Formatting
Open the practice worksheet and follow the instructions to practice conditional formatting.
2. Filtering:
Open the practice worksheet and follow the instructions on the worksheet to practice filtering.
3. Data Validation
Open the practice worksheet and follow the instructions on the worksheet to practice data validatiom.
4. VLOOKUP
Open the practice worksheet and follow the instructions on the worksheet to practice vlookup.