ALPFA 2011 Annual Convention - Excel Workshops
Sunday - August 7, 2011 |
| 9:00am-10:30am |
Disneyland Hotel - Monorail |
Basic Excel Functions |
Lookup, Match, Index, Text functions, Auditing Tool, Goal Seek, Data Tables |
Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business |
| 10:45am-12:00pm |
Disneyland Hotel - Monorail |
Advanced Excel Functions |
Financial Functions, SUMIF, SUMIFS, COUNTIF, COUNTIFS, OFFSET, INDIRECT |
| 2:30pm-3:45pm |
Disneyland Hotel - Monorail |
Describing Data: Pivot Tables, Sparklines, Excel Statisical functions, Subtotals, Data Consolidate |
Describing Data: Pivot Tables, Sparklines, Excel Statisical functions, Subtotals, Data Consolidate |
| 4:00pm-5:15pm |
Disneyland Hotel - Monorail |
Modeling Relationships |
Excel Trendcurve, Correlation and Regression |
|
