Event box

Excel for Data-Wrangling, Anaysis, and Visualization Part 2 - Online Only - Jingjing Wu, Kimberly Vardeman

This workshop will be offered through the Zoom/MediaSite platform. You must register to receive email with the link to participate. Registration will close 48 hours prior to allow for sending out emails. You may contact kimberly.vardeman@ttu.edu to be added after registration stops.

 

Learning Outcomes:

1.    Use Excel Power Query to connect data from various sources

2.    Use Data model and Power Pivot

3.    Transform data into a format ready for analysis

Abstract:

Researchers are dealing with more and more data in their routine work. Although many tools are available, Excel spreadsheets remain an indispensable part of data management. Excel handles a variety of data formats, transforms raw data into other formats for further analysis, and has important features for summarizing and visualizing data. This two-part workshop aims to develop Excel skills. Part 2 of the workshop will use some example datasets to demonstrate Power Query, Power Pivot, and Data Model. (Part 1 of this workshop will demonstrate these Excel features: PivotTable and PivotChart.)   This session will expect that attendees have at least basic familiarity with Excel. The methods of analyzing and visualizing data will be practical for attendees at the beginner or intermediate level. This workshop is open to people of any academic status—graduate, undergraduate, faculty, or staff. Attendees are invited to bring their own laptops to follow along with hands-on learning.

 

Related LibGuide: Data Visualization by Jingjing Wu

Date:
Tuesday, September 29, 2020
Time:
3:00pm - 5:00pm
Campus:
University Library
Audience:
  Undergrads, Graduates, Staff and Faculty  
Categories:
  Workshops  

Registration is required. There are 100 seats available.

Event Organizer

Jingjing Wu
No Profile image
Denise Caspell

More events like this...