When   Tuesday, July 7, 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

This full-day workshop is ideal for self-taught users of Microsoft Excel who would like to fill in the gaps in their know-how as well as learn time-saving tips and tricks. Techniques to produce reliable Excel workbooks are covered, including how to display, format, edit existing worksheets and develop new ones plus how to make the most of Excel by creating formulas to analyze data quickly. Prerequisite: Office 2007: Fundamentals or equivalent experience.

Key Points

Tour of the Excel 2007 Environment Enter and edit labels, values, and formulas in a worksheet Use Autofil to quickly fill in predefined labels and to copy text, numbers and formulas Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas Use functions such as SUM, AVERAGE, MIN, MAX, and COUNT to perform calculations in a worksheet Format text, numbers, rows, and columns in a worksheet to make them more prominent and easier to read Preview, control Page Setup options for, and print worksheets and set and clear a print area Learn about the new SmartArt