BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Pitman Training Courses Scotland - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20240531T093000
DTEND;TZID=UTC:20240531T163000
DTSTAMP:20261022T201417
CREATED:20231127T162833Z
LAST-MODIFIED:20231127T163108Z
UID:10004057-1717147800-1717173000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate
DESCRIPTION:For individuals who are already using Excel\, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. \nWhat you will learn: \n\nFormula – Vlookups\, IF Statements\, SumIf\, CountIf\, Text formula\, Concatenate\, linking spreadsheets.\nUtilities – Protecting data\, hide and unhide data\, named ranges\, working with dates\, comments\, data validation\, headers and footers.\nLinking Data – linking spreadsheets\, identifying links\, linking separate workbooks.\nData Analysis – Updating Pivot Tables\, filters\, subtotals\, icons and data bars in conditional formatting\, filter and sort using colour.\nPivot Tables – creating Pivot Tables\, Pivot Charts\, Slicers\, refreshing data\, updating ranges.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-10/2024-05-31/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR