Section: Module 4: Lesson 3: Filtering | Let's Learn Excel | NextGenU.org
-
Student Learning Outcomes:
Upon completion of this lesson, you will be able to:
- Filter and custom-filter a sheet dataset with the filter commands.
-
Students mustMark as done
Required Learning Resources and Activities
-
-
-
Students mustViewMake a submission
Activity 3, Module 4: Filtering Basics
1. Open the workbook with the dataset for Activity 3, Module 4: Dataset_Activity3_Mod4.xlxs.
2. Apply a filter to show only electronics and instruments.
3. Clear that Filter.
4. Using a number filter, show loan amounts greater than or equal to $100. 5. Filter the resulting dataset to show only items that have deadlines in 2016 -
-
-