When:
Tuesday, July 29, 2014
9:00 AM - 4:00 PM CT
Where: Wieboldt Hall North Entrance, 415, 339 E Chicago Ave, Chicago, IL 60611 map it
Audience: Faculty/Staff - Student - Public - Post Docs/Docs - Graduate Students
Cost: NU employees $165; Non NU Registrants $300
Contact:
Learning & Organization Development
(847) 467-5081
Group: Office of Human Resources | Talent Development & Well-being
Category: Training
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 the 2010 environment.
Prerequisite: Excel 2010: Beyond the Basics or equivalent experience/skills. If you have not completed Excel 2010: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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