Harpenden

<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>

The In House Training Company

Office Skills & Productivity

Office Skills

Excel Analytics

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)

Meeting Skills

Counselling Skills

Sales Management

Presentation Skills

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>A question of trust. Leadership implies followership. And that means trust. Because who's going to follow a leader they don't trust?</p><p>This programme takes a values-driven approach to leadership. It gets current and aspiring leaders to hold up the mirror to themselves and to see their reflections as leaders of people. It asks them whether what they see justifies their view of themselves as leaders. It helps them understand just what it takes to be an effective leader.</p><p>And it does so in a highly practical, constructive manner. It helps the course participants to truly understand the core skills of effective leadership. It focuses on the difference between leadership and management, defining what high performing teams do and how they do it. It helps people to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. And it explores concepts such as emotional intelligence, authentic leadership and the RAIV approach (relationships-achievement-independence-vocation) to help explore underlying values and use them to drive effective leadership. Because what worth do our values have unless we put them into practice?</p>The course will help you:<br />• Appreciate the key skills a leader needs to be effective<br />• Understand what the organisation expects of you as a leader<br />• Recognise your leadership style and the impact it has on others<br />• Consider your role models - who inspires you?<br />• See leadership from the 'followers' perspective - how do you like to be led?<br />• Discover what holds you back - limiting beliefs<br />• Examine your core values -do they support your ambition?<br />• Explore the concept of Emotional Intelligence - how do we manage ourselves?<br />• Discover how to lead through change<br />• Explore the concept of 'Authentic Leadership' - consider how it can work for you<br />• Practice some of the skills essential to motivating and influencing for success<br />• Use the RAIV approach to generating enthusiasm and commitment<br />• Plan how best to 'walk the leadership talk' - in your role, in your organisation<p>Above all, this course will help you put theory into practice, values into actions, in a mature, considered, effective way.</p><section>
                    <h3>Day 1</h3> <h3>1 Welcome and introduction</h3><ul><li>Participants are welcomed to the programme and invited to share their personal objectives and people challenges</li><li>Participants given an action plan template to complete throughout the workshop</li><li>Participants required to bring an inspirational quote to share with the group</li></ul> <h3>2 What is leadership?</h3><ul><li>The concept of 'leadership'</li><li>The role of a leader</li><li>Skills assessment for all participants#</li><li>Leadership v Management</li><li>Assess your team effectiveness</li></ul> <h3>3 Your leadership style</h3><ul><li>Leadership questionnaire</li><li>You and your role models</li><li>Push v Pull styles of leadership</li><li>Empowerment v Control</li><li>Team goals and role profiling</li></ul> <h3>Day 2</h3> <h3>1 You, the leader</h3><ul><li>Your core values</li><li>Your communication style</li><li>Situational leadership</li><li>The Emotional Bank Account</li><li>Buy Me Today</li></ul> <h3>2 Are you Emotionally Intelligent? (EI)</h3><ul><li>What is emotional intelligence?</li><li>Self-assessment exercise</li><li>Manage your emotions</li><li>Nine strategies for promoting EI</li></ul> <h3>3 Leading through change</h3><ul><li>Identify the major changes affecting you / your team</li><li>Types of change</li><li>The roles of resistance</li><li>How safe are you to talk to?</li><li>Forcefield Analysis</li></ul> <h3>Day 3</h3> <h3>1 Authentic Leadership (AL)</h3><ul><li>What is AL?</li><li>Managing perceptions is managing their truth</li><li>A leadership challenge</li></ul> <h3>2 Motivating and influencing for success</h3><ul><li>What motivates you?</li><li>Motivational theory</li><li>Leading by example</li><li>Influencing skills required</li><li>Influencing styles</li><li>The influence challenge!</li></ul> <h3>3 Creating enthusiasm and commitment</h3><ul><li>The RAIV approach (relationships-achievement-independence-vocation)</li><li>Building self-worth</li><li>What drives your team?</li><li>Your leadership legacy</li><li>Your commitment to leadership</li></ul> 


                </section>

Global Leadership

Leadership

Leadership Skills

Project Leadership

Leadership Development

Leadership - turning values into action (In-House)

<p>This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations.</p>This programme will help you:<ul><li>Use a proven, structured tool-kit when designing and developing presentations</li><li>Benefit from short cuts and best practice when designing and using Powerpoint presentations</li><li>Select the right information, examples, exercises and activities - and use them well</li><li>Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives</li><li>Maintain audience or group interest</li><li>Develop and practise presentation skills to improve your voice tone, speech power and body language</li><li>Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility</li><li>Command a room, hold attention and create a high impact</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Personal objectives</li><li>Key messages and learning objectives of the workshop</li></ul> <h3>2 Presentation skills</h3><ul><li>What does good look like?</li><li>Exercise: Characteristics of high/low impact presentations</li><li>Presenting yourself as a 'winner'</li><li>The energy / attitude model</li><li>Exercise: Being a winner</li></ul> <h3>3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips</h3>•The magic circle<br />• How to 'assume the role' when presenting<br />• The eight steps<br />• Step 1 - develop your objectives<br />- The five questions that you must answer before preparing your presentation<br />- Defining your objectives and outcomes<br />- Creating a first draft<br />- Step 1 exercise<br />• Step 2 - analyse your audience<br />- Doing your homework: audience, event, venue<br />- Developing a pre-event check-list<br />- Methods and means for researching your audience<br />- Step 2 exercise<br />• Steps 3 and 4 - structure the main body of your presentation and state the main ideas<br />- Ways to structure your presentation for maximum impact<br />- Balancing and managing content and topics<br />- Organising your information: 6 options and methods<br />- Your 'one main point' and creating a 30-second summary<br />- Steps 3 and 4 exercises<br />• Step 5 - decide on supporting information, using the toolkit<br />- Making your case convincing: ways to support your claims<br />- Selecting and using relevant and interesting examples<br />- Quotes, case studies and printed material<br />- Presenting statistics, tables and graphs<br />- Ways of maintaining visual interest<br />- Transitions and links, creating a 'golden thread'<br />- Step 5 exercise: Creating compelling stories and anecdotes<br />4<br />• Step 6 - create an effective 'opening'<br />- Claiming the stage and creating a good first impression<br />- The three most powerful ways of opening a presentation<br />- The five elements of a strong opening<br />- Step 6 exercise: Participants work individually to prepare an opening, focusing on<br />personal introduction, and then deliver to the group, with structured feedback<br />• Step 7 - develop transitions<br />- Step 7 exercise / examples<br />• Step 8 - create an effective close<br />- Signalling and sign-posting; the importance of, and how to do it effectively<br />- Five ways to close a presentation successfully<br />- Step 8 exercise / examples<br />• Presentation design and Powerpoint<br />- An interactive review of participants' own real-life past presentations and advanced tips<br />and techniques on using Powerpoint effectively <h3>4 Facilitation skills</h3><ul><li>The three main types of group activity - triads, teams and main group</li><li>How to select the right activity, define the objectives, set it up and run the debrief</li><li>Using energisers - with examples</li><li>Exercise: Dealing with 'difficult' behaviours</li><li>Exercise: Working in triads, design and deliver</li></ul> <h3>5 Tips and tricks: presentation and facilitation</h3><ul><li>10 reasons why facilitation fails</li><li>Five golden rules for success</li><li>Defining the session goals and the facilitation plan</li><li>Open and closed questions - why and when to use</li><li>Using a 'car park' to manage unresolved issues</li><li>Using AV aids - tips and tricks</li><li>Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations</li></ul> <h3>6 Putting it all together</h3><ul><li>Summary of key learning points</li><li>Action plan</li></ul> 


                </section>

Executive Presentation

Facilitation Skills

Powerful presentation skills (In-House)

<p>R&amp;D work is often carried out in entrepreneurial companies with the aim of developing solutions to scientific or technological problems for a wide range of customers. Projects can include longer term 'frontiers of science' research, medium term product development/manufacturing or more immediate troubleshooting or contract research assignments.</p><p>In all these contexts, the ability to create innovative solutions in a timely and cost-effective manner is the essence of successful R&amp;D. Whilst R&amp;D groups typically excel in technical expertise, those involved often recognise that there is scope for improving the way that projects are managed. The aim of this training programme is to address this need whilst ensuring that the creative, entrepreneurial spirit that is fundamental to good R&amp;D continues to flourish.</p><section>
                    MODULE 1: Creating the foundations for success <ul><li>Off-line video tutorials and exercises</li><li>Total time ~ 1 - 1.5 hours</li></ul> 	<i></i><h3>Video 1: Making the most of project management in R&amp;D</h3><ul><li>Characterising R&amp;D projects</li><li>Applying project management to R&amp;D work</li><li>Exploiting the potential of project management in R&amp;D</li></ul> 	<i></i><h3>Video 2: Promoting success in R&amp;D project management</h3><ul><li>Modelling successful project management</li><li>Evaluating performance and promoting success</li><li>The role and skills of the project manager/leader</li></ul> MODULE 2: Initiating and defining R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Selecting and initiating projects</h3><ul><li>Recognising worthwhile opportunities; initiating projects</li><li>Identifying stakeholders and their goals</li><li>Characterising and engaging stakeholders</li></ul> <h3>Session 2: Defining goals and agreeing deliverables</h3><ul><li>Establishing the full scope of the project</li><li>Clarifying and prioritising project deliverables</li><li>Defining and agreeing deliverable specifications</li></ul> MODULE 3: Planning R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Identifying and organising activities</h3><ul><li>Creating effective plans; avoiding planning pitfalls</li><li>Identifying tasks and assigning responsibilities</li><li>Sequencing tasks and estimating durations</li></ul> <h3>Session 2: Developing the timeline and resource plan</h3><ul><li>Identifying the 'critical path'; creating a resource plan</li><li>Dealing with estimating uncertainty</li><li>Accelerating the programme</li></ul> MODULE 4: Leadership and teamwork in R&amp;D projects <ul><li><strong>Off-line </strong>video tutorials and exercises</li><li>Total time ~ 1 - 1.5 hours</li></ul> 	<i></i><h3>Video 1: Working effectively in project teams</h3><ul><li>Building teamwork in contemporary organisations</li><li>Recognising each other's skills; building synergy</li><li>Building good working relationships; handling conflict</li></ul> 	<i></i><h3>Video 2: The role of the R&amp;D project team leader</h3><ul><li>Building teamwork: the role of leadership</li><li>Creating an effective team culture</li><li>Delegating work and motivating team members</li></ul> MODULE 5: Managing uncertainty in R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Characterising uncertainty; identifying risks</h3><ul><li>Exploring uncertainty; applying risk management</li><li>Focusing the risk management process</li><li>Identifying and defining risk events</li></ul> <h3>Session 2: Managing and controlling risks to the project</h3><ul><li>Evaluating risk events</li><li>Selecting between risk strategies; setting contingencies</li><li>Updating and controlling exposure to risk</li></ul> MODULE 6: Implementing and controlling R&amp;D projects <ul><li>Live interactive sessions (via Zoom):</li><li>Session 1: 10:00 - 12:00</li><li>Session 2: 14:00 - 15:30</li></ul> <h3>Session 1: Initiating assignments and managing changes</h3><ul><li>Creating a pro-active implementation and control culture</li><li>Establishing effective implementation and control procedures</li><li>Assigning work and managing changes</li></ul> <h3>Session 2: Monitoring, managing and developing performance</h3><ul><li>Adopting meaningful monitoring techniques</li><li>Responding to problems; building performance</li><li>Managing and controlling multiple project assignments</li></ul> 


                </section>

Learning & Development

Online Course Creation

Project Management

Manager Training

R&D project management (In-House)

<p>What do engineers and project managers need to know of finance? 'Nothing - leave it to the accountants!'</p><p>No, no, no! Engineers must be conversant with the terminology and statements that accountants use. Technical expertise in projects, service delivery, production or other areas can only really be harnessed if the managers understand the accounting and reporting that drives businesses.</p><p>This course gives the necessary understanding to project, production and technical managers. It develops their skills in understanding financial and management accounting.</p><p>Accountants may not always like it but a major part of their work is to be the 'servants of business' and to gather, compile and present your figures. So you must understand the figures - they belong to you, your processes or projects. There are many reasons for maintaining accurate accounts. This course focuses on the strategic issues (those over-used words) - what figures reveal about the drivers of business and what they reveal about the day-to-day issues that accountants bother you with. The course will enhance your understanding of finance and of the accounting issues which affect your projects, production and technical areas of business.</p>This course will help you:<ul><li>Understand the business world in figures - make sense of what the accountants are telling you</li><li>Appreciate what drives business - and how this affects your role in your part of the business</li><li>Relate your activities to the success of the business - through figures</li><li>Gain the skills to advance in management - financial awareness is a 'must have' if you are to progress in your career</li></ul><section>
                    <h3>1 What do accountants do?</h3><ul><li>The finance function, types of accountant, financial v management accounting and the treasury function</li><li>Understanding the role of the finance function and how the information you provide may be used</li></ul> <h3>2 The basic financial statements</h3><ul><li>Balance sheets and income statements (P&amp;L accounts)</li><li>What they are, what they contain and above all what they can reveal - how to read them</li><li>The accounting process - from transactions to financial statements</li><li>What underpins the statements - accounting systems and internal controls</li></ul> <h3>3 Why be in business - from a financial perspective</h3><ul><li>The driving forces behind financial information</li><li>Performance measures - profitability, asset utilisation, sales and throughput, managing capital expenditure</li></ul> <h3>4 Accounting rules - accounting standards</h3><ul><li>Accounting concepts and the accounting rules: accruals, 'going concern' - substance over form and other 'desirable qualities'</li><li>Accruals - why the timing of a transaction is so important to the finance function</li><li>Depreciation and amortisation - the concepts and practice</li><li>Accounting standards - the role of International Financial Reporting Standards</li></ul> <h3>5 Cash</h3><ul><li>The importance of cash flow - working capital management</li><li>Cash flow statements - monitoring overall cash flows</li><li>Raising cash - levels of borrowing, gearing</li><li>Spending cash - an outline of capital expenditure appraisal</li></ul> <h3>6 Budgeting</h3><ul><li>Why budget? - good and bad practice</li><li>Determining why budgets play a key role and should not be simply an annual ritual</li><li>Justifying your budgets - the link between the strategic plan and day-to-day budgeting - alignment of company culture</li><li>Budgets as motivators - the importance of the right culture</li><li>Techniques to improve budgeting - whether day-to-day or capital budgeting</li></ul> <h3>7 Costing</h3><ul><li>The type and detail of costing very much depends on your business - eg, manufacturing piston rings is quite different from the construction of a power plant</li><li>Issues with overhead allocation</li><li>Accounting for R&amp;D</li></ul> <h3>8 Reading financial statements</h3><ul><li>Annual financial statements - why they are produced, what's in them and what you should look for</li><li>Learning what a set of accounts reveals about a company's current situation, profitability and future prospects</li></ul> <h3>9 Performance measurement - analytical reviews and ratio analysis</h3><ul><li>ROI/ROCE</li><li>Profitability, margins and cost control</li><li>Sales - asset turnover</li><li>Efficiency (asset / stock turnover, debtor / creditor days)</li><li>'City' measures</li><li>Investment (interest / dividend cover, earnings per share, dividend yield)</li></ul> 


                </section>

Accounting & Finance

Business Accounting

Corporate Finance Level 1

Finance For Non Finance Managers

Financial Accounting

Practical Accounting

Finance for project managers and engineers (In-House)

<p>The leadership role of the project manager is increasingly recognised as a key determinant in delivering success. These skills can often be critical in project situations, where tight budgets and deadlines demand the highest levels of team performance and where the working environment presents fresh challenges on a daily basis.</p><p>This programme focuses on the leadership skills required of project managers and will benefit anyone involved in managing projects large or small wishing to extend or enhance those skills.</p>The objectives of this programme are to help the participants:<ul><li>Understand the significance of leadership skills to the project manager and the impact of these skills on project performance</li><li>Review the key skills needed to be an effective 'multi-dimensional' project leader and learn how to develop, adapt and apply them in practice</li><li>Learn how to identify the preferred leadership style for the context and organisational culture of a project and how to develop personal style versatility</li><li>Understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance</li><li>Gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team</li></ul><section>
                    DAY ONE <h3>1 Introduction</h3><ul><li>Aims and objectives</li><li>Personal objectives</li></ul> <h3>2 Project management and leadership</h3><ul><li>What is a leader? How much can leadership be learned?</li><li>The project environment and the impact of leadership skills</li><li>The characteristics of high performance project teams and their leaders</li></ul> <h3>3 Principles of effective leadership</h3><ul><li>Some useful models and theories of leadership explored</li><li>Types of leadership; choosing how to use leadership power</li><li>Evaluating personal leadership style; how to develop style flexibility</li></ul> <h3>4 Syndicate case study: Leadership in action</h3><ul><li>Review of the role of leadership in a contemporary project</li><li>Feedback and plenary discussion: effective project leadership</li></ul> <h3>5 Team exercise: Leadership skills of the project manager</h3><ul><li>Teams compete in performing a project simulation</li><li>Project review and feedback</li><li>Discussion of the outcome: role and skills of the project leader</li></ul> <h3>6 Leadership skills for project managers</h3><ul><li>The 3 dimensions of project leadership: inwards, outwards, and upwards</li><li>The vital role of communication skills and how to develop them</li><li>Developing a 'project vision': strategic thinking skills</li><li>Understanding others; emotional intelligence skills</li><li>Being a visible leader; behavioural and influencing skills</li><li>Building effective relationships; the importance of trust and respect</li></ul> DAY TWO <h3>7 Leading the project team</h3><ul><li>The role of leadership in developing team performance</li><li>Understanding individual strengths; recognising team role preferences</li><li>Managing conflict and promoting positive team dynamics</li><li>Setting standards, maintaining discipline and rewarding performance</li><li>Harnessing team potential: building motivation within the team</li><li>Promoting team learning; the team leader as coach / mentor</li></ul> <h3>8 Leading through the organisation</h3><ul><li>Gaining the support others; developing effective influencing skills</li><li>Getting empowerment from key stakeholders</li><li>Knowing when and how to take the initiative and lead</li><li>Building and maintaining rapport with key partners</li><li>Becoming an effective team player in leadership teams</li><li>Becoming a business leader; leading colleagues and co-workers</li></ul> <h3>9 Team exercise: Leadership and negotiation</h3><ul><li>Teams engage in a negotiation exercise</li><li>Exercise review and feedback</li><li>Discussion of the outcome: negotiation skills of the project leader</li></ul> <h3>10 Negotiation skills for project leaders</h3><ul><li>Characteristics of effective negotiators</li><li>Classic problem behaviours and mind-sets to avoid</li><li>Getting to win-win; building partnership and trust</li></ul> <h3>11 Leading more senior stakeholders</h3><ul><li>The challenges and skills of leading and managing upwards</li><li>Communicating with more senior stakeholders; building credibility</li><li>Negotiating upwards: knowing when and how</li><li>The role of networking skills; building and maintaining rapport</li><li>Handling disagreements; the art of diplomacy</li><li>Handling personality and style conflicts with more senior people</li></ul> 


                </section>

Team Leading

Organisational Skills

Effective project leadership (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.

433 Courses in Belfast

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

Leadership - turning values into action (In-House)

By The In House Training Company

Powerful presentation skills (In-House)

By The In House Training Company

R&D project management (In-House)

By The In House Training Company

Finance for project managers and engineers (In-House)

By The In House Training Company

Effective project leadership (In-House)

By The In House Training Company

Search By Location