IT Learning and Development
View Menu
Excel: Data Management

Excel: Data Management

In this hands-on workshop, participants will become familiar with the basic tools for data management in Microsoft Excel. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to work more efficiently, including data validation, PivotTables, and PivotCharts. 

Objectives

  • Explore ways to import data from external sources into Excel for analysis 
  • Specify criteria to control data entered into a worksheet 
  • Create pivot tables to explore, analyze, and summarize data sets
Faculty
Staff
Students
Live Training: Online
Data
Microsoft Excel
Microsoft O365
Sites at Penn State Resources

Sites at Penn State Resources

The resources listed on this page can help you get started using Sites at Penn State.

Faculty
Staff
Students
Other online resources
Communication
Teaching and Learning
Other
Sites
Sites at Penn State: Building Blogs and/or ePortfolios

Sites at Penn State: Building Blogs and/or ePortfolios

This hands-on online session  focuses on the Sites at Penn State tool, a blogging and website platform powered by WordPress. Get started with the Sites at Penn State tool and learn to create a personal or course blog, department, event, or course website, or an ePortfolio. Discuss best practices for managing text, posts, pages, media, and themes while exercising best practices in site design.

Objectives:

  • Explore the Sites at Penn State interface
  • Create new site pages to include content such as contact information, information about the site owner, or a resume
  • Create and manage blog and ePortfolio content including text, files, links, images, and video
  • Change the site theme including the header image

 

Students
Live Training: Online
Collaboration
Communication
Teaching and Learning
Sites