Skip to main content

Staff Education Resources (BMC)

Resources for Bryn Mawr College Staff to assist in the development of skills and competencies related to their professional growth.

Volunteer to Help Your Colleagues!

If you would like your name added to any of the categories, please fill out the following form: Community-based Excel Support Volunteer Signup Form. If you’d like to be removed from the list at any time, contact amantuano@brynmawr.edu.

Community-based Excel Support Network

Stumped with an Excel question? Can’t find an answer online? Reach out to a colleague! Staff and Faculty have volunteered their time and expertise to be available for Excel assistance via phone or email. 

View the directory of staff and faculty volunteers below willing to offer support in various Excel competencies. Their areas of expertise are listed along with their preferred method of contact.

*Please understand that the volunteers make themselves available as a courtesy to the staff and faculty community. Please be respectful and mindful of the person’s time and other responsibilities, and understand that they may not be able to provide an immediate response.

Support Directory

Charts

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Jenny Spohrer - jspohrer@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 

Conditional Formatting

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Jenny Spohrer - jspohrer@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu

Data Validation

Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu
Andrew Mantuano - amantuano@brynmawr.edu
Jenny Spohrer - jspohrer@brynmawr.edu

Filtering and Sorting Data

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Jenny Spohrer - jspohrer@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu

Formatting Cells

Andrew Mantuano - amantuano@brynmawr.edu

Formulas and Functions

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160 (VLOOKUP, PivotTables, Financial Functions)
Jen Hawkes - jhawkes@brynmawr.edu (AVERAGE, INDEX, COUNT, COUNTIF, IFNA, TRUNC, TRANSPOSE, TODAY, LEFT, RIGHT, FIND)
Andrew Mantuano - amantuano@brynmawr.edu
Jenny Spohrer - jspohrer@brynmawr.edu (VLOOKUP, SUMIF/IFs, COUNTIF/IFs, AVERAGEIF/IFs, Concatenate, MIN, MAX, STDEV) 
Tijana Stefanovic -tstefano@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu (SUM, SUMIF, VLOOKUP, Information Category (ISERROR, TYPE), Financial Category (PMT, PV, FV))

Importing Data

Jen Hawkes - jhawkes@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu

Linking Workbooks and Worksheets

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu

Objects (Pictures, Shapes, Text Boxes, etc.)

Lindsey Dever - ldever@brynmawr.edu
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 

PivotTables

Lindsey Dever - ldever@brynmawr.edu
Kari Fazio - kfazio@brynmawr.edu - 610-526-5160
Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu

Printing and Page Layout

Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu
Tijana Stefanovic -tstefano@brynmawr.edu 
Maria Wiemken - mwiemken@brynmawr.edu

Sharing and Protecting Workbooks

Jen Hawkes - jhawkes@brynmawr.edu 
Andrew Mantuano - amantuano@brynmawr.edu

VBA and Macros

Andrew Mantuano - amantuano@brynmawr.edu (recording basic macros)
Maria Wiemken - mwiemken@brynmawr.edu (recording basic macros)