Dec
13
Thu 9:00 AM

HRD166- Excel 2010: Advanced Functions

export event print e-mail
When: Thursday, December 13, 2012
9:00 AM - 4:00 PM  
Where: Wieboldt Hall North Entrance, 415
339 E. Chicago Avenue  
Chicago, IL 60611 map it
Audience: - Faculty/Staff - Student - Public
Costs: - NU Employees: $135 - Non NU Registrants: $250
Contact: Learning & Organization Development   847-467-5081  
Group: Learning & Organization Development
Category: Training
More Info

To register, click the "More Info" link above

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 2010 environment.

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