| |
EMBA Math Workshop - Summer 2008
| General Info |
|
| Class Schedule (all classes in BAEEC) |
Date
Tues., 8/19
Thurs., 8/21
Tues., 8/26
Thurs., 8/28
|
Room
Room 310
Room 310
Room 310
Room 310
|
Topics
Overview, tutorials 2, 3
Tutorials 4, 5
Tutorials 6, 8, 9
Tutorials 11, 12
|
|
Session 4 (Thurs. 8/28):
What-If Analysis (2003 Tutorial 9, 2007 Tutorial 10)
Tutorial:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Accessing External Data (2003/2007 Tutorial 11)
Tutorial:
2003: notes, unsolved/solved data (self-extracing .exe)
2003: notes, unsolved/solved data (self-extracing .exe)
Session 3 (Tues. 8/26):
Multiple Worksheets/Workbooks (2003/2007 Tutorial 6)
Tutorial:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Excel Applications (2003/2007 Tutorial 8)
Tutorial:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Tutorial case:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Financial Analysis (2007 Tutorial 9)
Tutorial:
2003: notes, unsolved workbook, solved workbook, source doc
2007: notes, unsolved workbook, solved workbook
Session 2 (Thurs. 8/21):
Charts and Graphics (2003/2007 Tutorial 4)
Tutorial:
2003: notes, unsolved workbook, background image, solved workbook
2007: notes, unsolved workbook, solved workbook
Tutorial case:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Excel Lists, PivotTables/Charts (2003/2007 Tutorial 5)
Tutorial:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Tutorial case:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Session 1 (Tues. 8/19):
Formatting Workbooks (2003 Tutorial 3, 2007 Tutorial 2)
Tutorial:
2003: notes, unsolved workbook, background image, solved workbook
2007: notes, unsolved workbook, background image, solved workbook
Tutorial case:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Formulas and Functions (2003 Tutorial 2, 2007 Tutorial 3)
Tutorial:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Tutorial case:
2003: notes, unsolved workbook, solved workbook
2007: notes, unsolved workbook, solved workbook
Preliminary material:
Tutorial 1: Intro to Excel (lecture notes, tutorial files)
Class intro slides
|
|
