Log In

Microsoft Excel for Beginners--Real Life Examples (Self-Paced)

Colleen Smith
Average rating:
Number of reviews:
Rising Star
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.

Class experience

US Grade 4 - 7
Beginner - Intermediate Level
8 lessons//4 Weeks
 Week 1
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.
 Week 2
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.
 Week 3
Lesson 5
Sorting, Filtering and Using Functions
Learners will imagine they are running the snack stand at the local football field. I will upload an Excel file to the classroom containing an "inventory list." We will use the inventory list to practice filtering and sorting data. We will also create subtraction and division formulas. We will learn additional Excel functions like COUNT and AVERAGE.
Lesson 6
Add to Your List
Learners will add items to their inventory list.
 Week 4
Lesson 7
Create Graphs
Learners will continue running the snack stand. They will create graphs to show how much they have earned, define their most popular snack types, and compare their busiest times. New topics covered will include creating pie, bar and line graphs.
Lesson 8
Format Your Own Graph
I will ask learners to format a graph in their own unique style.
  • Students will learn the basic functions of Microsoft Excel and get hands-on practice. 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.
I have virtually tutored over 1,000 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. 
Homework Offered
Students will create Excel files as they watch the recordings. They can submit them to me for review.
0 - 1 hours per week outside of class
Assessments Offered
Grades Offered
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.
 1 file available upon enrollment
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.
Joined September, 2021
Rising Star
Teacher expertise and credentials
Bachelor's Degree
𝗛𝗲𝗹𝗹𝗼!  My name is Colleen, or Miss Colleen, and I am excited to work with your student in my online classroom! I have been teaching on Outschool since September 2021 and am thrilled to continue this journey.

My Outschool offerings encompass... 
Self-Paced Class


weekly or $39 for all content
8 pre-recorded lessons
4 weeks of teacher support
Choose your start date
1 year of access to the content

Completed by 41 learners
Ages: 10-14

Enroll Now, Start Anytime
SafetyPrivacyCA PrivacyLearner PrivacyTerms
Outschool International
Get The App
Download on the App StoreGet it on Google Play
© 2024 Outschool