In this hands-on workshop, participants will become familiar with the basic tools for data management in Microsoft Excel 2016. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to help manage multiple worksheets, visually compare workbooks, and work more efficiently in Excel.
Objectives
• Create tables and pivot tables
• Explore workbook and worksheet protection
• Import, sort, filter and validate data
• Create built-in and custom lists
This session will acquaint members of the Penn State community with several of the primary features of the Qualtrics survey tool. Qualtrics is a robust tool that allows users to quickly create and distribute surveys, as well as report the results of surveys using a powerful reporting tool.
Objectives: