412 Courses in London

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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Certificates Certificates Certificate of completion Digital certificate - Included

Interior design tutor one to one open 7 days 9 am to 9 pm

Take your knowledge to the next level with EnergyEdge course on Layer of Protection Analysis (LOPA). Enroll now to advance your career.

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

Join AAT Level 2 Bookkeeping | Online | Learn From Home at Your Flexible Time | Excellent Support and Advice | Join Now

Unlock a Rewarding Path as a Dementia Advocate Are you ready to make a difference by understanding and supporting individuals with Dementia? Embark on a fulfilling journey of advocacy through our comprehensive Dementia training courses – Dementia Champion and Dementia Interpreters. This course is an advanced level of training with innovative practical elements and teachings from experts which will change your approach and better your service. You will also be able to display your team’s achievements with pins and certificates that will differentiate you from other services. So often we have training that takes care of the physical elements of our service users but this truly explores how to take care of emotional and cognitive health, ensuring that you are catering to your service users at all levels. Dementia Champion Course £1000 + VAT Modules: What Dementia is and what it isn’t Living with Dementia What causes Dementia? Diagnosis and who can help Common difficulties and how to help The emotional impact of Dementia Positive communication Duration 3 Full Days Maximum Delegates 12 for face-to-face or unlimited for virtual Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance. Full Day - Dementia Interpreters Course £800 + VAT Duration 2 x 3-hour sessions Maximum Delegates 16 Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance. Half Day - Dementia Interpreters Course £495 + VAT Duration 1 x 3-hour session Maximum Delegates 8 Location Location: We can travel to any UK location for your convenience. *Note: Price may vary based on travel distance.

– the practical steps you need to know This live online suicide intervention training covers a wealth of essential information and strategies to help you help anyone you suspect may be thinking about or planning suicide, or who has survived a previous attempt… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) You never know when you may need these skills… Brilliant! I’ve been on previous suicide intervention courses over the years, but this is by far the best – great pace, very knowledgeable trainer...who brings real experience into the learning...SUE HASWELL Join Malcolm Hanson LIVE ONLINE on Tuesday 12th March for his essential suicide intervention training, delivered via Zoom. Book your place and we’ll send you the Zoom link the day before the event. BONUS Recording – the training is recorded, in case anyone experiences technical difficulties, so you also get a recording for a limited time afterwards to maximise your learning. Why take this suicide prevention course Suicide can be a difficult subject to broach and a daunting one to deal with – anyone working with distressed or depressed people wants to keep them safe, to give them the hope they need that circumstances can change for the better, and to provide the skills for coping until that comes about. When people can’t envisage an end to their difficulties, particularly in highly challenging times, a slump into depression can all too quickly spiral down into suicidal thoughts, plans and suicide attempts. The negative trance state of depression itself can beguile people into thinking that there is no other way out of their hopelessness. Thankfully, there is much we can do to help – as this indepth suicide intervention course shows. Tutor Malcolm Hanson has a wealth of experience at helping seriously distressed people get through difficulties which he draws upon as he takes you clearly through the steps to take when faced with anyone who feels suicidal. (He worked for 9 years as a psychotherapist in NHS primary care in an area of extreme deprivation, and for many more years since has seen patients referred by GPs, social workers, psychiatrists, police and probation officers for complex issues.) He has successfully helped clients experiencing multiple trauma (including veterans), chronic pain and terminal illness, clients struggling with uncertain asylum status or facing deportation, and also victims of human trafficking – a tragic range of circumstances in which even the most resilient may sometimes sink into despair. His compassion and understanding shine through this course as he shares with you what he has learnt, along with the latest psychiatric research and risk assessment strategies, to give you the knowledge and assurance you need to work confidently and respectfully with clients struggling to find reasons to stay alive. You will learn how to build in expectation of positive change from the start, have plenty of time to benefit from group discussions and will work through case scenarios with other attendees to help embed your learning. Suicide affects countless people, not only those directly involved, and is now the most common cause of death in men aged 17 to 34. The highest suicide rate is in men aged 45–49; in women, it is highest in those aged between 50–54.1 Join us for this practical online suicide prevention training to learn how you can help reverse this state of affairs… Book your place So much helpful and insightful information delivered in a way that was easy to listen to and take on board...STEVEN TESSEYMAN What will you learn Deeper insight into when and why different people consider suicide Crucial elements needed to build rapport with suicidal people Why most suicidal crises are surprisingly temporary How to normalise circumstances safely A model for running therapeutic sessions that best manages suicide risk Ways to use your own demeanour to instil confidence in the person who is feeling suicidal Effective information gathering to challenge unhelpful beliefs What to look for in their answers to your questions How to broach the subject of suicidal thoughts A structure for difficult conversations The ability to reframe unhelpful beliefs Methods of risk assessment that do not risk losing rapport Advances in psychiatric research on suicide risk management and the implications of this for psychotherapy and counselling How to use language of influence Effective means to address beliefs about being a burden How to set realistic and empowering goals How to make best use of the client’s own resources The importance of addressing emotional needs How to create a safety plan Strategies for client safe self-management between sessions The power of guided imagery for working with suicidal clients Powerful insights and hope from real case histories How to take care of yourself – and more… Malcolm is a wonderful communicator: so clear, measured and thoughtful ... it was a pleasure and privilege to learn from himMATTHEW HOPKINS Course Programme The ‘How To Reduce Suicide Risk’ live online course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am The important first steps for suicide risk management 11.00am Comfort break and discussion 11.30am Working with what the client brings 1.00pm Lunch break 1.45pm Rehearsing the safety plan 2.45pm Comfort break and discussion 3.00pm Putting what you have learned into practice 4.00pm Day ends Who is this suicide awareness and prevention course for? Psychotherapists and counsellors All mental health and welfare professionals – including GPs, social workers, the emergency services, pastoral care and outreach workers – and anyone else working with people with suicidal ideation Anyone concerned for personal or HR reasons – the training contains a lot of key, helpful information which is presented in a clear, easy to understand way, even though it is primarily geared towards carrying out therapy effectively with suicidal clients Anyone working with young people, such as teachers and youth workers, will benefit from this live online suicide intervention course Anyone who may come into contact with people who are very distressed, whether through their paid or volunteer work, will also learn essential live-saving information. Please Note This course is not a substitute for therapy. Reference 1. www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/bulletins/suicidesintheunitedkingdom/2019registrations The one certainty in life is that circumstances ALWAYS change... This online suicide awareness and prevention course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Team development to improve business performance. Quantifiable results. Change measured. &0+% of teams are measured as more effective after 6 months.

About this Virtual Instructor Led Training (VILT) This Virtual Instructor Led Training (VILT) course presents advanced methodologies that implement demand response and energy conservation programs in light of the integration of new technologies, regulatory changes and the accelerated penetration of renewable energy resources. This VILT course provides examples and case studies from North American and European jurisdictions covering the operational flexibilities on the demand side including requirements for new building codes to achieve zero net energy. The course describes a public agency's goals and objectives for conserving and otherwise reducing energy consumption and managing its demand for energy. This course presents the demand response implemented for economics and system security such as system balancing and relieving transmission congestion, or for system adequacy. The course also presents the principal attributes of conservation programs and the associated success criteria. In a system with increased penetration of renewable resources, demand response provides flexibility to system operators, helping them to maintain the reliability and the security of supply. Demand response is presented as a competitive alternative to additional power sources, enhancing competition and liquidity in electricity markets. The unique characteristics are discussed from a local, consumer centric and also from a system perspective bringing to life the ever changing paradigm for delivery energy to customers. Interoperability aspects and standards are discussed, as well as the consumer centric paradigm of Transactive Energy with IOT enabled flexibilities at system level, distribution networks and microgrids. The VILT course introduces the blockchain as a new line of defense against cyber threats and its increasing application in P2P transactions and renewable certificates. Our trainer's industry experience spans three decades with one of the largest Canadian utilities where she led or contributed to large operational studies and energy policies and decades of work with IEEE, NSERC and CIGRE. Our key expert also approaches to the cross sectional, interdisciplinary state of the art methodologies brings real life experience of recent industry developments. Training Objectives Innovative Digital Technologies How systems Facilitate Operational Flexibility on the Demand Side The Ecosystem of Demand Side Management Programs Advanced Machine Learning techniques with examples from CAISO Regulatory Policy Context and how to reduce regulatory barriers Industry Examples from NERC and ENTSO Relevant Industry standards: IEEE and IEC Manage Congestion with Distributed Operational Flexibilities: Grid to Distribution Controls; examples from NERC (NA) and ENTSO (Europe) Grid solutions with IEC 61850 communication protocols Decentralized grid controls The New Grid with accelerated V2G and Microgrids How DSM is and will be applied in Your System: Examples and discussions Target Audience Regulators and government agencies advising on public energy conservation programs All professionals interested in expanding their expertise, or advancing their career, or take on management and leadership roles in the rapidly evolving energy sector Energy professionals implementing demand side management, particularly in power systems with increased renewable penetration, to allow the much needed operational flexibility paramount to maintaining the reliability and stability of the power system and in the same time offering all classes of customers flexible and economical choices Any utility professional interested in understanding the new developments in the power industry Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your first expert course leader is a Utility Executive with extensive global experience in power system operation and planning, energy markets, enterprise risk and regulatory oversight. She consults on energy markets integrating renewable resources from planning to operation. She led complex projects in operations and conducted long term planning studies to support planning and operational reliability standards. Specializing in Smart Grids, Operational flexibilities, Renewable generation, Reliability, Financial Engineering, Energy Markets and Power System Integration, she was recently engaged by the Inter-American Development Bank/MHI in Guyana. She was the Operations Expert in the regulatory assessment in Oman. She is a registered member of the Professional Engineers of Ontario, Canada. She is also a contributing member to the IEEE Standards Association, WG Blockchain P2418.5. With over 25 years with Ontario Power Generation (Revenue $1.2 Billion CAD, I/S 16 GW), she served as Canadian representative in CIGRE, committee member in NSERC (Natural Sciences and Engineering Research Council of Canada), and Senior Member IEEE and Elsevier since the 90ties. Our key expert chaired international conferences, lectured on several continents, published a book on Reliability and Security of Nuclear Power Plants, contributed to IEEE and PMAPS and published in the Ontario Journal for Public Policy, Canada. She delivered seminars organized by the Power Engineering Society, IEEE plus seminars to power companies worldwide, including Oman, Thailand, Saudi Arabia, Malaysia, Indonesia, Portugal, South Africa, Japan, Romania, and Guyana. Your second expert course leader is the co-founder and Director of Research at Xesto Inc. Xesto is a spatial computing AI startup based in Toronto, Canada and it has been voted as Toronto's Best Tech Startup 2019 and was named one of the top 10 'Canadian AI Startups to Watch' as well as one of 6th International finalists for the VW Siemens Startup Challenge, resulting in a partnership. His latest app Xesto-Fit demonstrates how advanced AI and machine learning is applied to the e-commerce industry, as a result of which Xesto has been recently featured in TechCrunch. He specializes in both applied and theoretical machine learning and has extensive experience in both industrial and academic research. He is specialized in Artificial Intelligence with multiple industrial applications. At Xesto, he leads projects that focus on applying cutting edge research at the intersection of spatial analysis, differential geometry, optimization of deep neural networks, and statistics to build scalable rigorous and real time performing systems that will change the way humans interact with technology. In addition, he is a Ph.D candidate in the Mathematics department at UofT, focusing on applied mathematics. His academic research interests are in applying advanced mathematical methods to the computational and statistical sciences. He earned a Bachelor's and MSc in Mathematics, both at the University of Toronto. Having presented at research seminars as well as instructing engineers on various levels, he has the ability to distill advanced theoretical concept to diverse audiences on all levels. In addition to research, our key expert is also an avid traveler and plays the violin. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

PRINCE2 is a process-based project management methodology that offers a flexible and scalable solution to handle all kinds of projects. This is why many organisations favour it since it fosters better collaboration between team members and external stakeholders. Course Overview PRINCE2 is a process-based project management methodology that offers a flexible and scalable solution to handle all kinds of projects. This is why many organisations favour it since it fosters better collaboration between team members and external stakeholders. The PRINCE2 certification will surely help learners advance in terms of worth and employment opportunities if they list it as a skill in their resumes. This 3-day introductory PRINCE2® Foundation course is designed to give candidates a comprehensive overview of the PRINCE2® methodology. They will learn about various essential topics such as integrated elements, applying PRINCE2®, delivery approaches, processes, principles, tailoring, etc. The PRINCE 2 foundation course will introduce project management to students. This course will focus on different aspects of project management, providing the knowledge, tools and techniques used to understand each concept and methodology. At the end of this PRINCE2® Foundation course, delegates will be able to perform various project manager activities in an organisation effectively and efficiently. They will also be able to use various PRINCE2® methodologies properly. This training will also cover the following concepts: • Project management • Projects in context • Measuring success • Tailor to suit the project • Embedding PRINCE2® • Tailoring constraints and influences Who it’s for? Prerequisites: In this PRINCE2® Foundation course, there are no formal prerequisites. PRINCE2 Foundation can be studied on its own or as a prerequisite for the PRINCE2 Practitioner course This PRINCE2® Foundation course is designed for anyone who wants to gain in-depth knowledge about project management methodologies. What's Included in this PRINCE2 Foundation Training Course? The following is included in this PRINCE2® Foundation training course: • PRINCE2® Foundation Examination • Pre-course material • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments PRINCE2® Foundation Exam: The PRINCE2® Foundation examination Focuses on knowledge of PRINCE2® as a methodology. • Type of Questions: Multiple choice. • Total Questions: 60. • Number of marks: 60 marks, each question is worth 1 mark. • Pass mark: 55%, or 33/60. • Duration: 60 Minutes. • Material allowed: No, this is a ‘closed book’ exam. This PRINCE2® foundation training course covers the following topics: Module 1: Introduction to Projects and the PRINCE2® Methodology: • PRINCE2® “Project” Definition • Project Characteristics • Project Management • What is PRINCE2®? • Four Integrated Elements • What Does PRINCE2® Not Provide? • What Makes a Project a PRINCE2® Project? Module 2: Project Manager Activities: • Customer/Supplier Environment • Projects in Context • Commercial Environment • Applying PRINCE2® • Delivery Approaches • Measuring Success • Organisational Capability • Seven Processes Module 3: Seven Themes: • Business Case • Organisation • Quality • Plans • Risk • Change • Progress Module 4: Seven Principles: • Continued Business Justification • Learn from Experience • Defined Roles and Responsibilities • Manage by Stages • Manage by Exception • Focus on Products • Tailor to Suit the Project Module 5: Considerations for Organisational Adoption: • Creating a PRINCE2® Based Project Management Method • Creating Tailoring Rules and Guidelines • Rating the Complexity of Projects • Embedding PRINCE2® • Tailoring • What Should Be Tailored? • Tailoring Constraints and Influences • Creating an Organisation’s Method DURATION 2-3 days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate