MS Excel 技能巡遊 - 高中和大學預科

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. 

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

Needed for this class:  
Prerequisite: None
Computer with video, sound and document saving capability, newer version of Microsoft Excel (2019 or Office 365) preferred.