Decision Support: Excel & VBA - Milking Schedule

STAT 3704/4704 - Decision Support: Excel & VBA - Syllabus
Mon Jan 2	Wed Jan 4
NO CLASS	EXCEL BASICS AND SPREADSHEET MODELING Reading: Powell '95; Mather '99; McKay '09 Blackboard: M1-Lesson 1 Training Manual
Mon Jan 9	Wed Jan 11
EXCEL TEXT AND SUMMARY FUNCTIONS Reading: About.com SS Functions Blackboard: M1-Lesson 2 Training Manual	USING EXCEL FOR MANAGING DATABASES Reading: About.com SS Functions Blackboard: M1-Lesson 3 Training Manual
Mon Jan 16	Wed Jan 18
M.L. KING HOLIDAY	USING ARRAY FORMULAS IN EXCEL / EXAM REVIEW Reading: Array Formulas Blackboard: M1-Lesson 4 Training Manual
Mon Jan 23	Wed Jan 25
MODULE 1 EXAM	EXCEL VBA MACROS Reading: Albright, Ch 1-4, Ch 10:10.6 Blackboard: M2-Lesson 1 Training Manual
Mon Jan 30	Wed Feb 1
ADVANCED FUNCTIONS / USING BUTTONS FOR USER INPUT Reading: Albright, Ch 5, Ch 7 Blackboard: M2-Lesson 2 Training Manual	WORKING WITH RANGES Reading: Albright, Ch 6 Blackboard: M2-Lesson 3 Training Manual
Mon Feb 6	Wed Feb 8
WORKING WITH WORKBOOKS, WORKSHEETS, AND CHARTS Reading: Albright, Ch 8 Blackboard: M2-Lesson 4 Training Manual	WORKING WITH ARRAYS Reading: Albright, Ch 9 Blackboard: M2-Lesson 5 Training Manual
Mon Feb 13	Wed Feb 15
PSEUDOCODING AND REVIEW Reading: Albright, Ch 1-9; 10.6 Blackboard: M2-Lesson 6 Training Manual	MODULE 2 EXAM
Mon Feb 20	Wed Feb 22
CREATING ADD-INS Reading: Albright, Ch 10; 19; 11.1-11.4 Blackboard: M3-Lesson 1 Training Manual	ADVANCED USER FORMS Reading: Albright, Ch 11 Blackboard: M3-Lesson 2 Training Manual
Mon Feb 27	Wed Feb 29
MENUS AND ERROR HANDLING Reading: Albright, Ch 12; 16 Blackboard: M3-Lesson 3 Training Manual	CATCH UP DAY
Mon Mar 5	Wed Mar 7
WORKING WITH OTHER FILES / OFFICE APPLICATIONS Reading: Albright, Ch 13; 32 Blackboard: M3-Lesson 4 Training Manual	WORKING WITH SOLVER / CODING TIDBITS Reading: Albright, Ch 17 Blackboard: M3-Lesson 5 Training Manual
Mon Mar 12	Wed Mar 14
REVIEW Reading: Albright, Ch 8; 10-13; 16-17; 32 Blackboard: M3-Lesson 6 Training Manual	MODULE 3 EXAM

Excel Home | Milking Schedule | Feed Bucket | WhiteGold Inc.

K. Keeling DU Home Page | Department of Business Information & Analytics

DU Home Page | Daniels College of Business