Inquire to Inspire
Recipients who were awarded an Inquire to Inspire grant in 2017 reported on the knowledge and experiences they gained at the professional development events they attended.
Amy Brink, Jennifer Kuklentz, Michele Poruban, and Barbara Tyson, who attended the PA Conference for Women, created this PowerPoint presentation.
Monica Giancarlo, who attended the ONLC Training Centers Excel 2016 Database Features and Pivot Table class, provided this report:
I’d like to extend a thank you to the Inquire to Inspire Funding Committee for granting me the opportunity to attend the Excel 2016 Database Features and Pivot Table course through the ONLC Training Centers.
The training was conducted by a remote instructor with attendees connecting from several training center locations. The training included a course booklet with hands-in exercise during the training session.
Topics covered included an array of Excel features like:
- auto-fill and auto-complete to enter data
- absolute name ranges
- useful short cut keys
- freezing and unfreezing panes
- splitting worksheets for easier viewing, functions with lists
- creating a table to work with data organized like a database
- creating a slicer with table data and calculated columns in tables
- importing and exporting data
- converting text to columns and using flash-fill to separate or join text into columns
- commonly used text functions
- connecting to data in an Access database to import from Access to use Excel data analysis tools and charting features
- creating and working with Pivot tables, enhancing pivot tables with the summary function, creating a slicer, applying filters, grouping data and creating a calculated field
- the very useful VLOOKUP function
- using automatic outlining, inserting subtotals and creating an advanced filter
Sarah Smart, who attended the Phonathon Conference at Washington & Lee University, had this to say:
Over the summer I was able to attend a conference at Washington & Lee University in Virginia focusing on student Phonathon, student philanthropy and young alumni programs. It was a great opportunity to benchmark with peers whose job responsibilities are similar to mine and discuss what’s working, what isn’t working, what’s on the horizon for Phonathon, student philanthropy and young alumni programs. Having the opportunity to network and create working relationships at conferences is really beneficial as we continue to email with each other and bounce ideas off of each other.