BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//PYVOBJECT//NONSGML Version 1//EN
BEGIN:VTIMEZONE
TZID:Pacific/Auckland
BEGIN:STANDARD
DTSTART:20000319T030000
RRULE:FREQ=YEARLY;BYDAY=3SU;BYMONTH=3;UNTIL=20070317T140000Z
TZNAME:NZST
TZOFFSETFROM:+1300
TZOFFSETTO:+1200
END:STANDARD
BEGIN:STANDARD
DTSTART:20080406T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4
TZNAME:NZST
TZOFFSETFROM:+1300
TZOFFSETTO:+1200
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20001001T020000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=10;UNTIL=20060930T140000Z
TZNAME:NZDT
TZOFFSETFROM:+1200
TZOFFSETTO:+1300
END:DAYLIGHT
BEGIN:DAYLIGHT
DTSTART:20070930T020000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=9
TZNAME:NZDT
TZOFFSETFROM:+1200
TZOFFSETTO:+1300
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:20260727T081812Z - 19169@au27a.odoo.com
DTSTART;TZID=Pacific/Auckland:20250218T140000
DTEND;TZID=Pacific/Auckland:20250218T163000
CREATED:20260727T081812Z
DESCRIPTION:<a href="https://www.knowitinc.com/event/excel-lists-and-pivott
 ables-11">Excel - Lists and PivotTables</a>\n🇳🇿 Timezone: New Zealan
 d Date: 18 February 2025​ Time: 2:00 pm to 4:30 pm World Time Buddy allo
 ws you to quickly convert times across​ timezones to see if you can join
  this live online session from anywhere.​ Then learn to transfer your da
 ta collection into data analysis by converting your lists into PivotTables
  and PivotCharts. Prerequisites Participants are expected to have a basic 
 understanding of Excel and its core functionalities or have attended the E
 xcel Calculation Basic training. Familiarity with basic calculations\, spr
 eadsheet navigation\, data entry\, and basic formatting will be beneficial
 . This course is designed for users of all levels\, making it suitable for
  beginners eager to learn\, or long time Excel users looking to work bette
 r with their lists of information and grasp how to create PivotTables and 
 PivotCharts. Topics Duration: Approx. 2.5 hours ListsWhat is a List?Lists 
 Creation RulesSort Data in ListsFilter Data in ListsAdd Subtotals to Data 
 in ListsApply Conditional FormattingWhy and when to use the Format Table f
 eatureHow and when to unFormat as Table PivotTablesWhat is a PivotTable an
 d when to use themCreate a PivotTableFilter a PivotTableModify a PivotTabl
 eRefresh a PivotTableChange a PivotTable’s Data SourcePivotTable Format 
 OptionsInsert and Format PivotTable SlicersLink Slicers to Multiple PivotT
 ablesCreate a PivotChart Don't miss out - boost your Microsoft Excel skill
 s today! Location Online Live with a trainer Date and Time ( New Zealand 
 🇳🇿 time) 18 February 2025 2:00 pm 4:30 pm With World Time Buddy\, yo
 u can easily convert times across different timezones\, helping you determ
 ine if you can join this live online session from anywhere in the world. D
 uration Approx 2.5 Hours Session may end sooner or later depending on vari
 ous factors in the session like interactions\, questions\, pacing of the a
 ttendees\, etc. Price in New Zealand Dollars [...]
DTSTAMP:20260727T081812Z
LOCATION:NEW ZEALAND 🇳🇿 Online (Live)
SUMMARY:Excel - Lists and PivotTables
X-ALT-DESC;FMTTYPE=text/html:<a href="https://www.knowitinc.com/event/excel
 -lists-and-pivottables-11">Excel - Lists and PivotTables</a>\n🇳🇿 Tim
 ezone: New Zealand Date: 18 February 2025​ Time: 2:00 pm to 4:30 pm Worl
 d Time Buddy allows you to quickly convert times across​ timezones to se
 e if you can join this live online session from anywhere.​ Then learn to
  transfer your data collection into data analysis by converting your lists
  into PivotTables and PivotCharts. Prerequisites Participants are expected
  to have a basic understanding of Excel and its core functionalities or ha
 ve attended the Excel Calculation Basic training. Familiarity with basic c
 alculations\, spreadsheet navigation\, data entry\, and basic formatting w
 ill be beneficial. This course is designed for users of all levels\, makin
 g it suitable for beginners eager to learn\, or long time Excel users look
 ing to work better with their lists of information and grasp how to create
  PivotTables and PivotCharts. Topics Duration: Approx. 2.5 hours ListsWhat
  is a List?Lists Creation RulesSort Data in ListsFilter Data in ListsAdd S
 ubtotals to Data in ListsApply Conditional FormattingWhy and when to use t
 he Format Table featureHow and when to unFormat as Table PivotTablesWhat i
 s a PivotTable and when to use themCreate a PivotTableFilter a PivotTableM
 odify a PivotTableRefresh a PivotTableChange a PivotTable’s Data SourceP
 ivotTable Format OptionsInsert and Format PivotTable SlicersLink Slicers t
 o Multiple PivotTablesCreate a PivotChart Don't miss out - boost your Micr
 osoft Excel skills today! Location Online Live with a trainer Date and Tim
 e ( New Zealand 🇳🇿 time) 18 February 2025 2:00 pm 4:30 pm With World
  Time Buddy\, you can easily convert times across different timezones\, he
 lping you determine if you can join this live online session from anywhere
  in the world. Duration Approx 2.5 Hours Session may end sooner or later d
 epending on various factors in the session like interactions\, questions\,
  pacing of the attendees\, etc. Price in New Zealand Dollars [...]
END:VEVENT
END:VCALENDAR