$10

weekly

or $40 for all content

Microsoft Excel for Beginners--Real Life Examples

Completed by 66 learners

Ages 10-14

Self-Paced Course

This four-lesson self-paced class will teach the basics of Excel. Students will be given real-life scenarios in which they can use Excel. They'll create a Disney vacation schedule, a party budget, snack stand business graphs, and more.

Colleen Smith

Average rating:

5.0

Number of reviews:

(334 reviews)

Star Educator

8 pre-recorded lessons

4 weeks of teacher support

Choose your start date

1 year of access to the content

Enroll Now, Start Anytime

Go at your own pace

Your learner can start learning when they want and progress at the speed that works best for them.

Enroll Now, Start Anytime

Start when you want.

Learn at your own pace

Access course material for a full year.

Get hands-on support from teacher.

About Learning Overview Schedule Teacher Reviews

What's included

8 pre-recorded lessons

4 weeks

of teacher support

1 year access

to the content

Homework

1-2 hours per week. Students will create Excel files as they watch the recordings. They can submit them to me for review.

Grading

Please let me know if you need specific grading or a certificate of completion for this class.

Class Experience

US Grade 4 - 7

Beginner - Intermediate Level

During this class, students will learn the basic functions of Microsoft Excel and get hands-on practice. This class will not only teach the basics of Excel, but it will excite students to discover ways they can use Excel in their everyday lives.  

This is a "Self-Paced" class, so there are no live sessions. Students will have access to four pre-recorded lessons that I created exclusively for Outschool. During the recording, I share my screen so students can watch me using Excel as I describe its functions. Learners are encouraged to use Excel as they watch the recording, so that they can follow along and gain hands-on practice. 

After the learner has completed a recording and created the Excel file described, they can submit it to me for review.  Next, there will be a recommended activity to add to the file in order to reinforce the skills the learner learned during the most recent recording. 

For a detailed lesson plan, please see the "Syllabus" section. 

Topics covered will include:
•	Vocabulary (cell, column, row, worksheet, formula, budget, sum)
•	Organizing data
•	Gridlines
•	Formatting cells (color, font, currency, time)
•	SUM, COUNT, and AVERAGE functions
•	Multiplication, Subtraction, Division, Addition formulas
•	Sorting and filtering cells
•	Pie, bar, and line graphs 

Students do not need any experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program.

Learning Goals

At the end of the class, students will be able to name parts of an Excel worksheet, input information into cells, format cells, use the sum function, input a multiplication formula, sort, filter, and create graphs.

Syllabus

8 Lessons

over 4 Weeks

Lesson 1:

Create a Schedule

 I'll begin by discussing real-world uses for Excel and related vocabulary. I'll then dive in and begin using the program.  Learners will imagine they are planning a trip to Disney. We'll use Excel to create a vacation schedule. Topics covered will include organizing data, formatting cells, auto-populating, and saving the file.

Lesson 2:

Add to Your Schedule

 Learners will post their own additions to their schedule.

Lesson 3:

Create a Budget

 Learners will imagine they are throwing their family member a birthday party!  We will use Excel to create a party budget. New topics covered will include formatting for currency, sorting, using sum function, and writing a multiplication formula.

Lesson 4:

Add to Your Budget

 Learners will add three additional items to their budgets and share why they added these items and their costs.

Other Details

Pre-Requisites

Students do not need any experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program.

Supply List

In addition to the Outschool classroom, this class uses: Microsoft Excel.

Students should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as they watch my recordings.

1 file available upon enrollment

External Resources

Learners will not need to use any apps or websites beyond the standard Outschool tools.

Meet the teacher

Colleen Smith

Joined September, 2021

5.0

334reviews

Star Educator

Profile

Teacher expertise and credentials

Bachelor's Degree from Bucknell University

I have virtually tutored over 1,300 young learners, but prior to that I enjoyed a thirteen-year corporate career, where I used Excel to make my work more efficient and effective on a daily basis. I hold a Bachelor's of Science in Business Administration from Bucknell University.