weekly
or for all content
Microsoft Excel Intermediate Level--Formulas & Functions
Completed by 23 learners
Ages 12-18
Self-Paced Course
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.Start when you want.
Learn at your own pace
Access course material for a full year.
Get hands-on support from teacher.
What's included
8 pre-recorded lessons
4 weeks
of teacher support1 year access
to the contentHomework
1 hour per week. Homework will be completed as part of the recorded lessons. Recordings are 30-32 minutes, but may take longer if paused to complete steps. Review lessons will take about 10 minutes.Grading
I provide feedback on all submitted work, but please let me know if you need specific grading.Class Experience
US Grade 8 - 11
Intermediate Level
During this course, students will learn to utilize formulas and functions within Microsoft Excel. In order to benefit from this course, students only need a basic understand of Excel, like how to type in cells and select/highlight cells with their cursor/mouse. 𝗛𝗼𝘄 𝗗𝗼𝗲𝘀 𝘁𝗵𝗶𝘀 𝗦𝗲𝗹𝗳-𝗣𝗮𝗰𝗲𝗱 𝗖𝗹𝗮𝘀𝘀 𝗪𝗼𝗿𝗸? This self-paced class features four 30-minute recordings and four 10-minute review activities. Each recording includes a hands-on Excel project, where I will share my screen to demonstrate tasks. Students should follow along on their computers for practical experience. We will imagine managing an online book and movie store, using a provided Excel file to create formulas and make business decisions. After each lesson, a review activity will reinforce the skills learned. I'll also discuss how the formulas and functions apply to other scenarios. If this class is purchased individually (not part of Outschool Unlimted), students have access to the teacher to ask questions and will receive feedback on all questions and submitted work. Please see the "𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨" section for a detailed breakdown of what is included in each lesson. 𝗧𝗼𝗽𝗶𝗰𝘀 𝗰𝗼𝘃𝗲𝗿𝗲𝗱 𝘄𝗶𝗹𝗹 𝗶𝗻𝗰𝗹𝘂𝗱𝗲: • Excel vocabulary (cell, column, row, worksheet, formula, function, static, cell reference) • Math vocabulary (exponent, median, mode, sum) • Formulas (addition, subtraction, multiplication, division, exponents, change) • Functions (SUM, AVERAGE, MEDIAN, MODE, RANK, LENS, &, YEAR, MONTH, DAY, DATE, SUMIF, COUNTIF, VLOOKUP)
Learning Goals
Students will learn Excel vocabulary and skills (cell, column, row, worksheet, formula, function, static, cell reference, sorting).Students will learn to create formulas and functions within Microsoft Excel, including SUM, AVERAGE, MEDIAN, MODE, RANK, LENS, &, YEAR, MONTH, DAY, DATE, SUMIF, COUNTIF, and VLOOKUP.Syllabus
8 Lessons
over 4 WeeksLesson 1:
The Basics and Math Formulas: Video and Follow-Along
I'll begin by briefly discussing real-world uses for Excel and related vocabulary. I'll define "static" and "cell reference" formulas and discuss the benefits of cell reference formulas. We'll then dive in and begin using the program. We'll create basic math formulas, including addition, subtraction, multiplication, division, and exponents. I'll then discuss how "dragging" a formula effects the formula and how the formula can be changed to allow for auto-populating. We'll use the SUM function. Lesson 2:
Quick Review Exercise: Adding Lines and Extending Formulas
For additional practice, learners will share a book that is not already in our bookstore "inventory" and add it to their inventory spreadsheet. Lesson 3:
More Summarizing Formulas: Video and Follow-Along
We'll continue to use our "business's" sales data to practice using formulas. We'll use the COUNT function to total transactions, and the RANK function to rank our most popular items. We'll use Excel functions to calculate our average transaction size. We'll also determine the MEDIAN and MODE transaction values and I'll discuss why these formulas would be helpful. We'll look at a customer birthday list and use date functions to split information into different cells. Lesson 4:
Quick Review Exercise: Uses of Excel
The learner will share in what other ways they may need to use an Excel function or formula. Other Details
Supply List
Students should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class.
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
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
I have virtually taught over 1,300 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
Colleen Smith suggests this class next...
Financial Literacy: Private Tutoring
Colleen Smith
5.0
(334)
per session
1-on-1 Coaching
On Demand
6-18
Other classes by Colleen Smith
Other classes by Colleen Smith
Parents also liked
1:1 Microsoft Office (for beginners)
Ms. Katrena
per session
1-on-1 Coaching
On Demand
11-14
Cruising for Skills on MS PowerPoint - Middle School - Camp
Ms. Ryan, M.S.
5.0
(62)
per class
Next session at 3 PM on Mon 6/16
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Excel - Pt 1 for Middle School - Camp
Ms. Ryan, M.S.
5.0
(62)
per class
Next session at 3 PM on Mon 6/16
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Excel - HS and College Prep - Camp
Ms. Ryan, M.S.
5.0
(62)
per class
Next session at 2 PM on Mon 6/16
Group Class
1 wk, 5/wk, 50 min
14-18
Cruising for Skills on MS Word - Pt 1 - Camp for Middle School
Ms. Ryan, M.S.
5.0
(62)
per class
Next session at 3 PM on Mon 6/16
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Word - High School and College Prep - Camp
Ms. Ryan, M.S.
5.0
(62)
per class
Next session at 2 PM on Mon 6/16
Group Class
1 wk, 5/wk, 50 min
14-18
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Part 1
Thrive Virtual Academy by Patch Kulp
4.9
(644)
per class
Next session at 6 PM on Mon 4/7
Group Class
6 wks, 1/wk, 45 min
12-16
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Level 2
Thrive Virtual Academy by Patch Kulp
4.9
(644)
per class
Next session at 8 PM on Thu 4/10
Group Class
4 wks, 1/wk, 45 min
12-16
Introduction to Microsoft PowerPoint
Brandon
4.9
(31)
per class
Next session at 6:30 PM on Wednesday
Group Class
1 wk, 1/wk, 55 min
13-18
Adobe Blast-Off: Private Lesson!
Bethanie Jones
4.8
(623)
per session
1-on-1 Lessons
On Demand
10-15
Introduction to Microsoft Excel
Brandon
4.9
(31)
per class
Next session at 5 PM on Wednesday
Group Class
1 wk, 1/wk, 55 min
12-17
1-on-1 Microsoft PowerPoint Learning Session
Motivational Mario
5.0
(1)
per session
1-on-1 Lessons
On Demand
13-18
Mastering Canva for School Projects: 1:1 Instruction for High Schoolers
Dr. Bridget Prichard
per session
1-on-1 Lessons
On Demand
15-18
Introduction to Microsoft Word
Brandon
4.9
(31)
per class
Next session at 2 PM on Wednesday
Group Class
1 wk, 1/wk, 55 min
12-16
Mastering Excel: A Step-By-Step Guide
Pauline
5.0
(1)
per session
1-on-1 Lessons
On Demand
11-18
How Do You Use Google Docs?
Ria Purcell
5.0
(5)
per class
Next session at 10 PM on Friday
Group Class
2 wks, 2/wk, 45 min
14-17
More to explore
Around The World
Around The World With
Scratch A Thon
New Oregon Trail
Introduction To Set Theory
Drawing Realistic
Valentines History
Storytime
Drawing Painting
Writing The 5 Paragraph Essay Take 2 A Collaborative Approach To Learning
Advanced Vocabulary
1950s
Intro To Wwii
Computer Skills
Voice Piano
Holiday Sewing
Kristy
Intermediate Photography
Multiplication for Beginners
Scholastic Scope
