Are you a teacher that wants to improve your classroom environment? Do you have questions about supporting children with their behaviour, communication and relationships? Book a 30 minute / 1 hour 1:1 coaching call. My coaching model will provide you with practical solutions to help you create a calm classroom environment. Discounts offered to subscribers.
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.
Why Learn Adobe Illustrator Basic to Intermediate Training Course? Course Link With our Illustrator Intermediate Course take your vector graphics to the next level and bring your designs to life with advanced techniques and tools. Gain hands-on skills in creating shapes, patterns, and logos, and learn how to edit images with precision. Duration: 6 hrs. Method: 1-on-1 - Personalized attention Schedule: Schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. This course covers fundamental tools and features of Adobe Illustrator, aimed at beginners, to enable them to create and edit vector graphics efficiently and effectively. Adobe Illustrator is the industry-leading vector graphic software for working with vector graphics, providing a comprehensive set of tools for producing exceptional graphics for various media, including print, video, web, and mobile devices. Course Title: Adobe Illustrator Course Outline: Mastering Advanced Drawing Techniques In-Depth Curvature Tool Mastery Advanced Pen Tool Usage: Drawing Complex Paths Understanding Path, Anchor Points, and Handles Precision Editing with Direct Selection Tool Slicing and Dividing Paths using Scissors and Knife Tools Exploring Advanced Stroke and Path Options Custom Width Profiles with the Width Tool Diverse Brushes Exploration in Brush Library Creating Scattered Objects with Scatter Brushes Applying Patterns along Paths with Pattern Brushes Crafting Custom Pattern Brushes Understanding Graphic Styles Efficient Usage of Graphic Style Libraries Creating, Deleting, and Saving Graphic Styles with Graphic Style Panel Leveraging the Power of Graphic Styles Mastering Pattern Manipulation Techniques Creating and Editing Patterns using Pattern Mode Modifying Pattern Elements with Precision Adjusting Spacing and Resizing Patterns using the Tile Tool Rectifying Background Errors with Overlap Options Saving and Exporting Custom Patterns Exploring Advanced Gradient Options Gradient Styles Exploration Fine-Tuning Gradients with the Gradient Annotator Creating Free Transform Gradient Points and Lines Applying Single Gradient across Multiple Objects Gradient and Transparency Integration Creative Applications and Practical Projects Applying Advanced Techniques to Real-World Projects Creative Problem-Solving Strategies Q&A Session and Feedback Gathering Note: Each section includes practical exercises and hands-on projects to reinforce learning. The course emphasizes practical application, ensuring participants leave with tangible skills and a deep understanding of advanced Adobe Illustrator concepts. Q: What will I learn in the London Design Training Course in Adobe Illustrator? A: In this course, you'll learn essential techniques for creating and editing vector graphics using Adobe Illustrator. The training covers drawing tools, shapes, layers, effects, styles, logo design, Image Trace, Live Paint, and integration into your design workflow. Q: What can I expect to achieve after completing the Illustrator training course? A: By the end of the course, you'll be proficient in Illustrator tools, create graphics for print, web, and mobile, design logos with special effects, and manipulate images. You'll receive an accredited Illustrator training certification and post-course support. Q: Is any prior knowledge of Illustrator required to attend the course? A: No, the course is designed for beginners, and no prior knowledge of Illustrator is necessary. Q: Which version of Illustrator will the training be based on? A: The training is primarily based on Illustrator 2023, but the techniques apply to recent releases. Q: Can I attend the course on either a Windows or Mac computer? A: Yes, Illustrator works identically on both Windows and Mac. Our training centers offer both platforms for your convenience.
Course Information Join us for a two-day immersive course crafted to equip participants with an in-depth understanding of remote audit methodologies. Delve into the nuances between remote and face-to-face audits, dissecting their respective strengths and limitations. Through practical scenarios tailored for remote audit conduct, this course stands as an essential counterpart to our on-site audits course The Auditing Course. Who Should Attend: Applicable across various domains of regulated research and development, this course proves invaluable in contexts requiring a quality system for audit. Participants with firsthand audit experience stand to gain the most benefit from this programme. Expanding on Previous Learning: This course extends its relevance to all forms of audits and further amplifies concepts explored in RQA's suite of research quality assurance courses, including: 'Research Quality Assurance for Good Laboratory Practice,' 'Good Clinical Practice Auditing – Principles and Practice,' and 'Good Manufacturing Practice for Investigational Medicinal Products.' Benefits include improved: Understand the processes of planning, conducting, reporting and follow-up of audits Recognising the importance of personal approach in developing positive audit outcomes Ability to analyse evidence and present logical audit findings Appreciate the importance of audit in continuing improvement. This course is structured to encourage delegates to: Discuss and develop ideas Solve problems Exchange information. Tutors Tutors will be comprised of (click the photos for biographies): Andrew Waddell Founder Director, Tower Mains Ltd Rosemary Ichaba Senior QA Associate, Tower Mains Ltd Cate Ovington Director, The Knowlogy Group Ltd Jean McWilliam Associate Director, Alexion Programme Please note timings may be subject to alteration. Day 1 09:00 Course Registration 09:15 Welcome and Introductions 09:35 Introduction to Audits Delegates explore the range of audits which they have experienced, define the purpose of each audit type and establish which of those audits are performed to meet regulatory requirements. 10:05 Introduction to Remote Audits Presentation to introduce the major differences between face-to-face audits and remote audits. The major elements of audits will be examined to determine where there may be differences. 10:30 Break 10:45 Workshop 1 - Remote Audits This workshop will examine participants experience or understanding of the differences between face-to-face and remote audits. 11:15 Workshop 1 - Feedback 11:35 Audit Preparation The essential steps in preparation for audits will be discussed with emphasis on remote audits. 12:05 Workshop 2 - Remote Audit Preparation Factors relating to the preparation for remote audits will be considered in discussion groups. 12:35 Workshop 2 - Feedback 12:50 Lunch 13:30 Audit Logistics Preparation for the audit includes many arrangements other than the audit content. 14:00 Workshop 3 - Audit Logistics Delegates will discuss some of the issues that may occur during the set up and conduct of remote audits and how to resolve them. 14:30 Workshop 3 - Feedback 14:45 Break 15:00 The Opening Meeting Presentation regarding the importance and content of the opening meeting. 15:20 Workshop 4 - Opening Meeting Delegates will consider the practicalities of arranging and conducting an opening meeting. 15:45 Workshop 4 - Feedback 16:10 Audit Conduct Tools Practical advice on preparation of some of the tools that will be valuable in the conduct of audits. 16:40 Questions and Answers An overview of the first day and a chance to ask questions 17:00 Close of Day Day 2 09:00 Reflections on Day 1 Recap on the topics covered and a chance for delegates to raise points. 09:15 Gathering Evidence Presentation on challenges of gathering evidence and conducting interviews during remote audits. 09:45 Workshop 5 - Remote Interviews Scenarios of different remote interviews will be played and delegates assess the strengths and weaknesses of each approach. 10:15 Break 10:30 Creating Audit Findings Ideas regarding how to create good audit findings will be discussed during this short presentation. 10:50 Workshop 6 - Creating Audit Findings Delegates will be provided with examples of evidence from an audit. They will discuss these and create their audit findings for presentation at the closing meeting. 11:35 The Closing Meeting The content and conduct of the closing meeting will be discussed. 11:55 Workshop 7(a) - Preparing for the Closing Meeting The findings from workshop 6 will be reviewed and a Lead Auditor selected to provide feedback in workshop 7(b) 12:15 Workshop 7(b) - The Closing Meeting The Lead Auditor from each group will hold a meeting to present the results (role play). 12:45 Lunch 13:30 The Audit Report This presentation will cover not only the essential contents of the audit report but also how to write the report in a manner that will generate the most positive reaction. 14:00 Workshop 8 - The Audit Report Delegates will be provided with an audit report from an audit conducted remotely and will conduct a peer review of the report in their breakout groups. 15:00 Workshop 8 - Feedback 15:20 Break 15:35 Audit Closure Presentation on how to conclude the audit with reference to post-audit activities. 15:55 Open Forum 16:30 Close of Course Extra Information Course material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking You will need a stable internet connection, a microphone and a webcam.
Develop your skills in agile project management and learn the agile approach using the DSDM® framework. Gain confidence to sit the AgilePM® Foundation and Practitioner qualifications on this accredited programme. Duration: 4 days (26 hours) This accredited course is designed for Project Managers, who require an understanding of the agile approach and/or who are intending to run projects using the DSDM® framework. It is also designed to equip practising Project Managers with the confidence to sit the AgilePM® Foundation and Practitioner qualifications, and each delegate will receive a copy of the Agile Project Management V2 Handbook, published by the Agile Business Consortium, formally known as the DSDM Consortium. Objectives By the end of the course you will be able to: Demonstrate a detailed, practical knowledge of Agile Project Management, based upon the DSDM framework and be equipped with the ability to apply the agile approach in the workplace Describe how the agile way of working can sit alongside more traditional project management frameworks, such as PRINCE2® Plan, organise and control Agile projects Sit the AgilePM Foundation examination, held on the third day and for the Practitioner examination, held on the afternoon of the fourth day Content Agile fundamentals What is Agile? Choosing an appropriate Agile approach Philosophy, Principles and Project Variables Preparing for Success Roles and responsibilities Roles and Responsibilities and the Project Manager view People, Teams and Interactions The DSDM process and products Looking at the DSDM Process and Project Management through the Lifecycle, as well as the DSDM Products and their Effective Use Practices and control Delivering on Time – combining MoSCoW Prioritisation and Timeboxing Requirements and User Stories Estimating Planning Quality Risk Examination and results Foundation Examination and results Practitioner Workshop and Examination AgilePM® Foundation Exam The AgilePM® Foundation Exam is of 40 minutes duration and consists of 50 multiple choice questions. A Pass is 25 correct answers. The exams are marked by the trainer immediately following the exam and the results are available within an hour. The AgilePM® Practitioner Exam A written paper of 2.5 hours duration. There are 8 Objective Test style questions to be answered in the 2.5 hours and the candidate may use an annotated manual. Each question is worth 10 marks and the candidate must score 40/80 to be successful. Please note that examinations are the responsibility of the examination board, APMG. Presented in association with aims4change, an APMG Accredited Training Organisation. AgilePM®is a Registered Trade Mark of the Agile Business Consortium Limited.
3ds max face to face training customised and bespoke. Live online or Face to Face.
Introducing Crisis Life Coach Package: Navigating Challenges and Rediscovering Your Strength Are you currently facing a crisis or challenging situation that is causing distress and uncertainty in your life? Miss Date Doctor’s Crisis Life Coach Package offers you targeted support and guidance from a trained life coach to help you navigate through crises, regain stability, and transform challenges into opportunities for growth. Life can present unexpected hurdles that leave us feeling overwhelmed and lost. Our experienced crisis life coaches are dedicated to helping you harness your inner resilience, develop coping strategies, and create a path forward amidst difficult circumstances. Here’s how the Crisis Life Coach Package can support you: Personalized Assessment: Our crisis life coach will conduct an initial assessment to understand your situation, concerns, and immediate needs. Stabilization Strategies: We’ll work on strategies to help you manage immediate crisis-related stress and anxiety. Crisis Transformation: Our life coach will guide you in reframing challenges as opportunities for personal growth and positive change. Coping Techniques: We’ll equip you with practical coping techniques to manage emotions and navigate stressors. Goal Setting: Together with your life coach, you’ll set realistic short-term and long-term goals to work towards during and after the crisis. Resilience Building: Crisis life coaching focuses on building emotional and mental resilience to handle adversity with strength. Actionable Steps: Our coach will provide you with actionable steps and strategies to implement in your daily life. Supportive Partnership: The Crisis Life Coach Package offers you a supportive partnership to guide you through challenging times. The Crisis Life Coach Package at Miss Date Doctor is designed to provide you with targeted support during moments of crisis. Our experienced life coaches are committed to helping you find clarity, develop coping skills, and navigate the path towards renewal and transformation. Invest in your well-being and take the first step towards resilience with the Crisis Life Coach Package. Embrace the opportunity to transform challenges into opportunities for growth, navigate through crises, and emerge from them stronger than before. Let our skilled life coach guide you towards a brighter and more empowered future. 3 X 1 HOUR and daily calls https://relationshipsmdd.com/product/crisis-life-coach-package/
Introducing the Dating Profile Specialist Package: Elevate Your Online Dating Experience with Expert Guidance Are you seeking professional assistance to create an exceptional online dating profile that stands out and captures the attention of potential matches? Miss Date Doctor’s Dating Profile Specialist Package offers you personalized guidance and support from experienced specialists who are dedicated to helping you present your best self in the online dating world. Crafting a standout dating profile requires expertise and insight into what makes a profile truly captivating. Our specialized dating profile experts are committed to helping you showcase your unique qualities and increase your chances of making meaningful connections. Here’s how the Dating Profile Specialist Package can support you: Personalized Assessment: Our dating profile specialists will conduct a thorough assessment to understand your personality, interests, and dating goals. Tailored Profile Creation: We’ll work with you to create a personalized and compelling dating profile that reflects your authentic self. Photo Selection: Our experts will provide guidance on selecting and arranging photos that highlight your best features and personality. Attention-Grabbing Bio: We’ll help you craft a captivating bio that effectively communicates your values, hobbies, and what you’re looking for in a partner. Showcasing Unique Qualities: Our specialists will assist in highlighting your unique qualities and qualities that set you apart from the crowd. Online Etiquette Guidance: We’ll provide insights into how to initiate conversations, maintain engaging communication, and build connections. Boosting Confidence: The Dating Profile Specialist Package can boost your confidence by providing expert support in creating an impressive and authentic profile. Attracting Compatible Matches: We’ll work towards attracting matches who resonate with your personality and are genuinely interested in connecting with you. The Dating Profile Specialist Package at Miss Date Doctor is designed to empower you with a standout online dating profile that captures your true essence. Our specialized dating profile experts provide tailored guidance and practical advice to help you make a lasting impression in the online dating community. Invest in your online dating success and take the first step towards a captivating dating profile with the Dating Profile Specialist Package. Embrace the opportunity to showcase your best self and attract matches that align with your values and aspirations. Let our experts guide you towards an enhanced online dating experience filled with meaningful connections. 4 sessions x 1 hour 20 new photos using Artificial intelligence approved https://relationshipsmdd.com/product/dating-profile-specialist/
About this Training Course This is an advanced chemistry training course for power plant chemists and boiler engineers wishing to expand their knowledge and skills, and to become more effective in their day-to-day roles dealing with thermal power plant chemistry. This 5 full-day course will provide ample opportunity for robust technical discussion and expand on advanced concepts in thermal power plant cycle chemistry. It focuses only on the steam/water aspects of the thermal power cycle. This course is a MUST for all power plant chemists and boiler engineers. It is also beneficial for anyone involved in power plant operation and maintenance because it provides guidelines and rules for improving power plant performance and reliability. Training Objectives Gain a significant increase in understanding of cycle chemistry in steam power plants and the inter-relationships between plant operation, cycle chemistry and potential failure modes due to corrosion and/or deposition throughout the cycle Gain a thorough understanding of all causes of corrosion in a steam power plant and all the methods used to reduce the corrosion rate in a steam power plant Become better equipped to effectively manage the corrosion and deposition risks in a thermal power plant Learn how to reduce failure rate in boilers and steam power plants and improve plant performance Understand condensate polishing and treatment of condensate return to industrial boilers Discover the causes of boiler water contamination and treatment programs Learn about layup and offline corrosion protection Understand water chemistry limits to prevent steam contamination by carryover Learn about boiler water chemistry guidelines and control of steam chemistry Understand high-purity make-up treatment methods Perform demineralizer calculations Perform system design calculations Gain a thorough understanding of mixed bed polishing and reverse osmosis Target Audience Power Plant Chemists Boiler Engineers Engineers involved in the operation and maintenance of power plants Managers Technicians Maintenance personnel Other technical individuals (this seminar is suitable for individuals who do not have a background in chemical engineering) Course Level Advanced Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'POWER GENERATION HANDBOOK' second edition, published by McGraw-Hill in 2012 in New York (800 pages) Water Chemistry for Thermal Power Plant Chemists and Boiler Engineers Manual (650 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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 post training support and fees applicable Accreditions And Affliations