When   Wednesday, November 11, 2009   Time   9:00 AM - 4:00 PM  
Where   Millar Chapel/parkes 127 1870 Sheridan Rd.   map it
Audience   - Faculty/Staff - Student - Public
Contact   HR Training & Development   847-467-5081  
Group   HR: Training and Development
More Info   http://www.northwestern.edu/hr/training/computer.html#excel07

Participants learn to use Excel's built-in computational and analytical tools to make complex calculations quickly and easily. Learn tips and tricks from the expert to make your spreadsheets efficient in this new 2007 environment.

Prerequisite: Excel 2007- Beyond the Basics or equivalent skills.

Key Points Use additional Statistical functions not previously covered Use logical functions Nest multiple functions Lookup function and naming ranges for pulling in data How and when to use Error functions Format and calculate date and time functions Calculate investments using financial functions Concatenate, left, right, middle and other text functions Plenty of time to answer your specific questions - Bring your files if desired Loads of Tips and Tricks