Name: Master Business Networking in Just 1 Day - Join our Workshop in Worcester
Price: 595 GBP
Availability: InStock

Nottingham

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Overview:</h1>This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.Course Contents:Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.Course Topics:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Qualities of an Effective Leader&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Leader or Manager?&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">That Vision Thing&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Developing Your Team Goals&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivation&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">What Motivates?&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Being Consistently Different&nbsp;&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Dealing With Difficult Team Members&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coaching&nbsp;&ndash; Using a simple method of coaching, including action plans.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Three Key Skills of Coaching&nbsp;&ndash; Looking at the skills required to be an effective coach.</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Instant Results Coaching&nbsp;&ndash; Coaching in a hurry!</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Can Do Coaching Practice&nbsp;&ndash; Putting the learning into practice</li></ul>Course Feature:By the end of this training you will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</li></ul>Certification:Once after the training you receive course completion certificate from MangatesWho can Attend?Anybody who is interested in learning Effective Skills to Lead a Team.

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
Communication Skills are the most highly valued skills in today’s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.
Communication Skills intensive is a cutting edge training program designed to help today’s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.
You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It’s never too late to work on your communication skills and by doing so improve your quality of life.
Learning Objectives:
Script yourself with clear, compelling and well-developed messages that reflect your thinking .
Speak with vision and a logical structure that drives home your points.
Answer questions confidently.
Develop professional relationships and networks.
Communicate with empathy and compassion .
Inspire people by appealing to their emotions.
Move from an informational to an inspirational and action oriented style when creating and delivering presentations.
Integrate effective slides into your presentations.
Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.
Target Audience:
There is no Eligibility Criteria for this training, anyone can attend this training
Agenda:
The Science of Effective Human Communication
Frames of Business and Communication
Principles and Strategies for Effective Business Conversations
Art of Giving and Receiving Feedback
How to Listen Effectively and Accurately
Science of Body Language
How to look confident and charismatic
Business Presentation Skills and Strategies
Powerpoint Best Practices
Principles and Techniques for Effective Written Communication
How to write clear, concise and fast at the same time

Mangates

Communication

Coaching Skills

Communication Skills 1 Day Training in Nottingham


































































The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Ipswich

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Lunch and Beverages are included in a classroom session
Course Delivery: Classroom | Virtual Live
Course Overview:
Communication Skills are the most highly valued skills in today’s business environment. Successful professionals who add value to their companies communicate clearly, accurately and effectively. Poor communication skills, on the other hand, restrict even the most talented professionals from getting ahead in the business world.
Communication Skills intensive is a cutting edge training program designed to help today’s business professionals take their communication skills and effectiveness to the next level. It immerses you into the most advanced and innovative communication techniques.
You will dive deep into all forms of verbal, non-verbal and written communication, and come out with a developed sense of personal communication style that will help you to connect with, communicate to, and inspire people around you. The ability to communicate information accurately, clearly and as intended, is a vital life skill and something that should not be overlooked. It’s never too late to work on your communication skills and by doing so improve your quality of life.
Learning Objectives:
Script yourself with clear, compelling and well-developed messages that reflect your thinking .
Speak with vision and a logical structure that drives home your points.
Answer questions confidently.
Develop professional relationships and networks.
Communicate with empathy and compassion .
Inspire people by appealing to their emotions.
Move from an informational to an inspirational and action oriented style when creating and delivering presentations.
Integrate effective slides into your presentations.
Become a more powerful leader and communicator by applying effective strategic planning and writing tactics for enhanced writing speed and fluency.
Target Audience:
There is no Eligibility Criteria for this training, anyone can attend this training
Agenda:
The Science of Effective Human Communication
Frames of Business and Communication
Principles and Strategies for Effective Business Conversations
Art of Giving and Receiving Feedback
How to Listen Effectively and Accurately
Science of Body Language
How to look confident and charismatic
Business Presentation Skills and Strategies
Powerpoint Best Practices
Principles and Techniques for Effective Written Communication
How to write clear, concise and fast at the same time

Communication Skills 1 Day Training in Ipswich





















































Real Estate Financial Modelling School (5 days)The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.The school combines three of our courses:<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;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</li></ul> All of the courses are interlinked to give you a full understanding of the subject using Excel. On this course you will&hellip;<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</li></ul> Who will benefit from this school?<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" 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="2" 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="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</li></ul> Course OutlineDay OneReal Estate Analyst IKnow how to build a property asset cash flow, analyse geared, and un-geared IRRs.<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> Day TwoReal Estate Analyst IIKnow how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.<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> Day ThreeReal Estate Investor I<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</li></ul> Day FourReal Estate Investor II<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</li></ul> Day FiveReal Estate Modelling Masterclass<ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul> Included in the Course<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> For more information about the Real Estate Financial Modelling School such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:E - s.musgrave@bayfieldtraining.comT - 01223 517851W - <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>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


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 Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


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


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

Bayfield Training

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

General Admission

Kingston upon Hull

Course Overview:According to a 1973 survey by the Sunday Times of London, 41% of people list public speaking as their biggest fear. Forget small spaces, darkness, and spiders, standing up in front of a crowd and talking is far more terrifying for most people. Through this workshop you will become more confident and relaxed in front of an audience which will translate into a successful speaking event.However, mastering this fear and getting comfortable speaking in public can be a great ego booster, not to mention a huge benefit to your career. The Public Speaking workshop will give participants some public speaking skills, including in-depth information on developing an engaging program and delivering their presentation with power.Learning Objectives:Inside This Training, You&#39;ll Learn<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Completely remove your stage fear and become a dynamic speaker</li><li fr-original-style="" style="box-sizing: border-box;">Raise your confidence up to a level you never thought to be possible!</li><li fr-original-style="" style="box-sizing: border-box;">Deeper insights into group dynamics</li><li fr-original-style="" style="box-sizing: border-box;">Presentation design, skills &amp; styles</li><li fr-original-style="" style="box-sizing: border-box;">Tools to get your audience to say yes to you</li><li fr-original-style="" style="box-sizing: border-box;">Advanced new behavior patterns required for public speaking</li><li fr-original-style="" style="box-sizing: border-box;">Control time for effective training</li><li fr-original-style="" style="box-sizing: border-box;">Secrets of mind control techniques</li><li fr-original-style="" style="box-sizing: border-box;">Develop your personal winning style</li></ul>Prerequisites:NoneCourse Materials:Attendees will receive a course manual with presentation slides and reference materials.Agenda:Module One: Identifying Your Audience<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Performing a Needs Analysis</li><li fr-original-style="" style="box-sizing: border-box;">Creating an Audience Profile</li><li fr-original-style="" style="box-sizing: border-box;">Identifying Key Questions and Concerns</li></ul>Module Two: Creating a Basic Outline<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Outlining the Situation</li><li fr-original-style="" style="box-sizing: border-box;">Identifying the Task That Had to Be Performed</li><li fr-original-style="" style="box-sizing: border-box;">Listing the Actions You Took</li><li fr-original-style="" style="box-sizing: border-box;">Revealing the Results</li></ul>Module Three: Organizing the Program<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Making Organization Easy</li><li fr-original-style="" style="box-sizing: border-box;">Organizational Methods</li><li fr-original-style="" style="box-sizing: border-box;">Classifying and Categorizing</li></ul>Module Four: Fleshing It Out<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Identifying Appropriate Sources</li><li fr-original-style="" style="box-sizing: border-box;">Establishing Credibility</li><li fr-original-style="" style="box-sizing: border-box;">The Importance of Citations</li></ul>Module Five: Putting It All Together<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">&nbsp;Writing Your Presentation</li><li fr-original-style="" style="box-sizing: border-box;">Adding a Plan B</li><li fr-original-style="" style="box-sizing: border-box;">Reviewing, Editing, and Rewriting</li></ul>Module Six: Being Prepared<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Checking Out the Venue</li><li fr-original-style="" style="box-sizing: border-box;">Gathering Materials</li><li fr-original-style="" style="box-sizing: border-box;">A 24 Hour Checklist</li></ul>Module Seven: Overcoming Nervousness<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">A Visit from the Boss</li><li fr-original-style="" style="box-sizing: border-box;">Preparing Mentally</li><li fr-original-style="" style="box-sizing: border-box;">Physical Relaxation Techniques</li><li fr-original-style="" style="box-sizing: border-box;">Appearing Confident in Front of the Crowd (Even If You Don&acirc;&euro;&trade;t Feel That Way)</li></ul>Module Eight: Delivering Your Speech (I)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Starting Off on the Right Foot</li><li fr-original-style="" style="box-sizing: border-box;">Using Visual Aids</li><li fr-original-style="" style="box-sizing: border-box;">Checking the Volume of Your Voice</li></ul>Module Nine: Delivering Your Speech (II)<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Adjusting on the Fly</li><li fr-original-style="" style="box-sizing: border-box;">Gauging Whether Breaks Are Required</li><li fr-original-style="" style="box-sizing: border-box;">Wrapping Up and Winding Down</li></ul>Module Ten: Questions and Answers<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Ground Rules</li><li fr-original-style="" style="box-sizing: border-box;">Answering Questions That Sound Like an Attack</li><li fr-original-style="" style="box-sizing: border-box;">Dealing with Complex Questions</li></ul>Module Eleven: Wrapping Up<ul type="disc" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Words from the Wise</li><li fr-original-style="" style="box-sizing: border-box;">Review of Parking Lot</li><li fr-original-style="" style="box-sizing: border-box;">Lessons Learned</li><li fr-original-style="" style="box-sizing: border-box;">Completion of Action Plans and Evaluations</li></ul>Target Audience:Anybody who is interested in Public Speaking Skills.Technical Requirements:For eBooks:Internet for downloading the eBookLaptop, tablet, Smartphone, eReader (No Kindle)Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)eBook download and activation instructions

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
This networking skills training will help you to build a professional reputation and develop a network of connections through the two key methods available to you; face-to-face and online.
You will discover how to effectively combine these two approaches and create a strategy for networking success that will generate your own community and actively grow your personal network. This will result in an improved performance in your approach to networking and consequently provide opportunities and prospects that will increase your business success.
The training provides you with the tools and techniques to both plan a successful, strategic approach to networking and develop your personal communication skills, which will ensure you build effective business relationships.
Course Contents:
Effective Networking Strategies and Techniques – Business Networking Training
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We provide you with a comprehensive networking skills training course to make your life easy.
This business networking training is aimed at helping you develop your business or career. You will help ensure you have the skills, knowledge and techniques to develop a joined-up networking strategy that gets you the outcomes you want.
You will also be encouraged to develop the correct behaviours and attitudes to help build your visibility and credibility through networking so that you develop strong working relationships that last.
Course Topics:
Why Network? – Establishing the importance of networking with some shocking statistics and an activity that defines the importance of networking to the individual. This is followed by some insight into the key aims of a networking strategy, what puts people off as well as some personal revelations about networking
Increase Your Business Presence – Looking at the components of a strong business presence, including; credibility, personal brand, visibility and social capital.
Developing a Networkers Attitude – An exercise that clarifies the perfect attitudes and behaviours of great networkers and comparing the participants against this. Thus identifying areas for development.
Face to Face Networking – An overview and insight into the main types of face to face networking opportunities available with the benefits and pitfalls of each.
Online Networking – An overview of the different social media and online networking tools and how to get the best out of them. Includes; LinkedIn, Twitter, Facebook and online forums.
Communication Skills for Networking Success – Ensuring a good first impression, creating an opening sound bite and writing an online profile that promotes and engages.
Developing a Conversation – Building on the opening sound bite and developing a conversation through good questioning techniques and following a selection of key networking rules. Including an activity to test and practice the skills.
Working a Room – A fun activity that embeds and develops learning while encouraging practice and communication. This activity covers 10 of the main skills required to work a room.
Breaking into a Group – Identifying body language to spot when a group or pair is open to new people entering the conversation or would rather not encourage participation. Knowing how to break into a group, what to say and how to remain professional.
Exiting a Conversation – Developing some techniques to extricate oneself from a conversation without causing embarrassment or rudeness.
The Follow Up – Using a structure to identify the most important contacts created and establishing when and how to follow up with each group. Includes example follow up email and a chance to develop their own.
Creating a Network Plan – Participants are provided with a networking action plan to review and complete. This sets them on the journey of developing their networking skills and ensures they have a strategy and goals to target.
This training is highly interactive and includes lots of activities and exercises to stimulate discussion and develop learning opportunities.
Networking has become a crucial factor in the modern workplace. It is the most effective method of developing your business or career and is a key component of your personal brand. You need to be able to build strong business relationships, develop a level of personal credibility and increase your network of contacts in order to enhance your visibility and create opportunities for yourself and your organisation.
Perhaps you’re looking to improve the networking performance of a management or sales team. Or you want to include networking skills training as part of management and leadership training programmes. Whatever your need, We will provide you with a comprehensive networking skills training course to make your life easy.
Course Feature:
At the end of this business networking skills training, you will be able to:
Develop a successful networking strategy
Maximise their effectiveness with face-to-face and online networking opportunities
Improve their approach, attitude and behaviours when networking
Create a plan for networking that will help them meet their goals
Certification:
Once after the training you receive course completion certificate from Mangates
Who can Attend?
Anybody who is interested in learning Business Networking Skills.

Networking Skills

Business & Marketing

Business Networking 1 Day Training in Kingston upon Hull

Master Business Networking in Just 1 Day - Join our Workshop in Kingston upon Hull

High Wycombe 

Business Networking 1 Day Training in High Wycombe

Master Business Networking in Just 1 Day - Join our Workshop in High Wycombe

Aberystwyth

Business Networking 1 Day Training in Guildford

Master Business Networking in Just 1 Day - Join our Workshop in Guildford

Business Networking 1 Day Training in Exeter

Master Business Networking in Just 1 Day - Join our Workshop in Exeter

Dundee

Business Networking 1 Day Training in Dundee

Master Business Networking in Just 1 Day - Join our Workshop in Dundee

Cirencester

Business Networking 1 Day Training in Cirencester

Master Business Networking in Just 1 Day - Join our Workshop in Cirencester

Worcester

Business Networking 1 Day Training in Worcester

Master Business Networking in Just 1 Day - Join our Workshop in Worcester

Chesterfield

Diabetes and Nutrition: Science-Based Strategies for Blood Sugar Control


This course provides in-depth guidance on how nutrition influences diabetes management. Learn practical strategies to regulate blood sugar and improve overall health.

½ day course (face to face classroom)
2 x 2 hr sessions (virtual classroom)
Learn about diabetes
Learn how food affects blood sugar levels
Learn how many calories you actually need
Understand nutrition and how it relates to diabetes
Learn about food labeling and how to use this information to improve your blood sugar levels
Session Contents
Introduction to Diabetes and Relevant Statistics.
What is Diabetes, Different Types of Diabetes, Risk Factors for Diabetes
Affects of uncontrolled Diabetes on the Body
Diabetes Blood Sugar Control
Type 2 Remission
Basal Metabolic Rate (BMR) and Energy Expenditure
How sugars break down
Food Labelling
Essential Nutrients
Balanced Diet
How to Apply this Knowledge in Daily Life
Who Is This Course For?
People newly diagnosed with diabetes
Individuals managing diabetes
Health-conscious individuals focused on prevention
Healthcare professionals and nutritionists
Benefits of this Course:
Expert-led, research-backed information
Practical, real-life meal planning tips
Science-based strategies to improve health
Run with a fully qualified Nutritionist

This Diabetes and Nutrition Course is a CPD Accredited course. We are a CPD accredited Centre via the CPD Accreditation Office.

Pochat Training

Food & Nutrition

Obesity & Diabetes

Health & Nutrition

Nutritional

Diabetes

Obesity

Nutrition

Endocrinology, Diabetes & Metabolism

Nutrition & Diet

Did you know your diet plays a huge role in managing diabetes? 🍏 Learn how in our expert-led course!

Diabetes and Nutrition

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.Pilates help you build up your core strength, improves posture and breath as well as helping you become more aware of how your body react to movement.If you work from home or are just wanting to move more, then look no furtherA pre-course registration form should be filled out prior to attending a class.Form can be found here: <a href="https://forms.gle/CrDwjPxLk8xgo7eP9" id="isPasted" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">https://forms.gle/CrDwjPxLk8xgo7eP9</a>

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.
Pilates help you build up your core strength, improves posture and breath as well as helping you become more aware of how your body react to movement.
If you work from home or are just wanting to move more, then look no further
A pre-course registration form should be filled out prior to attending a class.
Form can be found here: https://forms.gle/CrDwjPxLk8xgo7eP9

For A Better You - Pilates & Pelvic Floor Health 

Pilates

Health & Fitness

Pelvic Floor

Pilates is a great way to get your body moving, with low resistance body weight exercises it is suitable for any fitness level.

If you work from home or are just wanted to improve yourself then look no further

Pilates - Mixed Ability - ONLINE

Clay Cross

The Emergency Lighting BS 5266 one day course is based upon BS5266:1 (including latest amendments), BS5266:7 and BS5266:8. Emergency lighting is essential for the safety of building occupants. It is vital that the emergency lighting automatically operates in the event of normal lighting failure. The illumination levels and period of time the illumination can be sustained should be sufficient to allow the building occupants to evacuate safely and locate both fire alarm, fire fighting and first aid equipment. The Emergency Lighting BS 5266 course provides the necessary information to designate emergency escape routes and design and commission an emergency lighting scheme to BS 5266. The morning of the Emergency Lighting BS 5266 course is spent reading through and interpreting the relevant parts of BS 5266. The afternoon takes the form of a practical workshop where a system is designed and the participant is then introduced to the practical issues of commissioning, inspection and testing, certification and reporting.

Technique Learning Solutions

Emergency Lighting

Chelmsford

Stratford

Our CITB Online - Site Supervisors’ Safety Training Scheme (SSSTS) Refresher course is designed to give attendees a broad reminder of their responsibilities for health and safety on construction sites. Approved and endorsed by the United Kingdom Contractors Group, the SSSTS refresher course is a must for anyone who occupies a supervisory role on UKCG sites and wants to brush up on their knowledge of their legal responsibilities and the latest construction industry regulations.
The SSSTS Refresher course has been created to provide existing supervisors, or those who are just entering into a supervisory role, with in-depth knowledge of health and safety legislation and procedures. If a candidate completed a full SSSTS training course up to 5 years ago, they will be required to attend a refresher programme.
Prerequisites
SSSTS certificates are of course valid for up to 5 years, but due to the ever-changing nature of the industry, it is recommended that staff stay up to date by enrolling on a refresher course long before the qualification expires.
Instructions
Please note all Site Supervisor Training courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

SMC Safety Solutions

Site Supervisor Training Scheme (SSSTS) Refresher

This one-day course is a must for anyone considering or already working within a construction or civil engineering environment. This course provides Health and Safety awareness and is endorsed by Build UK as a standard training for all operatives on site.
Aims
To give a clear understanding of Regulations & Legislation that applies to construction work and is an ideal refresher for any operative that has previously completed training in Health & Safety.
Course Content
• Accident prevention
• Health & Safety law
• Control and management of the site and your how your role fits in with this
• Risk assessments and method statements
• Performing safely on site
• Reporting unsafe acts to prevent an accident
• Individual & employee responsibilities
• What to do if you think anyone’s Health and Safety is being put at risk
Assessment
At the end of this course, all delegates will have a clear understanding of the requirements of Health and Safety Legislation and their responsibilities to comply with them.
Candidates will need to complete a multiple-choice exam at the end of the CITB course. They will also need to engage and interact with others throughout the day.
Certificate
This certification for this course is valid for 5 years and is endorsed by Build UK as a standard training for all operatives. The certificate is part of CSCS Green Card requirements.
To remain certified in this area, you will need to retake the course before the expiry date or have completed an NVQ2 or higher in your skills set.
Instructions
Please note all Health & Safety Awareness courses with the venue “Remote Learning” will be delivered by a tutor over a video call.
This training will be delivered and assessed in English language; therefore, a good standard is required to complete the course.
Further attendee information will be sent in a separate email, please check your inbox.

Health & Safety Awareness (for Green CSCS)

IT Cyber Security Engineer – Job Ready Programme
Enrol in Our IT Cyber Security Engineer – Job Ready Programme with Career Support!
Gain access to 3,000+ online courses and earn Free Certificates to showcase your skills and boost your career potential.
Step into the high-demand world of cyber security with a comprehensive programme designed for the UK job market. Master critical areas like penetration testing, secure cloud architecture, AI-powered threat detection, and GDPR compliance—skills that can lead to roles earning up to £95,000 a year.
As UK businesses face £27 billion in cybercrime losses annually, the demand for skilled IT Cyber Security Engineers has never been greater. Whether you're changing careers or upskilling, this course equips you with in-demand expertise in threat intelligence, cryptography, and secure coding.
Become the digital defence every company needs. Start your journey toward a resilient and rewarding career in cyber security today.

Professional Diploma in IT Cyber Security Engineer – 25 Core Courses
– Course 01: Cyber Security Online Course: DOSS and DDOS
– Course 02: Cyber Security Training: Incident Handling & Response
– Course 03: Security Threat Management
– Course 04: Certified Information Security Manager (CISM)
– Course 05: Certified Information Systems Security Professional (CISSP)
– Course 06: CompTIA Advanced Security Practitioner (CASP)
– Course 07: Computer Network Security Complete Training
– Course 08: CyberSec First Responder: Threat Detection and Response [QLS Level 7]
– Course 09: Bash Scripting and Shell Programming for Beginners
– Course 10: Ethical Hacking Masterclass
– Course 11: CompTIA PenTest+ Ethical Hacking Course
– Course 12: BlackArch Linux: Ethical Hacking and Penetration Testing
– Course 13: Ultimate Linux Security and Hardening Training
– Course 14: The Complete Python Hacking Course: Beginner to Advanced!
– Course 15: SQL Database Basics
– Course 16: CompTIA Network+ Certification (N10-008)
– Course 17: CompTIA A+ Core 1 (220-1101) Course
– Course 18: CompTIA A+ Core 2 (220-1102) Course
– Course 19: CompTIA Security+ (SY0-601)
– Course 20: CompTIA Cloud+ CV0-002 Course
– Course 21: Cisco CCENT/CCNA Interconnecting Cisco Networking Devices Part 1
– Course 22: Cisco CCNA Interconnecting Cisco Networking Devices Part 2 (ICND2) Training
– Course 23: Cisco ASA Firewall Training with Step-by-Step Lab Workbook
– Course 24: FortiGate Firewall Training Step-by-Step Lab Workbook
– Course 25: Palo Alto Firewall Training with Step-by-Step Lab Workbook
Job Readiness & Career Development Training (Complementary)
– Course 01: Career Development Training
– Course 02: Effective CV Writing
– Course 03: CV Writing and Interview Tricks
– Course 04: Ace the Interview – Interview Prep That Makes a Difference
– Course 05: Job Search Skills
– Course 06: Effective Communication Skills for Professionals
– Course 07: Boost Your Confidence, Assertiveness
– Course 08: Body Language Secrets
– Course 09: Coaching and Mentoring
– Course 10: Presentation Skills – Present like a Pro
– Course 11: Public Speaking Course
– Course 12: Project Management Training
– Course 13: Leadership & Management
– Course 14: Negotiation and Agreement Training
– Course 15: Workplace Equality & Diversity
– Course 16: Professional Development and Personal Well-being
– Course 17: Emotional Intelligence and Human Behaviour
– Course 18: Time Management: Step By Step Training
– Course 19: Cross-Cultural Awareness
– Course 20: Productivity Boosting
– Course 21: Critical Thinking & Problem Solving
– Course 22: Perfect LinkedIn Profile Creation
– Course 23: Resume Writing Skills & Job Search With LinkedIn
– Course 24: Email Writing
– Course 25: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes!

Skill Up

IT Cyber Security Engineer – Job Ready Programme

Programme With Certification

Programme Without Certification

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'>Explainer Video:

<iframe width="560" height="315" src="https://www.youtube.com/embed/VQoRbCSm_0s?si=pTTAJBNdO9vq1joy" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;"></iframe>

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'> If you&#39;re familiar with OBS Studio, you&#39;re already aware of its incredible capabilities for effortless video creation.

For those who haven&#39;t yet discovered it, it&#39;s worth exploring.

OBS Studio, a completely FREE software, empowers you to craft and record videos in a matter of minutes.

Benefits of attending this workshop:

By the end of this workshop, you will be able to effortlessly capture your video while seamlessly integrating animated text and images with just a click. Capture your screen, zoom in on specific elements, and even play videos while recording your content.

Say goodbye to the hassle of editing and filming separate segments. Simply set it up, hit the record button, and deliver your video.

We&#39;re hosting exclusive, interactive training sessions on this fantastic product throughout the year. This unique format allows you to ask questions as we progress through the course material.



Start creating videos for your business using OBS Studio, it&#39;s easier than you think.

Explainer Video:


If you're familiar with OBS Studio, you're already aware of its incredible capabilities for effortless video creation.
For those who haven't yet discovered it, it's worth exploring.
OBS Studio, a completely FREE software, empowers you to craft and record videos in a matter of minutes.
Benefits of attending this workshop:
By the end of this workshop, you will be able to effortlessly capture your video while seamlessly integrating animated text and images with just a click. Capture your screen, zoom in on specific elements, and even play videos while recording your content.
Say goodbye to the hassle of editing and filming separate segments. Simply set it up, hit the record button, and deliver your video.
We're hosting exclusive, interactive training sessions on this fantastic product throughout the year. This unique format allows you to ask questions as we progress through the course material.
Start creating videos for your business using OBS Studio, it's easier than you think.

Clockwork Eye Video

Video

Video Marketing

Video Creation

Mobile Video Production

Video Design

Video Production

Video Editing

Video & Mobile Marketing

Learn how to create video content easily using this FREE to use software. Create videos for your business and start improving your marketing. This interactive workshop allows you to ask questions as we progress through the course material.

Creating Videos With OBS Studio (Interactive Workshop)

London

<div>
	 <h5>Excel Macros and VBA Course summary</h5>
	 </div>
	 <div></div>
	 
				 
				 For Excel users. Extend the capabilities of Excel with Macros and VBA code.
	 

				 
				 
				 
	 <div>
	 <div>
	 <h5>Excel Macros and VBA Course Description</h5>
	 </div>
	 <div></div>
	 
	 
					 
					 
					 
	 

	 		 Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

						 Setting Excel Macro Options
						 Record and Run Simple Macros
						 Assign Macros to the Quick Access Toolbar

					 Introduction to the Excel VBA Editor

					 Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

						 Starting the Visual Basic Editor
						 Using the Project Explorer
						 Using the Properties Window
 

					 Creating Procedures and Functions

					 Create simple macro procedures in code that use variable to store data and communicate with the user

						 Creating Sub and Function Procedures
						 Declare and Use Variables
						 Displaying Message to the User
						 Getting Input from the User

					 Controlling Program Flow

					 Using decision making and looping structures to control the way your program works

						 Using the IF Statement
						 Using the Select Case Statement
						 Using For Next Loops
						 Using Do Loops
						 Using For Next Loops
			 

					 Interacting with the spreadsheet :

						 Referencing Cells and Ranges
						 Gathering Cell and Range Information
						 Using the Offset Method
						 Using With Blocks
						 Referencing Workbooks and Worksheets
						 Updating values in the spreadsheet 

					 Functions

						 Using standard Excel functions in VBA
						 Creating new custom functions
						 Calling functions and sub procedures

					 User Forms

						 Basic design and display
						 Getting information via forms and update cells
					

					 Practical project and examples
					 
					
			 
			<h4>Other Excel Courses</h4>
			 
 
 
 
 
	 </div>
	 <div id="cincluded">
	 <div>
	 <h5>What is included in the Excel VBA Courses:</h5>
	 </div>
	 <div>
	 <ul>
	 <li>Excel VBA Course Certificate on completion </li>
	 <li>Excel VBA Course notes</li>
	 <li>Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work</li>
	 
	 <li>After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.</li>
	 <li>Max group size, online and in classroom, on this Excel VBA Course is 4. </li>
	 </ul>
	 </div>
	 </div>

Excel Macros and VBA Course summary
 For Excel users. Extend the capabilities of Excel with Macros and VBA code. 
Excel Macros and VBA Course Description
Create a simple mile/km converter with a frontend, user-input for, click button to start and update a spreadsjeet 
What is included in the Excel VBA Courses:
Excel VBA Course Certificate on completion
Excel VBA Course notes
Practical Excel VBA Course exercises, Excel VBA Course Homework / Excel VBA Course Revision work
After the course, 1 free session for questions online Excel VBA Course via Gotomeeting.com.
Max group size, online and in classroom, on this Excel VBA Course is 4.

PCWorkshops

Visual Basic

Access VBA

For Excel users. Extend the capabilities of Excel with Macros and VBA code. 

Excel Macros and VBA Course, 1-Hour Taster

General admission

This course meets and exceeds the Maryland requirement for the security officer course of 12 hours. The course is taught over 2 days, 6 hours per day for the day course or 3 days, 4 hours per day for the night course. In this course, you will learn the required curriculum for security officers prescribed by the Maryland Police and Corrections Training Commission. Once you purchase this course, it may not be canceled.  You can request another later scheduled date if a conflict arises.

MDSPOSA & USTASC TRAINING PORTAL

Maryland Security Officer Initial & Renewal Course

Droitwich Spa

Southampton

Portsmouth

Rotherham

Manchester

Leeds

Newport

Peterborough

Milton Keynes 

Dartford

Paisley

Derby

Birmingham

Luton

Hull

Northampton

Berkshire

Bedford

Liverpool 

Swansea

Essex

ONLINE STUDY - In your own time (approx. 6 hours study time) +
CLASSROOM SESSION - Morning, Afternoon or Evening session (approx. 3 hours)



Awarding Body: Open College Network (OCN) Credit for Learning
Award Level: Level 4 (Foundation Degree Level) - Ireland Level 6
CPD Certified: Yes (CPD Accreditation)
Minimum Age: 18 (16 with parental consent)
Entry requirements: None. (English Level 2 desirable)
Training Locations: Study online + Classroom
 
OCN Accredited at UK Level 4 (Ireland Level 6)

 
PART 1 - Theory: Complete this part of your course online at home or work in your own time (stop and start learning when it suits you). Can be completed on multiple devices - smart phones, kindle, laptop, tablet etc.

PART 2 - Skills and Practical Development:
Covers advanced specialised phlebotomy techniques to give you the leading edge as a phlebotomist. Learn to use a wide range of non-routine equipment.


Attend a classroom location to complete your practical training.


Please make sure you verify the precise dates and timings of your course when you receive your booking confirmation, as it may vary from the information provided above.


Course Itinerary:
PART 1 - THEORY (ONLINE)
M00 - Introduction:
Learning outcomes, Assumptions and Overview.
M01 - Basic Phlebotomy - revision:
Recap of basic phlebotomy theory and practice - precursor to
the advanced course.
M02 - Aspirated and Vacuated Systems:
Open systems (Syringe & Needle), closed systems (Vacutainer & Monovette), Alternative closed systems, Using Monovette - aspiration and evacuated techniques, monovette adapter systems.
M03 - Specialised and Advanced Phlebotomy Equipment:
The centrifuge - overview. Safe operation and use. Managing a centrifuge breakage or spillage.
Equipment and practices in unusual situations.
Patients with special needs and requiring specific attention.
Equipment preparation for blood samples that are collected at
0 degrees, 37 degrees C and other non-standard conditions.
A look at advances in technology and how to use the latest devices.
M04 - Point of Care Testing:
What is POC Testing? Advantages, Disadvantages and Clinical
Outcomes. Comparison of POC with lab testing. 10 common POC tests. Roles for phlebotomists performing POC Tests.
M05 - Neonates and Children:
Sample collection from new-born to pre-adult. A detailed overview of legal principles of law including child consent and child protection for phlebotomists. Neonatal and child blood collection equipment.
A comprehensive look at heel and finger-prick procedures including
microtainers, lancets and capillary tube collection. Detailed heel prick procedure. Paediatric finger prick collection. The life-threatening hazard of over-collecting. Communication techniques in differing age bands.
Consent and the law. Basic principles of lawful consent for neonates and paediatric patients. Child protection.
Detailed analysis of neonatal and paediatric blood collection including Guthrie card collection. Neonatal bottles - colours and tests. Paediatric blood gases collection.
Butterfly needles - when to use. Blood tests during pregnancy. Neonatal blood screening - nine conditions covered. Bilirubin in neonates.
M06 - Geriatric Patients:
The challenges of phlebotomy in older people. Understanding skin changes and venepuncture implications. A profile of common
geriatric blood tests. Age related problems. Procedural precautions.
M07 - Special Procedures:
Drawing blood from back of hand. Drawing blood from lower limb veins. Managing the unwilling or difficult patient. Managing the psychiatric patient. Managing the isolated patient. Non-routine blood tests. Managing the latex allergy patient (type 1 and type 4 reactions). Latex indicators. Sample handling - non-routine procedures. Drug trials and research projects.
M08 - Special Tests and Sample Handling Procedures:
A look at sample collection at specific times of day and night,
samples that are protected from light, collected on ice and
collected at body temperature. Procedures for each group - collection notes, analytic time, optimal collection time and notes for each group.
M09 - Advanced Phlebotomy Tasks:
Additional procedures. Maintaining POC equipment. Stock control and stock rotation. Quality control. Data entry. Product evaluation. Training and competency evaluation.
M10 - Alternative Environments:
A step-by-step look at non-clinical phlebotomy environments including private testing, DEFRA, forensic and police, cord blood collection, DNA analysis, veterinary services, overseas and volunteering.

PLEASE NOTE THAT PART 1 SHOULD BE COMPLETED
BEFORE JOINING US FOR YOUR PRACTICAL TRAINING

PART 2 (CLASSROOM)
MORNING , AFTERNOON OR EVENING SESSION:

1 - Welcome, introductions and overview:
- Classroom - health & safety briefing, schedule overview.
- Virtual Classroom - audio/visual checks and registration. Unpacking and overview of your training kit.
2 - Syringe and Needle (open system): Correct use and applications.
3 - Monovette (open and closed systems):
Using the Monovette system in aspiration mode - correct use and applications.
Using the Monovette system in evacuated mode - correct use and applications.
4 - IR Vein Detector:
Demonstration of the IR vein detector for assisting in detection of difficult veins.
5 - Veins in back of hand:
Detecting suitable veins in the back of the hand.
6 - POC testing:
Point of Care Testing - use of glucose meter to demonstrate a typical POC test procedure. Correct use and overview of other POC test devices.
7 - Using lancets (finger collection)
We look at the correct use of lancets for POC testing and whole blood micro-collection.
8 - Using lancets (heel collection)
We look at the correct use of lancets for neonatal blood spot tests (Guthrie Test).
9 - Capillary collection
Using glass capillary tubes for micro-collection. Correct use and handling.
10 - Microtube collection
Correct use of BD Microtainers (and similar micro-collection bottles) - collection and handling.

This course is supported with downloadable resources and may include extra video segments to reinforce your practical training.
 
(THE COURSE DELIVERY AWARDS SAME NATIONALLY RECOGNISED AND DUALLY ACCREDITED QUALIFICATION AS OUR VIRTUAL CLASSROOM COURSE VERSION)



Geopace Training

Allied Health

Allied Health Professions (AHP)

Blood Taking

Healthcare Workers

Venepuncture

Phlebotomist

Phlebotomy

Accredited Phlebotomy

Healthcare

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6)

    FDSc (Foundation Degree Level) qualification

    Nationally Recognised certificate

    Dually accredited: Open College Network  and CPD

    Covers both aspirated and evacuated systems

    Covers specialised blood collection systems & methods

    Classroom or Virtual Classroom learning options

    Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep)

    Complete your training from beginner to advanced level

    This course either follows on from our Introduction to Phlebotomy Course  or can be combined with our introductory course as part of a course package (see below)

    Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.


59519 Courses

Communication Skills 1 Day Training in Nottingham

By Mangates

Communication Skills 1 Day Training in Ipswich

By Mangates

Real Estate Financial Modelling School

By Bayfield Training

Master Business Networking in Just 1 Day - Join our Workshop in Kingston upon Hull

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in High Wycombe

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Guildford

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Exeter

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Dundee

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Cirencester

By Mangates

Master Business Networking in Just 1 Day - Join our Workshop in Worcester

By Mangates

Search By Location