BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Pitman Training Courses Scotland - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Pitman Training Courses Scotland
X-ORIGINAL-URL:https://pitmantrainingscotland.co.uk
X-WR-CALDESC:Events for Pitman Training Courses Scotland
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20241016T093000
DTEND;TZID=UTC:20241016T123000
DTSTAMP:20261019T214813
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004093-1729071000-1729081800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze\, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. \nWhat you will learn: \n\nMacros – Editing and deleting macros\, recording macros\, customizing ribbon.\nReview Data – track changes\, auditing tools\, watch window\, review changes\, restricting data area.\nUtilities – Goal seek\, data consolidation\, power view reports\, create scenarios\, What -If analysis\, drawing diagrams\, recommended pivot tables.\nAdditional – IfAnd/IfOr formula\, IfNa formula\, Convert to table\, screenshots\, removing duplicates\, filter timeline\, IfError\, HLookups\, Sparklines\, Pivot tables\, flash fill.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-11/2024-10-16/
LOCATION:Virtual Classroom
CATEGORIES:Excel Advanced,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241017T093000
DTEND;TZID=UTC:20241017T123000
DTSTAMP:20261019T214813
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004094-1729157400-1729168200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze\, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. \nWhat you will learn: \n\nMacros – Editing and deleting macros\, recording macros\, customizing ribbon.\nReview Data – track changes\, auditing tools\, watch window\, review changes\, restricting data area.\nUtilities – Goal seek\, data consolidation\, power view reports\, create scenarios\, What -If analysis\, drawing diagrams\, recommended pivot tables.\nAdditional – IfAnd/IfOr formula\, IfNa formula\, Convert to table\, screenshots\, removing duplicates\, filter timeline\, IfError\, HLookups\, Sparklines\, Pivot tables\, flash fill.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-11/2024-10-17/
LOCATION:Virtual Classroom
CATEGORIES:Excel Advanced,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR