BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Barnsley &amp; 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 &amp; 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: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
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20270328T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20271031T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260204T093000
DTEND;TZID=Europe/London:20260204T163000
DTSTAMP:20260604T115436
CREATED:20251128T110425Z
LAST-MODIFIED:20260522T124340Z
UID:10011163-1770197400-1770222600@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Introduction: Spreadsheets Made Easy
DESCRIPTION:Member price – £180.00 + VAT\nNon-member price – £200.00 + VAT \nDuration – 1 Day \n  \nCourse Overview \nOne of the hardest problems users face in Excel is Percentages (finding\, adding and deducting). This introduction course shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively. In addition\, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today\, Median\, Mode and Absolute Cell Referencing. Delegate’s confidence will quickly grow allowing them to start learning filtering and subtotal functions. \n  \n\nKeyboard – Function Keys / Shortcuts\nScreen Layout – Terminology / Toolbars / Shortcut / Cursors / Navigation\nFormatting – Open / Close / Saving / Text / Columns & Rows \nEditing – Planning / Autofill / Copy / Cut / Paste / Paste Special\nPrinting – Selection / Entire Workbook / Worksheet / Page Setup\nData – Sort / Filter / Subtotals\nBasic Graphs – Bar / Area / PieBasic Formulas – + – ÷  X / Basic Percentages / Absolute References / Averages / Dates\nBODMAS – 2+2*2=6\nAverage / Median / Mode Formulas\nCount / CountA / CountBlank / CountIF Formulas\nMin / Max Formulas\nToday Formula\nProblem Solving Workshop\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-introduction-spreadsheets-made-easy/2026-02-04/
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.png
ORGANIZER;CN="Chamber Skills Solutions":MAILTO:training@brchamber.co.uk
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20260205T093000
DTEND;TZID=Europe/London:20260205T163000
DTSTAMP:20260604T115436
CREATED:20251128T105820Z
LAST-MODIFIED:20260522T125248Z
UID:10011168-1770283800-1770309000@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Intermediate: Complex Formulas
DESCRIPTION:Member price – £180.00 + VAT\nNon-member price – £200.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/2026-02-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:20260205T093000
DTEND;TZID=Europe/London:20260205T170000
DTSTAMP:20260604T115436
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011182-1770283800-1770310800@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/2026-02-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:20260205T093000
DTEND;TZID=Europe/London:20260205T170000
DTSTAMP:20260604T115436
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011188-1770283800-1770310800@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/2026-02-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:20260205T093000
DTEND;TZID=Europe/London:20260205T170000
DTSTAMP:20260604T115436
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011194-1770283800-1770310800@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/2026-02-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:20260223T090000
DTEND;TZID=Europe/London:20260223T133000
DTSTAMP:20260604T115436
CREATED:20250417T083706Z
LAST-MODIFIED:20260126T114153Z
UID:10010196-1771837200-1771853400@www.brchamber.co.uk
SUMMARY:Cybersecurity Awareness Certification for SMEs
DESCRIPTION:Price: £50 + VAT \nDuration 1 Day \n  \nSYMCA funded Cybersecurity Awareness Certification\, delivered by Optimise Cyber Solutions\, is a fully instructor led\, one day live course delivered via MS Teams and designed specifically for SMEs. \nThe training is non technical and suitable for employees\, managers\, and business owners at all levels\, focusing on reducing cyber risk caused by human error while improving everyday awareness and decision making. On completion\, attendees receive recognised compliance certification aligned with Cyber Essentials and ISO 27001 awareness requirements\, helping organisations demonstrate due diligence and build trust with clients\, insurers\, and supply chain partners. \nWith the support of SYMCA funding\, eligible South Yorkshire SMEs can access this normally £1\,000 course for just a £50 contribution per person\, with up to two funded places available per business. \n  \n 
URL:https://www.brchamber.co.uk/event/cybersecurity-awareness-for-business-leaders/
LOCATION:United Kingdom
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/webp:https://www.brchamber.co.uk/wp-content/uploads/2025/04/Cyber-Awareness-Training.webp
ORGANIZER;CN="Chamber Skills Solutions":MAILTO:training@brchamber.co.uk
END:VEVENT
END:VCALENDAR