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: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:20260604T093000
DTEND;TZID=Europe/London:20260604T163000
DTSTAMP:20260604T001326
CREATED:20251128T110425Z
LAST-MODIFIED:20260522T124340Z
UID:10011165-1780565400-1780590600@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-06-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:20260605T093000
DTEND;TZID=Europe/London:20260605T163000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20260522T125248Z
UID:10011170-1780651800-1780677000@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-06-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:20260605T093000
DTEND;TZID=Europe/London:20260605T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011190-1780651800-1780678800@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-06-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:20260605T093000
DTEND;TZID=Europe/London:20260605T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011196-1780651800-1780678800@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-06-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:20260605T093000
DTEND;TZID=Europe/London:20260605T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011184-1780651800-1780678800@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-06-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:20260608T093000
DTEND;TZID=Europe/London:20260608T163000
DTSTAMP:20260604T001326
CREATED:20251201T093854Z
LAST-MODIFIED:20260303T094613Z
UID:10011909-1780911000-1780936200@www.brchamber.co.uk
SUMMARY:Microsoft Excel: Introduction
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £185.00 +VAT\nDuration – 1 Day \n  \nA 1 day Introduction Course\, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day\, users will be able to create\, amend and manipulate their own spreadsheets. \n Course Basics \nIntroduces the user to the layout of Excel\, identifying commonly used features and functions. \n\nMenu bar\nRibbon\nStatus bar\n\n  \nSpreadsheet Management \nBuild confidence by performing simple tasks whilst navigating through Excel. \n\nCreating new documents\nSaving spreadsheets\nClosing Excel\n\n  \nData Management \nSorting and Filtering your data to get more accurate statistics from your spreadsheet. \n\nSorting Data\nSubtotalling Data\nUsing Filters\nFreezing Panes\n\n  \nFormatting Excel \nChanging the look and feel of spreadsheets. \n\nSelecting cells\, columns and rows\nDisplaying data as currency (£)\nDisplaying figures as percentages (%)\nChanging cell\, text and border colour\n\n  \nFormulas and Functions \nCreating and using simple formulae to return totals\, averages\, largest and smallest figures from a range of data. \n\nUnderstanding simple formulas\nUsing AutoSum\nUnderstanding Absolute Cell References\nUsing AutoFill tools\n\n  \nFormula Auditing \nUnderstanding and fixing complex spreadsheets that other users may have set up \n\nTrace Precedents\nTrace Dependents\nEvaluating formulas\nTracing errors\nUsing the Watch Window\n\n  \nCharts \nHow to use your data in various chart types. \n\nUsing the Chart Wizard\nSelect appropriate chart types\nSpecifying the data source\nCustomising your charts
URL:https://www.brchamber.co.uk/event/microsoft-excel-introduction/2026-06-08/
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:20260609T093000
DTEND;TZID=Europe/London:20260609T163000
DTSTAMP:20260604T001326
CREATED:20251201T094555Z
LAST-MODIFIED:20260303T095128Z
UID:10011915-1780997400-1781022600@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/2026-06-09/
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:20260610T093000
DTEND;TZID=Europe/London:20260610T163000
DTSTAMP:20260604T001326
CREATED:20251201T102558Z
LAST-MODIFIED:20260303T095317Z
UID:10011921-1781083800-1781109000@www.brchamber.co.uk
SUMMARY:Microsoft Excel: Advanced
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £185.00 +VAT\nDuration – 1 Day \n  \nA 1 Day Advanced Course\, aimed at users that have attended the previous stages or experienced users. This course aims to extend the users knowledge with more tools and commands. By the end of the course\, users will be able use features including Goal Seek\, Data Tables\, Scenario Manager and Macros. \n  \nRefresh on Formulas  \n\nQuick refresh on commonly used formulas in Excel\nVLOOKUP formula\nIF Logical Tests\nSUMIF formula\nCOUNTIF formula\n\n  \nConsolidation \n\nHow to consolidate your excel data from multiple locations\nBringing together data from multiple sources\nViewing multiple worksheets\nViewing multiple workbooks\n\n  \nText Manipulation  \n\nAnalysing Data from external Sources.\nUse basic Text Formulas\nFormat data using Text to Columns\nConnect to an external Data Source using OBDC Connectors\n\n  \nWhat if Analysis  \n\nForecasting return figures for business\nGoal Seek\nData Tables\nScenario Manager\n\n  \nForms  \n\nHow to use the form controls to make filling in spreadsheets quicker and easier for your users\nCommand Buttons\nCheck Boxes\nScroll Boxes\nDropdown lists\nData Validation\n\n  \nMacros  \n\nIntroduces the user to the basics of macros\nCreating macros\nEditing macros\nRunning Macros\nMacro Security\nAssign a macro to a command button\n\n  \nCustomising Excel  \n\nCustomising excels default settings Modify existing toolbars\nCreate custom toolbars\nCreate and edit menu bars
URL:https://www.brchamber.co.uk/event/microsoft-excel-advanced/2026-06-10/
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:20260624T093000
DTEND;TZID=Europe/London:20260624T163000
DTSTAMP:20260604T001326
CREATED:20251201T093854Z
LAST-MODIFIED:20260303T094613Z
UID:10011910-1782293400-1782318600@www.brchamber.co.uk
SUMMARY:Microsoft Excel: Introduction
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £185.00 +VAT\nDuration – 1 Day \n  \nA 1 day Introduction Course\, aimed to give users the confidence and knowledge to create and use Excel spreadsheets. By the end of the day\, users will be able to create\, amend and manipulate their own spreadsheets. \n Course Basics \nIntroduces the user to the layout of Excel\, identifying commonly used features and functions. \n\nMenu bar\nRibbon\nStatus bar\n\n  \nSpreadsheet Management \nBuild confidence by performing simple tasks whilst navigating through Excel. \n\nCreating new documents\nSaving spreadsheets\nClosing Excel\n\n  \nData Management \nSorting and Filtering your data to get more accurate statistics from your spreadsheet. \n\nSorting Data\nSubtotalling Data\nUsing Filters\nFreezing Panes\n\n  \nFormatting Excel \nChanging the look and feel of spreadsheets. \n\nSelecting cells\, columns and rows\nDisplaying data as currency (£)\nDisplaying figures as percentages (%)\nChanging cell\, text and border colour\n\n  \nFormulas and Functions \nCreating and using simple formulae to return totals\, averages\, largest and smallest figures from a range of data. \n\nUnderstanding simple formulas\nUsing AutoSum\nUnderstanding Absolute Cell References\nUsing AutoFill tools\n\n  \nFormula Auditing \nUnderstanding and fixing complex spreadsheets that other users may have set up \n\nTrace Precedents\nTrace Dependents\nEvaluating formulas\nTracing errors\nUsing the Watch Window\n\n  \nCharts \nHow to use your data in various chart types. \n\nUsing the Chart Wizard\nSelect appropriate chart types\nSpecifying the data source\nCustomising your charts
URL:https://www.brchamber.co.uk/event/microsoft-excel-introduction/2026-06-24/
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:20260625T093000
DTEND;TZID=Europe/London:20260625T163000
DTSTAMP:20260604T001326
CREATED:20251201T094555Z
LAST-MODIFIED:20260303T095128Z
UID:10011916-1782379800-1782405000@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/2026-06-25/
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:20260626T093000
DTEND;TZID=Europe/London:20260626T163000
DTSTAMP:20260604T001326
CREATED:20251201T102558Z
LAST-MODIFIED:20260303T095317Z
UID:10011922-1782466200-1782491400@www.brchamber.co.uk
SUMMARY:Microsoft Excel: Advanced
DESCRIPTION:Member price – £150.00 + VAT\nNon-member price – £185.00 +VAT\nDuration – 1 Day \n  \nA 1 Day Advanced Course\, aimed at users that have attended the previous stages or experienced users. This course aims to extend the users knowledge with more tools and commands. By the end of the course\, users will be able use features including Goal Seek\, Data Tables\, Scenario Manager and Macros. \n  \nRefresh on Formulas  \n\nQuick refresh on commonly used formulas in Excel\nVLOOKUP formula\nIF Logical Tests\nSUMIF formula\nCOUNTIF formula\n\n  \nConsolidation \n\nHow to consolidate your excel data from multiple locations\nBringing together data from multiple sources\nViewing multiple worksheets\nViewing multiple workbooks\n\n  \nText Manipulation  \n\nAnalysing Data from external Sources.\nUse basic Text Formulas\nFormat data using Text to Columns\nConnect to an external Data Source using OBDC Connectors\n\n  \nWhat if Analysis  \n\nForecasting return figures for business\nGoal Seek\nData Tables\nScenario Manager\n\n  \nForms  \n\nHow to use the form controls to make filling in spreadsheets quicker and easier for your users\nCommand Buttons\nCheck Boxes\nScroll Boxes\nDropdown lists\nData Validation\n\n  \nMacros  \n\nIntroduces the user to the basics of macros\nCreating macros\nEditing macros\nRunning Macros\nMacro Security\nAssign a macro to a command button\n\n  \nCustomising Excel  \n\nCustomising excels default settings Modify existing toolbars\nCreate custom toolbars\nCreate and edit menu bars
URL:https://www.brchamber.co.uk/event/microsoft-excel-advanced/2026-06-26/
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:20260707T093000
DTEND;TZID=Europe/London:20260707T163000
DTSTAMP:20260604T001326
CREATED:20251008T124224Z
LAST-MODIFIED:20260522T125447Z
UID:10011013-1783416600-1783441800@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-07-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:20260707T093000
DTEND;TZID=Europe/London:20260707T170000
DTSTAMP:20260604T001326
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011020-1783416600-1783443600@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/2026-07-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:20260707T093000
DTEND;TZID=Europe/London:20260707T170000
DTSTAMP:20260604T001326
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011024-1783416600-1783443600@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/2026-07-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:20260707T093000
DTEND;TZID=Europe/London:20260707T170000
DTSTAMP:20260604T001326
CREATED:20251008T124224Z
LAST-MODIFIED:20251008T124224Z
UID:10011028-1783416600-1783443600@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/2026-07-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:20260804T093000
DTEND;TZID=Europe/London:20260804T163000
DTSTAMP:20260604T001326
CREATED:20251128T110425Z
LAST-MODIFIED:20260522T124340Z
UID:10011166-1785835800-1785861000@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-08-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:20260805T093000
DTEND;TZID=Europe/London:20260805T163000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20260522T125248Z
UID:10011171-1785922200-1785947400@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-08-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:20260805T093000
DTEND;TZID=Europe/London:20260805T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011185-1785922200-1785949200@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-08-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:20260805T093000
DTEND;TZID=Europe/London:20260805T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011191-1785922200-1785949200@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-08-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:20260805T093000
DTEND;TZID=Europe/London:20260805T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011197-1785922200-1785949200@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-08-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:20260904T093000
DTEND;TZID=Europe/London:20260904T163000
DTSTAMP:20260604T001326
CREATED:20251128T110425Z
LAST-MODIFIED:20260522T124340Z
UID:10011167-1788514200-1788539400@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-09-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:20261005T093000
DTEND;TZID=Europe/London:20261005T163000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20260522T125248Z
UID:10011172-1791192600-1791217800@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-10-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:20261005T093000
DTEND;TZID=Europe/London:20261005T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011186-1791192600-1791219600@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-10-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:20261005T093000
DTEND;TZID=Europe/London:20261005T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011192-1791192600-1791219600@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-10-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:20261005T093000
DTEND;TZID=Europe/London:20261005T170000
DTSTAMP:20260604T001326
CREATED:20251128T105820Z
LAST-MODIFIED:20251128T105820Z
UID:10011198-1791192600-1791219600@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-10-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
END:VCALENDAR