Skip to main content
Let's Learn Excel
0%
Focus Mode is ON. Click on the ‘collapse icon’ to close it.
Previous
Filtering with Microsoft Excel- Part 2
Introduction
Course Registration
Peer Corner
Module1: Lesson 1: Microsoft Excel
Introducing: Microsoft Excel
A Tour of The Excel Worksheet
Module 1: Lesson 2: Entering Data into Your 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
Module 1: Lesson 3: How to Format Your Worksheet
The Format Command Buttons
Formatting Your Worksheet
Activity for Module 1
Activity Module 1 Dataset
Module 2: Lesson 1: The Basics of Calculations
Excel Calculation Basics
Module 2: Lesson 2: Autofill
Excel's Autofill
Exercise 1, Module 2
Exercise1_Module2_Autofill_Dataset
Module 2: Lesson 3: Functions
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: Lesson 1: Excel Chart Fundamentals
Excel Chart Fundamentals
Activity 1, Module 3
Activity 1, Module 3
Module 3: Lesson 2: Scatterplots and Line Charts
Scatterplots and Line Charts
Activity 2, Module 3
Module 4: Lesson 1: Relative and Absolute Cell Referencing
Relative and Absolute Cell Referencing
Cell referencing in Excel
Activity 1, Module 4
Module 4: Lesson 2: Sorting
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
Module 4: Lesson 3: Filtering
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
Assignment
Next
Side panel
Categories
All categories
Public Health
Medicine Courses
Nursing
Professional Development Courses
Community Health Workers
Humanitarian Response
Health Sciences
Sciences
For our institutional partners: Full Programs/Graduate Medical Education
NIED Courses
Home
Calendar
About Us
About Us
FAQs
The Frank Foundation
Board Members
Publications
Quality Assurance
Guests
Learners
Mentors
Universities
Courses
All Courses
Medicine Courses
Public Health Courses
Community Health Courses
Professional Development Courses
Nursing Courses
Health Sciences
Sciences
Programs
Addiction Training for Health Professionals
Public Health U - MPH
Primary Education STEPS
Humanitarian U
Connect
Contact Us
Volunteer
Careers
Join Our Network
sign up for our newsletter
Donate
Blog
Recent
Environmental Health SC
Climate Change and Health - old
You are currently using guest access
Log in
Categories
Collapse
Expand
All categories
Public Health
Medicine Courses
Nursing
Professional Development Courses
Community Health Workers
Humanitarian Response
Health Sciences
Sciences
For our institutional partners: Full Programs/Graduate Medical Education
NIED Courses
Home
Calendar
About Us
Collapse
Expand
About Us
FAQs
The Frank Foundation
Board Members
Publications
Quality Assurance
Guests
Collapse
Expand
Learners
Mentors
Universities
Courses
Collapse
Expand
All Courses
Medicine Courses
Public Health Courses
Community Health Courses
Professional Development Courses
Nursing Courses
Health Sciences
Sciences
Programs
Collapse
Expand
Addiction Training for Health Professionals
Public Health U - MPH
Primary Education STEPS
Humanitarian U
Connect
Collapse
Expand
Contact Us
Volunteer
Careers
Join Our Network
sign up for our newsletter
Donate
Blog
Recent
Collapse
Expand
Environmental Health SC
Climate Change and Health - old
Let's Learn Excel
Expand all
Collapse all
Open course index
Dashboard
Let's Learn Excel
Module 4: Lesson 3: Filtering
Filtering with Microsoft Excel- Part 2
Filtering with Microsoft Excel- Part 2
Completion requirements:
View
Click on
Filtering with Microsoft Excel- Part 2
to open the resource.
Previous Activity
Jump to activity
Jump to activity
Course Registration
Peer Corner
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
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
Excel Chart Fundamentals
Activity 1, Module 3
Activity 1, Module 3
Scatterplots and Line Charts
Activity 2, Module 3
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
Assignment
Next Section
