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