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
Major Incident Training for IT Staff

Major Incident Training for IT Staff

This video is intended for Penn State staff who support IT Services. The primary topic is the Major Incident Process. Recent improvements to this process have resulted in more streamlined steps and clear lines of responsibility and communication. You will walk away with visual reference materials describing this process and your role in it.

Staff
Video
Service Management
Other
ServiceNow
Other

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: Forms Learning Path

Submitted by kaw160 on Tue, 04/24/2018 - 12:20
Microsoft Forms is a web-only application that enables you to create, distribute, and analyze quizzes and forms. This Forms Learning Path supports Penn State faculty, staff, and students looking to gather information using quizzes or forms. Quizzes are used for general assessment, while forms are used as information-gathering tools, such as surveys or polls. This learning path teaches you how to create, customize, share, and analyze results from forms and quizzes, individually or collaboratively using Microsoft's Office 365 Forms. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Learning Path
Collaboration
Communication
Teaching and Learning
Microsoft O365
Microsoft Forms

Office 365: Planner Learning Path

Submitted by pxn105 on Sun, 04/08/2018 - 19:38
This Planner Learning Path supports all Penn State faculty, staff and students using Microsoft Planner. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Project Management
Microsoft O365
Microsoft Planner

Office 365: Sway Learning Path

Submitted by bxb11 on Mon, 02/19/2018 - 09:35
This Sway Learning Path supports all Penn State faculty, staff and students who use Microsoft Sway. Learn how to create, save and export, share and collaborate, and present Sways. You may choose to follow this learning path in the order of the modules or choose topics to review at your own pace. Sway is an online application. Windows 10 users can download the app and run it from their Windows 10 PC. The desktop app is not available on other versions of Windows or on Macintosh.
Faculty
Staff
Students
Learning Path
Communication
Creative
Teaching and Learning
Microsoft Sway
Microsoft O365
ServiceNow: Getting Started with Navigating the ServiceNow Interface

ServiceNow: Getting Started with Navigating the ServiceNow Interface

This video course introduces you to key features and functions of ServiceNow. This series of interactive videos, designed for new users, teaches you to navigate the interface, quickly locate relevant information, and maximize productivity by customizing your workspace.

Objectives:

  • Access and navigate the interface
  • View and filter applications and modules
  • Create and access favorites
  • Manage group lists
  • Locate information with global text search
  • Create and customize homepages
  • Modify account and notification preferences
Staff
Video
Service Management
ServiceNow
Sway versus PowerPoint: What’s the Difference?

Sway versus PowerPoint: What’s the Difference?

Faculty
Staff
Students
Documentation
Communication
Creative
Teaching and Learning
Microsoft O365
Microsoft Sway
Ways to Use Microsoft Forms

Ways to Use Microsoft Forms

Faculty
Staff
Documentation
Collaboration
Communication
Teaching and Learning
Microsoft O365
Microsoft Forms