Is it possible to control which parts of an Excel spreadsheet are displayed? The answer is yes, and viewers learn how by watching the 18th video from the 27-part Microsoft Excel 2016 series. With a brief yet thorough overview, learners discover how to filter data, apply multiple filters, and clear filters to make their desired data visible.

Concepts

basic computer skills, microsoft excel, spreadsheet skills, computer software, technology resources

Show More Show Less

Instructional Ideas

• Provide ample time for students to practice using advanced filters 

Classroom Considerations

• Requires a computer and headphones for each user, or projection and speakers for the entire class 
• Covers a lot of material in a short time frame 

• This video is hosted on YouTube

Pros

• Presented in a clear, concise way 
• Provides a text lesson  

Cons

• None

Common Core

SL.9-10.3 SL.11-12.3