BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//NJMEP - ECPv6.16.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:NJMEP
X-ORIGINAL-URL:https://www.njmep.org
X-WR-CALDESC:Events for NJMEP
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20260721T083000
DTEND;TZID=America/New_York:20260721T170000
DTSTAMP:20260531T184625
CREATED:20260519T194002Z
LAST-MODIFIED:20260519T194002Z
UID:90605-1784622600-1784653200@www.njmep.org
SUMMARY:Food Safety - FSPCA Preventive Controls for Human Food Version 2.0 Course - North
DESCRIPTION:7/21\, 7/23\, 7/24\nAbout Course: \n\n\n\n\n\nFSPCA Preventive Controls for Human Food Version 2.0 Course\nThe FSPCA (Food Safety Preventive Controls Alliance) Preventive Controls for Human Food (PCHF) Version 2.0 training course is an updated curriculum designed to train individuals as Preventive Controls Qualified Individuals (PCQI). It’s recognized by the FDA and covers the latest regulations and advancements in food safety. This training equips individuals with the knowledge and skills needed to develop and implement food safety plans\, manage hazards\, and ensure compliance with FSMA requirements. \nBy the end of the training course\, participants will be able to oversee or perform the following: \n\nCreating a Preventive Controls Food Safety Plan\nValidating preventive controls\nReviewing records for implementation and effectiveness\nReviewing corrective actions\nPerforming required re-analysis of the Food Safety Plan\n\nThe course is designed for: \n\nManagers\nOwners\nOperators\nQuality Control Personnel\nFood Safety Personnel\n\nCourse Length – 20 Hours
URL:https://www.njmep.org/calendar-event/food-safety-fspca-preventive-controls-for-human-food-version-2-0-course-north/
LOCATION:NJMEP North 2 Ridgedale Ave\, Suite 305\, Cedar Knolls\, NJ 07927\, 2 Ridgedale Ave\, Cedar Knolls\, NJ\, 07927\, United States
ATTACH;FMTTYPE=image/jpeg:https://www.njmep.org/wp-content/uploads/2023/03/Food_Safety_PCQI_2023.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20260721T123000
DTEND;TZID=America/New_York:20260721T163000
DTSTAMP:20260531T184625
CREATED:20260527T145919Z
LAST-MODIFIED:20260527T150217Z
UID:90916-1784637000-1784651400@www.njmep.org
SUMMARY:Beginner Pivot Tables Training  - Virtual
DESCRIPTION:7/21\, 7/22/26\nThis hands-on course teaches participants how to organize\, summarize\, analyze\, and present data using Microsoft Excel PivotTables and PivotCharts. \nStudents will learn how to transform large spreadsheets into meaningful reports and interactive dashboards without using complex formulas. \nParticipants will work with real-world datasets to build reports\, filter information\, calculate totals\, identify trends\, and create professional visual summaries. \nTopics Covered \nIntroduction to PivotTables \n\nUnderstanding structured data\nPreparing data for PivotTables\nCreating a PivotTable\nPivotTable layout and terminology\n\nWorking with Data \n\nSorting and filtering\nGrouping dates\, numbers\, and categories\nUsing report filters\nManaging large datasets\n\nCalculations and Analysis \n\nSum\, Average\, Count\, Min\, Max\nCalculated fields\nPercentage calculations\nRunning totals and comparisons\n\nPivotTable Design & Formatting \n\nCustom layouts\nNumber formatting\nConditional formatting\nRefreshing and updating data\n\nPivotCharts and Visualization \n\nCreating PivotCharts\nInteractive filtering with slicers and timelines\nDashboard basics\n\nLearning Outcomes: \nBy the end of the course\, participants will be able to: \n\nBuild PivotTables from raw data\nAnalyze trends and summarize information quickly\nCreate interactive reports and charts\nUse slicers and filters effectively
URL:https://www.njmep.org/calendar-event/beginner-pivot-tables-training-virtual/
LOCATION:Online
END:VEVENT
END:VCALENDAR