BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//PYVOBJECT//NONSGML Version 1//EN
BEGIN:VTIMEZONE
TZID:Australia/Melbourne
BEGIN:STANDARD
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3;UNTIL=20050326T160000Z
TZNAME:AEST
TZOFFSETFROM:+1100
TZOFFSETTO:+1000
END:STANDARD
BEGIN:STANDARD
DTSTART:20060402T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4;UNTIL=20060401T160000Z
TZNAME:AEST
TZOFFSETFROM:+1100
TZOFFSETTO:+1000
END:STANDARD
BEGIN:STANDARD
DTSTART:20070325T030000
RRULE:FREQ=YEARLY;BYDAY=4SU;BYMONTH=3;UNTIL=20070324T160000Z
TZNAME:AEST
TZOFFSETFROM:+1100
TZOFFSETTO:+1000
END:STANDARD
BEGIN:STANDARD
DTSTART:20080406T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4
TZNAME:AEST
TZOFFSETFROM:+1100
TZOFFSETTO:+1000
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000827T020000
RRULE:FREQ=YEARLY;BYDAY=4SU;BYMONTH=8;UNTIL=20000826T160000Z
TZNAME:AEDT
TZOFFSETFROM:+1000
TZOFFSETTO:+1100
END:DAYLIGHT
BEGIN:DAYLIGHT
DTSTART:20011028T020000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=20071027T160000Z
TZNAME:AEDT
TZOFFSETFROM:+1000
TZOFFSETTO:+1100
END:DAYLIGHT
BEGIN:DAYLIGHT
DTSTART:20081005T020000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=10
TZNAME:AEDT
TZOFFSETFROM:+1000
TZOFFSETTO:+1100
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:20260526T061125Z - 58135@au27a.odoo.com
DTSTART;TZID=Australia/Melbourne:20250417T090000
DTEND;TZID=Australia/Melbourne:20250417T113000
CREATED:20260526T061125Z
DESCRIPTION:<a href="https://www.knowitinc.com/event/excel-lists-and-pivott
 ables-80">Excel - Lists and PivotTables</a>\nThen learn to transfer your d
 ata collection into data analysis by converting your lists into PivotTable
 s and PivotCharts. Prerequisites Participants are expected to have a basic
  understanding of Excel and its core functionalities or have attended the 
 Excel Calculation Basic training. Familiarity with basic calculations\, sp
 readsheet navigation\, data entry\, and basic formatting will be beneficia
 l. This course is designed for users of all levels\, making it suitable fo
 r beginners eager to learn\, or long time Excel users looking to work bett
 er with their lists of information and grasp how to create PivotTables and
  PivotCharts. Location Online Live with a trainer Duration Approx 2.5 Hour
 s Session may end sooner or later depending on various factors in the sess
 ion like interactions\, questions\, pacing of the attendees\, etc. Topics 
 Duration: Approx. 2.5 hours ListsWhat is a List?Lists Creation RulesSort D
 ata in ListsFilter Data in ListsAdd Subtotals to Data in ListsApply Condit
 ional FormattingWhy and when to use the Format Table featureHow and when t
 o unFormat as Table PivotTablesWhat is a PivotTable and when to use themCr
 eate a PivotTableFilter a PivotTableModify a PivotTableRefresh a PivotTabl
 eChange a PivotTable’s Data SourcePivotTable Format OptionsInsert and Fo
 rmat PivotTable SlicersLink Slicers to Multiple PivotTablesCreate a PivotC
 hart Don't miss out - boost your Microsoft Excel skills today! Price in Ne
 w Zealand Dollars Only $250 per person + 15% GST = $287.50 Early Bird Seat
  = $200 per person + 15% GST = $230 Share Share this outline with others t
 o spread the word! This is an online training session open to the public. 
 Contact us if you would like to arrange this as a private online training 
 session for your team instead\, or for it to conducted in-person at your l
 ocation. Contact us
DTSTAMP:20260526T061125Z
LOCATION:Online (Live)
SUMMARY:Excel - Lists and PivotTables
X-ALT-DESC;FMTTYPE=text/html:<a href="https://www.knowitinc.com/event/excel
 -lists-and-pivottables-80">Excel - Lists and PivotTables</a>\nThen learn t
 o transfer your data collection into data analysis by converting your list
 s into PivotTables and PivotCharts. Prerequisites Participants are expecte
 d to have a basic understanding of Excel and its core functionalities or h
 ave attended the Excel Calculation Basic training. Familiarity with basic 
 calculations\, spreadsheet navigation\, data entry\, and basic formatting 
 will be beneficial. This course is designed for users of all levels\, maki
 ng it suitable for beginners eager to learn\, or long time Excel users loo
 king to work better with their lists of information and grasp how to creat
 e PivotTables and PivotCharts. Location Online Live with a trainer Duratio
 n Approx 2.5 Hours Session may end sooner or later depending on various fa
 ctors in the session like interactions\, questions\, pacing of the attende
 es\, etc. Topics Duration: Approx. 2.5 hours ListsWhat is a List?Lists Cre
 ation RulesSort Data in ListsFilter Data in ListsAdd Subtotals to Data in 
 ListsApply Conditional FormattingWhy and when to use the Format Table feat
 ureHow and when to unFormat as Table PivotTablesWhat is a PivotTable and w
 hen to use themCreate a PivotTableFilter a PivotTableModify a PivotTableRe
 fresh a PivotTableChange a PivotTable’s Data SourcePivotTable Format Opt
 ionsInsert and Format PivotTable SlicersLink Slicers to Multiple PivotTabl
 esCreate a PivotChart Don't miss out - boost your Microsoft Excel skills t
 oday! Price in New Zealand Dollars Only $250 per person + 15% GST = $287.5
 0 Early Bird Seat = $200 per person + 15% GST = $230 Share Share this outl
 ine with others to spread the word! This is an online training session ope
 n to the public. Contact us if you would like to arrange this as a private
  online training session for your team instead\, or for it to conducted in
 -person at your location. Contact us
END:VEVENT
END:VCALENDAR