Outschool
Search

$13

per class
Class

Microsoft Excel: IF Statements & IF Functions

Completed by 3 learners
Ages 10-15
Live One-Time Class
This one time class will show learners how to create IF Statements and work with the SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions in Microsoft Excel.
Average rating:
5.0
Number of reviews:
(60 reviews)

Live video meetings
Meets once
2-6 learners per class
45 min

What's included

1 live meeting
45 mins in-class hours

Class Experience

During this class I will teach students how to create IF Statements and work with the SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions in Microsoft Excel.   
Upon enrollment, students will gain access to Excel learning files, the lesson presentation, and an optional learning activity.  During class, I will explain each skill, provide a demonstration, then give students time to try the skill on their own.
Students will need access to Microsof Excel (any version 2010 or newer.  NOTE:  if using the 365 version of Excel you may not have acccess to all Excel options)  and they should know the basics of Excel:  opening, closing, saving, identifying colunms, rows and cells, selecting a range of data and working with basic formulas and functions.

Other Details

Parental Guidance
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, and pivot tables. Excel is part of the Microsoft Office suite of software.
Supply List
Microsoft Excel (any version 2010 or newer.  NOTE:  if using the 365 version of Excel you may not have acccess to all Excel options)
 3 files available upon enrollment
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.

Meet the teacher

Joined January, 2022
5.0
60reviews
Profile
Teacher expertise and credentials
Microsoft Office Specialist Certification
Google Certified Educator
Certified Computer Science Teacher
Certified Business Education Teacher

Reviews


Parents also liked
1:1 Microsoft Office (for beginners)
Ms. Katrena
$55 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)
$19 per class
Next session at 3 PM on Monday
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)
$19 per class
Next session at 3 PM on Monday
Group Class
1 wk, 4/wk, 50 min
10-13
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Part 1
Thrive Virtual Academy by Patch Kulp
4.9
(641)
$20 per class
Next session at 6 PM on Mon 4/7
Group Class
6 wks, 1/wk, 45 min
12-16
Cruising for Skills on MS Excel - HS and College Prep - Camp
Ms. Ryan, M.S.
5.0
(62)
$18 per class
Next session at 2 PM on Monday
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)
$19 per class
Next session at 3 PM on Monday
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)
$19 per class
Next session at 2 PM on Monday
Group Class
1 wk, 5/wk, 50 min
14-18
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Level 2
Thrive Virtual Academy by Patch Kulp
4.9
(641)
$20 per class
Next session at 8 PM on Thu 4/3
Group Class
4 wks, 1/wk, 45 min
12-16
AI Software: A Kid's Guide
Daniel Solomon Kaplan
4.9
(397)
$9 per class
Group Class
4 wks, 1/wk, 30 min
8-12
Adobe Blast-Off: Private Lesson!
Bethanie Jones
4.8
(623)
$86 per session
1-on-1 Lessons
On Demand
10-15
1-on-1 Microsoft PowerPoint Learning Session
Motivational Mario
5.0
(1)
$50 per session
1-on-1 Lessons
On Demand
13-18
Mastering Canva for School Projects: 1:1 Instruction for High Schoolers
Dr. Bridget Prichard
$25 per session
1-on-1 Lessons
On Demand
15-18
Mastering Excel: A Step-By-Step Guide
Pauline
5.0
(1)
$30 per session
1-on-1 Lessons
On Demand
11-18
How Do You Use Google Docs?
Ria Purcell
5.0
(4)
$38 per class
Next session at 8 PM on Mon 3/24
Group Class
2 wks, 2/wk, 45 min
11-15
Microsoft Word, PowerPoint or Excel Private Tutoring
Colleen Smith
5.0
(333)
$50 per session
1-on-1 Lessons
On Demand
8-18
Adobe Illustrator 1-on-1
Calvin McMurray
$50 per session
1-on-1 Lessons
On Demand
13-18
See More Classes
Home
Search
Give a Gift Card
Open currency, time zone, and language settings
Language & Region
Log In