6250 Courses

Enhance your ability to apply a range of techniques and tools to help improve management of emotions under stress, make more effective decisions in difficult scenarios and manage your energy more effectively in stressful situations.

Join internationally renowned baker & author, Emmanuel Hadjiandreou as he demonstrates the skills & techniques for you to recreate perfect pastry. 

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.

Enhance your SkillsBuilding on Level One and the skillset developed, you will be advancing onto more advanced machine polishing and cleaning techniques, to progress your detailing career and skillset further. Existing valeters and detailers confident in their skillset's reflection of Level One's content may also qualify to bypass to this level, should they be able to demonstrate their qualification by purchasing, taking, and passing with sufficient breadth, our online Level One assessment. Machines introduced at this level include forced rotation dual action polishers, every inception of Dual action polishers, both in throw and size. We'll also look at pad types, heavy cutting options and defect identification to assess what can be rectified and how. Interiors are explored in greater depth with higher yield services with 'dry' steam cleaning, odour removal, leather protection and treatment, and stain removal with the associated chemistry. Small area sanding and isolated correction are a key finish to this level and allow you to achieve fantastic results from otherwise irreparable damage Following your introduction skills learnt in Level One, you will be progressing onto more skilful machine polishing and cleaning techniques. Machines introduced at this level include forced rotation dual action polishers, every inception of Dual action polishers, both in throw and size. We'll also look at pad types, heavy cutting options and defect identification to assess what can be rectified and how. Interiors are explored in greater depth with higher yield services with dry steam cleaning, odour removal, leather protection and treatment, and stain removal with the associated chemistry. • Pad types • Compound grades • Rubber and plastic protection • Coatings after-care • Polymer and PTFE exterior LSPs • Glass sealants • Troubleshooting • Accreditations • Financial management • Insurance • Marketing • Pricing • Spot Sanding • Targeting your customer base • Safe working practice • Workshop planning • Intermediate chemical knowledge • Efficiency and time management • Matte finishes • Environmental considerations • Advanced cleaner chemistry • Bonded overspray and concrete • LSPs • Engine bay detailing • Plastic trim restoration • Odour removal • Steam cleaning • Stain removal & chemical principles • Fabric and leather protection • Paint types and their principles • Long and short throw DA machines • Forced action machines • Lighting • Defect identification Following the course, further case studies and exercises will allow the knowledge to develop further as you use it over a 3-6 month period, after which the Level 2 exam is sat to award certification. Course Length 2 Days (0930-1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Completion of Level 1 Refreshments or Lunch Refreshments included

The ACTIVE Coaching® system provides powerful, effective coaching to un-lock employee potential, improve motivation as well as build self-confidence.

Become a proficient assessor with our Level 3 Assessor CAVA course, designed to equip you with the essential skills to assess vocational competence effectively. Whether you're evaluating skills in a workshop, classroom, or training environment, this comprehensive course prepares you to guide learners through their learning journey with precision and feedback. Course Outline: Unit 301: Understanding the Principles and Practices of Assessment Unit 302: Assess Occupational Competence in the Work Environment Unit 303: Assess Vocational Skills, Knowledge, and Understanding Entry Requirements: No formal prerequisites are needed, but candidates should work in or aspire to quality assurance roles. This course is a solid foundation for those venturing into quality assurance responsibilities. Access to two learners is required for the full Award. Course Assessment: Under the guidance of your assessor, you'll compile a portfolio of evidence throughout the course. Your assessor will mark this portfolio, which will be internally quality-assured by the centre and authority. Course Fee: Online/Distance Learning: £359.99 Zoom Classroom-based Course: £479.99 Corporate or Group Booking: Benefit from special discounts on corporate or group bookings, allowing our experienced trainers to deliver tailored training at your location. How to Book: Book online via PayPal, debit/credit card, invoice, or bank transfer. You can also book over the phone or visit our office for assistance. Instant booking confirmation will be sent via email. Need Assistance? For any queries or assistance, our dedicated team is just a phone call or email away. We're here to support you every step of the way. Contact us today to embark on your journey towards becoming a certified assessor. Book Now

If you have already visited me for any training, including an initial 1-to-1 session, workshop or course and would like to come for a Follow-up, then please do book an appointment Support includes reinforcing and strengthening new skills and concepts for you and your dog and helping set new strategies.

This short workshop is designed to walk you through the basics of creating a pen portrait of your ideal customer – in this case, teachers. Understand what they want and need, hone your messaging and move towards increasing your visibility.

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

During this 2 day course, you will develop a learning-based action plan to use in your workplace ensuring that you can put the learning into action.