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:20240910T093000
DTEND;TZID=UTC:20240910T163000
DTSTAMP:20261022T232635
CREATED:20231127T162429Z
LAST-MODIFIED:20231127T162429Z
UID:10004048-1725960600-1725985800@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\nformatting\, 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-9/2024-09-10/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
END:VCALENDAR