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


Please download the exercise files and instruction for practice.

Workshop Agenda

Sep 22, 3:00-5:00 PM

  • Power Query
    • Data Import
    • Data Transformation
    • Load Data
  • Power Pivot
    • Import Big Data
    • Create Relationships
    • Data Analysis Expressions (DAX)

Sep 22, 3:00-4:00 PM

  • PivotTable
    • Create a PivotTable
    • Formatting
    • Sort & Filter
  • PivotChart
    • Create a PivotChart
    • Improve Data Visualization
  • Power Query
    • Import Data from Folders

Workshop Evaluation

Other Resources

Ask Me

Jingjing Wu's picture
Jingjing Wu
Room 8 (Basement)
TTU Library