探索 MS Excel 技能 - 高中和大學預科 - Flex

This five lesson flex class does not include face to face interaction. The 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, auto-fill, data tables, flash fill, conditional formatting, working with large worksheets, if function, goal seek.

How do the flex classes work?

At the beginning of each week I send a: 

 	* link to a video that I have made specifically for the class
 	* Document that goes over the new skill sets step-by-step. 
 	* When complete the learner submits the lesson. 
 	* I review the lesson and send a detailed message (sometimes another video) that tells them how to correct any errors. 
 	

During the week I am always available to answer any questions or schedule a brief meeting with them on Zoom, if necessary.

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 and pivot tables

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