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:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251125
DTEND;VALUE=DATE:20251126
DTSTAMP:20260802T062912
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004454-1764063000-1764090000@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-11-25/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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;VALUE=DATE:20251007
DTEND;VALUE=DATE:20251008
DTSTAMP:20260802T062912
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004461-1759829400-1759856400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2/2025-10-07/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250903
DTEND;VALUE=DATE:20250904
DTSTAMP:20260802T062912
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004453-1756891800-1756918800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-09-03/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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;VALUE=DATE:20250828
DTEND;VALUE=DATE:20250829
DTSTAMP:20260802T062912
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004460-1756373400-1756400400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2/2025-08-28/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20250825T093000
DTEND;TZID=Europe/London:20250826T120000
DTSTAMP:20260802T062912
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004466-1756114200-1756209600@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-3/2025-08-25/
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;VALUE=DATE:20250728
DTEND;VALUE=DATE:20250729
DTSTAMP:20260802T062912
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004452-1753695000-1753722000@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-07-28/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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=Europe/London:20250626T093000
DTEND;TZID=Europe/London:20250627T120000
DTSTAMP:20260802T062912
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004465-1750930200-1751025600@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-3/2025-06-26/
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;VALUE=DATE:20250611
DTEND;VALUE=DATE:20250612
DTSTAMP:20260802T062912
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004459-1749634200-1749661200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2/2025-06-11/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250507
DTEND;VALUE=DATE:20250508
DTSTAMP:20260802T062912
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004451-1746610200-1746637200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-05-07/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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=Europe/London:20250429T090000
DTEND;TZID=Europe/London:20250430T120000
DTSTAMP:20260802T062912
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004464-1745917200-1746014400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-3/2025-04-29/
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;VALUE=DATE:20250417
DTEND;VALUE=DATE:20250418
DTSTAMP:20260802T062913
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004458-1744882200-1744909200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2/2025-04-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250327
DTEND;VALUE=DATE:20250328
DTSTAMP:20260802T062913
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004450-1743067800-1743094800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-03-27/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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;VALUE=DATE:20250227
DTEND;VALUE=DATE:20250228
DTSTAMP:20260802T062913
CREATED:20241119T141356Z
LAST-MODIFIED:20241119T141356Z
UID:10004457-1740614400-1740700799@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2-2/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250220
DTEND;VALUE=DATE:20250221
DTSTAMP:20260802T062913
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004449-1740043800-1740070800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-02-20/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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=Europe/London:20250129T093000
DTEND;TZID=Europe/London:20250130T120000
DTSTAMP:20260802T062913
CREATED:20241028T171125Z
LAST-MODIFIED:20241029T134809Z
UID:10004463-1738143000-1738238400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-3/2025-01-29/
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;VALUE=DATE:20250128
DTEND;VALUE=DATE:20250129
DTSTAMP:20260802T062913
CREATED:20241028T170558Z
LAST-MODIFIED:20250819T121819Z
UID:10004448-1738022400-1738108799@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led/2025-01-28/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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;VALUE=DATE:20250122
DTEND;VALUE=DATE:20250123
DTSTAMP:20260802T062913
CREATED:20241028T170839Z
LAST-MODIFIED:20250819T121551Z
UID:10004456-1737504000-1737590399@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred. \nFor individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse\, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow. \n  \nWhat you will learn: \n\n\n\nMacros\nAdditional Items\n\n\nEditing & Deleting Macros\nIfAnd/ IfOr Formula\n\n\nRecording Macros\nIfNa Formula\n\n\nCustom Ribbon\nConvert to Table\n\n\n\nScreenshots\n\n\nReview Data\nRemoving Duplicates\n\n\nTracking Changes\nFilter Timeline\n\n\nAuditing Tools\nIfError\n\n\nWatch Window\nHLookups\n\n\nRestricting Data Area\nSparklines\n\n\n\nPivot Tables\n\n\nUtilities\nFlash Fill\n\n\nGoal Seek\n\n\n\nData Consolidation\n\n\n\nPower View Reports\n\n\n\nCreate Senarios\n\n\n\nWhat – If Analysis\n\n\n\nDrawing Diagrams\n\n\n\nRecommended Pivot Tables\n\n\n\n\n\n\n\n\n  \n  \nDuration: 1 Day \nWe can deliver onsite at your workplace of via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-tutor-led-2/2025-01-22/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241213T123000
DTEND;TZID=UTC:20241213T163000
DTSTAMP:20260802T062913
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004096-1734093000-1734107400@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-12-13/
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:20241212T133000
DTEND;TZID=UTC:20241212T163000
DTSTAMP:20260802T062913
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004095-1734010200-1734021000@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-12-12/
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:20241211T093000
DTEND;TZID=UTC:20241211T163000
DTSTAMP:20260802T062913
CREATED:20231127T164013Z
LAST-MODIFIED:20231127T164013Z
UID:10004081-1733909400-1733934600@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 -Ifanalysis\, 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-9/2024-12-11/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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:20241106T093000
DTEND;TZID=UTC:20241106T163000
DTSTAMP:20260802T062913
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004086-1730885400-1730910600@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 -Ifanalysis\, 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-10/2024-11-06/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
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:20260802T062913
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
BEGIN:VEVENT
DTSTART;TZID=UTC:20241016T093000
DTEND;TZID=UTC:20241016T123000
DTSTAMP:20260802T062913
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:20240905T093000
DTEND;TZID=UTC:20240905T163000
DTSTAMP:20260802T062913
CREATED:20231127T164013Z
LAST-MODIFIED:20231127T164013Z
UID:10004080-1725528600-1725553800@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 -Ifanalysis\, 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-9/2024-09-05/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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:20240801T093000
DTEND;TZID=UTC:20240801T163000
DTSTAMP:20260802T062913
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004085-1722504600-1722529800@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 -Ifanalysis\, 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-10/2024-08-01/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,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:20260802T062913
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
BEGIN:VEVENT
DTSTART;TZID=UTC:20240716T133000
DTEND;TZID=UTC:20240716T163000
DTSTAMP:20260802T062913
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004091-1721136600-1721147400@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-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:20240612T093000
DTEND;TZID=UTC:20240612T163000
DTSTAMP:20260802T062913
CREATED:20231127T164013Z
LAST-MODIFIED:20231127T164013Z
UID:10004079-1718184600-1718209800@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 -Ifanalysis\, 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-9/2024-06-12/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Advanced,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:20240604T093000
DTEND;TZID=UTC:20240604T163000
DTSTAMP:20260802T062913
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004084-1717493400-1717518600@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 -Ifanalysis\, 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-10/2024-06-04/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20240514T093000
DTEND;TZID=UTC:20240514T163000
DTSTAMP:20260802T062913
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004083-1715679000-1715704200@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 -Ifanalysis\, 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-10/2024-05-14/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR