Outschool
Open currency, time zone, and language settings
Log In

Cruising for Skills on MS Excel - HS and College Prep - Camp

Learn Excel skills including functions, charts, financial statement format, pivot charts, and more in 5 comprehensive lessons.
Ms. Ryan, M.S.
Average rating:
5.0
Number of reviews:
(62)
Class
Play

What's included

5 live meetings
4 hrs 10 mins in-class hours
Projects
1-2 hours per week. Completion of daily assignments
Certificate of Completion
Completion of projects

Class Experience

US Grade 9 - 12
This five lesson class introduces learners to: excel screen, terminology, sheet table, cell names, cell ranges, formatting cells, simple formulas, converting to formulas, simple functions, fill handle, merge and center, profit and loss statements, relative and absolute reference, autofill, data tables, flash fill, conditional formatting, working with large worksheets, if function, goal seek.

This class includes teacher prepared videos, worksheets, quizzes and multiple projects.
 
This is the Excel portion of the technology applications class that I taught for 20 years. I wrote the curriculum based on skill requirements set by the state of Texas. 

Lesson 1 – Excel screen, terminology, sheet tabs, cell ranges, formatting cells
Lesson 2 – Simple formulas, convert to formula, simple functions, fill handle, merge and center, wrap text
Lesson 3 – Profit and Loss Statements, charts, relative and absolute references, autofill
Lesson 4 – Creating data tables, flash fill, conditional formatting, grouping multiple worksheets
Lesson 5 – If function, goal seek, projections

Needed for this class:  

Prerequisite: None

Computer with video, sound and document saving capability, newer version of Microsoft Excel (2019 or Office 365) preferred installed on student computer.
Learning Goals
Master Excel skills presented
learning goal

Other Details

External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Sources
Computer with video, sound and document saving capability, newer version of Microsoft Excel (2019 or Office 365) preferred on installed on student computer.
Joined August, 2020
5.0
62reviews
Profile
Teacher expertise and credentials
Education and Experience:

•	20 years teaching middle through high school (dual credit)
•	17+ years teaching at college level
•	Master of Science in Computer Education and Cognitive Systems
•	Microsoft Office Specialist in Word, Excel and PowerPoint

Reviews

Live Group Class
Share

$90

for 5 classes
5x per week, 1 week
50 min

Completed by 23 learners
Live video meetings
Ages: 14-18
3-10 learners per class

About
Support
SafetyPrivacyCA PrivacyLearner PrivacyManage Data PreferencesTerms
Financial Assistance
Get The App
Download on the App StoreGet it on Google Play
© 2024 Outschool