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. Participants learn how to import, extract, and manipulate spreadsheet data. Participants will also use some of Excel’s tools to work more efficiently, including data validation, PivotTables, and PivotCharts. 

Objectives

  • Explore ways to import data from external sources into Excel for analysis 
  • Specify criteria to control data entered into a worksheet 
  • Create pivot tables to explore, analyze, and summarize data sets
Faculty
Staff
Students
Live Training: Online
Data
Microsoft Excel
Microsoft O365
Office 365: An Overview of Office 365 for the Classroom

Office 365: An Overview of Office 365 for the Classroom

Are you using Penn State’s Office 365 applications to enhance your teaching? Do you want to learn more about Office 365 and how the applications could potentially be used in the classroom?This 1.5 hour demonstration and discussion will walk you through how to locate Office 365 applications, identify how you can use these tools in your teaching environment, and follow up with the resources needed to get you there.

Objectives

  • Explore the Office 365 applications available for Penn State faculty and students
  • Discover how to use Office 365 applications to enhance teaching and simplify student interaction
  • Evaluate which Office 365 applications are appropriate for your needs
Faculty
Live Training: Online
Collaboration
Communication
Teaching and Learning
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: 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: Power Automate Learning Path

Submitted by pxn105 on Mon, 06/18/2018 - 18:42
Microsoft Power Automate, formerly Flow, is a web-only application that enables you to create automated tasks and processes across applications and services. This Power Automate Learning Path supports all Penn State faculty, staff and students who use Microsoft Power Automate. 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: Power BI Learning Path

Submitted by mak6570 on Tue, 03/31/2020 - 16:29
This Power BI Learning Path supports all Penn State faculty and staff using Microsoft Power BI. This Learning Path teaches you how to utilize the various analytics tools of Power BI within Office 365. Follow in the order of the modules or choose individual topics to review.
Faculty
Staff
Students
Learning Path
Data
Microsoft Power BI
Microsoft O365

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

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

Pages