Session covers Excel basics, descriptive statistics, histograms, charting, scattergrams, correlations, single and multiple regressions, auto filtering, conditional formatting, pivottables, and merging data using Access. Participants may bring their own laptops (Windows only). We can accommodate both Excel 2003 and 2007. If you do not bring a laptop, you will be using Excel 2003. Access and Excel are required as well as the Excel Add-ins, Analysis ToolPak and Analysis ToolPak-VBA. We will provide datasets to use as the various tools are presented. We encourage participants to bring their own datasets with which to practice.
Presenter(s): Gerry Zeller, West 40 Intermediate Service Center & Dr. Douglas Dirks, Lead Consultant (Retired), West 40 Intermediate Service Center Date(s): July 10, 2008 Time: 8:30 AM - 3:30 PM Contact E-Mail: gzeller@zellerandassociates.com Level: Participants should be familiar with Excel and should understand columns, rows, and simple formulas. Platform Information: Windows Only Bring Your Own Laptop Available: Yes Location: West 40 Intermediate Service Center 928 Barnsdale road La Grange Park, IL 60526