Harpenden

<p>This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.</p>The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth.<section>
                    <h3>1 The Query Editor</h3><ul><li>Grouping rows in a table</li><li>Split row by delimiter</li><li>Add days to determine deadlines</li><li>The query editor</li></ul> <h3>2 Fuzzy Matching Joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 The Query Editor M Functions</h3><ul><li>Adding custom columns</li><li>Creating an IF function</li><li>Nested AND logics in an IF function</li></ul> <h3>4 DAX New Columns Functions</h3><ul><li>Including TRUE with SWITCH</li><li>Using multiple conditions</li><li>The FIND DAX function</li><li>The IF DAX function</li><li>Logical functions IF, AND, OR</li></ul> <h3>5 Editing DAX Measures</h3><ul><li>Making DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>6 The Anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE filters</li><li>Add context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>7 The ALL Measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentages</li></ul> <h3>8 DAX Iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED with SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>9 Date and Time Functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>10 Time Intelligent Measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>11 Visualisations In-Depth</h3><ul><li>Utilising report themes</li><li>Applying static filters</li><li>Group data using lists</li><li>Group numbers using bins</li><li>Creating heatmaps</li><li>Comparing proportions</li><li>View trends with sparklines</li></ul> <h3>12 Comparing Variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - intermediate (2 day) (In-House)

<p>Take your sales people from average to high performance. Motivate and develop experienced sales professionals with some new insights and learning.</p><p>Applying NLP principles, techniques and models, this workshop will introduce the core attitudes and behaviours that differentiate the excellent sales person from the average one.</p>The programme will help participants:<ul><li>Understand and adopt the mindset and beliefs needed for sales excellence</li><li>Build rapport and connect with buyers at a deeper and more personal level</li><li>Recognise some of the thinking and language patterns that make each individual unique</li><li>Ask powerful questions to further understand the unique world of the individual and how they make decisions</li><li>Apply tools and techniques to empathise with clients - seeing things from their perspectives</li><li>Tailor their sales approach to the individual buyer's style, and talk in their language</li><li>Influence with integrity and sell to organisations and individuals successfully</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Aims and objectives of the programme</li><li>Personal introductions and objectives</li><li>Workshop overview</li></ul> <h3>2 An introduction to NLP and sales excellence with NLP</h3><ul><li>An overview of NLP and applying it to selling</li><li>The pillars of NLP</li><li>The NLP model of communication</li><li>The difference that makes the difference</li></ul> <h3>3 Building enhanced rapport</h3><ul><li>Defining rapport and why it is important when selling</li><li>Going beyond the initial small talk</li><li>Building relationships with individual decision-makers</li><li>Matching and mirroring</li><li>Levels of rapport</li></ul> <h3>4 Understanding the buyer's personal buying map</h3><ul><li>How we take in, filter and process information</li><li>How we judge others based on our own experiences of the world</li><li>The different ways in which we communicate when selling</li><li>Recognising and understanding the language and thinking patterns of others</li><li>Adapting your sales communication style to different buyers</li></ul> <h3>5 Making sense of the buying process</h3><ul><li>How we filter information through our senses</li><li>Understanding how we see, hear and experience the world</li><li>Visual, auditory and kinaesthetic buyers</li><li>Listening for key insights</li><li>What different buyers want from you to help them to buy</li><li>Applying sensory awareness to the sales process</li></ul> <h3>6 Successful sales mindset</h3><ul><li>The connection between thoughts and actions</li><li>The sales beliefs of excellence</li><li>Identifying negative thoughts and beliefs that are holding you back</li><li>How to change your mindset</li><li>Adopting the sales beliefs of excellence</li></ul> <h3>7 Powerful questions</h3><ul><li>Reviewing and honing your questioning skills</li><li>Understanding the questions that great sales people ask</li><li>Avoiding assumptions</li><li>Clean language questions</li><li>Getting to the bottom of it - precision questions</li><li>Turbo-charging how you qualify</li></ul> <h3>8 Influencing with integrity</h3><ul><li>Understanding empathy</li><li>Stepping into the buyer's shoes</li><li>Speaking the buyer's language</li><li>Tailoring your sales approach to the individual</li><li>Match, pace, lead - how to take your buyer with you</li></ul> <h3>9 Putting it all together</h3><ul><li>Personal learning summary and action plans</li></ul> 


                </section>

Coaching Skills

Professional Selling Skills (PSS)

Neuro-Linguistic Programming (NLP)

NLP Practitioner

Influencing Skills

Presentation Skills

Selling with NLP (In-House)

Birmingham

Erdington

Queensway

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For Private options, online or in-person, please send us details of your requirements:</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="28546e3a" data-element_type="section" style="color: rgb(98, 98, 98); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="530ff072" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="7ae5fe7" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="461193e7" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="8fd671b" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">The course is split into 3 phases and 9 modules:</h2></div><div data-id="58a6c8fc" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">PHASE 1: GET READY</h2></div><div data-id="5f8c8664" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 1: LAUNCH TABLEAU</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Check Install &amp; Setup</li><li fr-original-style="" style="box-sizing: border-box;">Why is Visual Analytics Important</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 2: GET FAMILIAR</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">What is possible</li><li fr-original-style="" style="box-sizing: border-box;">How does Tableau deal with data</li><li fr-original-style="" style="box-sizing: border-box;">Know your way around</li><li fr-original-style="" style="box-sizing: border-box;">How do we format charts</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Basics &ndash; My First Dashboard</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 3: DATA DISCOVERY</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Connecting to and setting up data in Tableau</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Explore my Data &ndash; Filters &amp; Sorting</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Structure my Data &ndash; Groups &amp; Hierarchies, Visual Groups</li><li fr-original-style="" style="box-sizing: border-box;">How Tableau Deals with Dates &ndash; Using Discrete and Continuous Dates, Custom Dates</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="2696f5d3" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="ec4f006" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="4520c476" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);"><br fr-original-style="" style="box-sizing: border-box;"></h2><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 2: GET SET</h2></div><div data-id="16ebe443" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 4: MAKE CALCULATIONS</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How Do I Create Calculated Fields &amp; Why</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 5: MAKE CHARTS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Charts that Compare Multiple Measures &ndash; Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots</li><li fr-original-style="" style="box-sizing: border-box;">Showing Relational &amp; Proportional Data &ndash; Pie Charts, Donut Charts, Tree Maps</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 6: MAKE TABLES</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating Tables &ndash; Creating Tables, Highlight Tables, Heat Maps</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5e5df3ea" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="491b064f" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="357bfc09" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 3: GO</h2></div><div data-id="4dd84eb2" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 7: ADD CONTEXT</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Reference Lines and Bands</p></li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 8: MAKE MAPS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Answering Spatial Questions &ndash; Mapping, Creating a Choropleth (Filled) Map</div></li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 9: MAKE DASHBOARDS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Using the Dashboard Interface</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Actions</li></ul></div></div></section></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5b9fdc59" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="649bcdb4" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="315826bb" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course includes over&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">25</strong>&nbsp;hands-on exercises and quizzes to help participants&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&ldquo;learn by doing&rdquo;</strong>&nbsp;and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format.</p></div><div data-id="6243dea8" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed.</p></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="649f95d" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="1c207d92" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="1bce9646" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(17, 41, 74); box-sizing: border-box;" fr-original-style=" color: rgb(17, 41, 74);">What People Are Saying About This Course</h2></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Richard L., Intelliflo" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;Excellent Trainer &ndash; knows his stuff, has done it all in the real world, not just the class room.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Richard L., Intelliflo</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#07294d" fr-original-style="" style="box-sizing: border-box;"><i fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></i></font><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" style="color: rgb(98, 98, 98); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&ldquo;Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.&rdquo;</div><cite style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Trevor B., Morrison Utility Services</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></font></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Trevor B., Morrison Utility Services" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></font></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Chelsey H., QVC</span></cite></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Matthew H., ISS Group</span></cite></div></div></section>

Tableau Training Uk

Tableau Desktop Training - Foundation

<p>The often-used phrase, 'just the receptionist', completely misrepresents the role. An excellent receptionist is a most valuable resource for any organisation.</p><p>This programme has been designed specifically to deal with the essential skills necessary to represent the organisation to the best possible effect. It will also help you get the most out of your working day.</p>There are six key reasons to take part in this workshop. It will help you:<ul><li>See your role in a new light</li><li>Develop your communication skills</li><li>Deal with different types of customer and situation</li><li>Boost your confidence</li><li>Cope in a pressurised environment</li><li>Get more satisfaction from your working day</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Workshop objectives and personal objectives</li><li>The challenges of 21st century communication</li><li>What makes an excellent point of Reception? And why is it so important?</li><li>Who and where are our customers?</li><li>As a customer, how do you like to be treated?</li><li>What makes people feel valued?</li><li>Objective and subjective aspects of customer service</li><li>'Micro moments' that shape the relationship</li></ul> <h3>2 Communication on reception</h3><ul><li>Definition of communication</li><li>Barriers to good communication</li><li>The 'recipe' of verbal, vocal and visual aspects of communication</li><li>Differences between communicating face-to-face and on the telephone</li><li>Communication 'leaks'</li><li>The primitive human response</li><li>The impact of visual communication - body language, gesture and facial expression</li><li>Voice - tone, speed, volume, pitch, clarity, inflection, pacing</li><li>Words - positive words and phrases compared with negative terminology</li><li>Professional greetings face-to-face</li><li>Steering the conversation with effective questioning</li></ul> <h3>3 Telephone excellence</h3><ul><li>How we use the telephone</li><li>Qualities of the telephone</li><li>Non-verbal communication on the telephone - what aspects can be 'seen' by the other person?</li><li>Professional telephone etiquette</li><li>Taking and leaving messages - key points that can help customers, colleagues and the organisation</li><li>Clarifying information</li></ul> <h3>4 Listening skills for accuracy and relationship building</h3><ul><li>How accurate are your listening skills?</li><li>What are the challenges for accurate listening?</li><li>Active / empathetic listening</li></ul> <h3>5 Creating a rapport by 'style flexing'</h3><ul><li>Understanding how different people communicate</li><li>Shaping our message to the other person so that they feel understood</li><li>How changing situations can alter communication needs</li></ul> <h3>6 Confidence and assertiveness</h3><ul><li>Recognising different styles of behaviour - aggressive, passive and assertive</li><li>Qualities of assertive communication - verbal, vocal and visual</li><li>Assertive techniques - basic, persistence, negotiation / empathetic</li><li>Demonstrating confidence</li></ul> <h3>7 Coping in a pressurised environment</h3><ul><li>Words - the most useful ones to use with stressed people and identifying the 'red rag' words</li><li>Challenging situations - what do you find difficult and how do you respond?</li><li>Dealing with outbursts of anger</li><li>Bringing non-stop talkers back from their tangent</li><li>Constructive ways to say 'no'</li></ul> <h3>8 Pulling it all together</h3><ul><li>Action plans</li><li>Summary of key learning points</li></ul> 


                </section>

Office Skills & Productivity

Professional Skills

Meeting Skills

Counselling Skills

Business Communication Skills

Reception perfection (In-House)

<p>In the fast-changing world of business, and especially IT, everyone in the organisation should be involved in sales.</p><p>One of the best ways is to give the customer an outstanding experience. The customer experience is the competitive battlefield of today. Sales may be won or lost here. You can either close a sale for a quick buck, or open a long-term relationship to create a high lifetime value customer.</p><p>By developing excellent communication skills, rapport and, most of all, a desire to serve and listen to the needs of the customer to the best of their ability, both sales teams and other IT professionals will create trust, nurture relationships and develop awareness of other opportunities with the customer.</p>By the end of this course, participants will be able to:<ul><li>Understand the power of a positive customer experience in developing sales opportunities</li><li>Recognise and develop a sales opportunity when it arises</li><li>Engage with customers and develop rapport and trust</li><li>Use verbal and non-verbal communication skills and pick up on signals</li><li>Ask powerful questions - and listen to the answers</li><li>Create 'magic moments' for the customer</li><li>Turn a complaint into an opportunity</li><li>Know when to ask for referrals and testimonials</li><li>Pass on leads to the relevant people</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Aims and objectives</li><li>Beliefs about sales</li></ul> <h3>2 Building rapport</h3><ul><li>First impressions</li><li>Short cuts to rapport</li><li>Finding common interests</li></ul> <h3>3 Selling or serving?</h3><ul><li>Managing emotions and behaviour - Transactional Analysis</li><li>Moments of truth - creating 'magic moments'</li><li>Speed sells - the follow-up</li></ul> <h3>4 Meetings</h3><ul><li>Planning a successful meeting</li><li>Pre-meeting connection and assistance</li><li>Sales meeting failure reasons</li><li>Right v wrong mindset</li></ul> <h3>5 Communication - verbal and non-verbal</h3><ul><li>The 3 Vs - Visual, Verbal, Vocal</li><li>Picking up on signals</li><li>7 power questions</li><li>Questioning techniques</li><li>LISTEN - 3 types of listening skills</li></ul> <h3>6 Influencing</h3><ul><li>6 levels of influence</li><li>Framing to change perspectives</li><li>Turning complaints into opportunities</li></ul> <h3>7 Referrals</h3><ul><li>The power of referrals</li><li>How and when to ask for a referral</li><li>5 steps from rapport to referral</li></ul> <h3>8 Presentation and pitching (optional session)</h3><ul><li>Basic presentation structure and delivery</li><li>Creating powerful impressions</li><li>Creating a 60-second pitch</li><li>The elevator 10-second pitch - answering 'What do you do?'</li><li>Sales presentations</li><li>Emotion <em>v</em> Intellect - how to engage</li><li>Using visuals</li></ul> 


                </section>

Online Course Marketing

Sales Management

Sales awareness for IT professionals (In-House)

<p>Many people have a misconception about networking events, and lose out on new business opportunities as a result. They either don't appreciate the real benefits and techniques of networking and don't attend events, or they attempt to 'sell on the first date', causing resentment.</p><p>You can either attempt to make a sale for a quick buck (which is particularly likely to backfire at a networking event), or you can try to open a long-term relationship, creating new opportunities and a high lifetime value customer (which is how it's meant to be done). Networking, when done properly, is an excellent tool for referrals. But you have to appreciate that it's done on the basis of giving rather than receiving and this doesn't always come naturally to sales professionals.</p><p>The old saying that it's about getting to 'know, like and trust' is still true. This workshop is about having your prospects and customers getting to know, like and trust you, and building that lifetime value as a result.</p>By the end of this programme, participants will be able to:<ul><li>Understand what networking is - networking etiquette</li><li>Know how and where to network</li><li>Clarify their objectives - why network</li><li>Use the 4 basic questions to start a conversation</li><li>Build rapport quickly and easily</li><li>Answer the question 'What do you do?' effectively in a few seconds</li><li>Deliver a 60-second pitch</li><li>Break into a group</li><li>Prepare for a network meeting</li><li>Identify opportunities</li><li>Use tools to assist in networking</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Aims and objectives</li></ul> <h3>2 What is networking?</h3><ul><li>Why network - objectives and goal setting</li><li>Networking etiquette</li><li>Preparation - online and offline tools to use</li><li>Identify networking opportunities - where to network</li><li>Know what you have to offer</li><li>'Know, like and trust' - the process</li></ul> <h3>3 What do you do?</h3><ul><li>Answer in 5-10 seconds</li><li>Create and deliver a 60-second pitch</li><li>Who is your target market?</li></ul> <h3>4 Starting a conversation</h3><ul><li>Breaking into a group</li><li>Building rapport</li><li>The 4 questions to start a conversation</li><li>Moving on</li></ul> <h3>5 Communicate and engage</h3><ul><li>LISTEN - 4 types of listening skill</li><li>Ask powerful questions</li><li>Influence - don't sell</li><li>What can you do to help others - give to get</li></ul> <h3>6 Power of referrals</h3><ul><li>Who can give you referrals?</li><li>When to give or ask for referrals</li><li>Have a referral system</li><li>Showing appreciation</li></ul> <h3>7 Social media and other online tools</h3><ul><li>Using LinkedIn and other social media</li><li>Online directories</li></ul> <h3>8 Next steps</h3><ul><li>Following up</li><li>Arranging one-to-one meetings</li><li>Developing relationships</li></ul> 


                </section>

Networking Skills

IT Networking Fundamentals

Personal Networking

Networking skills for sales professionals (In-House)

<p>This practical, enjoyable day will give you the tools to go and do your job effectively and the opportunity to practise using them in a safe and supportive environment before putting them into practice for real back in the workplace.</p><p>To inspire, you need to be inspired!Having the right set of skills, tools and techniques helps us to manage in a productive and beneficial way.</p><p>Above all, the workshop will inspire you with the determination to engage with the people you manage to produce greater levels of achievement.</p>This workshop will enable you to:<ul><li>Understand what the role of the manager is</li><li>Engage and inspire a team to perform</li><li>Recognise the range of styles appropriate for different situations and how your communication style impacts</li><li>Provide clear direction on your team's purpose, role and responsibilities</li><li>Understand how to create a motivating environment for those who report to you</li><li>Hold them accountable for delivery</li><li>Hold performance conversations</li><li>Review and evaluate your learning and have a plan to take back and implement at work</li></ul><section>
                    <h3>1 Bringing the role to life</h3><ul><li>Starting the day with sharing your current ideals and approaches using the pre workshop task</li><li>Understanding what you bring to your role and your objectives for the day</li></ul> <h3>2 The role and responsibilities of a manager: an overview</h3><ul><li>Responsibility and accountability</li><li>Producing results</li><li>Managing teams</li><li>Developing individuals</li></ul> <h3>3 Communication excellence</h3><ul><li>The model of a team communicator</li><li>What type of communicator are you and what about your team?</li><li>Practical interactive group exercise</li></ul> <h3>4 Your role as a team leader - shaping how we work using the organisation's values</h3><ul><li>Your role</li><li>Your team's role</li><li>Enabling your team to deliver in a changing mindset</li></ul> <h3>5 Engaging and motivating your team</h3><ul><li><em>Exercise: using a leadership model to explore how you are enabling your team to engage with current change, what's getting in the way and how you will manage this in your organisational context</em></li><li>Peer and group task and discussion</li></ul> <h3>6 Addressing motivation at team and individual level in times of change</h3><ul><li><em>Exercises:</em><ul><li>Identifying approaches to motivating people at work based on a work based model of motivation: team task</li><li>Exploring a behavioural model of motivation: team discussion</li></ul></li><li>Review in plenary</li></ul> <h3>7 Holding people accountable</h3><ul><li>The work cycle model of team performance:</li><li><ul><li>Agree purpose</li><li>Set objectives</li><li>Monitor performance</li><li>Provide feedback</li><li>Compliance vs. commitment</li></ul></li><li>Professional discussion in small groups</li><li><em>Exercise: Practising short conversations using peer coaching support</em></li></ul> <h3>8 Review of learning and action planning</h3><ul><li>Personal review and action planning</li><li>Group review of learning</li><li>Evaluation</li></ul> 


                </section>

Organisational Skills

Team Management

People Management

Lean Management

Manager Training

Management Skills

Management in a day! (In-House)

<p>The work of a technical team is invariably challenging and often unpredictable. Definition of the work can be problematic, timescales can be hard to estimate and the right technical approach difficult to select. Staff involved in this type of work usually have very high levels of specialist knowledge in their field and have high expectations of those who lead them.</p><p>In addition to the challenges of the work, the team leader often has to balance the need for professional excellence with financial and commercial considerations and to ensure that team goals are realistic by being an effective negotiator with other project and senior managers.</p><p>These characteristics make technical team leadership a demanding and complex activity. This programme aims to help participants develop the skills needed to become an effective technical team leader.</p>The objectives of this programme are to help participants:<ul><li>understand the significance of leadership skills and their impact on team performance</li><li>review the key skills needed to be an effective, 'multi-dimensional' team leader and learn how to develop, adapt and apply them in practice</li><li>learn how to identify the preferred leadership style for the context and organisational culture and how to develop personal style versatility</li><li>understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance</li><li>gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team</li></ul><section>
                    DAY ONE <h3>1 Technical teams and leadership</h3><ul><li>What is a leader?</li><li>How much can leadership be learned?</li><li>The team environment and the impact of leadership skills</li><li>The characteristics of high performance teams and their leaders</li><li>Some useful models and theories of leadership explored</li><li>Types of leadership; choosing how to use leadership power</li><li>Evaluating personal leadership style; how to develop style flexibility</li></ul> <h3>2 Essential skills for team leaders</h3><ul><li>3 key dimensions of effective leadership: inwards, outwards and upwards</li><li>Developing and promoting a 'team vision': strategic thinking skills</li><li>The vital role of communication skills and how to develop them</li><li>Understanding others; emotional intelligence skills</li><li>Being a visible leader; behavioural and influencing skills</li><li>Building effective relationships; the importance of trust and respect</li></ul> DAY TWO <h3>3 Leading inwards to build the team</h3><ul><li>The role of leadership in developing team performance</li><li>Understanding individuals in the team; recognising team role preferences</li><li>Managing conflict and promoting positive team dynamics</li><li>Setting standards, maintaining discipline and rewarding performance</li><li>Harnessing team potential: building motivation within the team</li><li>Promoting team learning; the team leader as coach / mentor</li></ul> <h3>4 Leading outwards and upwards to support the team</h3><ul><li>Negotiating realistic team goals; effective influencing skills</li><li>Gaining empowerment and support from the key stakeholders</li><li>Leading upwards: knowing when and how to take the initiative</li><li>Building team credibility within the organisation; helping the team deliver</li><li>Becoming an effective team player in leadership teams</li><li>Building and maintaining rapport with influential stakeholders</li></ul> 


                </section>

Leadership Skills

Team Leading

Project Leadership

Team Leader

Leadership Development

Leading technical teams (In-House)

<p>This highly practical one-day workshop has been designed specifically to help maximise sales where customers make contact by telephone.</p><p>When customers contact us direct they have clearly already considered the possibility that they might buy from us, but we're still only half-way to making a sale. Unless we fully understand their needs and make it easy for them to buy, we may not secure the business.</p><p>This workshop concentrates on the telephone skills and techniques needed to achieve the most positive outcome in any inbound customer call. A combination of excellent customer service skills and savvy sales awareness techniques will increase our chances of a successful outcome for both parties.</p><p>The programme features the unique INBOUND model, to help remember the key principles for effective inbound telephone sales:</p><p><b>I</b>nitial impressions</p><p><b>N</b>eeds of the customer</p><p><b>B</b>ring them with you</p><p><b>O</b>pen up the conversation</p><p><b>U</b>nderstand the triggers</p><p><b>N</b>arrow down the solutions</p><p><b>D</b>ecision time!</p><p>The programme also covers how to deal with difficult calls and challenging people - after all, every complaint is a sales opportunity!</p>This programme will help participants:<ul><li>Create the perfect interaction with any customer making contact by telephone</li><li>Make every call count</li><li>Build rapport quickly in any situation</li><li>Handle difficult calls and challenging people</li><li>Create sustainable and profitable relationships</li><li>Increase your sales conversions</li></ul><section>
                    <h3>1 The inbound sales process</h3><ul><li>Each customer who contacts us will be at a different stage of the sales process. Some might be making general enquiries whilst others will be ready to commit, having made most of their decisions already. Sales and customer service people need to be ready to find out the stage the customer has reached before helping them to make the right decision for them</li></ul> <h3>2 Engaging with the customer</h3><ul><li>Having clarified where the customer is on their journey to making a purchasing decision, our next responsibility is to create and build a trusting relationship on both sides. This involves establishing rapport quickly to ease the communication process, thus enabling smooth transactions, both now and in the future</li></ul> <h3>3 Questioning and listening skills for gathering information</h3><ul><li>Developing these skills requires practice so that the communication becomes natural for the customer. This helps the customer to feel comfortable with us and work with us towards an effective solution. We discuss different types of question and how to use high-gain questions to uncover key information. Active listening will ensure that we can really help customers get what they need</li></ul> <h3>4 Overcoming objections and excuses</h3><ul><li>If we have followed the process properly and really understood the customer, then there should no further objections or barriers to completing the transaction. The reality is that there will still be the occasional issue that needs clarifying, so we need to prepare for possible objections and questions that customers might have. This includes probing objections so that we fully understand the customer's perspective before constructing suitable responses or solutions</li></ul> <h3>5 Gaining commitment and ending the call</h3><ul><li>Customers want to gain a solution to the issue they are facing and the sooner we can help them achieve that the better. Guiding the customer and helping them to believe in their own decision is part of our role. This section is dedicated to getting commitment all the way along the process, not just at the close</li></ul> <h3>6 Dealing with difficult and challenging situations</h3><ul><li>The realisation that everybody is different, with different personality types, different ways of looking at the world and different goals, is key to understanding sales. With this is mind we discuss these differences and how we adapt our approach to ease communication and maintain trust and understanding</li></ul> <h3>7 Action plans</h3><ul><li>Course summary and presentation of action plans</li></ul> 


                </section>

Dealing With Difficult Customers

Telesales

Telephone sales - inbound (In-House)

Edinburgh

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">A 5‐day internal mediation training course from one of the UK&rsquo;s leading providers. Designed for organisations wishing to develop and offer a peer mediation service.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Professional, practical and affordable workplace mediation training</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Workplace Mediation</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Workplace mediation has become very popular in the UK. The types of issues covered are varied, but may include; bullying, team conflict, interpersonal differences, disputes over resources, manager/ employee conflict and issues related to grievance handling. There is a very high success rate for this type of intervention.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This Course</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Buon Consultancy, is one of the leading mediation training providers in the UK. We have been running this type of training for over 20 years.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Created specifically for the workplace setting and utilising a blend of interactive role play, peer coaching and case‐study based discussion, the course provides a comprehensive skills training for anyone wishing to gain competency in mediating workplace conflict as part of an internal mediation team.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This very practical course uses a variety of proven adult learning techniques to ensure maximum understanding, comprehension, and retention of the information presented. Participants are taught to mediate using co‐mediation. Co‐mediation is &lsquo;best‐ practice&rsquo; for internal peer mediation and utilises two volunteer mediators working together to help their fellow employees solve workplace conflicts.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Accredited Trainers</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course is taught by a CMC Accredited Mediator. Participants will receive a Certificate in Internal Workplace Mediation Skills.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">There is no accreditation for internal mediation training in the UK at present. Under the CMC Registration scheme in the UK, our Professional Training Course (7 days + assessment) is recognised by the CMC for Professional Registration. However, this level of registration is not required for internal mediators.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Lead Trainer</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The trainer is Tony Buon, the Managing Partner of Buon Consultancy. He is a well known workplace mediator with over 30 years experience as a mediator instructor. Tony is also a qualified workplace psychologist, trainer, educator and author.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tony holds Diplomas in Mediation, Conflict Resolution, Counselling and Teaching. Degrees in Psychology and Behavioural Sciences and Post‐ Graduate Qualifications in Education and Psychology. He is also a Certified Employee Assistance Professional (CEAP) and a Registered Civil, Commercial and Workplace Mediator (CMC).</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Tony has extensive adult and tertiary teaching experience and has taught up to Master&rsquo;s Level in Universities and Colleges in Australia and the UK.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Some of the over 1000 organisations Tony has worked with includes; 3M, Accor, Aramco, AXA, the British Council, BP, Coca Cola, CiC, CSR, DAA, Diageo, Dorset Police, DAA, DuPont, EAPA, ENI, Hampshire Council, NHS, Scottish Police College, &amp; the Sydney Olympics.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Comments from previous participants:</strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo; One of the best courses I have ever attended!&rdquo; &ldquo;I can&rsquo;t believe how much I learnt&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;...the trainer was excellent and the individual coaching and feedback I received was fantastic&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;I loved that the course focused on the practical skills of how to actually conduct a mediation at work&rdquo;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&ldquo;I now have the confidence to conduct a co‐mediation"</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Internal Peer Workplace Mediation Skills Course</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">5‐day Course (35 hours total)</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The training comprises five one‐day sessions. These can be done in two parts with a break between days 3 &amp; 4 or continuous (one‐week). Each day starts at 9:00 and finishes at 5:00.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Part One:<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Introduction to mediation &amp; models</li><li fr-original-style="" style="box-sizing: border-box;">Workplace mediation framework</li><li fr-original-style="" style="box-sizing: border-box;">The 6‐stage mediation processTM</li><li fr-original-style="" style="box-sizing: border-box;">Suitable for mediation?</li><li fr-original-style="" style="box-sizing: border-box;">Mediation at work DVD</li><li fr-original-style="" style="box-sizing: border-box;">Stage 1‐ pre‐mediation</li><li fr-original-style="" style="box-sizing: border-box;">Role play methodology</li><li fr-original-style="" style="box-sizing: border-box;">Controlling the process</li><li fr-original-style="" style="box-sizing: border-box;">Revision, review</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Bobby &amp; Taylor Stage 1 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Alex &amp; Sydney Stage 1 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Remaining impartial</li><li fr-original-style="" style="box-sizing: border-box;">Dylan &amp; Ashley Stage 1 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Communication skills for mediation</li><li fr-original-style="" style="box-sizing: border-box;">Active listening skills</li><li fr-original-style="" style="box-sizing: border-box;">Room &amp; furniture setup</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Three</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Revision, review</li><li fr-original-style="" style="box-sizing: border-box;">Guidelines for mediation</li><li fr-original-style="" style="box-sizing: border-box;">Stage 2 overview</li><li fr-original-style="" style="box-sizing: border-box;">Stage 3 ‐ opening statements</li><li fr-original-style="" style="box-sizing: border-box;">Bobby &amp; Taylor Stage 2&amp;3 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Alex &amp; Sydney Stage 2&amp;3 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Core, conditional and crisis techniques</li><li fr-original-style="" style="box-sizing: border-box;">Dylan &amp; Ashley Stage 2&amp;3 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Stage 4 ‐ identify the issues</li><li fr-original-style="" style="box-sizing: border-box;">Reframing</li><li fr-original-style="" style="box-sizing: border-box;">Blockages &ndash; moving people forward</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Part Two:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Four</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Revision, review</li><li fr-original-style="" style="box-sizing: border-box;">Stage 5 ‐ negotiation</li><li fr-original-style="" style="box-sizing: border-box;">Bobby &amp; Taylor Stages 4 &amp; 5 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Needs and positions</li><li fr-original-style="" style="box-sizing: border-box;">Brainstorming techniques</li><li fr-original-style="" style="box-sizing: border-box;">Alex &amp; Sydney Stage 4 &amp; 5 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Dylan &amp; Ashley Stage 4 &amp; 5 Role Plays</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Five</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Revision, review</li><li fr-original-style="" style="box-sizing: border-box;">Stage 6 ‐ reach agreement</li><li fr-original-style="" style="box-sizing: border-box;">Bobby &amp; Taylor Stage 6 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Alex &amp; Sydney Stage 6 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Dylan &amp; Ashley Stage 6 Role Plays</li><li fr-original-style="" style="box-sizing: border-box;">Toolbox tips</li><li fr-original-style="" style="box-sizing: border-box;">Bullying &amp; harassment</li><li fr-original-style="" style="box-sizing: border-box;">Ethics in mediation</li><li fr-original-style="" style="box-sizing: border-box;">Course review &amp; summary</li><li fr-original-style="" style="box-sizing: border-box;">Course evaluation</li></ul>

Buon Consultancy

Mediation

Internal Workplace Mediation Skills Course (5 days)

Elevate your auditing expertise and lead the way in quality management with our ISO 9001:2015 Lead Auditor course, certified by CQI and IRCA. This comprehensive program is designed for professionals seeking to conduct first, second, and third-party audits of Quality Management Systems (QMS) against the ISO 9001:2015 standard.
Our course provides in-depth training on the principles and practices of auditing, equipping you with the knowledge and skills to effectively lead audit teams and assess the conformance and effectiveness of QMS in organizations. You will learn how to plan, conduct, report, and follow up on audits in compliance with ISO 19011 guidelines and ISO/IEC 17021 standards.
Key Features of the Course:
Certified Expertise: Achieve a globally recognized certification from CQI and IRCA, enhancing your professional credibility and career prospects.
Experienced Instructors: Learn from industry experts with extensive experience in quality management and auditing, who provide real-world insights and practical guidance.
Interactive Learning: Engage in hands-on exercises, case studies, and role-play scenarios that simulate real auditing situations, ensuring that you can apply what you learn directly to your work.
Comprehensive Curriculum: Cover all aspects of the ISO 9001:2015 standard, audit principles, and techniques, as well as risk-based thinking and the process approach.
Career Advancement: This course is ideal for those aspiring to become lead auditors, quality managers, or consultants, offering a pathway to new opportunities and enhanced professional status.
Upon successful completion of the course and examination, you will be awarded the prestigious CQI and IRCA certification, recognized globally as a mark of excellence in auditing. This certification will enable you to conduct audits for certification bodies and help organizations achieve compliance and continual improvement.
Enroll in our ISO 9001:2015 Lead Auditor course today and take the next step in your journey to becoming a leader in quality management.

QUALITY ACADEMY

Quality Management System

ISO 9001

Quality Management

Quality Assurance

Quality Auditor

Become a certified ISO 9001:2015 Lead Auditor with our CQI and IRCA accredited course. Gain the skills to lead quality management audits and enhance your career. Enroll now!

ISO 9001:2015 Lead Auditor (CQI and IRCA Certified)

General Admission

Burnley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Have you ever wondered what is Reiki and would like to know more, then this course is for you if you would like to learn more about Reiki</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This Reiki Level One course is for you if you have heard a lot about Reiki and are interested in learning more about Reiki and is an introductory course on how to use Reiki healing techniques.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This is where you begin and my online course will teach you all you need to know to get you started with using Reiki on yourself and it is very simple to learn and to use. It is a gentle hands-on healing technique, which uses healing energy to treat any physical or emotional concerns.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Reiki is a helpful self-development technique for anyone wanting to learn more about reiki and how to enjoy the benefits of a healing treatment.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Reiki One course is taught live on line using Zoom.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What will I learn on this course:-</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">What is Reiki and its history?</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">The Principles of Reiki</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Auras and chakras</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Preparation for your initiation to the Reiki energy or attunement</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">What does the Reiki energy feel like?</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">21 day cleansing process</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">How to practise self-healing on yourself</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Reiki and its uses with other therapies</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Your own Reiki Lineage</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Question and answer session&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">You will be initiated to the Reiki energy by an attunement and receive a full instruction manual and your course certificate will be awarded to you at the end of the course.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">I am a Reiki Master and teacher and I am one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course.</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">The course can be booked online here and you will receive instructions on how to access the course.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">I look forward to meeting you and sharing my knowledge and experience of Reiki with you.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What this course offers you:</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Individual Support &ndash; During and after your course, if you have any questions</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Practical Experience &ndash; Step by step training is given so that you can gain valuable experience using Reiki on yourself</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Energy Perception &ndash; You will be taught to develop skills of energy perception and learn how to interpret the Reiki by what you sense and feel</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Personal Growth &ndash; You will discover for yourself the gift of Reiki healing and have increased confidence to use it for self-healing</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Testimonials:- What other students who have attended my courses are saying &nbsp;</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Level One Course</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;I enjoyed this course and Margaret is a great teacher and her calming voice explains everything clearly&rdquo;. (Anne-Marie M)</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;This is a very informative course. It gave me everything I needed to know to start working with the Reiki energy. (Sally R.)</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">&ldquo;This course is excellent!&rdquo; (Phil T)</p>

Margaret Cook - Learn More About Reiki

Energy Healing

Reiki

Reiki Healer

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

Reiki Level One Online Course - New to Reiki this is for you

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Kent.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

MJ Electrical Training 

Construction Industry Scheme (CIS)

City & Guilds

Health & Safety

Electrical Testing

Wiring Regulations

Electrical Installation

Electrical Inspection & Testing

ECS Health & Safety Course with MJ Electrical Training. Available every week, use this course to complete the application process when applying for an ECS Labourers Card. 

ECS Card Health & Safety Course Kent

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Bromley

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training has the largest centre network in the UK, with City &amp; Guilds exams available every week.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Final exams for the 18th Edition Wiring Regulations, Part P Building Regulations, <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">ECS Health &amp; Safety Courses&nbsp;</strong>and CSCS Green Labourers Health &amp; Safety in a Construction Environment are available weekly in Dover.</p><p style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><a href="https://mjelectricaltraining.co.uk/exam-venue/safety-passport/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Learn More @ MJ Electrical Training &gt;&gt;</span></strong></a></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Take the First Step Towards a Successful Career in the Electrical Industry with the SPA Health &amp; Safety Core Day</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Are you ready to kickstart or advance your career in the electrical industry? Obtaining the ECS Labourer Card is a crucial milestone that demonstrates your competence in assisting electricians in their installations. This card not only opens doors for new opportunities but also ensures that you are recognized as a qualified professional in the field. One of the most efficient ways to qualify for this essential certification is by completing the SPA Health &amp; Safety Core Day, offered by MJ Electrical Training.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why is the ECS Labourer Card Important?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The ECS Labourer Card is a must-have for anyone looking to start or further their career in the electrical industry. It signifies that you are competent to assist electricians in their electrical installations under supervision, ensuring safety and efficiency on the job. While advanced qualifications like the JIB Gold Card require extensive training and experience, the ECS Labourer Card provides a valuable entry point for newcomers, trainees, and those aiming to become fully qualified electricians.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Pathways to the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">MJ Electrical Training outlines two primary routes to gaining the ECS Labourer Card, depending on your previous qualifications and experience:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">1.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route One</strong>: If you already hold approved JIB theory qualifications, you may be exempt from additional health and safety courses.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">2.&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Route Two</strong>: If you do not hold these qualifications, you will need to complete an ECS-approved Health &amp; Safety Course. The SPA Health &amp; Safety Core Day is one of the most accessible and comprehensive options available.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">SPA Health &amp; Safety Core Day: Your Gateway to ECS Health &amp; Safety Exemption</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day, offered by MJ Electrical Training for just &pound;174.00 (including VAT), is a one-day online face-to-face training course delivered via Teams or Zoom. Available every week, this course is designed to provide you with the essential health and safety knowledge required for the electrical industry. Completing this course will exempt you from the ECS Health &amp; Safety Assessment, streamlining your path to obtaining the ECS Labourer Card.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who Should Take This Course?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The SPA Health &amp; Safety Core Day is ideal for anyone looking to gain an ECS Labourers Card or complete an ECS Health &amp; Safety Exemption:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Practising electricians looking to formalise their safety training.</li><li fr-original-style="" style="box-sizing: border-box;">Trainees and apprentices in the electrical industry.</li><li fr-original-style="" style="box-sizing: border-box;">Associated trade professionals such as electrical engineers, contracts managers, designers, consultants, surveyors, builders, and plumbers.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Benefits of the SPA Health &amp; Safety Core Day</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Comprehensive Training</b>: The course covers all necessary aspects of health and safety in the electrical industry, ensuring you are well-prepared for your role.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Flexible Learning</b>: Delivered online, you can complete the training from the comfort of your home or office, making it convenient and accessible.</li><li fr-original-style="" style="box-sizing: border-box;"><b fr-original-style="" style="box-sizing: border-box;">Certification</b>: Upon completion, you will receive a certificate that can be used to evidence you meet the H&amp;S requirements for the ECS Labourer Card.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Further Opportunities with the ECS Labourer Card</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Obtaining the ECS Labourer Card allows you to progress into employment and onto further qualifications, such as:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 2 Certificate in Fundamental Inspection, Testing and Initial Verification (2392-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Certificate in Building Regulations for Electrical Installation Contractors in Dwellings (2393-10)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Initial Verification (2391-50)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in the Periodic Inspection (2391-51)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 3 Award in Inspection and Testing (2391-52)</li><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds Level 4 Higher Professional Diploma in Building Services Engineering (4467-04)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To qualify for the ECS Labourer Card, not only must you have an ECS-approved H&amp;S course, but you must also demonstrate active engagement in the electrotechnical sector. This proof can be provided through:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">An application by your employer via the ECS Employer Portal.</li><li fr-original-style="" style="box-sizing: border-box;">A written reference from your current employer on company-headed paper, stating your role as an electrical labourer, start date, and signed by an authorised person.</li><li fr-original-style="" style="box-sizing: border-box;">Confirmation of your contract duration from an agency if you are working through one.</li><li fr-original-style="" style="box-sizing: border-box;">Documented proof of enrolment in a related electrical course from your educational institution.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Additionally, you can submit an offer letter, employment contract, or recent payslip from a reputable business within the industry. These documents validate your eligibility and expertise, completing the ECS Labourer Card application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Verify and Stay Updated</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">While every effort is made to provide accurate and up-to-date information, it is essential to verify the current application criteria by visiting the <a href="https://www.ecscard.org.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">ECS Website</a>. Keeping informed ensures that you meet all requirements and avoid any potential issues during the application process.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Conclusion</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Taking the SPA Health &amp; Safety Core Day is a strategic move for anyone looking to advance their career in the electrical industry. Not only does it provide essential health and safety training, but it also qualifies you for the ECS Labourer Card, a vital certification for gaining employment and furthering your career.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol in the SPA Health &amp; Safety Core Day with MJ Electrical Training today. Equip yourself with the knowledge and certification needed to excel in the dynamic and rewarding field of electrical installations. Your journey to becoming a fully qualified electrician starts here!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">&nbsp;</p>

ECS Card Health & Safety Course Dover

ECS Card Health & Safety Course Liverpool

ECS Card Health & Safety Course Newcastle

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Access VBA

Visual Basic Analysis

Microsoft Excel

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


Who will benefit from this School?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Real Estate Analyst II
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Day Three
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns


Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Investment School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Property Investment

Financial Analysis

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

167 Courses in Bradford

Power BI - intermediate (2 day) (In-House)

By The In House Training Company

Selling with NLP (In-House)

By The In House Training Company

Tableau Desktop Training - Foundation

By Tableau Training Uk

Reception perfection (In-House)

By The In House Training Company

Sales awareness for IT professionals (In-House)

By The In House Training Company

Networking skills for sales professionals (In-House)

By The In House Training Company

Management in a day! (In-House)

By The In House Training Company

Leading technical teams (In-House)

By The In House Training Company

Telephone sales - inbound (In-House)

By The In House Training Company

Internal Workplace Mediation Skills Course (5 days)

By Buon Consultancy

Search By Location