687 Courses in London delivered Live Online

Develop your technical report writing and presentation skills with EnergyEdge's course designed for oil & gas professionals. Sign up now!

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Course Overview The British Sign Language (BSL) Level 1 & 2 course offers a comprehensive foundation for learners keen to develop effective communication skills within the Deaf community. This course covers key vocabulary, everyday conversations, and cultural understanding across two recognised qualification levels. Through engaging modules, learners will build confidence in signing across a range of topics including greetings, family, transport, work, health, and leisure activities. The course provides a flexible learning experience, enabling learners to study at their own pace while gradually advancing from basic to more complex sign language structures. By the end of the course, learners will be able to confidently engage in conversations, describe people, express opinions, and interpret dialogues with greater fluency. Whether for personal growth, professional development, or community involvement, this course equips learners with the communication tools needed to create more inclusive and supportive environments for Deaf individuals. Course Description The British Sign Language (BSL) Level 1 & 2 course is structured to guide learners through a progressive journey, starting with the alphabet, fingerspelling, and simple daily interactions, before advancing to complex dialogues and storytelling. Key topics include family life, the home environment, weather, transport, work, hobbies, shopping, health, and holidays. Learners will engage with a variety of video dialogues—both with and without voice-over and subtitles—designed to enhance visual communication skills and comprehension. This learning experience not only builds practical sign language ability but also deepens understanding of Deaf culture, encouraging effective and respectful communication. With a focus on clarity, repetition, and gradual development, learners will acquire the skills needed to hold structured conversations, ask and respond to questions, and share detailed personal or professional information in BSL. The course aims to support learners in becoming confident and culturally aware communicators across different social and professional contexts. Course Modules Module 01: British Sign Language (BSL) Level 1 Online Course Module 02: Alphabet Fingerspelling and Names Practice Module 03: Greetings Module 04: Family, Question Forms and Family Story Module 05: Rooms in the House Vocabulary Module 06: Colours Module 07: Questions and Statements about the Home Module 08: Animals Module 09: Numbers and Money Module 10: Time and Months of the Year Module 11: Describing Ages Module 12: Weather Module 13: Transport Module 14: Directions Module 15: Hobbies Module 16: Work Module 17: Food and Drink Module 18: Dialogues (No Voice, No Subtitles) Module 19: Dialogues (With Voice and Subtitles) Module 20: Bonus: 5 Stories (With Voice and Subtitles) Module 21: Bonus: 5 Stories (No Voice Over) Module 22: Level 2 British Sign Language Module 23: Family Vocabulary Module 24: Describing People and Animals Module 25: Activities at School Module 26: Jobs and Activities at Work Module 27: Time Module 28: Activities in the Home Module 29: Leisure Activities Module 30: Opinions, Likes and Dislikes Module 31: Illnesses and Health Module 32: Eating and Drinking Module 33: Shopping and Spending Module 34: Travel and Holidays Module 35: Level 2 Dialogues (Without Voice and Subtitles) Module 36: Level 2 Dialogues (With Voice Over and Subtitles) Module 37: 5 Stories (No Voice Over and No Subtitles) Module 38: 5 Stories (With Voice Over and Subtitles) Module 39: Level 2 BSL Dialogues and Stories (See full curriculum) Who is this course for? Individuals seeking to communicate confidently with the Deaf community. Professionals aiming to enhance communication skills in inclusive workplaces. Beginners with an interest in sign language and Deaf culture. Teachers, healthcare workers, and public service providers. Parents, family members, or friends of Deaf individuals. Career Path BSL Interpreter (after further study and qualifications) Communication Support Worker Deaf Support Assistant Special Educational Needs (SEN) Teaching Assistant Community Support Worker Customer Service Advisor in accessible services Healthcare and Social Care Assistant Voluntary roles supporting Deaf organisations

Grateful Leadership: In-House Training Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model true acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?

For the Postgraduate Diploma (PG Dip.) you will study the four modules (60 credits) from the Postgraduate Certificate (PG Cert.) plus an additional three modules (60 credits) from the MA Business of Motorsport Master’s Degree. N.B. The Postgraduate Diploma (PG Dip.) does not include the Executive Project (Dissertation) the final module of the MA.

Learning how to have a better relationship Introspection test Learn where you are going wrong Love language testing Learn about boundaries Establishing your relationship needs Address past negative relationship patterns Learn about boundaries Relationship facets relationship course 2-hour session relationship training and 1 phone call 30 mins Coaching and relationship skills education https://relationshipsmdd.com/product/relationship-course-express-package/

Revit face to face training customised and bespoke.

This course is intended for Beginner-Moderate exposure is recommended for this course. The topics covered are cumulative in nature, and they require minimal understanding of email applications and composition. Overview The objective of the course is to give students the information needed to create emails that are written in a succinct, effective, and user-friendly manner. Students will learn how to set up an email subject, salutation, and will then work on how to write a credible email. In this course, students will learn about e-mail policies and learn how to write professional e-mail memos that convey appropriate messages. 1 - E-mail basics E-mail characteristics Writing online versus on paper Understanding the advantages and disadvantages of e-mail Understanding the cultural significance of e-mail E-mail programs Using an e-mail program to send e-mail When to use e-mail Communicating by e-mail Understanding when to avoid using e-mail Writing an e-mail message Using the MAIL acronym 2 - E-mail policies Company policies Avoiding improper e-mail messages Ensuring employee compliance to e-mail policies Copyright laws, viruses, and liability Avoiding copyright infringement Avoiding viruses Identifying e-mail liability 3 - E-mail features and security Features of an e-mail program Using attachments Using priority labels and signature files Features of an e-mail program Using attachments Using priority labels and signature files Discussing e-mail program options Securing e-mail Using encryption and digital signatures Using passwords 4 - E-mail messages Message headers Using headers E-mail message body Including proper greeting Structuring an e-mail message Closing an e-mail message 5 - E-mail effectiveness E-mail recipients Considering the factors that determine e-mail writing Anticipating recipient reaction Message management Managing your e-mail effectively 6 - Netiquette guidelines Netiquette style Using proper tone Following formatting guidelines Emoticons and abbreviations Using emoticons and electronic abbreviations 7 - Composing online correspondence Online communication Achieving the objective of the message Language and punctuation Improving online writing style Using punctuation correctly Efficient writing habits Constructing sentences Constructing paragraphs Editing e-mail messages

Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. Course Category Inclusion Person Centred Planning Visioning and Problem Solving Peer Support Description Person Centred Rehabilitation Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. PERSON CENTRED PLANNING A Person Centred Planning event would be carried out using the PATH or MAP process – majoring on dreams and goal setting leading to precise action planning. Facilitators would carry out the PATH or other person centred process. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the later follow up inclusion facilitation work. Following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. INCLUSION FACILITATION The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. Agreed visits from the Inclusion Facilitator are then carried out over a 3 month period. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist needs to be there to support the facilitator at all times and will guide all work done by the inclusion facilitator. Is this just Support work? No! This is proactive engagement – doing whatever is required. This is not passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. The work is built on careful research around a person’s interests and what opportunities exist locally There is community mapping There is work to tackle an individual’s own resistance and reluctance to engage more socially There is a need to engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders You will need to build circles around a person There is a need to create the conditions in which friendships can flourish There is a need for direct psychological supervision and support throughout This work is short term and intense. The facilitator’s main aims will vary depending on the dreams and goals of the focus person. The basic aim of the inclusion facilitator is to better the focus person’s quality of life. Learning Objectives 1 To create a better life for the Individual. 2 Give Individual and family a clear vision of a good life and to support first steps towards this 3 To maximise individuals inclusion and connection with the wider community. 4 To help with friendship, social connection and education 5 To increase confidence, social skills and presence in their local community and to pursue goals and dreams. Who Is It For? Anyone who is involved in the rehabilitation of children or adults who have become disabled through accident or trauma and who is committed to helping them get their life back on track. Course Content Understanding ordinary needs – the dimensions of social inclusion Pursuing the dreams and goals of the individual Improving social skills Community Mapping Being comfortable in social environments Developing conversational skills Having a positive mindset Staying physically active Building relationships Help in meeting new people Create natural circles of support Creating a community circle Having positive body language Employment of support staff Pursuing personal interests   If you like this you will almost certainly enjoy: Person Centred Planning using PATH and MAPs

Grateful Leadership (Virtual) Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model TRUE acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?