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

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
Qualtrics: An Introduction

Qualtrics: An Introduction

This session will acquaint members of the Penn State community with several of the primary features of the Qualtrics survey tool. Qualtrics is a robust tool that allows users to quickly create and distribute surveys, as well as report the results of surveys using a powerful reporting tool.

Objectives:

  • Discuss the primary features of Qualtrics
  • Explore the Qualtrics interface
  • Identify the resources available to Qualtrics users
Faculty
Staff
Live Training: Online
Communication
Data
Qualtrics
Ways to Use Microsoft Forms

Ways to Use Microsoft Forms

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

iTwo Learning Path

Submitted by kub26 on Mon, 07/03/2017 - 15:09
Learn how to use iTwo 11G at Penn State.
Staff
Learning Path
Data
iTwo
iTwo: Advancing Your Skills

iTwo: Advancing Your Skills

Want to explore more advanced options for analyzing and manipulating your data in iTwo? This 2-day, hands-on, in-depth training session builds upon the topics presented in “iTwo: Getting Started with Data Analysis.” You’ll dive deeper into the options available in iTwo, developing more complex queries while building upon the skills you gained in the introductory training.

Self-Study Option

A self-study alternative to the face-to-face training is also available. This allows you to study the materials on your own and then take a 10 question online assessment to test-out of the training. Completing this assessment serves as the equivalent of completing this face-to-face session. This is an excellent option if you are looking to receive training and access to iTwo right away, or if you prefer to go over the materials on your own, at your own pace. Please refer to the assessment and corresponding instructions.

Staff
Live Training: In-Person
Data
iTwo
iTwo: Advancing Your Skills Assessment

iTwo: Advancing Your Skills Assessment

Completing this online assessment serves as the equivalent of attending the face-to-face iTwo: Advancing Your Skills training session. If you successfully pass this test, you do not have to take the face-to-face training. There are 10 questions, and you must achieve a 70% in order to pass. You may attempt the test as many times as you would like, and there is no time limit.

Staff
Other online resources
Data
iTwo
iTwo: Advancing Your Skills Handout

iTwo: Advancing Your Skills Handout

Handout for iTwo: Advancing Your Skills

 
Staff
Documentation
Data
iTwo

Pages