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

G Suite for Education

Submitted by anj5053 on Thu, 10/17/2019 - 12:37
G Suite for Education is a cloud-based collection of productivity and collaboration applications. These applications will create learning opportunities, challenge users to think critically, and help streamline administrative tasks anywhere on the go to enhance teaching, learning, and research for students, faculty, and staff.
Faculty
Staff
Students
Learning Path
Collaboration
Communication
Creative
Teaching and Learning
G Suite for Education
Other
Microsoft Teams: Getting Started with Online Collaboration

Microsoft Teams: Getting Started with Online Collaboration

Collaborating and communicating online has become an integral part of our day-to-day lives, but it’s often messy and hard to navigate across multiple apps and devices. Join us for a brown bag session to learn how to create and organize a virtual collaboration space with Microsoft Teams. You’ll have a chance to explore relevant features available in Teams (channels, apps, tabs etc.) and walk away with tips for setting up, organizing, and managing your Team to make collaboration more seamless.

Faculty
Staff
Live Training: Online
Collaboration
Communication
Microsoft Teams
Microsoft O365
Office 365 and G Suite Apps Comparison Chart

Office 365 and G Suite Apps Comparison Chart

Faculty
Staff
Students
Documentation
Collaboration
Communication
Teaching and Learning
Other
G Suite for Education
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: 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: Sharing and Collaboration Learning Path

Submitted by lek136 on Fri, 01/19/2018 - 15:41
This Sharing and Collaboration Learning Path supports all Penn State faculty, staff, and students wanting to share and collaborate on files. Choose the appropriate tool to fit your needs. Find additional information about using Microsoft tools like OneDrive for Business, Groups, Teams, and SharePoint Online.
Faculty
Staff
Learning Path
Collaboration
Communication
Microsoft Outlook
Microsoft Teams
Microsoft SharePoint
Microsoft OneDrive
Microsoft O365

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
Workamajig: Timetracking in WMJ for Outreach Marketing

Workamajig: Timetracking in WMJ for Outreach Marketing

This resource was created specifically for the Outreach Online Education marketing group. This one-page handout provides step-by-step timetracking instructions, timetracking tips, and a weekly compliance schedule for the unit. 

Staff
Documentation
Project Management
Workamajig
Working Collaboratively with Office 365 and G Suite at Penn State

Working Collaboratively with Office 365 and G Suite at Penn State

With the introduction of G-suite for education alongside the existing Office 365 collaboration tools, it can be difficult to determine which tools may best suit your needs. In this session, we will compare tools available in G-suite and Office 365 for productivity, storage, and collaboration. In addition, we will work through several use cases to determine which tool(s) might be best to use for your unique needs.

Faculty
Staff
Live Training: Online
Collaboration
G Suite for Education
Microsoft O365