Event box

Excel for Data-Wranging, Analysis, And Visualization Part 2 - Jingjing Wu, Kimberly Vardeman ONLINE

This will be offered online only. Registration will close two days before the workshop so that an invite can be sent by email but you are welcome to email the presenter(s) to be added. Kimberly.vardeman@ttu.edu


Please attend online sessions with your TTU email address to receive credit for attendance.

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

2.    Transform data into a format ready for analysis  

3.    Use the Data Model and Power Pivot to handle big data

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.

Related LibGuide: Excel Data-wrangling, Analysis, and Visualization Workshop by Kimberly Vardeman

Tuesday, March 2, 2021
2:00pm - 4:00pm
Time Zone:
Central Time - US & Canada (change)
  Undergrads, Graduates, Staff and Faculty  
Registration has closed.

Event Organizer

Jingjing Wu
Kimberly Vardeman
No Profile image
Denise Caspell

More events like this...