Microsoft Excel Intermediate Level: Formulas & Functions, 3-Week Class

Botany: Plant Parts, Cells, Photosynthesis, Pollen & Seed Dispersal 10 Wks (8-12)

5.0 (13) · Ages 8-13

Hip Hop Dance Lessons Level 2 & 3 (Invite Only)

Microsoft Excel Intermediate Level: Formulas & Functions, 3-Week Class

Colleen Smith

Star Educator

Average rating:5.0Number of reviews:(311)

This three-week, hands-on class will teach Excel formulas and functions to learners who have a basic understanding of Excel. We will explore real-life examples in order to learn functions such as Sum, Average, Date, If, Vlookup, and more.

Class Experience

US Grade 7 - 10

Intermediate Level

During this three-week course, students will learn to utilize formulas and functions within Microsoft Excel. I will share my screen so that students can see what I am doing in Excel. Students should use Excel on their laptop or computer in-order to follow along and get hands on experience during class. 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.

During each class, we will...

Students will learn to utilize formulas and functions within Microsoft Excel. They will get hands-on practice during class and gain an understanding of how Excel can be used in every-day life. 

Topics covered will include:
•	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)

I have virtually taught over 400 young learners on Outschool and another platform, 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
Assessments Offered
Grades Offered

  1 file available upon enrollment
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.

Available times

Pacific

Table of available sections

Meet the teacher

Colleen Smith

Average rating:5.0Number of reviews:(311)

𝗛𝗲𝗹𝗹𝗼!  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...