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: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:20240524T093000
DTEND;TZID=Europe/London:20240524T170000
DTSTAMP:20260605T115443
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:20240524T093000
DTEND;TZID=Europe/London:20240524T170000
DTSTAMP:20260605T115443
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
END:VCALENDAR