| STAT 3704/4704 - Decision Support: Excel & VBA - Syllabus | |
| Mon Jan 2 | Wed Jan 4 |
| NO CLASS |
EXCEL BASICS AND SPREADSHEET MODELING Reading: Blackboard: |
| Mon Jan 9 | Wed Jan 11 |
| EXCEL TEXT AND SUMMARY FUNCTIONS Reading: Blackboard: |
USING EXCEL FOR MANAGING DATABASES Reading: Blackboard: |
| Mon Jan 16 | Wed Jan 18 |
| M.L. KING HOLIDAY |
USING ARRAY FORMULAS IN EXCEL / EXAM REVIEW Reading: Blackboard: |
| Mon Jan 23 | Wed Jan 25 |
| MODULE 1 EXAM |
EXCEL VBA MACROS Reading: Blackboard: |
| Mon Jan 30 | Wed Feb 1 |
| ADVANCED FUNCTIONS / USING BUTTONS FOR USER INPUT Reading: Blackboard: |
WORKING WITH RANGES Reading: Blackboard: |
| Mon Feb 6 | Wed Feb 8 |
| WORKING WITH WORKBOOKS, WORKSHEETS, AND CHARTS Reading: Blackboard: |
WORKING WITH ARRAYS Reading: Blackboard: |
| Mon Feb 13 | Wed Feb 15 |
| PSEUDOCODING AND REVIEW Reading: Blackboard: |
MODULE 2 EXAM |
| Mon Feb 20 | Wed Feb 22 |
| CREATING ADD-INS Reading: Blackboard: |
ADVANCED USER FORMS Reading: Blackboard: |
| Mon Feb 27 | Wed Feb 29 |
| MENUS AND ERROR HANDLING Reading: Blackboard: |
CATCH UP DAY |
| Mon Mar 5 | Wed Mar 7 |
| WORKING WITH OTHER FILES / OFFICE APPLICATIONS Reading: Blackboard: |
WORKING WITH SOLVER / CODING TIDBITS Reading: Blackboard: |
| Mon Mar 12 | Wed Mar 14 |
| REVIEW Reading: Blackboard: |
MODULE 3 EXAM |