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

Submitted by kaw160 on Thu, 11/16/2017 - 16:15
This Word Learning Path supports all Penn State faculty, staff, and students who use Microsoft Word. Although you probably know how to use Word already, this learning path teaches you how to use it within Office 365. Follow this learning path in the order of the modules or choose topics to review.
Faculty
Staff
Learning Path
Accessibility
Collaboration
Other
Microsoft Word
Microsoft O365

iTwo Learning Path

Submitted by kub26 on Mon, 07/03/2017 - 15:09
This iTwo Learning Path supports all Penn State faculty and staff who use iTwo for data analysis, data visualization, and automation of data queries.
Faculty
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? These hands-on training sessions build upon the topics presented in iTwo: Getting Started with Data Analysis. Over the course of 2 sessions, 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 online 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 the online 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: Online
Data
iTwo
iTwo: Advancing Your Skills Handout

iTwo: Advancing Your Skills Handout

Handout for iTwo: Advancing Your Skills

 
Staff
Documentation
Data
iTwo
iTwo: Developing Dashboards

iTwo: Developing Dashboards

This hands-on online training session is designed for advanced users of iTwo and builds upon the knowledge and skills presented in iTwo: Getting Started with Data Analysis and the iTwo: Advancing Your Skills training sessions. This session focuses on the basic skills needed to create interactive dashboards.

Staff
Live Training: Online
Data
iTwo

Pages