Let's Learn Excel: Activity 3, Module 4 - Filtering Basics

We've upgraded our Learning Management System

We've recently upgraded our platform to bring you a faster, more secure, and more reliable experience. Most things should look and work the same — with a few visual improvements along the way.
We're still fine-tuning some formatting details and minor display issues as part of this transition. If you notice anything that doesn't look or work quite right, we'd really appreciate you letting us know at Contact Us.

Thank you for your patience as we complete these final adjustments — and for helping us make the platform better for everyone.

Opened: Thursday, April 25, 2024, 12:00 AM

Due: Thursday, May 2, 2024, 12:00 AM

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

Completion requirements:

View
Make a submission

Introduction

Course Registration

Peer Corner

Module 1: Introduction to Excel

Introducing: Microsoft Excel

A Tour of The Excel Worksheet

Getting Data into Your Worksheet

Exercise 1: Inserting, Deleting, and Reaming Worksheets

Dataset_Mod1_Ex1

Exercise 2: Freezing Columns and Rows

Dataset_Mod1_Ex2

The Format Command Buttons

Formatting Your Worksheet

Activity for Module 1

Activity Module 1 Dataset

Module 2: Calculations and Functions

Excel Calculation Basics

Excel's Autofill

Exercise 1, Module 2

Exercise1_Module2_Autofill_Dataset

Excel's Built-In Functions

Exercise 2, Module 2

Activity 1, Module 2 - Calculations

Activity 2, Module 2 - Formulas and Functions

Activity2_Module2_Worksheet

Activity 1, Module 2 - Calculations

Activity 2, Module 2 - Formulas and Functions

Module 3: Excel Charts

Excel Chart Fundamentals

Activity 1, Module 3

Activity 1, Module 3

Scatterplots and Line Charts

Activity 2, Module 3

Module 4: A Closer Look At Working with Excel Cells

Relative and Absolute Cell Referencing

Cell referencing in Excel

Activity 1, Module 4

Fundamentals of Sorting

Exercise 1, Module 4 - Custom Sorting

Dataset_Ex1_Mod4.xlxs

Activity 2, Module 4 - Custom Sorting

Sorting with Microsoft Excel - Part 1

Sorting with Excel- Part 2

Activity 3, Module 4 - Custom Sorting

Dataset2_Mod4

Fundamentals of Filtering in Excel

Patients.xlxs

Activity 3, Module 4 - Filtering Basics

Dataset3_Module4

Filtering with Microsoft Excel- 1

Filtering with Microsoft Excel- Part 2

Module 5: Lesson 1: Introduction to AI-Infused Excel

Module 5: Lesson 2: Analyze Data

Module 5: Lesson 3: Power Query

Module 5: Lesson 4: Copilot

Course and Self Evaluation & Certificate

Course Activities

Activity 3, Module 4: Filtering Basics