Microsoft Excel for Beginners--Real Life Examples
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:(333)
Star Educator
What's included
8 pre-recorded lessons
average 18 mins per video4 weeks
of teacher support2 hrs 22 mins
total video learning hours1 year access
to the contentClass Experience
US Grade 4 - 7
Beginner 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 Subscription class, so there are no live sessions, nor teacher feedback. 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. The recordings are 33-37 minutes, but may take longer to complete, depending on if the student pauses/rewinds as they watch and complete their tasks in Excel. After each recorded lesson, there will be a recommended activity that adds to the previously worked on Excel file. These activities will help reinforce the skills the learner learned during the most recent recording. They are designed to take between 5 and 20 minutes to complete. 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
Students will comprehend Microsoft Excel vocabulary (cell, column, row, worksheet, formula, budget, sum)Students will be able to implement formatting (color, font, number type for currency and time, gridlines)
Syllabus
8 Lessons
over 4 WeeksLesson 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. 37 mins of video lessons
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. 37 mins of video lessons
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
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.
Language of Instruction
English
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Joined September, 2021
5.0
333reviews
Star Educator
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
I have virtually tutored over 1,200 young learners on Outschool, 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. Reviews
Self-Paced Course
$10
weekly8 pre-recorded lessons
4 weeks of teacher support
Choose your start date
1 year of access to the content
Choose your start date
Ages: 10-12
