When:
Tuesday, February 28, 2017
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 $260; Non-NU Participants $495
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 2010 environment.
Prerequisite: Excel 2016: Beyond the Basics or equivalent experience/skills. If you have not completed Excel 2016: 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