Harpenden

<p>This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact.</p>This course will help participants:<ul><li>Using Slide Master</li><li>Create a presentation using a template</li><li>Insert slides and change the layout</li><li>Manage slides and control formats</li><li>Enhance slides using animation, pictures, charts and graphics</li><li>Work with tables, rows, cells and columns</li><li>Create and control paragraph lists</li><li>Insert titles and labels</li><li>Effectively use slide show controls and presenter view</li><li>Print slides, handouts and notes</li></ul><section>
                    <h3>1 Introduction to PowerPoint </h3><ul><li>Navigating the features</li><li>Creating a simple presentation</li><li>Inserting new slides and changing layouts</li><li>Creating speaker notes</li></ul> <h3>2 Using Layouts in Slide Master</h3><ul><li>Editing templates in slide master</li><li>Adding a design theme</li><li>Adding transitions, pictures and logos</li><li>Using Slide Show View</li></ul> <h3>3 Drawing shapes and SmartArt</h3><ul><li>Using Drawing Tool Formats</li><li>Creating shapes</li><li>Aligning shapes and stacking order</li><li>Creating a cycle graphic</li><li>Creating an organisation chart</li></ul> <h3>4 Animation</h3><ul><li>Visually enhancing slides with animation</li><li>Using text and object animation</li><li>Adding animation to lists</li><li>Making animation work for you</li></ul> <h3>5 Presenting</h3><ul><li>Confidently running a presentation</li><li>Using presenter view</li><li>Using the slide show controls</li></ul> 


                </section>

The In House Training Company

Executive Presentation

Meeting Skills

Microsoft Powerpoint

Presentation Skills

Apple Keynote

PowerPoint - introduction (In-House)

<p>Meetings are a traditional and essential component of local government. For both elected members and officers, meetings serve as a forum for discussion and agreement, planning and monitoring, communication and leadership, and decision-making. Used appropriately, meetings can challenge, inspire, illuminate and inform. And while they are not the only meetings that elected members will be asked to attend, committee meetings, in particular, are a mainstay of the political management process.</p><p>Effective chairing is important because it can provide clear leadership and direction, ensure that debates are focused and balanced, enable decisions to be reached and ensure that resources are used to best effect.</p><p>This two-hour 'masterclass'-style workshop will help elected members to understand their role, offer some approaches and ideas that will help to tackle typical challenges, and help to generally improve their effectiveness as a chair.</p><ul><li>To understand the skills and qualities of a good chair</li><li>To learn ideas and approaches for chairing a successful meeting that is on time and achieves its outcomes</li><li>To understand the protocols and boundaries for appropriate meeting etiquette and the chair's role in managing this effectively</li><li>To appreciate how to manage yourself and others appropriately</li><li>To take away personal actions to apply to your role</li></ul><section>
                    <h3>1 Welcome and introductions</h3><ul><li>Objectives</li><li>What's the challenge for you?</li></ul> <h3>2 We can't go on meeting like this</h3><ul><li>Common meeting challenges for chairs and why they succeed or fail</li><li>Consequences and impact for the Council</li><li>What's the context?</li></ul> <h3>3 Roles and responsibilities of an effective chair</h3><ul><li>Activities and input that explore the role, skills and qualities needed</li><li>Role of the chair: what is it and how to do it well</li></ul> <h3>4 Chairing for success - ideas and approaches to meet the challenges</h3><ul><li>Managing time and boundaries</li><li>Preparation and planning</li><li>Creating the right environment</li><li>Self-management</li><li>Challenging personalities and good meeting behaviour</li></ul> <h3>5 Final plenary session</h3><ul><li>What's your plan? Take away actions</li></ul> 


                </section>

Leadership Skills

Chairing Skills

Meetings

Chairing Meetings

Chairing meetings skills for Elected Members Masterclass (In-House)

<p>M&amp;O of engineering plant and services is becoming more important to the success of the core business. To select the right M&amp;O technique for specific plant and equipment it is necessary to know what options are available, what they deliver and how they should be implemented. This course will help you consider options and techniques that provide best value based on that thorough understanding of the business need. M&amp;O will increasingly be required to demonstrate it is delivering the optimum of cost and value and the main purpose of the course is to show how this can be achieved.</p><p>Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements.</p>This course will help you:<ul><li>Determine what the business needs from the M&amp;O service</li><li>Determine the cost and value of the various M&amp;O options</li><li>Prepare and present the business case for the selected M&amp;O strategy</li><li>Introduce meaningful KPIs based on performance-based service by the M&amp;O provider</li><li>Undertake a review of current M&amp;O and make recommendations for improvement</li><li>Introduce energy and carbon management performance criteria in M&amp;O</li><li>Better deal with project risk and uncertainties</li><li>Motivate others to deliver a reliable and cost effective M&amp;O service</li></ul><section>
                    					<p><em>Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements.</em></p>			  <h3>1 What is maintenance and what is operation? - their relative importance to the business</h3> <h3>2 Comparison of the various maintenance options and techniques, including:</h3><ul><li>Planned preventative</li><li>Run to failure</li><li>Condition monitoring</li><li>Business focused</li><li>Business critical</li><li>Total productive</li><li>Reliability centred maintenance</li></ul> <h3>3 Forms of contracts and service, including:</h3><ul><li>Comprehensive</li><li>Input driven</li><li>Output driven</li><li>Limited replacement</li><li>Performance based M&amp;O</li></ul> <h3>4 Selecting the right options and making the business case</h3> <h3>5 Continuous commissioning as a tool for delivering best value</h3> <h3>6 Case studies</h3> 


                </section>

Operations Management

Computer Maintenance

Vehicle Maintenance

Plant Maintenance

Facility Management

Aircraft Maintenance

Maintenance and operation (M&O) of engineering plant and services (In-House)

<p>This very practical and focused one-day workshop enables end-users, technical experts, proponents, internal customers and other key stakeholders to work with procurement and contracting to develop effective specifications and scopes of work, to ensure fit-for-purpose outcomes. The programme empowers participants to collaborate with all key stakeholders.</p>This workshop will help participants:<ul><li>Understand the importance and value of clear and effective specifications</li><li>Differentiate between the different methods of creating specifications and when to apply them</li><li>Develop robust specification templates to ensure consistency</li><li>Understand the use of appropriate language (critical to creating effective specifications)</li><li>Appreciate the need to develop specifications in cooperation with stakeholders</li><li>Make use of techniques such as value analysis and value engineering to define 'fit for purpose' in the context of creating effective specifications</li><li>Embed key KPIs into the specification to ensure delivery</li><li>Manage and mitigate legal and contractual risks in the specification</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Learning outcomes</li><li>Learning styles</li><li>Plan for the day</li></ul> <h3>2 The importance of effective specifications</h3><ul><li>Scopes of work</li><li>Impact of poor scopes of work</li><li>Examples of costly errors</li></ul> <h3>3 The critical role of language</h3><ul><li>Terminology in creating effective specifications and scopes of work</li><li>Problems of communication</li><li>Lack of detail or too prescriptive</li></ul> <h3>4 Encouraging cooperation</h3><ul><li>Technical and commercial experts with responsibility for developing robust effective specifications and scopes of work</li><li>Managing stakeholders' expectations</li><li>Working with contractors</li></ul> <h3>5 Types of specification</h3><ul><li>Exploring and using the various approaches to the development of appropriate specifications and scopes of work</li><li>Output</li><li>Performance</li><li>Technical</li><li>Functional</li><li>Solutions-based</li></ul> <h3>6 The role of value analysis</h3><ul><li>Value engineering in the process of developing scopes of work and specifications</li></ul> <h3>7 Specifications and contracts</h3><ul><li>The legal and contractual impact of poor specifications and scopes of work</li><li>How to embed scopes of work and specification outputs into tender and quotation documents</li></ul> <h3>8 Specifications as a management tool</h3><ul><li>Developing KPIs and SLAs framed around robust effective specifications and scopes of work</li><li>Negotiating with contractors</li><li>Negotiating with stakeholders</li></ul> 


                </section>

Developing effective scopes of work and specifications (In-House)

<p>This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code.</p><p>This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references.</p>This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables.<section>
                    <h3>1 The query editor</h3><ul><li>Split by row delimiter</li><li>AddDays to determine deadlines</li><li>Advanced 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 Logical column functions</h3><ul><li>Logical functions IF, AND, OR</li><li>Using multiple conditions</li><li>Including FIND in functions</li></ul> <h3>4 Editing DAX measures</h3><ul><li>Make DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>5 The anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE context filters</li><li>Adding context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>6 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 percentage</li></ul> <h3>7 DAX iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED in SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>8 Date and time functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>9 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>10 Visualisations in-depth</h3><ul><li>Utilising report themes</li><li>Create a heatmap</li><li>Comparing proportions</li><li>View trends with sparklines</li><li>Group numbers using bins</li><li>Setting up a histogram</li></ul> <h3>11 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> <h3>12 User level security</h3><ul><li>Setting up row level security</li><li>Testing user security</li></ul> 


                </section>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - advanced (1 day) (In-House)

<p>This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result.  It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared.</p>This course will help participants:<ul><li>Calculate with absolute reference</li><li>Group worksheets</li><li>Link to tables</li><li>Use the function library effectively</li><li>Get to grips with the logical IF function</li><li>Use conditional formatting</li><li>Create pivot table reports</li><li>Use data validation</li><li>Master the VLOOKUP function</li></ul><section>
                    <h3>1 Calculating with absolute reference</h3><ul><li>The difference between a relative and absolute formula</li><li>Changing a relative formula to an absolute</li><li>Using $ signs to lock cells when copying formulas</li></ul> <h3>2 Grouping worksheets</h3><ul><li>Grouping sheets together</li><li>Inputting data into multiple sheets</li><li>Writing a 3D formula to sum tables across sheets</li></ul> <h3>3 Linking to tables</h3><ul><li>Linking to a source table</li><li>Using paste link to link a table to another file</li><li>Using edit links to manage linked tables</li></ul> <h3>4 The function library</h3><ul><li>Benefits of writing formulas in the function library</li><li>Finding the right formula using insert function</li><li>Outputting statistics with COUNTA and COUNTBLANK</li><li>Counting criteria in a list with COUNTIFS</li></ul> <h3>5 Logical IF Function</h3><ul><li>Outputting results from tests</li><li>Running multiple tests for multiple results</li><li>The concept of outputting results from numbers</li></ul> <h3>6 Conditional formatting</h3><ul><li>Enabling text and numbers to standout</li><li>Applying colour to data using rules</li><li>Managing rules</li><li>Copying rules with the format painter</li></ul> <h3>7 View side by side</h3><ul><li>Comparing two Excel tables together</li><li>Comparing two sheets together in the same file</li></ul> <h3>8 Pivot table reports</h3><ul><li>Analysing data with pivot tables</li><li>Managing a pivot table's layout</li><li>Outputting statistical reports</li><li>Controlling number formats</li><li>Visualising reports with pivot charts</li><li>Inserting slicers for filtering data</li></ul> <h3>9 Data validation</h3><ul><li>Restricting data input with data validation</li><li>Speeding up data entry with data validation</li></ul> <h3>10 VLOOKUP function</h3><ul><li>Best practices for writing a VLOOKUP</li><li>A false type lookup</li><li>A true type lookup</li><li>Enhance formula results with IFNA</li></ul> <h3>11 Print options</h3><ul><li>Getting the most from print</li><li>Printing page titles across pages</li><li>Scaling content for print</li></ul> 


                </section>

Office Skills & Productivity

Office Skills

Access VBA

Microsoft Excel

Spreadsheet

Excel - intermediate (In-House)

<p>When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation.</p><p>This programme provides staff with the basic skills they need to sell.</p>This course will help participants:<ul><li>Profile customers</li><li>Research and identify potential new customers</li><li>Use the consultative sales process</li><li>Build effective rapport with customers</li><li>Identify customer needs through effective questioning and listening</li><li>Position products and services effectively</li><li>Close the sale or gain commitment to further action</li><li>Manage their customer portfolio to maximise sales</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Aims and objectives of the training</li><li>Personal introductions and objectives</li><li>Self-assessment of existing sales skills</li><li>Overview of content</li></ul> <h3>2 Knowing your customers</h3><ul><li>Who are your customers, and what do they want from you?</li><li>What are your strengths, compared to your competitors?</li><li>Who are your new potential customers?</li><li>How do you communicate with new customers?</li><li>What do you need to know about your customers before you start to sell?</li><li>Making the initial approach</li><li>Planning your pipeline - keeping the customers coming</li></ul> <h3>3 The four-step sales process</h3><ul><li>Overview of the consultative sales process</li><li>Key benefits of using the consultative sales process</li><li>Focusing on behaviours not targets</li><li>The behaviours of a good salesperson</li><li>Common pitfalls and mistakes</li><li>Personal strengths and weaknesses</li></ul> <h3>4 Building rapport</h3><ul><li>First impressions - Mehrabian theory of communication</li><li>Short cuts to building rapport</li><li>Looking out for clues as to how the customer is thinking</li><li>Looping back to keep the conversation flowing</li><li>Acknowledging past communication</li><li>Dealing with emotions such as anger</li><li>Setting the agenda to keep control</li><li>Getting past gatekeepers</li></ul> <h3>5 Questioning and listening</h3><ul><li>How to ask open questions to uncover information</li><li>Left brain questions</li><li>When closed question can be useful</li><li>What stops us listening?</li><li>The four levels of listening</li><li>How to develop your listening skills</li></ul> <h3>6 Presenting products and services to customers</h3><ul><li>When to present</li><li>Using benefits not features</li><li>Making it personal</li><li>Using reciprocity</li><li>The tendency towards the middle</li><li>Using consistency</li></ul> <h3>7 Gaining commitment</h3><ul><li>Testing the water</li><li>Dealing with objections using ACLEO</li><li>Asking for the business</li><li>Getting referrals</li><li>Ending with a personalised close</li><li>Following-up</li></ul> <h3>8 Managing your customer pipeline</h3><ul><li>Spotting opportunities for cross-sales</li><li>Managing your portfolio</li><li>Maximising sales proactively</li><li>Review meetings</li><li>Customer satisfaction measures and surveys</li><li>Mystery shopping</li></ul> <h3>9 Putting it all together</h3><ul><li>Skills practice</li><li>Personal learning summary and action plans</li></ul> 


                </section>

Online Course Marketing

Professional Selling Skills (PSS)

Counselling Skills

Sales Management

Introduction to sales (In-House)

<p>This intensive one-day training programme has been developed to help those involved in producing specifications create high quality documents in an organised and effective way.</p><p>The programme explains the primary purpose of specifications and the importance of understanding the context in which they are used. It focuses particularly on how to develop and structure content and write requirements that are clear and concise. The methods and techniques presented will provide a practical foundation course for those new to the topic whilst offering new insights to those with more experience.</p>The objectives of the workshop are to:<ul><li>Review and discuss the role and purpose of specifications</li><li>Present a structured approach for organising and producing specifications</li><li>Explain each of the key steps involved in creating effective specifications</li><li>Review some methods for assisting in defining requirements</li><li>Explain how to define the scope and develop the structure for a specification</li><li>Present methods to assist the writing and editing of specifications</li><li>Review how specifications should be issued and controlled</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Course objectives</li><li>Review of participants' needs and objectives</li></ul> <h3>2 Specifications in perspective</h3><ul><li>The role and purpose of specifications</li><li>The impact of specifications on commercial performance</li><li>The qualities of an effective specification</li><li>The five key steps of 'POWER' writing: prepare-organise-write-edit-release</li></ul> <h3>3 Step 1: Preparing to write</h3><ul><li>Defining the purpose the specification; integrating the specification and contract</li><li>Deciding how to specify: when to specify in functional and technical terms</li><li>Getting the right people involved at the right time; engaging stakeholders</li><li>Applying procedures for writing, issuing and controlling specifications</li></ul> <h3>4 Step 2: Organising the specification content</h3><ul><li>Scoping the document: scope maps, check lists, structured brainstorming</li><li>Clarifying requirements; separating needs and desires</li><li>Dealing with requirements that are difficult to quantify</li><li>Useful techniques: cost benefit analysis, Pareto analysis</li><li>Deciding what goes where; typical contents and layout for a specification</li><li>Creating and using model forms: typical sections and sub sections</li></ul> <h3>5 Step 3: Writing the specification</h3><ul><li>Identifying and understanding the readers needs</li><li>Choosing and using the right words; dealing with jargon</li><li>Important words; will, shall, must; building a glossary</li><li>Using sentence structure and punctuation to best effect</li><li>Understanding the impact of style, format and appearance</li><li>Avoiding common causes of ambiguity; being concise and ensuring clarity</li></ul> <h3>6 Step 4: Editing the specification</h3><ul><li>Why editing is difficult; how to develop a personal editing strategy</li><li>Key areas to review: structure, content, accuracy, clarity, style and grammar</li><li>Editing tools and techniques</li></ul> <h3>7 Step 5: Releasing and controlling the specification</h3><ul><li>Key requirements for document issue and control</li><li>Final formatting and publication issues; document approval</li><li>Requirements management: managing revisions and changes</li></ul> <h3>8 Course review and action planning</h3><ul><li>What actions should be implemented to improve specifications?</li><li>Conclusion</li></ul> 


                </section>

Technical Writing

Service Design Courses (SDC)

Content Writing

UX Writing

Book Writing

Business Writing

Specification writing (introduction) (In-House)

<p>If you're looking to move to the next level in your career in sales, then understanding how to maximise your sales results, using a consultative and structured approach, will be key to your success. In order to develop the competitive advantage that enables you to stand out from the crowd, it is important to understand the tools and techniques to take your selling to new heights and build the confidence to apply them in work-based scenarios.</p><p>We have developed this programme to be practical, fun and interactive. Learners will gain a range of practical skills that they can take back and apply to the workplace straight away, that will have a positive impact on sales and customer satisfaction.</p>This course will help participants:<ul><li>Develop a structured and client-focused approach to creating high quality sales opportunities and account growth</li><li>Learn persuasion and influencing skills to better define needs and develop opportunities</li><li>Understand how to have better sales conversations, presentations, and proposals - leading to higher order value and increased sales</li><li>Develop advanced sales questioning skills and techniques; understand the importance of listening</li><li>Understand how to add value at all stages; plus gaining competitive advantage</li><li>Develop proven ways to overcome and reduce price pressure</li><li>Know when to use options and upselling when presenting products and solutions</li><li>Develop techniques and skills for improved negotiation and closing</li></ul><section>
                    <h3>1 Advanced Selling - How to Increase your sales results</h3><ul><li>Review of pre-course data and questionnaire</li><li>The AVC model of increasing your sales results</li><li>Creating a sales growth plan to achieve higher sales targets</li><li>Mapping the accounts and products for targeted growth</li></ul> <h3>2 The Four Cs to structure a sales call</h3><ul><li>Research before the meeting or call; setting objectives, planning and preparation</li><li>How to gain instant rapport and taking control - including online meetings</li><li>Qualifying and initial questioning skills</li><li>Creating an agenda and first-meeting structure: Four Cs</li><li>Planning and practice sessions</li></ul> <h3>3 Building bigger and better sales opportunities</h3><ul><li>How to use questions to 'build' more opportunities</li><li>Learning and using high-impact and third-level questions</li><li>Advanced sales questioning techniques: five questioning techniques</li><li>Qualifying and gaining commitment to the next stage</li><li>Planning and practice sessions - advanced questioning skills</li></ul> <h3>4 Presentation and persuading skills best practice</h3><ul><li>Compelling benefits and reducing perceived risk - key messages to deliver</li><li>Helping the customer choose your proposition by using options</li><li>Professional and effective presentation skills</li><li>Writing compelling sales proposals that improve your conversion rate</li><li>Planning and practice session - presenting your solution</li></ul> <h3>5 Overcoming concerns and client questions</h3><ul><li>Proven techniques for answering client objections and concerns</li><li>How to isolate, prioritise and answer objections, including price</li><li>Overcoming delay and procrastination</li><li>Planning and practice session - answering client concerns</li></ul> <h3>6 Gaining commitment and closing the sale</h3><ul><li>Knowing when to close for commitment</li><li>How to ask for commitment professionally and effectively</li><li>Key negotiation skills around the closing process - getting to 'yes'</li><li>Checklist of closing and negotiation skills</li><li>Practice session</li></ul> 


                </section>

Coaching Skills

Increasing sales results (In-House)

<p>This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan.</p><p>If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan.</p>This programme will help participants:<ul><li>Discover opportunities - through a deeper understanding of the customer's business</li><li>Develop partnership - through a better 'value proposition' for the customer</li><li>Increase repeat business - based on higher customer satisfaction</li><li>Improve synergy - by getting everyone to 'sing from the same hymn sheet'</li><li>Develop a collaborative account plan - validated by the customer and their own management</li><li>Secure resources - management <em>will</em> align resources to execute <em>soundly based</em> account plans</li><li>Win an increased share of 'customer wallet' - through systematic account development</li></ul><section>
                    <h3>1 The six principles of strategic account development</h3><ul><li>Introduction to the PROFIT account development model:<ul><li>- Performance</li><li>- Relationships</li><li>- Objectives and goals</li><li>- Feedback</li><li>- Integration</li><li>- Teamwork</li></ul></li><li>Practical account development strategies: overview and case studies</li></ul> <h3>2 Performance</h3><ul><li>Use practical tools to help you manage and measure account performance and success</li><li>Design and build a monthly account dashboard for all sizes of account</li><li>Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools</li><li>Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible</li></ul> <h3>3 Relationships</h3><ul><li>How to build and manage key relationships within an account</li><li>Qualifying and managing key influencers accurately</li><li>Producing a 'relationship matrix' for each account quickly and easily</li><li>Approaching and developing new contacts strategically</li><li>Tools and techniques for successful tracking of contacts and call-backs</li><li>Developing a coach or advocate in every customer organisation pro-actively</li></ul> <h3>4 Objectives and goals</h3><ul><li>Where are you now? - how to establish your competitive position within an account</li><li>Know how to set, monitor and track key objectives for accounts over the short, medium and long term</li><li>Selling against the competition - developing both long- and short-term sales strategies</li></ul> <h3>5 Feedback - building loyal and satisfied customers</h3><ul><li>The correct way to manage customer expectations and create listening loops within an account</li><li>How to monitor and track your customer's perception and satisfaction with your organisation</li><li>Building a personalised satisfaction matrix for each account</li><li>Customer review meetings - best practice in building loyalty by regular joint planning events</li><li>Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude</li></ul> <h3>6 Integration</h3><ul><li>How to integrate your products or solutions with the customer's business needs and processes</li><li>Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor</li><li>Developing a loyalty strategy for key accounts or groups of smaller accounts</li><li>Getting your message and strategy across to C-level contacts</li></ul> <h3>7 Teamwork</h3><ul><li>Working with others to achieve your account goals</li><li>Gaining internal commitment from your organisation</li><li>Managing and working with a virtual team</li><li>Creating cross-departmental communication loops</li></ul> <h3>8 Putting it all together</h3><ul><li>Personal account reviews</li><li>Personal learning summary and action plans</li></ul> 


                </section>

Account Manager

ACCA Strategic Business Leader (SBL)

Coaching & Consulting Business

Account Management

Business Development

Key account management (In-House)

<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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.</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;"><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 delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</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;"><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><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Finance such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p 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>



This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance 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

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

Real Estate Finance (Debt Financing)

General Admission

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Sixty minute webinar on rally regularity timing for jogularity and regularity in styles where a full average speed time schedule is provided. The competitive component of on the public highway historic road rallying, focusing on jogularity style timing. Ideal for competitors on events such as HERO Challenge, Rally the Globe events or Three Castles.
</p>

Join our exclusive 60-minute webinar on rally regularity timing, designed to give an introduction to regularities in the jogularity or cumulative speed table styles. Learn how to navigate a full average speed time schedule and master the competitive aspects of historic road rallying on public highways. This session focuses on the processes required to understand and use the supplied time schedules, perfect for those competing in events like the HERO Challenge, Rally the Globe, and Three Castles. Whether you're a seasoned competitor or looking to sharpen your skills, this webinar will equip you with the strategies you need to succeed.


Rally Navigation Training Services

Sports & Fitness

Historic Road Rallying training webinar on Regularity focusing on the Jogularity and Cumulative Speed Table styles.

Rally Navigation - Introduction to Regularity Timing

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Logistics real estate encompasses commercial structures meticulously tailored for the storage, handling, and distribution of goods, spanning warehouses, distribution centres, and fulfilment hubs.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">These vital infrastructures support businesses of varying scales, from local retailers to multinational manufacturers, in ensuring streamlined operations.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Our webinar will explore various facets of logistics real estate, focusing on pivotal elements like warehouses and distribution centres, and feature a model spotlighting their critical attributes.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">If you&rsquo;re eager to deepen your understanding of logistics assets, join us for this insightful session.</span></p>

Logistics real estate encompasses commercial structures meticulously tailored for the storage, handling, and distribution of goods, spanning warehouses, distribution centres, and fulfilment hubs. These vital infrastructures support businesses of varying scales, from local retailers to multinational manufacturers, in ensuring streamlined operations. Our webinar will explore various facets of logistics real estate, focusing on pivotal elements like warehouses and distribution centres, and feature a model spotlighting their critical attributes. If you’re eager to deepen your understanding of logistics assets, join us for this insightful session.

Free Webinar | Industrial/Logistics Assets – Theory and Model Showcase

Reading

Nottingham

Dickson Training Ltd

ILM Level 5 Qualifications in Business Coaching and Mentoring

Diploma (Zoom)

Certificate (Zoom)

Diploma

Certificate

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

CompTIA Network+

Cloud Architecture

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Security+

CompTIA Cloud+

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or who wish to prepare for the CompTIA Network+ certification. CompTIA Network+ is the first certification IT professionals specializing in network administration and support should earn. Network+ is aimed at IT professionals with job roles such as network administrator, network technician, network installer, help desk technician, and IT cable installer. This course is also designed for students who are seeking the CompTIA Network+ certification and who want to prepare for the CompTIA Network+ N10-008 Certification Exam.</p>Overview<p>In this course, you will describe the major networking technologies and systems of modern networks and configure, manage, and troubleshoot modern networks. Explain the OSI and TCP/IP Models. Explain properties of network traffic. Install and configure switched networks. Configure IP networks. Install and configure routed networks. Configure and monitor ports and protocols. Explain network application and storage issues. Monitor and troubleshoot networks. Explain network attacks and mitigations. Install and configure security devices. Explain authentication and access controls. Deploy and troubleshoot cabling solutions. Implement and troubleshoot wireless technologies. Compare and contrast WAN technologies. Use remote access methods. Identify site policies and best practices.</p><p>CompTIA's Network+ certification is a foundation-level certification designed for IT professionals with around one year of experience, whose job role is focused on network administration.<br /><br />The CompTIA Network+ exam will certify the successful candidate has the knowledge and skills required to troubleshoot, configure, and manage common network devices; establish basic network connectivity; understand and maintain network documentation; identify network limitations and weaknesses; and implement network security, standards, and protocols. The candidate will have a basic understanding of enterprise technologies, including cloud and virtualization technologies.  <br /><br /> The Official CompTIAÂ© Network+Â© (Exam N10-008): will teach you the fundamental principles of installing, configuring, and troubleshooting network technologies and help you to progress a career in network administration. In this course, you will build on your existing user-level knowledge and experience with personal computer operating systems and networks to master the fundamental skills and concepts that you will need to use on the job in any type of networking career.</p>Prerequisites<p></p><ul><li>CompTIA A+ Certification (Exams 220-1001 and 220-1002)</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Explaining the OSI and TCP/IP Models</h3> <ul> <li>Topic A: Explain OSI Model Layers</li> <li> Topic B: Explain the TCP/IP Suite</li> </ul> <h3>2 - Explaining Properties of Network Traffic</h3> <ul> <li>Topic A: Explain Media Types and Access Methods</li> <li> Topic B: Deploy Ethernet Standards</li> <li> Topic C: Configure and Monitor Network Interfaces</li> </ul> <h3>3 - Installing and Configuring Switched Networks</h3> <ul> <li>Topic A: Install and Configure Hubs and Bridges</li> <li> Topic B: Install and Configure Switches</li> <li> Topic C: Compare and Contrast Network Topologies</li> <li> Topic D: Compare and Contrast Network Types</li> </ul> <h3>4 - Configuring IP Networks</h3> <ul> <li>Topic A: Configure IPv4 Addressing Components</li> <li> Topic B: Test IP Interfaces with Command Line Tools</li> <li> Topic C: Configure IPv4 Subnets</li> <li> Topic D: Configure Private and Public IPv4 Addressing Schemes</li> <li> Topic E: Configure IPv6 Addressing Components</li> <li> Topic F: Configure DHCP Services</li> </ul> <h3>5 - Installing and Configuring Routed Networks</h3> <ul> <li>Topic A: Explain Characteristics of Routing</li> <li> Topic B: Install and Configure Routers</li> </ul> <h3>6 - Configuring and Monitoring Ports and Protocols</h3> <ul> <li>Topic A: Explain the Uses of Ports and Protocols</li> <li> Topic B: Use Port Scanners and Protocol Analyzers</li> <li> Topic C: Explain the Use of Name Resolution Services</li> <li> Topic D: Configure DNS and IPAM Services</li> </ul> <h3>7 - Explaining Network Application and Storage Services</h3> <ul> <li>Topic A: Explain the Uses of Network Applications</li> <li> Topic B: Explain the Uses of Voice Services and Advanced Networking Devices</li> <li> Topic C: Explain the Uses of Virtualization and Network Storage Services</li> <li> Topic D: Summarize the Concepts of Cloud Services</li> </ul> <h3>8 - Monitoring and Troubleshooting Networks</h3> <ul> <li>Topic A: Monitor Network Interfaces and Logs</li> <li>Topic B: Explain Network Troubleshooting Methodology</li> <li>Topic C: Troubleshoot Common Network Services Issues</li> </ul> <h3>9 - Explaining Networking Attacks and Mitigations</h3> <ul> <li>Topic A: Summarize Common Networking Attacks</li> <li>Topic B: Explain the Characteristics of VLANs</li> <li>Topic C: Explain the Characteristics of NAT and Port Forwarding</li> </ul> <h3>10 - Installing and Configuring Security Devices</h3> <ul> <li>Topic A: Install and Configure Firewalls and Proxies</li> <li>Topic B: Explain the Uses of IDS/IPS and UTM</li> </ul> <h3>11 - Explaining Authentication and Access Controls</h3> <ul> <li>Topic A: Explain Authentication Controls and Attacks</li> <li>Topic B: Explain the Uses of Authentication Protocols and Directory Services</li> <li>Topic C: Explain the Uses of Port Security and NAC</li> <li>Topic D: Implement Network Device Hardening</li> <li>Topic E: Explain Patch Management and Vulnerability Scanning Processes</li> </ul> <h3>12 - Deploying and Troubleshooting Cabling Solutions</h3> <ul> <li>Topic A: Deploy Structured Cabling Systems</li> <li>Topic B: Deploy Twisted Pair Cabling Solutions</li> <li>Topic C: Test and Troubleshoot Twisted Pair Cabling Solutions</li> <li>Topic D: Deploy Fiber Optic Cabling Solutions</li> </ul> <h3>13 - Implementing and Troubleshooting Wireless Technologies</h3> <ul> <li>Topic A: Install and Configure Wireless Technologies</li> <li>Topic B: Troubleshoot Wireless Performance Issues</li> <li>Topic C: Secure and Troubleshoot Wireless Connectivity</li> </ul> <h3>14 - Comparing and Contrasting WAN Technologies</h3> <ul> <li>Topic A: Compare and Contrast WAN Core Service Types</li> <li>Topic B: Compare and Contrast WAN Subscriber Service Types</li> <li>Topic C: Compare and Contrast WAN Framing Service Types</li> <li>Topic D: Compae and Contrast Wireless and IoT WAN Technologies</li> </ul> <h3>15 - Using Remote Access Methods</h3> <ul> <li>Topic A: Use Remote Access VPNs</li> <li>Topic B: Use Remote Access Management Methods</li> </ul> <h3>16 - Identifying Site Policies and Best Practices</h3> <ul> <li>Topic A: Manage Networks with Documentation and Diagrams</li> <li>Topic B: Summarize the Purposes of Physical Security Devices</li> <li>Topic C: Compare and Contrast Business Continuity and Disaster Recovery Concepts</li> <li>Topic D: Identify Policies and Best Practices</li> </ul></div>

Cisco Certified Entry Networking Technician (CCENT)

IT Networking Fundamentals

Computer Networking

<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

Property & Real Estate Photography

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

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The colour energies are the essential building blocks of team and personal effectiveness, they develop the vital self awareness that makes flexibility possible.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Being flexible is the key to building effective and productive relationships.&nbsp; Adapting your style to connect with the style of your customer will lead to greater rapport.&nbsp; With rapport you can begin to influence your customer.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This virtual workshop has been designed for any group of people who want to learn how to build rapport quickly with lots of customers and other key stakeholders.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our Building Influence &amp; Selling Skills Workshop is an interactive, informative and fun way to begin this journey. We focus on behaviours rather than personality and provide a common language that helps individuals identify how to flex their style and create stronger connections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">How will your team benefit from this workshop? They will:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Understand individual strengths and potential development needs in this area</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Explore effective sales and influencing techniques for different audiences</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Optimise communication with stakeholders</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Consider how body language as well as written and verbal communication styles can influence this area</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Understand different clients&#39; drivers and blockers</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">✔ &nbsp; &nbsp;Learn ways to practically apply these concepts to current situations and clients</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We have worked with thousands of teams and individuals, which statement best describes your team:</p><ul style="list-style-type: disc; box-sizing: border-box;" fr-original-style="list-style-type: disc;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Inexperienced</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Want to develop pitching &amp; presenting skills</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Not hitting targets</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Looking to improve results</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Would benefit from sales skills development</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Influencing others regularly</li></ul><p id="isPasted" style="text-align: left; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: left;">Take advantage of our add-on offers at the checkout and enhance your experience on this workshop.&nbsp; Buy a set of <a href="https://colour-energies.com/colour-energies-building-blocks/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Colour Energies Building Blocks</a> and/or a <a href="https://colour-energies.com/colour-energies-card-game/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Colour Energies Card Game</a> and see how easily you can embed the colour energies in your team.</p><p id="isPasted" style="text-align: center; color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style="text-align: center;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Act Now! Contact us to bring the world of the colour energies to your team and experience the benefit of a common language that will drive your performance to a higher level.</strong></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://colour-energies.com/" target="_blank" style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: rgb(255, 255, 255); font-weight: bold; text-decoration: none; border-radius: 5px; background-color: rgb(61, 86, 224); border-width: 12px 18px; border-style: solid; border-color: rgb(61, 86, 224); display: inline-block; user-select: auto; box-sizing: border-box; cursor: pointer;" rel="noopener noreferrer" fr-original-style="font-size: 14px; font-family: Helvetica, Arial, sans-serif; color: #ffffff; font-weight: bold; text-decoration: none; border-radius: 5px; background-color: #3D56E0; border-top: 12px solid #3D56E0; border-bottom: 12px solid #3D56E0; border-right: 18px solid #3D56E0; border-left: 18px solid #3D56E0; display: inline-block;">Get in touch</a></p>

colour-energies.com

Disc

Team Building

Business Leadership

Relationship Building

Insights

Influence Skills

Insights Discovery

The four colour energies will transform your teams ability to influence customers and tailor their approach to different customers preferences.  By building deep rapport and creating trust your customers will strengthen their bond with your organisation.  Watch as your sales and profits exceed your expectations.

The 4 Colour Energies - Building Influence & Selling Skills

Early Bird Offer

Buy a place and get a second place for 50% discount

Buy One place get a second half price



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

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)

<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;">A day of Data Governance, support, networking, and answering your questions</strong></p><h2 fr-original-style="" style="box-sizing: border-box;">About this event</h2><div style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);">

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Are you responsible for implementing Data Governance? Are you expected to have all the answers?</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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);">It can be a scary position to be in, especially if you are new to the role, and even if you have done it before, what worked for the last organisation doesn&#39;t always work for the new one.</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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 can end up feeling lonely, vulnerable and frustrated. After all, you are trying to implement Data Governance to help your organisation - why is it turning out to be so difficult?!</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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 can spend hours on the internet or reading books but it can be challenging trying to turn the theory into something practical that will work for your organisation. If only you could fast forward to a few years&rsquo; time when you have done many more Data Governance initiatives and had a wider range of experience to fall back on.</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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);">If you don&#39;t have a time machine to help you with that, the other option is to build a network of experienced trusted peers who are willing to share the benefit of their experience with you. But that can be easier said than done. These days many networking events still aren&rsquo;t taking place and those that are are online and it&rsquo;s very hard to get a chance to speak let alone get advice for your challenges.</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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);">I can help you with that.</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);">
<br fr-original-style="" style="box-sizing: border-box;">
</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);">Why not join this 1 Day Data Governance Mastermind Workshop, where you get allocated time to get specific advice on your current Data Governance challenges and get the chance to network with others in similar situations.</p>

<p style="color: rgb(111, 114, 135); text-align: center; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(111, 114, 135); text-align: center;"><iframe width="560" height="315" src="https://www.youtube.com/embed/LcKBlsChafg" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;"></iframe></p>
</div>

Untangle your Data Governance issue and collaborate with your peers during this one-day Mastermind
Discuss Data Governance approaches with people who get it
Are you struggling with a Data Governance issue and wish you had a team of other Data Governance professionals you could bounce it around with?
You’ve done Data Governance training and you know what you’re focusing on. While your team is supportive, you spend a lot of time dealing with, and driving forward, culture change, managing stakeholders, and fielding questions from people who have their own priorities and now need to do this ‘Data Governance stuff’ on top. 
It would be nice, once in a while, to have a conversation about how to achieve something free from internal issues. You want to talk about best practices and get some alternative ideas.
That’s what my Data Governance Mastermind gives you: space to reflect with the support of your peers and practical solutions you can implement.
What is a mastermind?
Mastermind groups are the definition of ‘sharing is caring’. It’s you and your fellow peers – people who do what you do - gathering to brainstorm, problem solve, set goals and be each other’s support network.
At the Data Governance Mastermind, you will meet and learn from other people implementing Data Governance initiatives. 
It’s a one-day event, on Zoom. One of the benefits of attending is you’ll get 30 minutes in the ‘hot seat’ where you can share something you’re struggling with and get input from the group. 
What you can expect during the day
Discussions about different aspects of Data Governance and the opportunity to share what’s worked for you.
Tailored advice specific to your situation from me.
Insights from other people implementing Data Governance about what’s worked for them, what hasn’t worked, and how they have tackled issues.
30 minutes in the hot seat so you can share something you need help with and get practical suggestions from the rest of the delegates.
Time to reflect and share learnings from discussions so you have your key takeaways written down, ready to take back to work with you.
Get to know other Data Governance professionals and build a support network
Get an action plan and confidence to take your next steps with Data Governance
Get ready to discover new ways of approaching your Data Governance challenges, while getting to know professionals from a range of industries.
You will:
Get a clear action plan to take away with you to tackle your specific Data Governance issues.
Develop a wider network of supportive Data Governance professionals, people got your back and will be available to continue to network and ask advice or in the future.
Leave with the confidence that you're not alone in tackling these issues. There are other people going through similar experiences that are willing to help you out.
Is attending a Mastermind right for me? 
Every individual's Data Governance journey is unique. Take my scorecard to determine if my Mastermind programme is the right fit for you and will effectively support your specific needs. You can also find out more about the day on my website.

The Data Governance Coach 

Data Management

A day of Data Governance, support, networking, and answering your questions. Join me for my 1 Day Data Governance Mastermind where you get allocated time to get specific advice on your current Data Governance challenges and get the chance to network with others in similar situations.

466 Courses in Edinburgh

PowerPoint - introduction (In-House)

By The In House Training Company

Chairing meetings skills for Elected Members Masterclass (In-House)

By The In House Training Company

Maintenance and operation (M&O) of engineering plant and services (In-House)

By The In House Training Company

Developing effective scopes of work and specifications (In-House)

By The In House Training Company

Power BI - advanced (1 day) (In-House)

By The In House Training Company

Excel - intermediate (In-House)

By The In House Training Company

Introduction to sales (In-House)

By The In House Training Company

Specification writing (introduction) (In-House)

By The In House Training Company

Increasing sales results (In-House)

By The In House Training Company

Key account management (In-House)

By The In House Training Company

Search By Location