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
Time-Savers
Friday - Lesson 04
Relative, Absolute, and Circular References
Week Three
Wednesday - Lesson 05
Sheet References; Creating 3-Dimensional Workbooks; Linking Files
Friday - Lesson 06
Sorting and Subtotaling
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