### 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

###### Intermediate Level
```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. `
`.css-1il00e6{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;gap:1em;-webkit-flex-direction:column;-ms-flex-direction:column;flex-direction:column;}.css-mt1z2p{-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;width:1em;height:1em;display:inline-block;fill:currentColor;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;-webkit-transition:fill 200ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;transition:fill 200ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;font-size:inherit;vertical-align:-0.125em;text-align:center;width:1.25em;color:#A3A3A3;margin-right:0.5em;margin-top:0.2em;}.css-4j7l6r{margin:0;font-family:Ginto Normal,sans-serif;font-size:1.6rem;line-height:1.3;font-weight:500;letter-spacing:0.01rem;}Homework OfferedAssessments OfferedGrades Offered`
`.css-jzlc08{margin-top:0.5em;margin-bottom:0.5em;}.css-wsteir{-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;width:1em;height:1em;display:inline-block;fill:currentColor;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;-webkit-transition:fill 200ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;transition:fill 200ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;font-size:inherit;vertical-align:-0.125em;}  1 file available upon enrollmentStudents 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
 .css-bns4tv{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-box-pack:left;-ms-flex-pack:left;-webkit-justify-content:left;justify-content:left;}.css-ixuj2e{display:block;background-color:rgba(46, 46, 46, 0.11);height:auto;margin-top:0;margin-bottom:0;transform-origin:0 55%;-webkit-transform:scale(1, 0.60);-moz-transform:scale(1, 0.60);-ms-transform:scale(1, 0.60);transform:scale(1, 0.60);border-radius:1px/1.7px;-webkit-animation:animation-c7515d 1.5s ease-in-out 0.5s infinite;animation:animation-c7515d 1.5s ease-in-out 0.5s infinite;}.css-ixuj2e:empty:before{content:"\00a0";}@-webkit-keyframes animation-c7515d{0%{opacity:1;}50%{opacity:0.4;}100%{opacity:1;}}@keyframes animation-c7515d{0%{opacity:1;}50%{opacity:0.4;}100%{opacity:1;}} .css-1uwjw6e{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-box-pack:right;-ms-flex-pack:right;-webkit-justify-content:right;justify-content:right;}

#### Meet the teacher

```𝗛𝗲𝗹𝗹𝗼!  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... .css-gw2jo8{position:relative;display:inline-block;font-family:'Ginto Normal',sans-serif;font-style:normal;font-weight:500;font-size:1.6rem;text-align:center;text-transform:none;height:auto;max-width:100%;white-space:nowrap;cursor:pointer;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;outline:none;border:none;background:none;padding:0;-webkit-transition:all ease-in-out 0.05s,outline 0s,;transition:all ease-in-out 0.05s,outline 0s,;line-height:1;color:#380596;}.css-gw2jo8:hover:not(:disabled),.css-gw2jo8:focus:not(:disabled){color:#380596;-webkit-text-decoration:underline;text-decoration:underline;}.css-gw2jo8:active:not(:disabled){color:#380596;}.css-gw2jo8:disabled{color:#C2C2C2;cursor:default;}.css-gw2jo8:focus-visible{outline-width:2px;outline-style:solid;outline-color:#4B01D4;outline-offset:2px;}```

#### \$50

for 3 classes
1x per week, 3 weeks
50 min

Average rating:5.0Number of reviews:(2)
Completed by 10 learners
Live video meetings
Ages 12-16
2-5 learners per class

##### Support
SafetyPrivacyCA PrivacyLearner PrivacyTerms