Loading Events

« All Events

Advanced Excel Concepts: Working with Power Pivot

June 23 @ 1:00 pm - 2:30 pm EDT

Advanced Excel Concepts: Working with Power Pivot to Create Multi-table Reports and Charts

In this Advanced Excel session, we will learn how to use Power Pivot to create pivots from two or more sources of data. We will learn how to define relationships between multiple data tables and data sources to create complex pivots. We will build on this and use slicers and timelines to create interactive reports and charts.

What participants can expect to gain?

Participants will gain an understanding of how to use Power Pivot to define data models from multiple tables or data sources. We will then explore methods to analyze this complex data using slicers, timelines, and interactive reports.

Participants should have experience with Excel, including the use of tables and named ranges. Participants should be comfortable with basic Pivot Tables. Participants should have access to a modern version of Excel (2016, 2019 or M365). Participants should enable the Power Pivot add-in.

Short Bio: Catherine Thenault is an IT Professional with over 40 years of experience. My current areas of focus are Content & Collaboration Management Systems including SharePoint, Teams, Office 365 and Microsoft’s Power Platform. I am also a facilitator and technical trainer. I thrive in the space where business problems and technical solutions intersect. When not working, I am happiest hiking, cycling, skiing, sailing, or spending time with friends and family cooking a great meal.

Some Additional information:

Our virtual event “Advanced Excel Concepts: Working with Power Pivot to Create Multi-table Reports and Charts ” will be hosted on Microsoft Teams . If you have never logged into a Microsoft Teams before, be sure to give yourself time beforehand to download Teams.

The link for the event will be sent the morning of the event. If you have not received the link, please email us at info@tech-collective.org to send it to you again.

Please plan on arriving at 12:55 am as we will start promptly at 1 pm and will run until 2:30 pm, with ample time for Q&A

Cameras on! Please plan on turning your camera on so we can all connect as we learn.

If you would like to contribute to our programming by hosting a session, please email Creusa Michelazzo at creusa.michelazzo@tech-collective.org

Questions? Email our team at info@tech-collective.org