Section: Module 1: Lesson 2: Entering Data into Your Worksheet | Let's Learn Excel

Section: Module 1: Lesson 2: Entering Data into Your Worksheet | Let's Learn Excel | NextGenU.org

Student Learning Outcomes:
Upon completion of this lesson, you will be able to:

Correctly enter data into a table in the worksheet.

Approximate time required for the readings for this lesson (at 144 words/minute): 1 hour and 40 minutes.

Click here to start this lesson
- Select activity Required Learning Resources and Activities
  
  Required Learning Resources and Activities
- Select activity Getting Data into Your Worksheet
  
  Getting Data into Your Worksheet File
  
  Students must
  
  View
  
  Watch the entire video. (20 minutes)
  
  92.7 MB
- Select activity Exercise 1: Inserting, Deleting, and Reaming Worksheets
  
  Exercise 1: Inserting, Deleting, and Reaming Worksheets File
  
  Students must
  
  Mark as done
  
  Do the hands-on exercise. (30 minutes)
  
  314.2 KB
- Select activity Dataset_Mod1_Ex1
  
  Dataset_Mod1_Ex1 File
  
  Students must
  
  Mark as done
  
  9.5 KB
- Select activity Exercise 2: Freezing Columns and Rows
  
  Exercise 2: Freezing Columns and Rows File
  
  Students must
  
  View
  
  Do the hands-on exercise. (30 minutes)
  
  449.5 KB
- Select activity Dataset_Mod1_Ex2
  
  Dataset_Mod1_Ex2 File
  
  Students must
  
  View
  
  56.6 KB

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

Section: Module 1: Lesson 2: Entering Data into Your Worksheet | Let's Learn Excel | NextGenU.org

Student Learning Outcomes:

Required Learning Resources and Activities