Excel: PivotTables (Apr.29, 1:30-3:30 PM, via Zoom)

Course Description:

UW accounts can take this course for free; email computer.training@uwyo.edu for the promo code.

Take a deep dive into pivot table functionality and learn the essential steps required to build and modify PivotTables in Excel spreadsheets which will likely save you substantial time! Topics include: building an initial table, adjusting fields and options for simple or in-depth analysis, filters and slicers, basic PivotCharts, and more!  We will be analyzing a wide range of data, from financial transactions through scientific research data sets. An optional (but highly-recommended) 30-minute practice lab immediately follows the workshop.

“Being able to quickly analyze data can help you make better decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. PivotTables are a great way to summarize, analyze, explore, and present your data, and you can create them with just a few clicks. PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your results. You can also create PivotCharts based on PivotTables that will automatically update when your PivotTables do.” (Microsoft)

Prerequisites: a basic understanding of Excel spreadsheets

Date/Time: Apr.29, 1:30-3:30 PM (mountain) plus 30-minutes of optional but highly recommended practice exercises (making this 2.5 hours of pivot table bliss!)

Location: via Zoom (a meeting link will be provided after enrollment)

Instructor: Alec Muthig (UWIT)

Important Information:

• Send questions regarding this course to computer.training@uwyo.edu
• Please make sure to arrive at least 5 minutes before the class is scheduled to begin.
• Workshop fees are non-refundable (unless the class is cancelled by UWIT Training).