BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Barnsley & Rotherham Chamber of Commerce - ECPv6.15.7//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.brchamber.co.uk
X-WR-CALDESC:Events for Barnsley & Rotherham Chamber of Commerce
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Europe/London
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20230326T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20231029T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20240331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20241027T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20251026T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240101T090000
DTEND;TZID=Europe/London:20240101T170000
DTSTAMP:20260614T102706
CREATED:20180816T093202Z
LAST-MODIFIED:20180816T093202Z
UID:10006993-1704099600-1704128400@www.brchamber.co.uk
SUMMARY:CIPS Level 3 Advanced Certificate in Procurement and Supply Operations
DESCRIPTION:Cost – £2\,099 + VAT \nDuration – 1 Year \nPlease note that the date given is the registration date. Full workshop dates are below. \nCourse Overview \nThe CIPS Level 3 Advanced Certificate in Procurement and Supply Operations introduces candidates to a wide range of essential key skills\, providing them with a sound understanding of the challenges facing professionals in the field of purchasing and supply chain management. \n  \nNo formal qualifications or professional experience is necessary to enrol on this programme. It is not necessary to have achieved the CIPS Level 2 Certificate before starting this programme but for people with little or no experience it does aid a smoother transition. \n  \nThis qualification is designed for those in an operational role who need the capability to carry out procurement and supply tasks. It is ideal for junior buyers and people with under 2 years’ experience. You will develop the knowledge to understand demand management\, arrange supply logistics and implement new contracts. \n  \nOur 10 day classroom programme is delivered over a 12 month period. Classroom based study helps students build confidence as learners and they benefit from the dynamics of being part of a group. \n  \nWorkshop Dates: \n18th October\, 1st November\, Exam November\n7th December\, 11th January\, Exam May\n15th & 22nd March\, Exam May\n12th & 26th April\, Exam July\n31st May\, 14th June\, Exam July \n  \n 
URL:https://www.brchamber.co.uk/event/cips-level-3-advanced-certificate-in-procurement-and-supply-operations/2024-01-01/
LOCATION:South Yorkshire\, United Kingdom
CATEGORIES:Training
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240103T083000
DTEND;TZID=Europe/London:20240103T163000
DTSTAMP:20260614T102706
CREATED:20160721T070342Z
LAST-MODIFIED:20160721T070342Z
UID:10012574-1704270600-1704299400@www.brchamber.co.uk
SUMMARY:First Aid at Work Requalification
DESCRIPTION:Member price – £165.00 + VAT\nNon-member price – £185.00 +VAT \nDuration – 2 Day’s \n  \nCourse Information:\n \nThe course provides an update to the delegates’ previous learning and the student will thus be expected to demonstrate a considerable degree of previous knowledge and be prepared to make a basic contribution throughout the course. \n  \nWho Should Attend the Two Day First Aid Course? \nThe 2 day refresher course is designed for students who currently hold a First Aid certificate which is due to expire. The HSE Guideline state that 3-day First Aid at Work Certificate MUST be renewed every 3 years. \n  \nBenefits From Attending \n\nBe able to act safely\, promptly and effectively during emergencies at work\nFeel confident in administering First Aid in an emergency situation\nUse First Aid equipment\nUnderstand employer duties and legislation\nMaintain first aid records\n\n  \nCourse Contents  \n\nRoles and responsibilities of a first aider\nAction in an emergency\nTreating an unconscious casualty\nInjuries to bone and muscles\nBurns and scalds\nPoisoning\nRecognising both major and minor injuries and illness\nManaging the stabilising of casualties\nAction to take in an emergency\nDealing and treating an unconscious casualty or a casualty is bleeding or wounded\nPracticing cardi pulmonary resuscitation (CPR)\nPrioritising casualties in a situation\nDealing with injuries to bones and muscles\nControl external bleeding\nAnticipating and dealing with shock in differing situations\nConsidering the ways poisons can be taken into the body and how to deal with them\nDealing with choking\nAutomated External Defibrillation (AED)\nStabilising and managing the transport of casualties\n\n  \nPlease note that photographic ID is required in order to sit the exams. Successful delegates will receive a HSE certificate\, valid for a further three years. \nDelegates are required to produce a copy of their existing certificate before the start of the course to ensure they are eligible to attend the requalification course.
URL:https://www.brchamber.co.uk/event/level-3-first-aid-work-re-qualification-2024-03-12/2024-01-03/
LOCATION:Sheffield\, South Yorkshire\, United Kingdom
CATEGORIES:First Aid Training Courses,Training
ATTACH;FMTTYPE=image/png:https://www.brchamber.co.uk/wp-content/uploads/2023/10/first-aid.png
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240105T093000
DTEND;TZID=Europe/London:20240105T170000
DTSTAMP:20260614T102706
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011017-1704447000-1704474000@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Advanced: Masterclass
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £170.00 + VAT \nDuration – 1 Day \n  \nThe previous stages of Excel introduce several very useful functions and tools\, as introduced in the intermediate course; one single function cannot always provide you with a solution. The master class focuses on how to combine the features\, functions and tools of Excel together. This course is not just about integration\, but several new functions will also be introduced such as Financial\, Text & Date formulas. This will give the user confidence to master any formula. In addition this course also introduces Macros VBA. \n\nRefresher Workshop\nDate Formulas – Day / Month / Year / WeekDay / WeekNum\nCombined Advanced Formulas – IF / AND / OR / V & H Lookup Combined\nProblem Solving Exercises – The Solver / Utilising / Complex Formulas\nIntroduction to Macros VBA – Recording\, Editing\, Running Macros / Understanding VBA / Rem\nStatements\nAdvanced Customising Of Excel – Toolbars / Menus\nAdvanced Formatting – Templates / Consolidating Data / Track Changes / Auditing\nForms / Dropdown Lists / Tick Boxes / Spinners\nDate Formulas – Day / Month / Year / Weekday / WeekNum\nCombined Date Formulas: =IF(WeekDay(A1\,2)<=5\,”Work”\,”Play”)\nAdvanced Combined Text Formulas – Len / Left / Right / Mid / Find / Proper / Upper / Lower\nProblem Solving Workshops\nQuestion and Answers\n\n  \nNow available as a virtual course – ring 01709 386200 for further details
URL:https://www.brchamber.co.uk/event/microsoft-excel-advanced-masterclass/2024-01-05/
LOCATION:Sheffield\, South Yorkshire\, United Kingdom
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/png:https://www.brchamber.co.uk/wp-content/uploads/2023/10/excel-training-new.png
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240105T093000
DTEND;TZID=Europe/London:20240105T170000
DTSTAMP:20260614T102706
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011181-1704447000-1704474000@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Intermediate: Complex Formulas
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £170.00 + VAT \nDuration – 1 Day \n  \nThis course introduces more complex features. By the end of this course delegates will be in a position to use some of Excel’s most beneficial functions such as If\, Sumif\, Countif\, And\, Or\, Vlookup\, and Hlookup and is an introduction to using combined formulas. In addition\, the trainer will also look at more advanced data analysis techniques with combined formulas such as Pivot tables. \n\nRefresher Workshop\nEditing – Custom Fills / Conditional Formatting\nAdvanced Linking Spreadsheets – Formula Linking\nData – Pivot Tables / Custom Filtering / Subtotals / Validation / Lists / Protection\nFormulas – IF Statements / CountIF & SumIF / Vlookup / Hlookup\nNested IFs: =IF(A1=1\,”Yes”\,IF(A1=2\,”No”\,IF(A1=3\,”Good”\,IF(A1=4\,”Bad”\,”Naughty”)))\nAND / OR Formulas\nWhat IF Analysis – Goal Seek / Scenario Manager\nPMT – Repayment of a Loan\nIntroduction to Combined Formulas\nText Formulas – Len / Left / Right / Mid / Find / Proper / Upper / Lower\nIntroduction to Combined Text Formulas: =Proper(Left(D1\,1)&” “&Right(D1\,Len(D1)-Find(” “\,d1\,1))\nProblem Solving Workshops\nQuestion and Answers\n\n  \nNow available as a virtual course – ring 01709 386200 for further details
URL:https://www.brchamber.co.uk/event/microsoft-excel-intermediate-complex-formulas/2024-01-05/
LOCATION:Sheffield\, South Yorkshire\, United Kingdom
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/png:https://www.brchamber.co.uk/wp-content/uploads/2023/10/Excel-3.png
ORGANIZER;CN="Chamber Skills Solutions":MAILTO:training@brchamber.co.uk
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240125T090000
DTEND;TZID=Europe/London:20240125T170000
DTSTAMP:20260614T102706
CREATED:20160720T144445Z
LAST-MODIFIED:20240117T184539Z
UID:10008084-1706173200-1706202000@www.brchamber.co.uk
SUMMARY:City & Guilds 2377: Certificate of Competence for the Inspection and Testing of Electrical Equipment
DESCRIPTION:Member price – £210.00 +VAT\nNon-member price – £260.00 +VAT \nDuration – 2 Days \nCourse Information:\nDeveloped in line with the latest IET Code of Practice\, this course focuses on the formal inspection\, testing and recording of electrical equipment\, with special regard for portable appliance testing. Using hands-on\, practical tuition\, it gives you the skills to meet typical contemporary challenges and prepare you for the City & Guilds 2377-22 examination. \nCourse Contents: \n\nThe legal requirement\, purpose and frequency of inspection and testing of electrical equipment.\nThe main inspection and testing requirements prescribed in the IET Code of Practice for In-Service Inspection and Testing of Electrical Equipment.\nEquipment construction and definition.\nApproved testing procedures with ‘Portable Appliance Testers’\nEstablish maintenance charts\, registers and recording of results.\nIntroduction to test instruments\nEquipment inspection and practical testing\nTest result analysis.\n\nAssessment: \n\nMultiple choice exam.\nPractical assessment.\n\nEach delegate will require a copy of the Code of Practice for the in-service inspection of electrical equipment (PATS)\, £66 each (not included in the price of the course).
URL:https://www.brchamber.co.uk/event/city-guilds-2377-2023-04-13-2024-01-25/2024-01-25/
LOCATION:Rotherham
CATEGORIES:Industrial Sector Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2023/10/Plug.jpg
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240130T093000
DTEND;TZID=Europe/London:20240130T110000
DTSTAMP:20260614T102706
CREATED:20230809T080251Z
LAST-MODIFIED:20230809T080251Z
UID:10008272-1706607000-1706612400@www.brchamber.co.uk
SUMMARY:Unlock the Power of Sustainability for Your Business
DESCRIPTION:Member price – £159.00 + VAT\nNon-member price – £185.00 +VAT \nDuration – 90 Minutes \n  \nAre you ready to future-proof your business and gain a competitive edge in today’s rapidly changing landscape? \nThen\, we’re thrilled to bring you a transformative online masterclass in response to the demand for understanding sustainability and maximizing its benefits in business. \nFor many businesses\, tackling sustainability can be daunting because of perceived extra costs\, confusing terminology\, and a lack of clear guidance on how to take meaningful action. This 90-minute masterclass is designed to demystify sustainability\, providing you with the knowledge and tools you need to navigate this critical landscape. \nSecure your future by embracing sustainability – the time to act is now! Don’t miss out on this exclusive sustainability training masterclass to take your business to the next level \n  \nIn this masterclass you’ll learn: \n\nFundamentals of sustainability and what it means for businesses\nMyths about sustainability and ‘Net Zero’ that will hinder your progress\nPractical actions to integrate sustainability into your business strategy\nHow to align sustainability with business priorities\nGetting ‘buy in’ from employees across the business\nMistakes to avoid in transitioning from talk to tangible action\n\nThis 90-minute online seminar/masterclass goes beyond theory\, learning about calculating carbon footprint in your business or even how many trees should be planted each year. Instead\, we help employees\, Directors and CEOs of limited companies and social enterprises to recognise that embracing sustainability isn’t just about compliance! \n  \nWho is this Workshop For? \nThis 90-minute online training masterclass is ideal for decision makers in small organisations who need to grasp the basics or gain greater insights into sustainability\, but do not have an internal expert on sustainability in their business. Neither are they interested in accreditation or other costly ‘bolted-on’ solutions for their business.
URL:https://www.brchamber.co.uk/event/sustainability-and-business-understanding-the-basics-for-maximum-benefits/
LOCATION:Online\, Online\, Online\, Online\, Online\, Online\, UK
CATEGORIES:Business & Personal Development Training Courses,Management & Supervision Training Courses,Training
ATTACH;FMTTYPE=image/png:https://www.brchamber.co.uk/wp-content/uploads/2024/01/Shaping-a-Sustainable-Future-image-1.png
END:VEVENT
END:VCALENDAR