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:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20231029T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20240331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20241027T010000
END:STANDARD
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:20250417
DTEND;VALUE=DATE:20250418
DTSTAMP:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063050
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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:20260924T063051
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
BEGIN:VEVENT
DTSTART;TZID=UTC:20240425T133000
DTEND;TZID=UTC:20240425T163000
DTSTAMP:20260924T063051
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004090-1714051800-1714062600@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-04-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;TZID=UTC:20240424T133000
DTEND;TZID=UTC:20240424T163000
DTSTAMP:20260924T063051
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004089-1713965400-1713976200@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-04-24/
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:20240319T093000
DTEND;TZID=UTC:20240319T163000
DTSTAMP:20260924T063051
CREATED:20231127T164013Z
LAST-MODIFIED:20231127T164013Z
UID:10004078-1710840600-1710865800@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-03-19/
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:20240227T093000
DTEND;TZID=UTC:20240227T123000
DTSTAMP:20260924T063051
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004088-1709026200-1709037000@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-02-27/
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:20240226T093000
DTEND;TZID=UTC:20240226T123000
DTSTAMP:20260924T063051
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004087-1708939800-1708950600@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-02-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;TZID=UTC:20240207T093000
DTEND;TZID=UTC:20240207T163000
DTSTAMP:20260924T063051
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004082-1707298200-1707323400@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-02-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;TZID=UTC:20240129T093000
DTEND;TZID=UTC:20240129T163000
DTSTAMP:20260924T063051
CREATED:20231127T164013Z
LAST-MODIFIED:20231127T164013Z
UID:10004077-1706520600-1706545800@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-01-29/
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:20231213
DTEND;VALUE=DATE:20231214
DTSTAMP:20260924T063051
CREATED:20230511T073905Z
LAST-MODIFIED:20230701T183826Z
UID:10000874-1702454400-1702486800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:The Microsoft Excel Advanced training course is available at the Edinburgh Pitman Training Centre. \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 data. These tools are extremely useful for auditing and streamlining your workflow. \n\n\n\n\nIn this course you will learn how to create\, convert and share documents through the universal Acrobat PDF format to produce interactive\, media rich and secure publications for Print or Web. \nThis course is designed for people who are collating documents with multiple contributors or publishing to a variety of mediums.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-7-2/2023-12-13/
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:20231107
DTEND;VALUE=DATE:20231108
DTSTAMP:20260924T063051
CREATED:20230511T072115Z
LAST-MODIFIED:20230701T183829Z
UID:10001023-1699344000-1699376400@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
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\n\n\n\nWhat you will learn: \nMacros \n\nEditing & Deleting Macros\nRecord Macros\nCustomising Ribbon\n\nReview Data \n\nTrack Changes\nAuditing Tools\nWatch Window Review\nChanges Restricting\nData Area\n\nUtilities \n\nGoal Seek\nData Consolidation\nPower View Reports\nCreate Scenarios\nWhat – If Analysis\nDrawing Diagrams Recommended Pivot Tables\n\n\n\nAdditional Items \n\nIfAnd/IfOr FormulaIfNa Formula\nConvert to Table Screenshots\nRemoving Duplicates Filter Timeline\nIfError\, HLookups\, Sparklines\, Pivot Tables\, Flash Fill\n\n\n\n\n\nTel 0131 556 5650 \n\n\nTel 0141 223 0090 \n\n\n\n\nDuration: 1 Day \n\n\n\n\nWe now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-8-2/2023-11-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:20230907
DTEND;VALUE=DATE:20230908
DTSTAMP:20260924T063051
CREATED:20230511T073905Z
LAST-MODIFIED:20230701T183826Z
UID:10000873-1694073600-1694106000@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:The Microsoft Excel Advanced training course is available at the Edinburgh Pitman Training Centre. \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 data. These tools are extremely useful for auditing and streamlining your workflow. \n\n\n\n\nIn this course you will learn how to create\, convert and share documents through the universal Acrobat PDF format to produce interactive\, media rich and secure publications for Print or Web. \nThis course is designed for people who are collating documents with multiple contributors or publishing to a variety of mediums.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-7-2/2023-09-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
END:VCALENDAR