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 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
Kaltura: Video Quizzes

Kaltura: Video Quizzes

Want to assess learning or gather information in a more unique and engaging way? Enter Kaltura Interactive Video Quizzes! Learn how to use Kaltura, Penn State's new media management and streaming service to create and share video quizzes. Through demonstration and hands-on elements, you'll leave this session with a new way to engage your audience!

Faculty
Staff
Live Training: Online
Communication
Creative
Data
Teaching and Learning
Kaltura

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