CANCELLED
When:
Tuesday, February 16, 2016
9:00 AM - 4:00 PM CT
Where: Parkes Hall, 127, 1870 Sheridan Road, Evanston, IL 60208 map it
Audience: Faculty/Staff - Student - Public - Post Docs/Docs - Graduate Students
Cost: NU Employees $165; Non-NU Participants $350
Contact:
Learning & Organization Development
(847) 467-5081
Group: Office of Human Resources | Talent Development & Well-being
Category: Training
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 2013 environment.
Prerequisite: Excel 2013: Sorting, Filtering, Subtotals, Pivot Tables.
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