2040 RES courses in London

Construction (Design & Management) Regulations 2015 - this law applies to the whole construction...

HACCP Level 3 Training Courses

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

A whole day of workshops for groups of pupils throughout your school, delivered by a dedicated ally of disabled people. Engaging and thought-provoking, these workshops are a must for schools that want to challenge prejudice and promote disability equality. Workshops will help pupils to: learn more about disability and human rights hear disabled people’s perspectives identify common stereotypes and some of the prejudices disabled people face consider what disability is and how it arises understand the difference between impairment and disability review terminology and its effect on disabled people’s identities learn about disabled people who have made a difference ask sensitive questions anonymously become advocates for disability equality 95-100% of participants say that they found our workshop helpful Some of the reasons pupils have given for finding the workshop helpful are: “Until today I had always been scared of disabled people but today I have learnt that disabled people have a heart and emotions too.” “I now understand more about disabilities. My sister and brother has disabilities.” “It shows that although disabled people have limits they can do many things.” “Because presenter told in very simply way about complicated things and used interesting examples.” “Now I know that disabled people do things differently.” FAQs: How long is each workshop? 40-45 minutes; this can be adjusted to fit in with your school day. How many workshops will you deliver? We can deliver up to six workshops in a day. How many pupils should there be in each group? The workshops are interactive, so they are more effective with groups of around 20 pupils. We are often asked to work with larger groups and this still generates excellent feedback from pupils and staff. What year groups are these workshops for? The workshops are suitable for all year groups in primary and secondary schools; we adapt the content and presentation according to the age of pupils. Does a member of staff need to stay with the group? Yes, we ask that a member of staff is present at each workshop. Will you need any equipment? We ask for a computer, projector and access to the internet. Pupils will need a pen to write with. How are the workshops evaluated? At the end of each workshop we ask all (except the youngest) pupils to write down if they have found it helpful or not and why; we may also offer them an opportunity to ask a question anonymously.If schools have opted for this (please see optional extras below) we will send the school written responses to questions and a transcript of pupils’ feedback as evidence of impact. Cost: CSIE price: £800+vat plus expenses Optional extras: a) written responses to pupils’ anonymous questions (£50+vat) b) transcript of pupils’ feedback, as evidence of impact (£50+vat)

Overview Account Management is an important role within any organisation. Account Managers are responsible for nurturing customer relationships and increasing sales with their organisation’s key customers. The Account Manager will usually act as a first point of contact for clients; responding to complaints, purchases, project requests and any general queries. Their approach should help maintain client relationships in order to ensure that they continue to use the company for business. This one day course can help them learn the key skills they need. Description Build a strong account management team that are able to effectively manage customer relationships and drive sales The role of account manager is both important and demanding. The account manager acts as the ‘face’ of the business and should professionally represent the business by creating a strategy for success and delivering a high level of customer service. Account managers need to be effective communicators, needing to both engage with the client and also develop internal relationships to ensure promises are delivered upon. Another key responsibility of the account manager is to identify business opportunities and help drive business results for their company. Account Management can be a very challenging role depending on the number of clients, the range of industries the clients represent, and the nature and attitude of the client. The main focus of the role is to provide continual client service to clients, this may include quarterly or annual business reviews, additions to the account in terms of extra services supplied plus face-to-face and online meetings, on a regular basis. The Account Manager will also be responsible for delivering high levels of client service to ensure that clients do not leave and will need to create a strategy around this. This strategy will depend on the type of client in terms of size of the business commitment, Key Performance Indicators plus contractual agreements which may dictate the framework for the relationship. Building a personal relationship as well as a business one is key to becoming an effective Account Manager. After all, “It is easier to fire a business associate or employee than it is to fire a friend”. Why should people attend this training course? Well, just imagine if your employees were better able to: Build effective business relationships with clients and help drive sales performance. Add value to clients and help ensure their requirements are met or exceeded. Measure the performance of their key accounts and adapt their approach accordingly. Understand the key attributes required for success and work on developing them. Set a strategy for sales success and create action plans for pre-defined goals. Monitor and measure their own performance and set their own targets. Ultimately, this training course will help employees to focus on what is required to succeed in the role of account manager, building a strategy with clear actions and helping the organisation to business success. Who is this course for? This Account Management training course is for anyone that works in an account management role or relevant sales function and will assist the participants in improving their working practices, developing customer relationships and in turn increasing business performance and sales success. Requirements for Attendance Prior sales experience is recommended, but an awareness of the sales process as a minimum will suffice.

Overview This one day course will provide guidance on how to become more assertive and build self-confidence, which in-turn will help your attendees to achieve greater work effectiveness and productivity, whilst putting them in control of their daily activities and making them more able to overcome stressful work and life situations. Description Being assertive is being able to express yourself with confidence without having to resort to passive, aggressive or manipulative behaviour. By developing assertiveness and becoming aware of our own strengths and weaknesses, we can modify our behaviour for greater effectiveness in social and business interactions. Topics covered: What is Assertiveness? – A series of activities relating to what assertiveness means and, perhaps more importantly, what it means to the participants. My Assertiveness Goals – A chance for the participants to review what they want to get out of the session and where they would like to end up with regard to their approach to assertiveness. How Assertiveness Works – A look at human reactions and the reasoning behind them culminating in an activity that looks at the participants own observations in relation to assertive behaviour. My Assertive Rights – A review of the rights we have as individuals followed by a commitment to the rights by the participants. Taking a Positive Approach – Looking at key methodology, including: – Giving and Receiving Compliments A review of typical responses to compliments and their negative consequences, followed by an opportunity to develop new, positive responses. – Improving Self-Esteem An in-depth review of each individual’s positive aspects. – New Challenges A set of challenges to take participants out of their comfort-zone and into the realm of possibilities. – Effective Communication A look at what makes effective communication, with some modelling of behaviours. Approaching Assertiveness – A look at the four cornerstones of being assertive with an opportunity to practice these behaviours. The Words You Use – Understanding the key areas of effective communication. Covering the areas of; Disclosing Your Feelings, Being Clear, Being Persistent, Empathising and Working Towards a Wise Outcome. Preparing to Be Assertive – A chance to understand and practice a set process of ‘scripting’ in order to develop an effective and natural approach to assertive interactions. Assertive Review – An activity that solidifies the reasoning behind wanting to become assertive, whilst demonstrating that it is not an unachievable outcome. Who should attend Anyone that needs to develop their assertiveness skills and improve communication with others Requirements for Attendees None.

Trust building Pain point assessment Relationship history analysation Communication strengthening Ascertain main problem areas Closure on reoccurring arguments Intervention and mediation Emotional intelligence training Love language assessment Resolving fights Private assessments with each individual 3 couples therapy sessions https://relationshipsmdd.com/product/couples-trust-building-and-communication-therapy-package/

This is a highly interactive programme designed by the communication experts at TCM. The course helps learners to develop essential skills for everyday management. On this programme, delegates learn how to navigate the complex maze of having difficult conversations, managing performance, and giving bad news. Offering a proactive and hands on approach to teaching, the TCM trainers equip delegates with the confidence to have those crucial conversations, to prevent disputes before they escalate out of control and, to be assertive in addressing performance issues to achieve engagement and sustainable outcomes.

Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.

Vray face to face training customised and bespoke.