BEGIN:VCALENDAR
VERSION:2.0
PRODID:
BEGIN:VEVENT
UID:168372imp
DTSTAMP:20260718T142934Z
DTSTART:20261119T170000Z
DTEND:20261119T190000Z
SUMMARY: Streamlined Excel Reporting Series Session 4: External Data and PivotCharts (2 hours) [NT]
DESCRIPTION: Extracting data for richer insightsYou'll gain meaningful analysis techniques while working alongside an industry expert and knowledgeable instructor. This session begins with the GETPIVOTDATA function to enable report customization. It's a great starting point before moving on to more advanced techniques. Power Query introduction With its user-friendly interface\, Power Query empowers Excel users to take the next step by enabling seamless data import and transformation. With Power Query\, you will explore features\, including: \n\nGetting and transforming data \nLoading data \nManaging columns \nData source settings \nLayouts and parameters \nVisualizing with PivotChartsA well-designed chart can effectively illustrate data trends and comparisons. You'll learn how to create and customize PivotCharts to elevate your reports and make the data more accessible to others. *Session 4 is one of four individual sessions. Each session builds on the previous one\, so consider watching all the sessions [Streamlined Excel Reporting Series](https://www.aicpa-cima.com/cpe-learning/webcast/streamlined-excel-reporting-series) to tackle real-world issues and create powerful workbooks.* \n  
CLASS:PUBLIC
END:VEVENT
END:VCALENDAR