English
Log In
Microsoft Excel for Beginners--Real Life Examples
Colleen Smith
Average rating:
5.0
Number of reviews:(326)
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
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...
8 lessons//4 Weeks
Week 1Lesson 1Create a ScheduleI'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 2Add to Your ScheduleLearners will post their own additions to their schedule.Week 2Lesson 3Create a BudgetLearners 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 4Add to Your BudgetLearners will add three additional items to their budgets and share why they added these items and their costs.Week 3Lesson 5Sorting, Filtering and Using FunctionsLearners 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 6Add to Your ListLearners will add items to their inventory list.Week 4Lesson 7Create GraphsLearners 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 8Format Your Own GraphI will ask learners to format a graph in their own unique style.
- 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,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.
1 - 2 hours per week outside of class
Homework
Frequency: 7 or more throughout the classFeedback: includedDetails: Students will create Excel files as they watch the recordings. They can submit them to me for review.Grading
Frequency: includedDetails: Please let me know if you need specific grading or a certificate of completion for this class.
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 enrollmentIn 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
5.0
326reviews
Rising Star
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
𝗛𝗲𝗹𝗹𝗼! 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...
Reviews
Self-Paced Class
$10
weekly or $40 for all content8 pre-recorded lessons
4 weeks of teacher support
Choose your start date
1 year of access to the content
Completed by 45 learners
Choose your start date
Ages: 10-14
