BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Pitman Training Courses Scotland - ECPv6.8.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Pitman Training Courses Scotland
X-ORIGINAL-URL:https://pitmantrainingscotland.co.uk
X-WR-CALDESC:Events for Pitman Training Courses Scotland
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20240201T093000
DTEND;TZID=UTC:20240201T163000
DTSTAMP:20261024T222147
CREATED:20231128T125439Z
LAST-MODIFIED:20231128T125451Z
UID:10004355-1706779800-1706805000@pitmantrainingscotland.co.uk
SUMMARY:Telephone Techniques
DESCRIPTION:This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important part of their job role. \n\n\n\n\nWhat you will learn: \n\nImproved communication skills\nThe importance of voice and attitude\nListening skills and questioning techniques.\nTo sound confident and helpful\nTo understand the caller’s needs\nTo handle awkward calls\nTo take messages\nTo hand over and re-route a call.\n\nThis course is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/telephone-techniques-12/2024-02-01/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Seminar Courses,Telephone Techniques
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:20240202T080000
DTEND;TZID=UTC:20240202T170000
DTSTAMP:20261024T222147
CREATED:20231128T100943Z
LAST-MODIFIED:20231128T100943Z
UID:10004227-1706860800-1706893200@pitmantrainingscotland.co.uk
SUMMARY:Better Business Writing
DESCRIPTION:In this course we will look at what business writing is\, how to do it and how to do it well. Although business writing can seem a little overwhelming to begin with\, it can be relatively easy to learn – once you understand the basics of what is required. \nWhat you will learn: \n\nIntroduction – why it’s important and the benefits of good business writing\, back to basics with grammar\, punctuation\, and spelling.\nWriting with impact – be clear\, write less\, active verbs\, setting the tone\, using positive versus negative language\, condescension\, cliches and jargon\, writing with your reader in mind\, non- sexist language.\nStructure and style – knowing your audience and knowing your purpose.
URL:https://pitmantrainingscotland.co.uk/event/better-business-writing-9/2024-02-02/1/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Better Business Writing,Edinburgh,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:20240202T093000
DTEND;TZID=UTC:20240202T163000
DTSTAMP:20261024T222147
CREATED:20231128T100943Z
LAST-MODIFIED:20231128T100943Z
UID:10004228-1706866200-1706891400@pitmantrainingscotland.co.uk
SUMMARY:Better Business Writing
DESCRIPTION:In this course we will look at what business writing is\, how to do it and how to do it well. Although business writing can seem a little overwhelming to begin with\, it can be relatively easy to learn – once you understand the basics of what is required. \nWhat you will learn: \n\nIntroduction – why it’s important and the benefits of good business writing\, back to basics with grammar\, punctuation\, and spelling.\nWriting with impact – be clear\, write less\, active verbs\, setting the tone\, using positive versus negative language\, condescension\, cliches and jargon\, writing with your reader in mind\, non- sexist language.\nStructure and style – knowing your audience and knowing your purpose.
URL:https://pitmantrainingscotland.co.uk/event/better-business-writing-9/2024-02-02/2/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Better Business Writing,Edinburgh,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:20240205T093000
DTEND;TZID=UTC:20240205T170000
DTSTAMP:20261024T222147
CREATED:20231127T161047Z
LAST-MODIFIED:20231127T161155Z
UID:10004017-1707125400-1707152400@pitmantrainingscotland.co.uk
SUMMARY:Excel Introduction
DESCRIPTION:For individuals who have never used spreadsheets or the Excel application before or only used Excel for limited tasks. At the end of the day\, you will be able to create professional-looking spreadsheets. \nWhat you will learn: \n\nAn Introduction to Excel – the ribbon bar\, enter move and clear data\, saving in Excel\, creating new workbooks\, cut copy and paste\, naming\, deleting\, and working with sheets.\nFormulas – introduction to basic formula\, order of operations\, add subtract multiply and divide\, auto sum and auto average\, percentages\, absolute cell referencing.\nData Manipulation – moving data\, sorting\, inserting rows and columns\, widening rows and columns\, deleting information.\nPrinting – print preview\, page layout\, headers and footers and print area.\nFormatting – formatting numbers\, formatting text\, borders\, and shading\, align data.\nUtilities – introduction to charts\, freeze panes\, introduction to conditional formatting\, autofill options.
URL:https://pitmantrainingscotland.co.uk/event/excel-introduction-9/2024-02-05/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Introduction,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:20240206T093000
DTEND;TZID=UTC:20240206T163000
DTSTAMP:20261024T222147
CREATED:20231127T162429Z
LAST-MODIFIED:20231127T162429Z
UID:10004041-1707211800-1707237000@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate
DESCRIPTION:For individuals who are already using Excel\, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. \nWhat you will learn: \n\nFormula – Vlookups\, IF Statements\, SumIf\, CountIf\, Text formula\, Concatenate\, linking spreadsheets.\nUtilities – Protecting data\, hide and unhide data\, named ranges\, working with dates\, comments\, data validation\, headers and footers.\nLinking Data – linking spreadsheets\, identifying links\, linking separate workbooks.\nData Analysis – Updating Pivot Tables\, filters\, subtotals\, icons and data bars in conditional\nformatting\, filter and sort using colour.\nPivot Tables – creating Pivot Tables\, Pivot Charts\, Slicers\, refreshing data\, updating ranges.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-9/2024-02-06/
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:20240206
DTEND;VALUE=DATE:20240207
DTSTAMP:20261024T222147
CREATED:20231127T155910Z
LAST-MODIFIED:20231127T160146Z
UID:10002213-1707213600-1707238800@pitmantrainingscotland.co.uk
SUMMARY:Adobe Photoshop
DESCRIPTION:For individuals who are new to Photoshop or have only used Photoshop for limited tasks. During the course you will learn the fundamentals of the Adobe Photoshop Creative Cloud from our certified Adobe Instructor. Classes are small group sessions guaranteeing time for practical training and questions and feedback from our tutor. \nWhat you will learn: \n\nDesign principles\, digital media theory (vector\, resolution\, raster)\, Photoshop interface\, workspace and navigation\, Photoshop preferences and colour settings\, rulers\, guides and grids\, resize and crop.\nColour and colour swatches\, enhancing through tonal and colour adjustments\, camera RAW\, adjustments layers.\nSelection tools and refining selections\, working with layers and layer masks\, layer blending modes and styles.\nDesign alignment\, transform and modify elements\, retouching\, styling and formatting text\, special characters.\nAdobe fonts\, resample resolution\, colour theory\, colour spaces (RGB\, CMYK)\, export session and file formats\, output and optimise work for digital print use.\n\n\n\n\n\n• Creative Cloud libraries\, hidden gems and shortcuts\, efficiency workflow. \nThis course is available on demand in our Glasgow & Edinburgh centres. Please contact us for more details.
URL:https://pitmantrainingscotland.co.uk/event/adobe-photoshop-2/2024-02-06/
CATEGORIES:Edinburgh,Glasgow,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:20261024T222147
CREATED:20231128T104208Z
LAST-MODIFIED:20231128T104209Z
UID:10004276-1707298200-1707323400@pitmantrainingscotland.co.uk
SUMMARY:Leadership Skills
DESCRIPTION:For managers who are developing into senior leaders. You are even less involved in the day-to-day delivery of the work; your success depends on your ability to manage your managers as well as mentor and inspire others. Your people skills need more finesse because there is more at stake; your emotional intelligence comes to the fore as people look to you to set the tone and the organizational culture. This course is going to show you the way of becoming an inspiring leader. \nWhat you will learn: \n\nIdentify the main types of leadership.\nIdentify the main characteristics of different theories of leadership – train\, transactions etc.\nDemonstrate an ability to apply different leadership styles and characteristics to different business situations.\nDemonstrate an understanding of the advantages and disadvantages of different leadership approaches to a problem.\n\n\n\n\n\n\nDevelop emotional intelligence skills.\nDemonstrate mentoring techniques.\nUnderstand the importance of starting with your ‘why’.\n\nThis course is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/leadership-skills-4/2024-02-07/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Leadership Skills,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:20240208T093000
DTEND;TZID=UTC:20240208T163000
DTSTAMP:20261024T222147
CREATED:20231127T173350Z
LAST-MODIFIED:20231127T173416Z
UID:10004141-1707384600-1707409800@pitmantrainingscotland.co.uk
SUMMARY:PowerPoint Introduction
DESCRIPTION:For Individuals who have never used PowerPoint or have only used it for limited tasks. At the end of the course\, you will be able to create professional-looking presentations. \nWhat you will learn: \n\nInitial screen and data entry – Introduction to the PowerPoint App\, inserting and selecting text\, moving\, and resizing objects\, adding new slides.\nBullet slides and pictures – entering bullet points\, multi-level bullets\, changing and deleting bullet points\, working with pictures\, grouping\, and ungrouping images.\nOrganisation – using organisation charts and tables\, basic tables\, and charts.\nFormatting – free text\, format test colours\, freehand drawings\, working with objects\, colouring objects\, backgrounds on slides.\nSlide master options – learning about master slides\, insert footers and page numbers\, using hyperlinks\, view slides and note pages\, slide orders.\nSlide shows – setting and running slide shows\, slide transitions\, animation effects\, printing presentations.
URL:https://pitmantrainingscotland.co.uk/event/powerpoint-introduction-9/2024-02-08/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Powerpoint Introduction,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:20240212
DTEND;VALUE=DATE:20240214
DTSTAMP:20261024T222147
CREATED:20231128T105746Z
LAST-MODIFIED:20231128T105746Z
UID:10004310-1707696000-1707868799@pitmantrainingscotland.co.uk
SUMMARY:Presentation Skills – 2-day workshop
DESCRIPTION:This 2-day course will help you hone your skills and give you the tools and space to practice delivering your message in a creative and confident manner. Classes are small and mainly experimental\, allowing the trainer to focus and coach whilst reflecting on your particular challenges and requirements. \nWhat you will learn: \n• To overcome the natural fear of speaking to an audience and use nervousness to your advantage. \n\n\n\n\n\nTo design a presentation that people remember.\nTo understand and gain the non-verbal skills all good speakers need.\nTo develop presence and confidence when speaking to a group.\nTo connect with your audience and make them listen.\nTo use pace to influence and impact listeners.\nTo deliver engaging and memorable presentations.\n\nThis course is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/presentation-skills-2-day-workshop/2024-02-12/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Presentation Skills,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:20240212
DTEND;VALUE=DATE:20240213
DTSTAMP:20261024T222147
CREATED:20231115T143810Z
LAST-MODIFIED:20231127T145226Z
UID:10002188-1707728400-1707757200@pitmantrainingscotland.co.uk
SUMMARY:Adobe Illustrator
DESCRIPTION:IT and Adobe Training Workshops \nAVAILABLE IN GLASGOW & EDINBURGH ON DEMAND – PLEASE CONTACT US FOR MORE DETAILS \nAdobe Illustrator \nFor Individuals who are new to illustrator or have only used Illustrator for limited tasks. During the course you will learn the fundamentals of Adobe Illustrator Creative Cloud from our certified Adobe Instructor. Classes are small group sessions guaranteeing time for practical training and questions and feedback from our tutor. \nWhat you will learn: \n\nDesign principles\, digital media theory (vector\, resolution\, raster)\nIllustrator interface\, workspace and navigation\, preferences and colour settings\, rulers\,guides and grids\, colour and colour swatches.\nShape and line tools\, transform and modify elements\, design alignment\, shape builder.\nCombining shapes with the pathfinder\, introduction to pen tool and Bezier curves\, applyingeffects\, drawing with brushes\, import\, link and embed elements.\nWorking with images\, clipping mask\, converting pixels to vector – image tracing\, styling\, andformatting text\, special characters\, Adobe fonts\, colour spaces (RGB\, CMYK)\, export settingsand file formats.\nOutput and optimize work for digital print use\, creative cloud libraries\, hidden gems and shortcuts\, efficiency workflow.
URL:https://pitmantrainingscotland.co.uk/event/adobe-illustrator-2/2024-02-12/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Adobe Illustrator,Edinburgh,Glasgow,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20240212T093000
DTEND;TZID=UTC:20240212T163000
DTSTAMP:20261024T222147
CREATED:20231128T104602Z
LAST-MODIFIED:20231128T104602Z
UID:10004285-1707730200-1707755400@pitmantrainingscotland.co.uk
SUMMARY:Management Skills
DESCRIPTION:As you develop as a manager you are even less involved in the day-to-day delivery of the work. Your success depends on your ability to manage your team\, manage others who supervise and manage technical specialists. Your role is less about your technical skills and will demand even higher levels of people skills. Your coaching skills will need more finess as you may find yourself coaching supervisors and junior managers who act as coaches at their own level. \nThis course will help you develop the right people skills and keep you developing for future management roles. Ideal for those with some management experience\, this course will help you benchmark your skills\, trouble shoot pinch points and set the scene for middle levels of management. \n\n\n\n\nWhat you will learn: \n\nDevelop your team.\nUse different management approaches.\nPlan and attend productive meetings.\nDeal with disciplinary situations with confidence.\nManage absence.\nDevelop and conduct competency-based interviews.\nStructure inspiring coaching sessions\n\nThis course is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/management-skills-4/2024-02-12/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Management Skills,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:20240215T093000
DTEND;TZID=UTC:20240215T163000
DTSTAMP:20261024T222147
CREATED:20231128T100221Z
LAST-MODIFIED:20231128T100221Z
UID:10004212-1707989400-1708014600@pitmantrainingscotland.co.uk
SUMMARY:Personal Development Workshops
DESCRIPTION:Assertiveness \nThis workshop is about helping you recognize your own type of behavior and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. The course will show you how to overcome your natural\, instinctive behavior in situations and learn more effective responses. \n\n\n\n\nWhat you will learn: \n\nWhat is assertive\, aggressive\, and passive behavior?\nWhat effect does this behavior have on you and others?\nUnderstanding our rights and responsibilities.\nRecognizing an assertive response.\nThree steps to assertive behavior\nSaying ‘no’ without feeling guilty.\nComparing constructive criticism and destructive criticism.\nDealing with criticism assertively.
URL:https://pitmantrainingscotland.co.uk/event/personal-development-workshops/2024-02-15/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Assertiveness,Edinburgh,Personal Development Workshops,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:20240220T093000
DTEND;TZID=UTC:20240220T163000
DTSTAMP:20261024T222147
CREATED:20231127T173021Z
LAST-MODIFIED:20231127T173021Z
UID:10004133-1708421400-1708446600@pitmantrainingscotland.co.uk
SUMMARY:Power BI Intermediate
DESCRIPTION:Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified\, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. \nWhat you will learn: \n\nDesign a data model.\nIntroduction to developing with the Microsoft Power Platform.\nUse Dax in Power BI Desktop.\nPublish and share.\nHow to build a Power BI dashboard.\nModel data in Power BI\nData analysis in Power BI\nManage workspaces and datasets in Power BI\nOptimise a model for performance.\nIf attending our virtual classroom courses – you will need to have the Microsoft Power BI license in addition to Microsoft Office. Having a second display is beneficial but not required. \n\n\nThis seminar is available on demand by virtual classroom\, contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/power-bi-intermediate-4/2024-02-20/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Power BI Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20240222T093000
DTEND;TZID=UTC:20240222T163000
DTSTAMP:20261024T222147
CREATED:20231127T162429Z
LAST-MODIFIED:20231127T162429Z
UID:10004042-1708594200-1708619400@pitmantrainingscotland.co.uk
SUMMARY:Excel Intermediate
DESCRIPTION:For individuals who are already using Excel\, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. \nWhat you will learn: \n\nFormula – Vlookups\, IF Statements\, SumIf\, CountIf\, Text formula\, Concatenate\, linking spreadsheets.\nUtilities – Protecting data\, hide and unhide data\, named ranges\, working with dates\, comments\, data validation\, headers and footers.\nLinking Data – linking spreadsheets\, identifying links\, linking separate workbooks.\nData Analysis – Updating Pivot Tables\, filters\, subtotals\, icons and data bars in conditional\nformatting\, filter and sort using colour.\nPivot Tables – creating Pivot Tables\, Pivot Charts\, Slicers\, refreshing data\, updating ranges.
URL:https://pitmantrainingscotland.co.uk/event/excel-intermediate-9/2024-02-22/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Excel Intermediate,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
END:VCALENDAR