BEGIN:VCALENDAR X-WR-TIMEZONE:US/Eastern DTSTART:20200528T130000 DTEND:20200528T140000 VERSION:2.0 LOCATION:OnlinePRODID:-//Training Doyens //EN METHOD:REQUEST BEGIN:VEVENT DTSTAMP:20200528T000000 DTSTART;TZID="US/Eastern":20200528T130000 DTEND;TZID="US/Eastern":20200528T140000 SUMMARY:Excel Advanced Pivot Tables: Integrating Power Pivot for Extraordinary Data Analysis DESCRIPTION: Power Pivot is a new Add-In for Microsoft Excel that gives you sophisticated Data Modeling tools. Bringing in data from different tabs, files, or even databases, you can establish relationships between those sources. For example, you can connect a list of customers from a spreadsheet to your sales database, or connect a list of employees to their completed training courses. With those relationships established, our Pivot Table can now calculate and filter information from these connected sources with no additional effort. Additionally, this data model provides an entire suite of calculations that use those relationships to create filtered reports in a flash. These calculations – like CALCULATE and ALL – give Pivot Tables all the tools users have been looking for in the last 20 years. PRIORITY:3END:VEVENT END:VCALENDAR