Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Excel Data-wrangling, Analysis, and Visualization Workshop: Getting Started

Exercises

Please download the exercise files and instructions for practice during the workshop. The PowerPoint slides are a reference to accompany the presentation. 

Workshop Agenda

Feb. 9, 2:00–3:30 PM (Pt 1)

  • PivotTable
    • Create a PivotTable
    • Formatting
    • Sort & Filter
  • PivotChart
    • Create a PivotChart
    • Improve data presentation
    • Highlight important finding

Mar. 2, 2:00–4:00 PM (Pt 2)

  • Power Query
    • Get Data
    • Transform Data
    • Import Data
  • Power Pivot
    • Data Model
    • Relationship
    • Data Analysis Expressions (DAX)

Other Resources

Ask Me

Profile Photo
Kimberly Vardeman

Contact:
Texas Tech University Library
Room 110A
(806) 834-4156

Web Librarian

Profile Photo
Jingjing Wu
Contact:
Room 8 (Basement)
TTU Library
806.834.3991