BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20260922T163000Z
DTEND:20260922T203000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Beginner Pivot Tables Training – Virtual
DESCRIPTION:9/22\, 9/23/26\n\nThis hands-on course teaches participants how to organize\, summarize\, analyze\, and present data using Microsoft Excel PivotTables and PivotCharts.\n\nStudents will learn how to transform large spreadsheets into meaningful reports and interactive dashboards without using complex formulas.\n\nParticipants will work with real-world datasets to build reports\, filter information\, calculate totals\, identify trends\, and create professional visual summaries.\n\nTopics Covered\n\nIntroduction to PivotTables\n\n\n Understanding structured data\n Preparing data for PivotTables\n Creating a PivotTable\n PivotTable layout and terminology\n\n\nWorking with Data\n\n\n Sorting and filtering\n Grouping dates\, numbers\, and categories\n Using report filters\n Managing large datasets\n\n\nCalculations and Analysis\n\n\n Sum\, Average\, Count\, Min\, Max\n Calculated fields\n Percentage calculations\n Running totals and comparisons\n\n\nPivotTable Design & Formatting\n\n\n Custom layouts\n Number formatting\n Conditional formatting\n Refreshing and updating data\n\n\nPivotCharts and Visualization\n\n\n Creating PivotCharts\n Interactive filtering with slicers and timelines\n Dashboard basics\n\n\nLearning Outcomes:\n\nBy the end of the course\, participants will be able to:\n\n\n Build PivotTables from raw data\n Analyze trends and summarize information quickly\n Create interactive reports and charts\n Use slicers and filters effectively
X-ALT-DESC;FMTTYPE=text/html:9/22\, 9/23/26
\n\nThis hands-on course teaches participants how to organize\, summarize\, analyze\, and present data using Microsoft Excel PivotTables and PivotCharts.
\n\nStudents will learn how to transform large spreadsheets into meaningful reports and interactive dashboards without using complex formulas.
\n\nParticipants will work with real-world datasets to build reports\, filter information\, calculate totals\, identify trends\, and create professional visual summaries.
\n\nTopics Covered
\n\nIntroduction to PivotTables
\n\n\n - Understanding structured data
\n - Preparing data for PivotTables
\n - Creating a PivotTable
\n - PivotTable layout and terminology
\n
\n\nWorking with Data
\n\n\n - Sorting and filtering
\n - Grouping dates\, numbers\, and categories
\n - Using report filters
\n - Managing large datasets
\n
\n\nCalculations and Analysis
\n\n\n - Sum\, Average\, Count\, Min\, Max
\n - Calculated fields
\n - Percentage calculations
\n - Running totals and comparisons
\n
\n\nPivotTable Design &\; Formatting
\n\n\n - Custom layouts
\n - Number formatting
\n - Conditional formatting
\n - Refreshing and updating data
\n
\n\nPivotCharts and Visualization
\n\n\n - Creating PivotCharts
\n - Interactive filtering with slicers and timelines
\n - Dashboard basics
\n
\n\nLearning Outcomes:
\n\nBy the end of the course\, participants will be able to:
\n\n\n - Build PivotTables from raw data
\n - Analyze trends and summarize information quickly
\n - Create interactive reports and charts
\n - Use slicers and filters effectively
\n
\n
LOCATION:Venue Online
UID:e.2857.2797
SEQUENCE:3
DTSTAMP:20260917T225103Z
URL:https://business.shccnj.org/events/details/beginner-pivot-tables-training-virtual-2797
END:VEVENT
END:VCALENDAR