Advanced Excel for Data Analysis Streamline your process and conduct more in-depth analysis with sophisticated number crunching.  Minimize manual labor, save time and perform more detailed analysis quickly. Develop more efficient ways to apply commonly used formulas.  Discover often overlooked Excel formulas.  Analyze data using functions such as pivot tables, sumif, sum+if, transpose, working with arrays, vlook-up, subtotals, and regression analysis.  Enhance your spreadsheets with data validation techniques, automation of alternate row shading and much more! Increase your Excel efficiency up to 75%. Prerequisite: Intermediate proficiency using Excel. Note: Bring your PC laptop with Microsoft Excel installed and a CD-ROM drive. Excel for Mac will not be as effective. DATE: Thursday, April 23, 2009 TIME: 9:00 a.m–5:00 p.m. LOCATION: NYSSA 1177 Avenue of the Americas, 2nd Floor (between 45th and 46th Streets), NYC (Directions) Photo ID required for access to the building. INSTRUCTOR: Hamilton Lin, CFA (Instructor Bio) TUITION: Members $545 | Nonmembers $645 LEVEL: Advanced   CREDITS: CE/CPE = 7