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
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20261025T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260709
DTEND;VALUE=DATE:20260710
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004864-1783589400-1783616400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-07-09/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260707
DTEND;VALUE=DATE:20260708
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004877-1783416600-1783443600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-07-07/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260616
DTEND;VALUE=DATE:20260617
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004876-1781602200-1781629200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-06-16/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260603
DTEND;VALUE=DATE:20260604
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004863-1780479000-1780506000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-06-03/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260514
DTEND;VALUE=DATE:20260515
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004875-1778751000-1778778000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-05-14/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260506
DTEND;VALUE=DATE:20260507
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004862-1778059800-1778086800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-05-06/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260428
DTEND;VALUE=DATE:20260429
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004861-1777368600-1777395600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-04-28/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260408
DTEND;VALUE=DATE:20260409
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004874-1775640600-1775667600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-04-08/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260403
DTEND;VALUE=DATE:20260404
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004873-1775208600-1775235600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-04-03/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260326
DTEND;VALUE=DATE:20260327
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004872-1774517400-1774544400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-03-26/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260317
DTEND;VALUE=DATE:20260318
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004860-1773739800-1773766800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-03-17/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260218
DTEND;VALUE=DATE:20260219
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004859-1771407000-1771434000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-02-18/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260203
DTEND;VALUE=DATE:20260204
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004871-1770111000-1770138000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-02-03/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260120
DTEND;VALUE=DATE:20260121
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004858-1768901400-1768928400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2026-01-20/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260113
DTEND;VALUE=DATE:20260114
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004870-1768296600-1768323600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2026-01-13/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251203
DTEND;VALUE=DATE:20251204
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004430-1764752400-1764781200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2025-12-03/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251202
DTEND;VALUE=DATE:20251203
DTSTAMP:20260802T062335
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004442-1764666000-1764694800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2/2025-12-02/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251202
DTEND;VALUE=DATE:20251203
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004791-1764662400-1764694800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2025-12-02/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251127
DTEND;VALUE=DATE:20251128
DTSTAMP:20260802T062335
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004441-1764234000-1764262800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2/2025-11-27/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251127
DTEND;VALUE=DATE:20251128
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004790-1764230400-1764262800@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2025-11-27/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251111
DTEND;VALUE=DATE:20251112
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004429-1762851600-1762880400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2025-11-11/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251106T090000
DTEND;TZID=Europe/London:20251107T000000
DTSTAMP:20260802T062335
CREATED:20241028T170300Z
LAST-MODIFIED:20241029T134937Z
UID:10004447-1762419600-1762473600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-3/2025-11-06/
LOCATION:Virtual Classroom
CATEGORIES:Excel Intermediate,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:20251016
DTEND;VALUE=DATE:20251017
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004428-1760605200-1760634000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2025-10-16/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251014
DTEND;VALUE=DATE:20251015
DTSTAMP:20260802T062335
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004440-1760432400-1760461200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2/2025-10-14/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20251014
DTEND;VALUE=DATE:20251015
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004789-1760428800-1760461200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2025-10-14/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250924
DTEND;VALUE=DATE:20250925
DTSTAMP:20260802T062335
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004439-1758704400-1758733200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2/2025-09-24/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250924
DTEND;VALUE=DATE:20250925
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004788-1758700800-1758733200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2025-09-24/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250910
DTEND;VALUE=DATE:20250911
DTSTAMP:20260802T062335
CREATED:20241028T165544Z
LAST-MODIFIED:20250819T121330Z
UID:10004427-1757494800-1757523600@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led/2025-09-10/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250820
DTEND;VALUE=DATE:20250821
DTSTAMP:20260802T062335
CREATED:20241028T165948Z
LAST-MODIFIED:20241029T135054Z
UID:10004438-1755680400-1755709200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2/2025-08-20/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250820
DTEND;VALUE=DATE:20250821
DTSTAMP:20260802T062335
CREATED:20250108T112212Z
LAST-MODIFIED:20250819T120957Z
UID:10004787-1755676800-1755709200@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate – Tutor Led
DESCRIPTION:Duration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred. \nFor individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package. \n  \nWhat you will learn: \n\n\n\nManaging Multiple Spreadsheets\nUsing Charts\n\n\n·      Using Multiple Worksheets\n·      Chart Objects\n\n\n·      Creating Multiple Views\n·      Creating a Chart\n\n\n·      Managing Multiple Worksheets and Workbooks\n·      Change the Location of a Chart \n·      Changing Chart Type\, Style and Sub Type\n\n\n·      Linking Data Between Worksheets\n·      Changes to Chart Source Data\n\n\n·      Viewing Multiple Applications\n·      Chart Quick Menus \n·      Creating a Chart Template\n\n\n\n\n\n\nProtection\nData Validation\n\n\n·      Workbook protection\n·      Adding Data Validation\n\n\n·      Worksheet protection\n·      Data Validation Messages\n\n\n\n·      Restrict Data Entry \n·      Data Validation Calculations\n\n\n Conditional Formatting\n\n\n\n·      Adding Conditional Formatting \n·      Remove Conditional Formatting \n·      Colour Scales \n·      Highlight Blank Scales \n·      Icon Sets \n·      Data Bars \n·      Conditional Formatting Formulas\nFilter and Sort \n·      Sorting a List \n·      Filtering a List \n·      AutoFilters \n·      Customer Auto Filters \n·      Using Subtotals in a List \n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nCreating and Using Functions \n·      Using Built in Functions \n·      Using Nested Functions \n·      AUTOSUM \n·      COUNT Functions \n·      IF Functions \n·      Using Date and Time Functions \n·      Combine and Separating Text \n·      Tracing and Correcting Worksheet Errors\nLookUps \n·      VLookUp \n·      HLookUp \n·      XLookUp \n  \nPivot Tables \n·      Creating a Pivot Table \n·      Conditional Formatting within Pivot Tables \n·      Pivot Table Slicers \n·      Creating a Pivot Chart\n\n\n\n  \n  \n  \n  \n  \nDuration: 1 Day \nWe can deliver training onsite at your workplace or via virtual classrooms if preferred.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-tutor-led-2-2/2025-08-20/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Intermediate,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR