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:20241114T093000
DTEND;TZID=UTC:20241114T123000
DTSTAMP:20261008T181125
CREATED:20231127T163549Z
LAST-MODIFIED:20231127T163549Z
UID:10004075-1731576600-1731587400@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 formatting\, 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-11/2024-11-14/
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;TZID=UTC:20241113T093000
DTEND;TZID=UTC:20241113T163000
DTSTAMP:20261008T181125
CREATED:20231128T112525Z
LAST-MODIFIED:20231128T112526Z
UID:10004339-1731490200-1731515400@pitmantrainingscotland.co.uk
SUMMARY:Report Writing
DESCRIPTION:This 1-day workshop will help you choose the correct style and tone for a report and clearly define your purpose. It will revisit the key principles of grammar\, punctuation and spelling and is aimed at anyone involved in writing on behalf of their employer\, and those for whom reports are or will be integral to their job role. \nWhat you will learn: \n\nUnderstand the different types of reports you can write.\nClearly define the purpose of your report\nIdentify the key areas of a report\, assess what should or should not be included in your report.\nDevelop your report outline quickly and efficiently.\nUnderstand the key principles of grammar\, punctuation\, and spelling for use in your report.\nExpress yourself effectively using plain English.\nIdentify ways of writing with more impact\nRevise and correct your reports effectively.\n\nThis workshop is also available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/report-writing-13/2024-11-13/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Report Writing,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241112
DTEND;VALUE=DATE:20241114
DTSTAMP:20261008T181125
CREATED:20231128T102941Z
LAST-MODIFIED:20231128T103031Z
UID:10004252-1731403800-1731515400@pitmantrainingscotland.co.uk
SUMMARY:Executive PA – 2-day workshop
DESCRIPTION:This 2-day workshop is ideal for any PA looking to increase the contribution they make to their organisation. It is also aimed at secretaries who wish to develop and move up to the role of a PA. \n\n\n\n\nWhat you will learn: \n\nTo understand the role of the Executive PA\nTo learn to communicate effectively at all levels.\nTo organize your time and your boss’s time more efficiently\nTo understand how to set priorities and stick to them.\nTo acquire basic management skills\n\nThis 2 day workshop is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/executive-pa-2-day-workshop/2024-11-12/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Executive PA,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:20241112
DTEND;VALUE=DATE:20241113
DTSTAMP:20261008T181125
CREATED:20231127T153254Z
LAST-MODIFIED:20231127T153505Z
UID:10002209-1731403800-1731430800@pitmantrainingscotland.co.uk
SUMMARY:Adobe InDesign
DESCRIPTION:Adobe InDesign is available on demand in our Glasgow & Edinburgh centres. Please contact us for more details  \nFor individuals who are new to InDesign or have only used InDesign for limited tasks. Throughout the course you will learn the fundamentals of Adobe InDesign 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). InDesign interface\, workspace and navigation.\nInDesign preferences and colour settings\, rulers\, guides and view modes\, page layout.\nDesign alignment\, working with layers\, colour and colour swatches\, automation settings\,shape and frame tools\, import\, link and embed elements.\nWorking with images\, styling and formatting text\, character and paragraph styles\, specialcharacters.\nAdobe fonts\, introduction to the pen tool and Bezier curves\, combining shapes with thepathfinder\, master pages and master items.\nText wrap\, interactivity\, spell check and proofing\, colour theory\, colour spaces (RBG\, CMYJ).\nExport settings and file formats\, output and optimise work for digital print use.\nCreative Cloud libraries\, hidden gems and shortcuts\, efficiency workflows
URL:https://pitmantrainingscotland.co.uk/event/adobe-indesign-2/2024-11-12/
LOCATION:Virtual Classroom
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241112T093000
DTEND;TZID=UTC:20241112T163000
DTSTAMP:20261008T181125
CREATED:20231127T170940Z
LAST-MODIFIED:20231127T170940Z
UID:10004110-1731403800-1731429000@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Project Introduction
DESCRIPTION:For Individuals who have never used Project. The course is designed to cover all aspects of Project at an Introduction level; to provide you with a good overall grasp of the application – it’s different areas\, features and how these can be adapted within a working environment. \nWhat you will learn: \n\nProject Environment – Starting a project\, different view areas of project\, loading a project.\nPlanning a project – Overview of planning\, creating a new base calendar\, creating other calendars.\nTasks – Interesting tasks\, linking tasks through predecessors\, creating phases within project\, view scheduling options\, deleting\, moving and editing tasks.\nViews – alternative sheet views\, viewing Gantt Charts\, altering Gantt Charts.\nPrinting reports – preview options\, page setup\, overview of project reports.\nTrack your projects – create a baseline benchmark to mark against\, view a tracking Gantt charge\, see your project’s progress.\n\nThis seminar is available on demand by virtual classroom. Please fill in our contact form or call for more details. 
URL:https://pitmantrainingscotland.co.uk/event/microsoft-project-introduction-4/2024-11-12/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Microsoft Project Introduction,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241111T093000
DTEND;TZID=UTC:20241111T163000
DTSTAMP:20261008T181125
CREATED:20231128T112812Z
LAST-MODIFIED:20231128T112812Z
UID:10004345-1731317400-1731342600@pitmantrainingscotland.co.uk
SUMMARY:Speedwriting
DESCRIPTION:This course is ideal for anyone involved in taking notes at all levels in both work and personal life. The course is particularly beneficial to those for whom taking minutes or dictation is an integral part of their role. You will learn how to write in a reduced and efficient way to help you save time taking dictation\, writing notes\, recording minutes\, or taking lecture notes. \nWhat you will learn: \n\nThe basic principles and theory of speedwriting using the BakerWrite system.\nSilent letters and vowels\, phonetics and prefixes\, exercises\, and dictation practice.\nMore prefixes\, use of subscript and superscript\, exercises\, and dictation practice.\nSuffixes\, exercises\, and dictation practice\n\n\n\n\nThis workshop is also available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/speedwriting-5/2024-11-11/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Speed Writing
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241107T093000
DTEND;TZID=UTC:20241107T163000
DTSTAMP:20261008T181125
CREATED:20231128T103507Z
LAST-MODIFIED:20231128T103508Z
UID:10004264-1730971800-1730997000@pitmantrainingscotland.co.uk
SUMMARY:Identify and Manage Stress
DESCRIPTION:This course is designed to understand what stress is\, where it comes from and how it can affect you and those around you. As well as what you can do about it. \nWhat you will learn: \n\nUnderstand what stress means to you and how your body reacts to stress.\nIdentify your own pressure and stress points at work and other areas in your life.\nBecome aware of your body’s warning signs.\nUnderstand how stress can become a useful tool for you to use to your benefit.\nIntroduce practical tools and techniques to reduce and manage your stress.\nDevelop a personal and practical plan of action to minimize and manage your stress.
URL:https://pitmantrainingscotland.co.uk/event/identify-and-manage-stress-5/2024-11-07/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Identify and Manage Stress,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241107T093000
DTEND;TZID=UTC:20241107T163000
DTSTAMP:20261008T181125
CREATED:20231127T162429Z
LAST-MODIFIED:20231127T162429Z
UID:10004050-1730971800-1730997000@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-11-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;TZID=UTC:20241106T093000
DTEND;TZID=UTC:20241106T163000
DTSTAMP:20261008T181125
CREATED:20231128T112404Z
LAST-MODIFIED:20231128T112404Z
UID:10004335-1730885400-1730910600@pitmantrainingscotland.co.uk
SUMMARY:Report Writing
DESCRIPTION:This 1-day workshop will help you choose the correct style and tone for a report and clearly define your purpose. It will revisit the key principles of grammar\, punctuation and spelling and is aimed at anyone involved in writing on behalf of their employer\, and those for whom reports are or will be integral to their job role. \nWhat you will learn: \n\nUnderstand the different types of reports you can write.\nClearly define the purpose of your report\nIdentify the key areas of a report\, assess what should or should not be included in your report.\nDevelop your report outline quickly and efficiently.\nUnderstand the key principles of grammar\, punctuation\, and spelling for use in your report.\nExpress yourself effectively using plain English.\nIdentify ways of writing with more impact\nRevise and correct your reports effectively.\n\nThis workshop is also available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/report-writing-12/2024-11-06/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Report Writing,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Edinburgh":MAILTO:edinburgh@pitman-training.com
GEO:55.956409;-3.1908176
X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Edinburgh 4 Queen Street Edinburgh EH2 1JE United Kingdom;X-APPLE-RADIUS=500;X-TITLE=4 Queen Street:geo:-3.1908176,55.956409
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241106T093000
DTEND;TZID=UTC:20241106T163000
DTSTAMP:20261008T181125
CREATED:20231127T164227Z
LAST-MODIFIED:20231127T164227Z
UID:10004086-1730885400-1730910600@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze\, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. \nWhat you will learn: \n\nMacros – Editing and deleting macros\, recording macros\, customizing ribbon.\nReview Data – track changes\, auditing tools\, watch window\, review changes\, restricting data area.\nUtilities – Goal seek\, data consolidation\, power view reports\, create scenarios\, What -Ifanalysis\, drawing diagrams\, recommended pivot tables.\nAdditional – IfAnd/IfOr formula\, IfNa formula\, Convert to table\, screenshots\, removing duplicates\, filter timeline\, IfError\, HLookups\, Sparklines\, Pivot tables\, flash fill.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-10/2024-11-06/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Excel Advanced,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241106T093000
DTEND;TZID=UTC:20241106T123000
DTSTAMP:20261008T181126
CREATED:20231127T161950Z
LAST-MODIFIED:20231127T161950Z
UID:10004039-1730885400-1730896200@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-11/2024-11-06/
LOCATION:Virtual Classroom
CATEGORIES:Excel Introduction,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241105T093000
DTEND;TZID=UTC:20241105T163000
DTSTAMP:20261008T181126
CREATED:20231128T100529Z
LAST-MODIFIED:20231128T100530Z
UID:10004222-1730799000-1730824200@pitmantrainingscotland.co.uk
SUMMARY:Personal Development Workshops - Assertiveness
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-assertiveness/2024-11-05/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Assertiveness,Glasgow,Personal Development Workshops,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241105T093000
DTEND;TZID=UTC:20241105T123000
DTSTAMP:20261008T181126
CREATED:20231127T161950Z
LAST-MODIFIED:20231127T161950Z
UID:10004038-1730799000-1730809800@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-11/2024-11-05/
LOCATION:Virtual Classroom
CATEGORIES:Excel Introduction,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241104
DTEND;VALUE=DATE:20241105
DTSTAMP:20261008T181126
CREATED:20231127T155910Z
LAST-MODIFIED:20231127T160146Z
UID:10002222-1730714400-1730739600@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-11-04/
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:20241031T093000
DTEND;TZID=UTC:20241031T163000
DTSTAMP:20261008T181126
CREATED:20231128T101413Z
LAST-MODIFIED:20231128T102507Z
UID:10004243-1730367000-1730392200@pitmantrainingscotland.co.uk
SUMMARY:Communication Skills
DESCRIPTION:This practical workshop is ideal for those who need to build effective working relationships or depend on effective communication in critical situations. It will also benefit those who would like to develop their own skills and confidence in communication generally. \nWhat you will learn: \n\nPractical verbal and non-verbal communication\nThe importance of rapport and how to build relationships.\nMethods of organizing your thinking to convey the message you really mean.\nTo use precise questioning skills to control and move the conversation along.\nHow to communicate carefully in difficult situations.\nHow to resolve conflict and open up communication.\nHow to implement changes on return to the office.
URL:https://pitmantrainingscotland.co.uk/event/communication-skills-10/2024-10-31/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Communication Skills,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:20241031T093000
DTEND;TZID=UTC:20241031T163000
DTSTAMP:20261008T181126
CREATED:20231127T162833Z
LAST-MODIFIED:20231127T163108Z
UID:10004063-1730367000-1730392200@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 formatting\, 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-10/2024-10-31/
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:20241029
DTEND;VALUE=DATE:20241031
DTSTAMP:20261008T181126
CREATED:20231127T171304Z
LAST-MODIFIED:20231127T171304Z
UID:10004113-1730194200-1730307600@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Project Complete – 2-day course
DESCRIPTION:For individuals who have never used Project or have only used Project for limited tasks. At the end of the 2-day sessions you will be able to create professional-looking planning documentation. \nWhat you will learn: \n\nProject Introduction – Ribbon bar overview\, task area\, Gantt chart area\, view navigation\, starting a project overview\, project calendars.\nResources – creating resource calendars\, create resources\, assign resources to tasks\, over allocation\, team planner view.\nCreating Tasks – insert tasks\, delete\, and move tasks\, promote and demote tasks\, link tasks\, manual and auto scheduling\, predecessors\, task types\, adding task summary and outline numbers\, setting restraints.\nGannt Charts – formatting Gantt Charts\, altering Gantt Charts styles.\nCompleting tasks – set baseline\, tracking Gantt view\, view reports\, filter tasks\, percentage complete.\n\n\n\n\n\n\nPrinting and views – print preview\, page setup.\nCosts – creating costs\, assign costs to tasks\, add new columns.
URL:https://pitmantrainingscotland.co.uk/event/microsoft-project-complete-2-day-course/2024-10-29/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Glasgow,MS Project Complete
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:20241029T093000
DTEND;TZID=UTC:20241029T163000
DTSTAMP:20261008T181126
CREATED:20231128T104816Z
LAST-MODIFIED:20231128T104816Z
UID:10004291-1730194200-1730219400@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-5/2024-10-29/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Management Skills,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241029
DTEND;VALUE=DATE:20241030
DTSTAMP:20261008T181126
CREATED:20231115T143810Z
LAST-MODIFIED:20231127T145226Z
UID:10002196-1730192400-1730221200@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-10-29/
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:20241024T093000
DTEND;TZID=UTC:20241025T123000
DTSTAMP:20261008T181126
CREATED:20231128T130218Z
LAST-MODIFIED:20231128T130218Z
UID:10004378-1729762200-1729859400@pitmantrainingscotland.co.uk
SUMMARY:Time Management
DESCRIPTION:This workshop is ideal for anyone who wishes to improve their self-managing techniques\, achieve more in their working day and gain more balance in their lives. Spending 1-day learning how to manage your time – will save you hours! \nWhat you will learn: \n\nTo take an objective look at how you spend your time at work.\nTo prioritize effectively\nHow to establish short- and long-term goals and to achieve results.\nTo be aware of your own style in dealing with work and how this helps to manage yourself more effectively.“Well – arranged time is the surest mark of a well-arranged mind” – Sir Isaac Pitman
URL:https://pitmantrainingscotland.co.uk/event/time-management-13/2024-10-24/
LOCATION:Virtual Classroom
CATEGORIES:Seminar Courses,Time Management,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241024T093000
DTEND;TZID=UTC:20241024T163000
DTSTAMP:20261008T181126
CREATED:20231127T170133Z
LAST-MODIFIED:20231127T170133Z
UID:10004098-1729762200-1729787400@pitmantrainingscotland.co.uk
SUMMARY:Macros Deep Dive
DESCRIPTION:In this ‘Deep Dive’ we will devote the full day to exploring Macros and how they are used in Excel. We recommend that you have a basic to intermediate understanding of Excel already. \nThis seminar is also available on demand by virtual classroom.  \nWhat you will learn: \n\nIntroduction to Macros\nHow to use the macro recorder\nSave your file support with macros\nUsing absolute versus relative cell referencing when recording\nRun a macro from a button you create\nUse keyboard shortcuts to navigate during recording to get the correct result\nApply macros to different sized data sets\nAdd macro to Excel menu tabs\nIntroduction to VBA Editior\nAdd IF condition to macro VBA code\nAdd Loop to macto VBA code\nIntroduction to debugging VBA code\nCopy macros between workbooks
URL:https://pitmantrainingscotland.co.uk/event/macros-deep-dive/2024-10-24/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Macros Deep Dive Workshop,Seminar Courses,Virtual Class
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:20241023T093000
DTEND;TZID=UTC:20241023T163000
DTSTAMP:20261008T181126
CREATED:20231128T094415Z
LAST-MODIFIED:20231128T094415Z
UID:10004170-1729675800-1729701000@pitmantrainingscotland.co.uk
SUMMARY:Word Introduction
DESCRIPTION:For individuals who have never used a word processing package before or have only used Word for limited tasks. At the end of the day\, you will be able to create professional looking Word documents. \nWhat you will learn: \n\nIntroduction – screen layout\, ribbon bar\, entering and editing text\, spell and grammar checking\, change case\, saving documents\, creating new documents\, saving as different versions.\nPrinting – print preview\, applying page settings\, page layouts\, page numbering\, basic headers and footers\, page breaks.\nFormatting – selecting text\, moving text – copy\, cut and paste\, navigating a document\, full formatting text options\, aligning text\, applying text styles.\nParagraph formatting – setting tabs\, using bullets and numbering\, paragraph spacing\, borders and shading\, watermarks.\n\n\n\n\n\n• Other – basic tables\, pictures\, shapes\, drawing.
URL:https://pitmantrainingscotland.co.uk/event/word-introduction-9/2024-10-23/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Seminar Courses,Word Introduction
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241022
DTEND;VALUE=DATE:20241023
DTSTAMP:20261008T181126
CREATED:20231127T153254Z
LAST-MODIFIED:20231127T153505Z
UID:10002208-1729589400-1729616400@pitmantrainingscotland.co.uk
SUMMARY:Adobe InDesign
DESCRIPTION:Adobe InDesign is available on demand in our Glasgow & Edinburgh centres. Please contact us for more details  \nFor individuals who are new to InDesign or have only used InDesign for limited tasks. Throughout the course you will learn the fundamentals of Adobe InDesign 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). InDesign interface\, workspace and navigation.\nInDesign preferences and colour settings\, rulers\, guides and view modes\, page layout.\nDesign alignment\, working with layers\, colour and colour swatches\, automation settings\,shape and frame tools\, import\, link and embed elements.\nWorking with images\, styling and formatting text\, character and paragraph styles\, specialcharacters.\nAdobe fonts\, introduction to the pen tool and Bezier curves\, combining shapes with thepathfinder\, master pages and master items.\nText wrap\, interactivity\, spell check and proofing\, colour theory\, colour spaces (RBG\, CMYJ).\nExport settings and file formats\, output and optimise work for digital print use.\nCreative Cloud libraries\, hidden gems and shortcuts\, efficiency workflows
URL:https://pitmantrainingscotland.co.uk/event/adobe-indesign-2/2024-10-22/
LOCATION:Virtual Classroom
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241022T093000
DTEND;TZID=UTC:20241022T163000
DTSTAMP:20261008T181126
CREATED:20231127T172109Z
LAST-MODIFIED:20231127T172109Z
UID:10004124-1729589400-1729614600@pitmantrainingscotland.co.uk
SUMMARY:Pivot Tables Deep Dive
DESCRIPTION:In this ‘Deep Dive’ topic\, we will devote the full day to exploring Pitvot Tables and how they can be used for Data Analysis. We recommend that you have a basic to intermediate understanding of Microsoft Excel but no prior knowledge of Pivot Tables is required. \n\n\n\n\nWhat you will learn: \n\nIntroduction to pivot tables\nConvert data to tables\nAdjust field list settings\nCreate multiple reports with one click\nAdd data bars to pivot tables\nMaster pivot table settings\nAdd and remove calculated fields to pivot tables\nCalculate the difference between columns\nAdd smart custom number formatting\nCreate custom groupings to pivot tables\nGroup dates as unique\nAdd slicers to easily filter data\nAdd dynamic charts\nAdd a timeline to pivot tables\nIntroduction to Microsoft Power Pivot\n\nThis seminar is also available on demand by virtual classroom. Contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/pivot-tables-deep-dive-2/2024-10-22/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Glasgow,Pivot Tables Deep Dive Workshop,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241021
DTEND;VALUE=DATE:20241024
DTSTAMP:20261008T181126
CREATED:20231128T130613Z
LAST-MODIFIED:20231128T130613Z
UID:10004382-1729503000-1729701000@pitmantrainingscotland.co.uk
SUMMARY:Train the Trainer – 3- day workshop
DESCRIPTION:This course will introduce participants to the issues\, methodologies and techniques of training design and delivery. Each day consists of practical experience as well as hundreds of useful tips and techniques. The first part of the course concentrates on the design and structure of training as a learning tool; it then moves on to presentation\, delivery\, and facilitation so each day builds up to complete a full training methodology. Attendees will be presenting their own short training on the final day\, to put into practice everything they learn throughout the sessions. \nWhat you will learn: \n\nIdentify training needs.\nDefine and create aims and objectives that fit within an organizational perspective.\nDesign training sessions\nDeliver training sessions that incorporate the trainer’s personality – metaphors\, stories and humor.\n\n\n\n\n\n\nEvaluate training interventions.\nDealing with difficult delegates.\n\nThis workshop is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/train-the-trainer-3-day-workshop/2024-10-21/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Seminar Courses,Train the Trainer
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:20241021T093000
DTEND;TZID=UTC:20241021T163000
DTSTAMP:20261008T181126
CREATED:20231127T162833Z
LAST-MODIFIED:20231127T163108Z
UID:10004062-1729503000-1729528200@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 formatting\, 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-10/2024-10-21/
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;TZID=UTC:20241018T093000
DTEND;TZID=UTC:20241018T163000
DTSTAMP:20261008T181126
CREATED:20231127T170606Z
LAST-MODIFIED:20231127T170745Z
UID:10004106-1729243800-1729269000@pitmantrainingscotland.co.uk
SUMMARY:Microsoft Project Introduction
DESCRIPTION:For Individuals who have never used Project. The course is designed to cover all aspects of Project at an Introduction level; to provide you with a good overall grasp of the application – it’s different areas\, features and how these can be adapted within a working environment. \nWhat you will learn: \n\nProject Environment – Starting a project\, different view areas of project\, loading a project.\nPlanning a project – Overview of planning\, creating a new base calendar\, creating other calendars.\nTasks – Interesting tasks\, linking tasks through predecessors\, creating phases within project\, view scheduling options\, deleting\, moving and editing tasks.\nViews – alternative sheet views\, viewing Gantt Charts\, altering Gantt Charts.\nPrinting reports – preview options\, page setup\, overview of project reports.\nTrack your projects – create a baseline benchmark to mark against\, view a tracking Gantt charge\, see your project’s progress.\n\nThis seminar is available on demand by virtual classroom. Please fill in our contact form or call for more details. 
URL:https://pitmantrainingscotland.co.uk/event/microsoft-project-introduction-3/2024-10-18/
LOCATION:Edinburgh\, 4 Queen Street\, Edinburgh\, EH2 1JE\, United Kingdom
CATEGORIES:Edinburgh,Microsoft Project 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:20241017T093000
DTEND;TZID=UTC:20241017T123000
DTSTAMP:20261008T181126
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004094-1729157400-1729168200@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze\, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. \nWhat you will learn: \n\nMacros – Editing and deleting macros\, recording macros\, customizing ribbon.\nReview Data – track changes\, auditing tools\, watch window\, review changes\, restricting data area.\nUtilities – Goal seek\, data consolidation\, power view reports\, create scenarios\, What -If analysis\, drawing diagrams\, recommended pivot tables.\nAdditional – IfAnd/IfOr formula\, IfNa formula\, Convert to table\, screenshots\, removing duplicates\, filter timeline\, IfError\, HLookups\, Sparklines\, Pivot tables\, flash fill.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-11/2024-10-17/
LOCATION:Virtual Classroom
CATEGORIES:Excel Advanced,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20241016
DTEND;VALUE=DATE:20241018
DTSTAMP:20261008T181126
CREATED:20231128T103207Z
LAST-MODIFIED:20231128T103207Z
UID:10004256-1729071000-1729182600@pitmantrainingscotland.co.uk
SUMMARY:Executive PA – 2-day workshop
DESCRIPTION:This 2-day workshop is ideal for any PA looking to increase the contribution they make to their organisation. It is also aimed at secretaries who wish to develop and move up to the role of a PA. \n\n\n\n\nWhat you will learn: \n\nTo understand the role of the Executive PA\nTo learn to communicate effectively at all levels.\nTo organize your time and your boss’s time more efficiently\nTo understand how to set priorities and stick to them.\nTo acquire basic management skills\n\nThis 2 day workshop is available on demand by virtual classroom\, please contact us for more details. 
URL:https://pitmantrainingscotland.co.uk/event/executive-pa-2-day-workshop-2/2024-10-16/
LOCATION:Glasgow\, 3rd Floor\, Tontine House 8 Gordon Street\, Glasgow\, G1 3PL\, United Kingdom
CATEGORIES:Executive PA,Glasgow,Seminar Courses
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241016T093000
DTEND;TZID=UTC:20241016T123000
DTSTAMP:20261008T181126
CREATED:20231127T165905Z
LAST-MODIFIED:20231127T165905Z
UID:10004093-1729071000-1729081800@pitmantrainingscotland.co.uk
SUMMARY:Excel Advanced
DESCRIPTION:For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze\, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. \nWhat you will learn: \n\nMacros – Editing and deleting macros\, recording macros\, customizing ribbon.\nReview Data – track changes\, auditing tools\, watch window\, review changes\, restricting data area.\nUtilities – Goal seek\, data consolidation\, power view reports\, create scenarios\, What -If analysis\, drawing diagrams\, recommended pivot tables.\nAdditional – IfAnd/IfOr formula\, IfNa formula\, Convert to table\, screenshots\, removing duplicates\, filter timeline\, IfError\, HLookups\, Sparklines\, Pivot tables\, flash fill.
URL:https://pitmantrainingscotland.co.uk/event/excel-advanced-11/2024-10-16/
LOCATION:Virtual Classroom
CATEGORIES:Excel Advanced,Seminar Courses,Virtual Class
ORGANIZER;CN="Pitman Training Centre %E2%80%93 Glasgow":MAILTO:glasgow@pitman-training.com
END:VEVENT
END:VCALENDAR