Let's Learn Excel: Resources

Section	Name	Description
Module1: Lesson 1: Microsoft Excel	Introducing: Microsoft Excel	Watch the entire video. (8 minutes)
	A Tour of The Excel Worksheet	Watch the entire video. (12 minutes)

Module 1: Lesson 2: Entering Data into Your Worksheet	Getting Data into Your Worksheet	Watch the entire video. (20 minutes)
	Exercise 1: Inserting, Deleting, and Reaming Worksheets	Do the hands-on exercise. (30 minutes)
	Dataset_Mod1_Ex1
	Exercise 2: Freezing Columns and Rows	Do the hands-on exercise. (30 minutes)
	Dataset_Mod1_Ex2

Module 1: Lesson 3: How to Format Your Worksheet	The Format Command Buttons	Read the entire article. (4 minutes)
	Formatting Your Worksheet	Watch the entire video. (14 minutes)
	Activity for Module 1	Do the hands-on activity. (30 minutes)
	Activity Module 1 Dataset

Module 2: Lesson 1: The Basics of Calculations	Excel Calculation Basics	Watch the entire video. (13 minutes)

Module 2: Lesson 2: Autofill	Excel's Autofill	Watch the entire video. (14 minutes)
	Exercise 1, Module 2	Do the hands-on exercise. (30 minutes)
	Exercise1_Module2_Autofill_Dataset

Module 2: Lesson 3: Functions	Excel's Built-In Functions	Watch the entire video. (21 minutes)
	Exercise 2, Module 2	Do the hands-on exercise. (30 minutes)
	Activity 1, Module 2 - Calculations	Do the hands-on activity. (30 minutes)
	Activity 2, Module 2 - Formulas and Functions	Do the hands-on activity. (30 minutes)
	Activity2_Module2_Worksheet

Module 3: Lesson 1: Excel Chart Fundamentals	Excel Chart Fundamentals	Watch the entire video. (16 minutes)
	Activity 1, Module 3	Do the hands-on activity. (30 minutes)

Module 3: Lesson 2: Scatterplots and Line Charts	Scatterplots and Line Charts	Watch the entire video. (18 minutes)

Module 4: Lesson 1: Relative and Absolute Cell Referencing	Relative and Absolute Cell Referencing	Read the entire article. (10 minutes)
	Cell referencing in Excel	Watch the entire video. (24 minutes)

Module 4: Lesson 2: Sorting	Fundamentals of Sorting	Read the entire article. (9 minutes)
	Exercise 1, Module 4 - Custom Sorting	Do the hands-on exercise. (30 minutes)
	Dataset_Ex1_Mod4.xlxs
	Sorting with Microsoft Excel - Part 1	Watch the entire video- 17 minutes
	Sorting with Excel- Part 2	Watch the entire video-17 minutes
	Dataset2_Mod4

Module 4: Lesson 3: Filtering	Fundamentals of Filtering in Excel	Read the entire article. (9 minutes)
	Patients.xlxs
	Dataset3_Module4
	Filtering with Microsoft Excel- 1	Watch the entire video- 16 minutes
	Filtering with Microsoft Excel- Part 2	Watch the entire video- 17 minutes

Course Activities	Assignment