BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Barnsley & Rotherham Chamber of Commerce - ECPv6.15.7//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Barnsley & Rotherham Chamber of Commerce
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:20190331T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20191027T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20200329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20201025T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20210328T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20211031T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:BST
DTSTART:20220327T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:GMT
DTSTART:20221030T010000
END:STANDARD
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
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:20260107T093000
DTEND;TZID=Europe/London:20260107T163000
DTSTAMP:20260604T004156
CREATED:20251008T124224Z
LAST-MODIFIED:20260522T125447Z
UID:10011011-1767778200-1767803400@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Advanced: Masterclass
DESCRIPTION:Member price – £180.00 + VAT\nNon-member price – £200.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/2026-01-07/
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:20251218T093000
DTEND;TZID=Europe/London:20251218T163000
DTSTAMP:20260604T004156
CREATED:20251201T094555Z
LAST-MODIFIED:20260303T095128Z
UID:10011243-1766050200-1766075400@www.brchamber.co.uk
SUMMARY:Microsoft Excel: Intermediate
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £185.00 +VAT\nDuration – 1 Day \n  \nA 1 Day course aimed at users that have attended the introduction course or are an experienced user currently creating and using excel within their role. By the end of the day users will be able to use features including sort\, filters\, PivotTables and Linking spread sheets. \n  \nFormulas \n\nShows the user how to action the more enhanced commonly used formulas.\nVLOOKUP formula\nIF Logical Tests\nNested IF Formulas\nSUMIF formula\nCOUNTIF formula\nAVERAGEIF Formula\n\n  \nFormatting Cells  \n\nQuick ways to professionalise your cells formatting and appearance.\nConditional Formatting\nFormat Painter Tool\nData Validation\n\n  \nWorking with Data  \n\nEffective ways of working with sets of Data in Excel.\nUsing Named Ranges\nFormatting data using Tables\nCreating Dynamic Expanding Ranges\n\n  \nExcel with other programs  \n\nShows the functions of other programs through excel.\nLinking multiple excel workbooks\nEmbedding word documents\nEmbedding PDF files\n\n  \nProtection  \n\nRestrict the formatting and editing of your spread sheets by users.\nRead Only\nRestricted editing options\nPassword protection\nSplitting Windows\n\n  \nPivot Tables  \n\nCreating\, editing and understanding the Pivot Table tool in Excel.\nUnderstanding Pivot Tables\nCreating Pivot Tables\nModifying data and refresh data\nCreating Pivot Charts\n\n 
URL:https://www.brchamber.co.uk/event/microsoft-excel-intermediate/2025-12-18/
LOCATION:Rotherham
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/png:https://www.brchamber.co.uk/wp-content/uploads/2025/12/Microsoft-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:20251205T093000
DTEND;TZID=Europe/London:20251205T163000
DTSTAMP:20260604T004156
CREATED:20251128T110425Z
LAST-MODIFIED:20260522T124340Z
UID:10011162-1764927000-1764952200@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/2025-12-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.png
ORGANIZER;CN="Chamber Skills Solutions":MAILTO:training@brchamber.co.uk
GEO:53.4696968;-1.3259683
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20251205T093000
DTEND;TZID=Europe/London:20251205T163000
DTSTAMP:20260604T004156
CREATED:20251128T105820Z
LAST-MODIFIED:20260522T125248Z
UID:10011156-1764927000-1764952200@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/2025-12-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:20251107T093000
DTEND;TZID=Europe/London:20251107T163000
DTSTAMP:20260604T004156
CREATED:20251008T124224Z
LAST-MODIFIED:20260522T125447Z
UID:10011010-1762507800-1762533000@www.brchamber.co.uk
SUMMARY:Microsoft Excel - Advanced: Masterclass
DESCRIPTION:Member price – £180.00 + VAT\nNon-member price – £200.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/2025-11-07/
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:20250411T090000
DTEND;TZID=Europe/London:20250411T160000
DTSTAMP:20260604T004156
CREATED:20220826T131742Z
LAST-MODIFIED:20250127T091454Z
UID:10007890-1744362000-1744387200@www.brchamber.co.uk
SUMMARY:Understanding Microsoft 365
DESCRIPTION:Member price – £100.00 + VAT\nNon-member price – £120.00 + VAT \nDuration – 1 Day \n  \nHave you asked yourself theses questions about your Microsoft system? \n\nIs your company using office 2010\,2013 or 2016 and will be migrating to Microsoft 365?\nHave you recently upgraded your systems and they have a later version of the traditional desktop software\, including Outlook\, Excel and Word?\nAre you considering using SharePoint and OneDrive?\nHave you already migrated to 365 but not using it to it’s fullest extent?\n\n  \nOur Microsoft 365 training take you through all the features of the software\, making the transition straightforward for your employees and causing minimum disruption to your business. \n  \nTopics Covered \n\nMigrating to version 365 – Outlook\, Excel\, Word\, PowerPoint and OneNote\nSharePoint- share and manage content across your organisation\nIntroduction to Teams\, incorporating Channels\nOneDrive/ SharePoint for Cloud Storage\nLists\, Planner\, Forms & Co-Pilot\n\n  \nYou will need to bring your own laptop to this session. 
URL:https://www.brchamber.co.uk/event/understanding-microsoft-365/
LOCATION:United Kingdom
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/video-call-group-business-people-meeting-virtual-workplace-remote-office-1024x683-1.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20240524T093000
DTEND;TZID=Europe/London:20240524T170000
DTSTAMP:20260604T004156
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011193-1716543000-1716570000@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-05-24/
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:20240524T093000
DTEND;TZID=Europe/London:20240524T170000
DTSTAMP:20260604T004156
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011025-1716543000-1716570000@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-05-24/
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:20240408T093000
DTEND;TZID=Europe/London:20240408T170000
DTSTAMP:20260604T004156
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011187-1712568600-1712595600@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-04-08/
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:20240408T093000
DTEND;TZID=Europe/London:20240408T170000
DTSTAMP:20260604T004156
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011021-1712568600-1712595600@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-04-08/
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:20260604T004156
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:20240105T093000
DTEND;TZID=Europe/London:20240105T170000
DTSTAMP:20260604T004156
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:20230726T100000
DTEND;TZID=Europe/London:20230726T130000
DTSTAMP:20260604T004156
CREATED:20230509T132219Z
LAST-MODIFIED:20230509T132219Z
UID:10008168-1690365600-1690376400@www.brchamber.co.uk
SUMMARY:ChatGPT and The AI Revolution
DESCRIPTION:What UK Business Owners need to know NOW to stay ahead… \nMember price: £97 + VAT\nNon-member price: £110 + VAT \nDuration: 1/2 Day \nLocation: Online \n  \nContent: \nThe AI Revolution isn’t Coming-it’s here already!  And it’s bringing significant changes and opportunities in it’s wake. \nI’m sure you’ve heard of ChatGPT by now-maybe even had a little play. \nWell\, there is no doubt that it’s an absolute Gamechanger and it will transform businesses that ‘Get in Early’ and leave behind those that don’t! \nJoin this inspiring and important programme to discover what you need to know NOW about Artificial Intelligence and particularly ChatGPT which in just a few months has become a worldwide phenomenon with over 100m users! \nAt ‘ChatGPT and the AI Revolution’ we will: \n\nIntroduce you to ChatGPT\nShow you what it can do for your Business!\nIntroduce you to a range of Practical Tools which use ChatGPT or other AI that you can use today!\nHelp you develop your ChatGPT/AI Growth Plan\n\n  \nWhy is this Event so important? \n  \nWhat is ChatGPT? \nOne of the big things that computers have found it very difficult to do is to talk and communicate naturally with people…until now that is with ChatGPT…This is a huge development of course\, both for ourselves generally and our businesses \nChatGPT Stands for Chat Generative Pre-trained Transformer and basically it’s something called  ‘Generative AI’ which is a type of artificial intelligence that can EASILY create new and original content such as images\, music\, text and much more… \nBy attending this unique and practical training\, you will have the opportunity to gain an insight as to how ChatGPT/AI can transform your business almost overnight and be introduced to a range of essential AI tools which are available NOW to initially experiment with\, but then rapidly build into the core of your business. \nBusinesses which adopt this technology first of all (and use it effectively) will clearly have significant advantages over those that hold back\, or don’t embrace ChatGPT and the other tools that are coming available everyday!
URL:https://www.brchamber.co.uk/event/chatgpt-and-the-ai-revolution/
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/CHATGPT.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20210202T093000
DTEND;TZID=Europe/London:20210202T123000
DTSTAMP:20260604T004156
CREATED:20200715T105515Z
LAST-MODIFIED:20200715T105515Z
UID:10007390-1612258200-1612269000@www.brchamber.co.uk
SUMMARY:Microsoft Teams Training (Delivered via Teams)
DESCRIPTION:Member price – £95.00 +VAT\nNon-member price – £120.00 +VAT \nHere at The IT Trainer our Teams training consists of a full and half day workshops on how to utilise the benefits of Teams. Not only is it the replacement for Skype for Business (which is being retired in 2021)\, but it is a fantastic tool for internal communication inside an organisation. \nWhether it is for instant messages / chats or a video or audio call to an individual or group of people\, Teams is simple to use on the desktop app\, mobile app or even on the web.  The massive advantage of Teams is the ‘teams’ feature – no more email chains\, no more multiple replies of confirmation from a group email or losing track of which attachment is being worked on – Teams allows for groups to communicate\, reply to messages\, attach files and documents and collaborate together. \nTeams can also replace your current phone system as a fully featured VOIP phone system and replace current Conference Call and Webinar solutions. \nOur workshops include: \n\nGetting to grips with Teams and its major features\nUsing the Audio and Video Calling features\nManaging and using Chats and Teams\nCollaboration – work together on the same file and the same time\nOnline Webinars\, Conferencing Calls\, scheduled meetings – use Teams to set up and manage\nAdd additional 365 Apps and connect to SharePoint sites.
URL:https://www.brchamber.co.uk/event/microsoft-teams/2021-02-02/
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/IT-Trainer.jpg
ORGANIZER;CN="IT Trainer":MAILTO:info@the-it-trainer.co.uk
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20210105T093000
DTEND;TZID=Europe/London:20210105T123000
DTSTAMP:20260604T004156
CREATED:20200715T105515Z
LAST-MODIFIED:20200715T105515Z
UID:10007389-1609839000-1609849800@www.brchamber.co.uk
SUMMARY:Microsoft Teams Training (Delivered via Teams)
DESCRIPTION:Member price – £95.00 +VAT\nNon-member price – £120.00 +VAT \nHere at The IT Trainer our Teams training consists of a full and half day workshops on how to utilise the benefits of Teams. Not only is it the replacement for Skype for Business (which is being retired in 2021)\, but it is a fantastic tool for internal communication inside an organisation. \nWhether it is for instant messages / chats or a video or audio call to an individual or group of people\, Teams is simple to use on the desktop app\, mobile app or even on the web.  The massive advantage of Teams is the ‘teams’ feature – no more email chains\, no more multiple replies of confirmation from a group email or losing track of which attachment is being worked on – Teams allows for groups to communicate\, reply to messages\, attach files and documents and collaborate together. \nTeams can also replace your current phone system as a fully featured VOIP phone system and replace current Conference Call and Webinar solutions. \nOur workshops include: \n\nGetting to grips with Teams and its major features\nUsing the Audio and Video Calling features\nManaging and using Chats and Teams\nCollaboration – work together on the same file and the same time\nOnline Webinars\, Conferencing Calls\, scheduled meetings – use Teams to set up and manage\nAdd additional 365 Apps and connect to SharePoint sites.
URL:https://www.brchamber.co.uk/event/microsoft-teams/2021-01-05/
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/IT-Trainer.jpg
ORGANIZER;CN="IT Trainer":MAILTO:info@the-it-trainer.co.uk
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20201201T093000
DTEND;TZID=Europe/London:20201201T123000
DTSTAMP:20260604T004156
CREATED:20200715T105515Z
LAST-MODIFIED:20200715T105515Z
UID:10007388-1606815000-1606825800@www.brchamber.co.uk
SUMMARY:Microsoft Teams Training (Delivered via Teams)
DESCRIPTION:Member price – £95.00 +VAT\nNon-member price – £120.00 +VAT \nHere at The IT Trainer our Teams training consists of a full and half day workshops on how to utilise the benefits of Teams. Not only is it the replacement for Skype for Business (which is being retired in 2021)\, but it is a fantastic tool for internal communication inside an organisation. \nWhether it is for instant messages / chats or a video or audio call to an individual or group of people\, Teams is simple to use on the desktop app\, mobile app or even on the web.  The massive advantage of Teams is the ‘teams’ feature – no more email chains\, no more multiple replies of confirmation from a group email or losing track of which attachment is being worked on – Teams allows for groups to communicate\, reply to messages\, attach files and documents and collaborate together. \nTeams can also replace your current phone system as a fully featured VOIP phone system and replace current Conference Call and Webinar solutions. \nOur workshops include: \n\nGetting to grips with Teams and its major features\nUsing the Audio and Video Calling features\nManaging and using Chats and Teams\nCollaboration – work together on the same file and the same time\nOnline Webinars\, Conferencing Calls\, scheduled meetings – use Teams to set up and manage\nAdd additional 365 Apps and connect to SharePoint sites.
URL:https://www.brchamber.co.uk/event/microsoft-teams/2020-12-01/
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/IT-Trainer.jpg
ORGANIZER;CN="IT Trainer":MAILTO:info@the-it-trainer.co.uk
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Europe/London:20201103T093000
DTEND;TZID=Europe/London:20201103T123000
DTSTAMP:20260604T004156
CREATED:20200715T105515Z
LAST-MODIFIED:20200715T105515Z
UID:10007387-1604395800-1604406600@www.brchamber.co.uk
SUMMARY:Microsoft Teams Training (Delivered via Teams)
DESCRIPTION:Member price – £95.00 +VAT\nNon-member price – £120.00 +VAT \nHere at The IT Trainer our Teams training consists of a full and half day workshops on how to utilise the benefits of Teams. Not only is it the replacement for Skype for Business (which is being retired in 2021)\, but it is a fantastic tool for internal communication inside an organisation. \nWhether it is for instant messages / chats or a video or audio call to an individual or group of people\, Teams is simple to use on the desktop app\, mobile app or even on the web.  The massive advantage of Teams is the ‘teams’ feature – no more email chains\, no more multiple replies of confirmation from a group email or losing track of which attachment is being worked on – Teams allows for groups to communicate\, reply to messages\, attach files and documents and collaborate together. \nTeams can also replace your current phone system as a fully featured VOIP phone system and replace current Conference Call and Webinar solutions. \nOur workshops include: \n\nGetting to grips with Teams and its major features\nUsing the Audio and Video Calling features\nManaging and using Chats and Teams\nCollaboration – work together on the same file and the same time\nOnline Webinars\, Conferencing Calls\, scheduled meetings – use Teams to set up and manage\nAdd additional 365 Apps and connect to SharePoint sites.
URL:https://www.brchamber.co.uk/event/microsoft-teams/2020-11-03/
CATEGORIES:Information Technology (IT) Training Courses,Training
ATTACH;FMTTYPE=image/jpeg:https://www.brchamber.co.uk/wp-content/uploads/2024/01/IT-Trainer.jpg
ORGANIZER;CN="IT Trainer":MAILTO:info@the-it-trainer.co.uk
END:VEVENT
END:VCALENDAR