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


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