Outschool
Search

$15

weekly
or $128 for all content
Class

Excel | Beginner | 09 Week SP | Explore Data W/ Excel - Become a Data Ninja

Completed by 48 learners
Ages 13-18
Self-Paced Course
In this 9 week course, students will learn how to use Microsoft Excel, explore data, build dashboards, though fun and exciting examples. #builder
Average rating:
4.8
Number of reviews:
(1,187 reviews)

9 pre-recorded lessons
9 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

9 pre-recorded lessons
9 weeks
of teacher support
1 year access
to the content
Homework
1 hour per week. Students will be given a small assignment each week to practice what they have learned. Feedback will be provided the following week.

Class Experience

Understanding data is a superpower for the future. In this flex course, students will receive weekly detailed videos and examples (on average, around 1 hour of video per week) and practice fun and interesting data sets that go through various topics in Microsoft Excel, which can proceed at the learners own pace. Students can watch the videos, or follow along with the videos and the provided Excel sheets. 

The course will scaffold those topics to build an understanding of how to analyze data. Students will work on a small weekly homework task and submit it before the next class for feedback. We will start from scratch and cover topics from an overview of Excel, conditional formatting, formulas, and functions. Each week we will discuss new ways to look at data, learn additional functions, and explore the program. We will cover logical statements, tables, pivot tables, macros, formatting, math, formulas, forecasting, cell referencing, named cells, and many other topics. This is a great course for both beginners and those who have some background in Excel. In addition to weekly videos and feedback, students will be presented with summaries and links that review the topics we cover each week. 

Students can use either Mac or PC versions of Excel, and we will try to feature both in the course and show the differences between them.

Learning Goals

Students will learn many aspects of Microsoft Excel, and find ways to quickly sort through large data sets. The goal of the course is not only to learn how to use the tools, but to understand the data, and what tools can be used to sort through it. We will cover a lot of topics in the course, with the goal that students will understand how to use Excel, and learn a lot of neat tips and tricks to make them data analysis ninjas.

Syllabus

9 Lessons
over 9 Weeks
Lesson 1:
Excel Basics
 Introduction to the course and Excel basics. Includes familiarization with Excel interface and basic functions. Covers setting up simple spreadsheets and inputting data. 
Lesson 2:
Formatting Data
 Formatting data in Excel. Covers cell formatting, conditional formatting, and working with basic charts and graphs. Focuses on enhancing visual data representation. 
Lesson 3:
Intermediate Functions
 Intermediate Excel functions. Introduces functions like SUM, AVERAGE, and other common Excel formulas. Focuses on creating more complex spreadsheets with calculated data. 
Lesson 4:
Advanced Topics
 Advanced Excel topics. Explores concepts like data validation, defined names, and worksheet protection. Focuses on creating and managing structured data within Excel. 

Other Details

Parental Guidance
Microsoft Excel is recommended for this course. It may be possible to complete most of the course using other software (such as Google Sheets) but in this course we will be working with Excel.
Supply List
Students will need Microsoft Excel to follow along. Office versions 2016, 2019, 365, and other newer versions should all work. Older versions of Excel (2013, 2010, 2003, 2007) may be lacking some features but many or most of the formulas should still work.
External Resources
In addition to the Outschool classroom, this class uses:

Offered by

Joined October, 2020
4.8
1187reviews
Profile
Teacher expertise and credentials
I teach Excel, PowerBI, Sheets, and many other spreadsheet programs to various levels of students. I find that exploring data can be fun and exciting, particularly when you find unknown or new connections or conclusions you were unaware of in the data. 

Reviews

Sidney - KidsSpeakCode suggests this class next...
Python Programming | Beginner
Sidney - KidsSpeakCode
4.8
(1,187)
$20 per class
Group Class
8 wks, 1/wk, 1.50 hr
13-18


Parents also liked
1:1 Microsoft Office (for beginners)
Ms. Katrena
$55 per session
1-on-1 Coaching
On Demand
11-14
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Part 1
Thrive Virtual Academy by Patch Kulp
4.9
(636)
$20 per class
Next session at 9 PM on Thu 2/20
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
(636)
$20 per class
Next session at 8 PM on Thu 4/3
Group Class
4 wks, 1/wk, 45 min
12-16
Introduction to Microsoft PowerPoint
Brandon
4.9
(30)
$10 per class
Next session at 8 PM today
Group Class
1 wk, 1/wk, 55 min
13-18
Adobe Blast-Off: Private Lesson!
Bethanie Jones
4.8
(622)
$86 per session
1-on-1 Lessons
On Demand
10-15
Introduction to Microsoft Excel
Brandon
4.9
(30)
$10 per class
Next session at 10:30 PM tomorrow
Group Class
1 wk, 1/wk, 55 min
12-17
1-on-1 Microsoft PowerPoint Learning Session
Motivational Mario
5.0
(1)
$50 per session
1-on-1 Lessons
On Demand
13-18
Google Sheets for Beginners
Dan Hartman
4.9
(573)
$15 per class
Next session at 6 PM tomorrow
Group Class
1 wk, 1/wk, 30 min
9-14
Google Earth: How to Navigate and Use Tools
Megan Decker
5.0
(6)
$10 per class
Next session at 9 PM on Wednesday
Group Class
1/wk, 25 min
8-13
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
Introduction to Microsoft Word
Brandon
4.9
(30)
$10 per class
Next session at 3:30 PM on Mon 2/10
Group Class
1 wk, 1/wk, 55 min
12-16
Mastering Excel: A Step-By-Step Guide
Pauline
5.0
(1)
$30 per session
1-on-1 Lessons
On Demand
11-18
Presenting...(Wait, I Need Slides!) - 6 Rules for Formatting Your Slideshow
Ms. Diosa, MEd.
$10 per class
Next session at 12 AM on Friday
Group Class
1 wk, 1/wk, 45 min
12-17
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
PowerPoint Level 1: Learn the Basics of PowerPoint: My Favorite Animal Project
Miss Sammi, ACE Educator
5.0
(56)
$20 per class
Next session at 8 PM on Wed 2/12
Group Class
4 wks, 1/wk, 30 min
10-12
See More Classes
Home
Search
Give a Gift Card
Open currency, time zone, and language settings
Language & Region
Log In