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:20240717T093000
DTEND;TZID=UTC:20240717T163000
DTSTAMP:20261021T073828
CREATED:20231127T162429Z
LAST-MODIFIED:20231127T162429Z
UID:10004046-1721208600-1721233800@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-07-17/
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
BEGIN:VEVENT
DTSTART;TZID=UTC:20240717T093000
DTEND;TZID=UTC:20240717T163000
DTSTAMP:20261021T073828
CREATED:20231128T101106Z
LAST-MODIFIED:20231128T101106Z
UID:10004234-1721208600-1721233800@pitmantrainingscotland.co.uk
SUMMARY:Better Business Writing
DESCRIPTION:In this course we will look at what business writing is\, how to do it and how to do it well. Although business writing can seem a little overwhelming to begin with\, it can be relatively easy to learn – once you understand the basics of what is required. \nWhat you will learn: \n\nIntroduction – why it’s important and the benefits of good business writing\, back to basics with grammar\, punctuation\, and spelling.\nWriting with impact – be clear\, write less\, active verbs\, setting the tone\, using positive versus negative language\, condescension\, cliches and jargon\, writing with your reader in mind\, non- sexist language.\nStructure and style – knowing your audience and knowing your purpose.
URL:https://pitmantrainingscotland.co.uk/event/better-business-writing-10/2024-07-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Better Business Writing,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20240717T133000
DTEND;TZID=UTC:20240717T163000
DTSTAMP:20261021T073828
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004092-1721223000-1721233800@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-07-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