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

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.