5288 Courses in London delivered Online

A personalised resilience profile and 60 minute coaching and exploration session for those who want to develop their capacity to adapt positively in an ever changing world.

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

Project Leadership Skills (On-Demand) To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan

Description: Managing a workspace is not an easy task by any means. Employers require vast experience to understand how to work with people of various mindset. This course brings you the opportunity to learn and understand these different mindsets and help you skillful in managing your workspace. This course will give you an insight on how every person is unique and accustomed to having their own way of living. Yet, we all need to work together to make something happen. You get to learn about the factors that effect the work environment, both positive and negative. Moreover, this course highlights on how substance abuse may lead to unhealthy work environment for the co-workers. Learning Outcomes: Realise about marijuana along with the other genres of cannabis and of their uses Decode the ways of marijuana use and the effect an individual physically, psychologically, as well as in his behavior Identify the symptoms of marijuana uses Allot a definition to its related issues as it creates at the workplace Understand the legal rights of employers and employees with regards to cannabis use in the workplace Figure out the valid rights of the employers as well as the employees with respect to cannabis usage at the workplace Make your response to the events of the accused marijuana usage at the workplace Improve a positive workplace drug along with an alcohol code of conducts Identify the advantages to having tough conversations Describe the components of an effective behavior modification conversation Use your organization's resources to help you deal with hygiene issues Overcome barriers that employees put up when discussing hygiene problems Resolve hygiene issues such as bad hair days, inappropriate piercings and body art, poor clothing choices, bad breath, body odor, excessive gas, and incontinence Nip poor hygiene habits in the bud Identify ways to encourage good hygiene at your workplace Define frame of reference Establish a positive intent and the desired outcome Use good communication skills during a conversation Draft a script for a difficult conversation Use specific steps to carry out a difficult conversation Access additional resources as required Maintain safety in a conversation Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Controversial Workplace Management is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Controversial Workplace Management is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module 1 Drugs and the Workplace 00:15:00 Marijuana 00:15:00 Workplace Impacts 00:15:00 Medical Marijuana 00:30:00 How to Intervene 00:30:00 Drug and Alcohol Policy 01:00:00 Module 2 Let's Talk About It! 00:15:00 Guidelines for Difficult Conversations 00:15:00 Overcoming Objections 00:30:00 Bad Hair Days (And Weeks and Months) 00:15:00 Addressing Piercings and Body Artwork 00:15:00 Helping Employees Dress for Success 00:15:00 Bad Breath 00:15:00 Gastrointestinal Issues 00:15:00 Body Odor 00:15:00 Module 3 Choosing to Have the Conversation 00:30:00 Toolkit for Successful Conversations 00:30:00 Choosing the Time and Place 00:15:00 Framework for Difficult Conversations 00:30:00 Staying Safe 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 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 Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. 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 Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview Ultimate Job Interview in English Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Ultimate Job Interview in English Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: English for Job Interview: Introduction How to Use this Course? 00:06:00 Better Fluency Habits - Best Learning Habits for a Better Performance 00:09:00 Strategies to Research Companies for Your Field 00:13:00 Starting Your Vocabulary and Pronunciation List 00:09:00 Question 1: Tell Me about Yourself 00:06:00 Job Interview Audio Samples Question 1: Tell Me about Yourself 00:01:00 Question 2: What are Your Key Strength? 00:04:00 Job Interview Audio Samples Question 2: What are Your Key Strengths? 00:01:00 Question 3: Why Should We Hire You? 00:03:00 Job Interview Audio Samples Question 3: Why Should We Hire You? 00:01:00 Question 4: What are Your Weaknesses or Weak Points? 00:03:00 Job Interview Audio Samples Question 4: What is Your Weak Point? 00:01:00 Question 5: Where Do You See Yourself in 5 Years? 00:04:00 Job Interview Audio Samples Question 5: Where Do You See Yourself in 5 Years? 00:01:00 Question 6: Why Do You Want this Job? 00:05:00 Job Interview Audio Samples Question 6: Why Do You Want this Job? 00:01:00 Question 7: Why Did You (or Why Do You Want to) Leave your Current Employer? 00:04:00 Job Interview Audio Samples Question 7: Why Did You (or Why Do You Want to) Leave Your Current Employer? 00:01:00 Question 8: When are You Available to Start? 00:04:00 Job Interview Audio Samples Question 8: When are You Available to Start? 00:01:00 Question 9: How Do You Deal with Pressure or Stress? 00:04:00 Job Interview Audio Samples Question 9: How Do You Deal with Pressure or Stress? 00:01:00 Question 10: How Did You Hear about the Position? 00:02:00 Job Interview Audio Samples Question 10: How Did You hear about the Position? 00:01:00 Question 11: What Do You Know about our Company? 00:03:00 Job Interview Audio Samples Question 11: What Do You Know about our Company? 00:01:00 Question 12: Do You Have Any Questions? 00:03:00 Job Interview Audio Samples Question 12: Do You Have Any Questions? 00:01:00 Question 13: What are Your Salary Expectations? 00:04:00 Job Interview Audio Samples Question 13: What are Your Salary Expectations? 00:01:00 Question 14: Describe Yourself in Three Words/ Describe Your Personality 00:04:00 Job Interview Audio Samples Question 14 : Describe Yourself in Three Words/ Describe Your Personality 00:12:00 Question 15: What Do You Like to Do in Your Free Time? 00:03:00 Job Interview Audio Samples Question 15: What Do You Like to Do in Your Free Time? 00:01:00 Section 02: How to Answer Difficult Interview Question? 5 Kinds of STAR Question 00:09:00 How to Find STAR Interview Stories 00:04:00 How to Write Your STAR Answers 00:05:00 How to Combine Your Stories with the 5 Categories of Question 00:03:00 How to Answer Difficult Interview Questions and the STAR Interview Technique 00:03:00 Tell me about a time when you worked successfully as a Member of a Team? 00:07:00 Describe a Difficult Situation or Task that you had to Deal with? 00:06:00 Tell me about Your Biggest Achievement to Date 00:06:00 Tell me about a Time When you worked with a Difficult Team Member 00:04:00 Tell me about a Time When you had to make a Difficult Decision 00:03:00 STAR Sample Answers Video 1 00:04:00 STAR Sample Answers Video 2 00:04:00 Assignment Assignment - Ultimate Job Interview in English 00:00:00

Essential Skills for Positive Project Leadership How can you approach a difficult conversation to achieve the desired outcome? This video addresses the importance of having a plan when a conversation with a project stakeholder may be difficult and involve bad news, major changes, or a performance issue. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Essential Skills for Positive Project Leadership How can you approach a difficult conversation to achieve the desired outcome? This video addresses the importance of having a plan when a conversation with a project stakeholder may be difficult and involve bad news, major changes, or a performance issue. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Consistent 11+ Reading is vital to build an extensive vocabulary for all aspects of the 11+ English Exams. Excellent vocabulary is what ultimately brings 11+ English Exam Success and top results.

Do you want to achieve your corporate goals by building strong and lasting relationships with your clients, colleagues, and partners? Do you want to learn how to communicate effectively, collaborate efficiently, and manage conflicts professionally? If yes, then this Corporate Relationship Goals for Success course is for you. This course will teach you the essential skills and strategies to establish and maintain successful corporate relationships. You will learn about the basics of corporate etiquette, the principles of effective communication, and the challenges of cross-cultural communication. You will also learn how to establish trust and rapport, work as a team, and handle difficult conversations and conflicts. By the end of this course, you will be able to build professional networks and alliances, and sustain long-term relationships and success. Learning Outcomes By the end of this course, you will be able to: Demonstrate proper corporate etiquette in various situations and contexts Apply effective communication techniques to convey your message clearly and persuasively Understand and respect the cultural differences and preferences of your counterparts Establish trust and rapport with your clients, colleagues, and partners Collaborate and cooperate with your team members to achieve common goals Manage difficult conversations and conflicts with confidence and professionalism. Why choose this Corporate Relationship Goals for Success course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Corporate Relationship Goals for Success course for? Business owners and entrepreneurs who want to attract and retain loyal customers Managers and leaders who want to motivate and inspire their teams Sales and marketing professionals who want to increase their sales and revenue Consultants and advisors who want to provide value and solutions to their clients Professionals and employees who want to advance their careers and expand their opportunities. Career path Corporate Relationship Manager: £40,000 - £60,000 per year Business Development Manager: £30,000 - £50,000 per year Account Manager: £25,000 - £45,000 per year Customer Service Manager: £20,000 - £35,000 per year Project Manager: £35,000 - £55,000 per year Corporate Trainer:£30,000 - £50,000 per year Prerequisites This Corporate Relationship Goals for Success does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Corporate Relationship Goals for Success was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Corporate Relationship Goals Introduction to Corporate Relationship Goals 00:11:00 Module 02: Basics of Corporate Etiquette Basics of Corporate Etiquette 00:11:00 Module 03: Understanding Effective Communication Understanding Effective Communication 00:15:00 Module 04: Cross-Cultural Communication Cross-Cultural Communication 00:13:00 Module 05 Establishing Trust and Rapport Establishing Trust and Rapport 00:13:00 Module 06: Collaboration and Teamwork Collaboration and Teamwork 00:14:00 Module 07: Managing Difficult Conversations and Conflict Managing Difficult Conversations and Conflict 00:14:00 Module 08: Building Professional Networks and Alliances Building Professional Networks and Alliances 00:15:00 Module 09: Sustaining Long-Term Relationships and Success Sustaining Long-Term Relationships and Success 00:16:00