What's included
5 live meetings
4 hrs 10 mins in-class hoursProjects
1-2 hours per week. Completion of daily assignmentsCertificate of Completion
Completion of projectsClass 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
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.
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
$90
for 5 classes5x per week, 1 week
50 min
Completed by 23 learners
Live video meetings
Ages: 14-18
3-10 learners per class