IT Learning and Development
View Menu

Filter by service or technology:

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 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

Faculty
Staff
Students
Live Training: Online
Data
Microsoft Excel
Microsoft O365

Office 365: Excel Learning Path

Submitted by bxb11 on Fri, 01/19/2018 - 10:08
This Excel Learning Path supports all Penn State faculty, staff, and students using Microsoft Excel. Although you probably already know how to use Excel, this learning path teaches you how to do it within Office 365. Follow in the order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Data
Microsoft Excel
Microsoft O365

Office 365: Flow Learning Path

Submitted by pxn105 on Mon, 06/18/2018 - 18:42
Microsoft Flow is a web-only application that enables you to create automated tasks and processes across applications and services. This Flow Learning Path supports all Penn State faculty, staff and students who use Microsoft Flow. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Data
Microsoft O365
Microsoft Flow

Office 365: Stream Learning Path

Submitted by bxb11 on Fri, 06/08/2018 - 10:45
Microsoft Stream is a web-only application that enables you to store and share your videos of lessons, meetings, presentations, training sessions, or other content. This Microsoft Stream Learning Path supports all Penn State faculty, staff, and students who use Microsoft Stream. Follow this Learning Path in order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Other
Microsoft Stream
Microsoft O365
Qualtrics: An Introduction

Qualtrics: An Introduction

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:

  • Discuss the primary features of Qualtrics
  • Explore the Qualtrics interface
  • Identify the resources available to Qualtrics users
Faculty
Staff
Live Training: Online
Communication
Data
Qualtrics
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 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

 

Faculty
Staff
Students
Live Training: In-Person
Collaboration
Communication
Teaching and Learning
Sites