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 and Zoom: Using Video to Recover Lost Class Time

Kaltura and Zoom: Using Video to Recover Lost Class Time

Snow day? Are you or your students sick? Students missing prerequisite skills? With Kaltura and Zoom, you can breathe easy knowing you can recover lost class time.  In this session, participants will learn strategies to keep students engaged and accountable for missed material.  Create reusable lectures with automatic chapters and slides allowing students to find exactly what they need, when they need it. Learn to use Kaltura Capture to create picture-in-picture videos giving students the flexibility to personalize the viewing experience.  Create Video Quizzes to ensure that students are engaged and interacting with your lecture recordings.

Objectives

  • Develop learning materials, including videos which chapters and slides, picture-in-picture videos, and video quizzes
  • Select the best way to deliver video-based learning materials to your students
  • Use video analytics to evaluate interaction and effectiveness
Faculty
Live Training: Online
Teaching and Learning
Zoom
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

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

Submitted by kaw160 on Thu, 02/15/2018 - 09:55
This OneNote Learning Path prepares Penn State faculty, staff, and students to take, organize, and share notes with others within Office 365. 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 OneNote
Office 365: Outlook - An Introduction to Outlook on the Web (1h 30m)

Office 365: Outlook - An Introduction to Outlook on the Web (1h 30m)

This online demonstration session will show you how to use Outlook's most important email and calendar features on the Web.

Faculty
Staff
Live Training: Online
Collaboration
Communication
Other
Microsoft Outlook
Microsoft O365

Office 365: Outlook Learning Path

Submitted by lek136 on Mon, 10/30/2017 - 14:44
This Outlook Learning Path supports all Penn State faculty, staff, and students using Outlook. Although you probably know how to use email and calendars in other systems, this learning path is designed to teach you how to do it in Office 365. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Learning Path
Collaboration
Communication
Other
Microsoft Outlook
Microsoft O365

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

Submitted by bxb11 on Mon, 01/15/2018 - 11:34
This PowerPoint Learning Path supports all Penn State faculty, staff, and students using Microsoft PowerPoint. Although you probably already know how to use PowerPoint, this learning path teaches you how to do it within Office 365. Follow this learning path in order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Creative
Teaching and Learning
Other
Microsoft Powerpoint
Microsoft O365

Pages