EP Professional Development Series: Microsoft Excel

A series of four non-credit professional development courses exploring the powerful tools of Microsoft Excel®. Wednesdays, 6:00pm-9:00pm starting April 1, 2015 $125 per course; $400 for the entire series Alumni receive 50% off - inquire for discount code.

Course One: Efficiency Tips and Tricks, April 1: Learn to use Microsoft Excel® to perform tasks more efficiently and effectively using selected keyboard shortcuts, built-in features and tools.

Course Two: Organize and Extract Information from Data, April 8: Learn how to organize your data with Excel® Table and how to extract information from data using filter, together with summary measures, and conditional formatting.

Course Three: Summarizing Data with PivotTable, April 15: Learn how to use PivotTable to analyze your data by comparing and contrasting subgroups within your data set and how to generate tables for results.

Course Four: Automating Tasks with Formulae and Functions, April 22: Learn how to use selected Microsoft Excel® functions (such as IF and VLOOKUP) to create formulae, together with dynamic drop-down lists, that will automate selected tasks.

Presenter  Dr. Siaw-Peng Wan will present at all four sessions in the EP Series. Dr. Wan is a professor of business administration and a CFA who has developed and taught numerous Microsoft Excel® workshops and courses. He earned his Ph.D. in Economics from the University of Illinois at Urbana-Champaign.

Reserve your space today. Contact Tracy Tomasetti at (630) 617-5997 or tracy.tomasetti@elmhurst.edu, or register online. Participants may register for individual courses or the entire series. Elmhurst College Alumni are eligible for special rates, please inquire for special rate code.