Syllabus
A new section of each course starts monthly. If enrolling in a series of two or
more courses, please be sure to space the start date for each course at least two
months apart.
All courses run for six weeks, with a two-week grace period at the end. Two lessons
are released each week for the six-week duration of the course. You do not have
to be present when lessons are released. You will have access to all lessons until
the course ends. However, the interactive discussion area that accompanies each
lesson will automatically close two weeks after the lesson is released. As such,
we strongly recommend that you complete each lesson within two weeks of its release.
The final exam will be released on the same day as the last lesson. Once the final
exam has been released, you will have two weeks to complete all of your course work,
including the final exam.
|
Week One
|
|
Wednesday - Lesson 01
|
Excel Terminology; Navigation and Editing; Constant Values vs. Formulas
|
|
Friday - Lesson 02
|
Creating a Worksheet: Labels, Values, Formulas, and Formatting
|
|
Week Two
|
|
Wednesday - Lesson 03
|
|
|
|
Friday - Lesson 04
|
Relative, Absolute, and Circular References
|
|
Week Three
|
|
Wednesday - Lesson 05
|
Sheet References; Creating 3-Dimensional Workbooks; Linking Files
|
|
Friday - Lesson 06
|
|
|
|
Week Four
|
|
Wednesday - Lesson 07
|
Creating Graphs: The Chart Wizard
|
|
Friday - Lesson 08
|
Advanced Graphing Techniques
|
|
Week Five
|
|
Wednesday - Lesson 09
|
Statistics Made Easy: The Function Wizard
|
|
Friday - Lesson 10
|
Financial Functions; Amortization
|
|
Week Six
|
|
Wednesday - Lesson 11
|
Worksheet Automation: Creating Macros and Customizing Toolbars
|
|
Friday - Lesson 12
|
Creating Worksheets with Decision-Making Capabilities
|