Please click on the title of an event to view details such as links to a registration form.
Tue, Mar 27, 2018
Introduction to creating and modifying pivot tables using Excel and imported data with an emphasis on using pivot tables to determine the answers to specific questions.
This is an intermediate level Excel training workshop. You should be familiar with using Excel to get the most out of this workshop.
Tue, Apr 3, 2018
This training workshop covers adding content including SmartArt, graphics, media and animation, working with charts, printing your presentation, and design tips for presentations.
Wed, Apr 4, 2018
Thu, Apr 5, 2018
This training workshop is a custom class designed for Amherst College. Learn to use Excel effectively for Data Analysis. Topics covered will include named ranges, lookup functions, logic functions (IF-THEN-ELSE, Sumif, Countif), Excel tables, sorting and filtering, and pivot tables.
Tue, Apr 10, 2018
Wed, Apr 11, 2018
Wed, Apr 18, 2018
Tue, Apr 24, 2018
This training workshop provides an Introduction to PowerPivot tables, which are pivot tables that can incorporate multiple data sets. This includes a description of working with relationships and an introduction to the DAX programming language used for advanced PowerPivot development.
This is an advanced level Excel training. You should be familiar with using Excel and ideally also with using Pivot Tables to get the most out of this workshop.