676 Courses

Enhance your ear assessment and care skills with our comprehensive course on ear irrigation. Gain practical knowledge and updated insights for optimal ear hygiene.

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

Immerse yourself in the ancient practice of yoga, a transformative journey that extends far beyond the mere physical postures. Our comprehensive yoga sessions are meticulously curated and led by seasoned professionals, offering a serene sanctuary tailored for the demands of modern-day professionals yearning for holistic balance and wellness. Delve into innate human abilities such as intuition, telepathy, clairvoyance, lucid dreaming, and energy healing. Uncover these dormant gifts existing within and enjoy awakening them fully.

Miss Date Doctor’s Emotional Intelligence coaching is designed to help you develop the skills and knowledge needed to understand and manage your emotions effectively. Emotional intelligence is a critical factor in building strong, healthy relationships, and our coaching can provide you with the tools needed to enhance your emotional intelligence and improve your relationships. Our Emotional Intelligence coaching includes a range of techniques and strategies, such as self-awareness, self-regulation, empathy, and social skills. We can help you learn to identify and manage your emotions, as well as to understand and respond effectively to the emotions of others. With our Emotional Intelligence coaching, you can learn to build stronger, more fulfilling relationships by improving your ability to communicate effectively, resolve conflicts, and understand the needs of your partner or potential partner. Whether you’re looking to enhance your personal relationships or to improve your professional performance, our Emotional Intelligence coaching can help you achieve your goals. Have 3 one hour sessions with a certified qualified experienced professional The Miss Date Doctor Emotional Intelligence package includes the following: Relationship Emotional Intelligence, Emotional Intelligence Coaching, Self-Awareness, Self-Regulation, Empathy, Social Skills, Emotion Management, Emotion Understanding, Emotional Intelligence Training, Communication, Conflict Resolution, Relationship Building, Emotional Intelligence Techniques. https://relationshipsmdd.com/product/emotional-intelligence-package/

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

***Note: Offer is Valid for the First 10 Learners Only*** DET: Level 5 Diploma in Education and Training (RQF) Are you passionate about teaching? Would you like to pursue a career in the education sector? If the answer is yes, the Focus Awards Level 5 Diploma in Education and Training (RQF) course is the perfect one to land a job with an average salary of £30,000 per year in the UK. Our meticulously designed curriculum covers various essential topics, from understanding educational theories to effective teaching methodologies. The Focus Awards Level 5 Diploma in Education and Training (RQF) course will boost your tutor skills. At the end of the period, you will be able to demonstrate proficient teaching and instructional skills and assess and evaluate student progress plus performance accurately. The Focus Awards Level 5 Diploma in Education and Training (RQF) course is not just about obtaining a diploma; it's about embracing your passion, unlocking your potential, and making a lasting impact on the lives of your future students. Why this Job Ready Program is a Perfect Package for You! So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our {Course_Title}: Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis. One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking professionals. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Our aim is to maximise your employment prospects and provide you with a range of exciting opportunities to choose from. Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Get Unlimited Access to Entire Library: Enjoy unlimited access to our entire course library for a year. Seize this golden opportunity to advance your skills and achieve new heights! Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee. So enrol in this DET: Level 5 Diploma in Education and Training (RQF) course to begin a smooth career in the education industry. Why choose focus awards? Focus Awards is recognised and regulated by Ofqual (The Office of Qualifications and Examinations Regulation) in the United Kingdom. Focus Awards qualification is respected worldwide, opening doors to diverse career opportunities. Therefore, the Level 5 Diploma in Education and Training (RQF) course is one of the best in the market due to Focus Awards accreditation. Stay ahead of the curve with the cutting-edge teaching methods and technologies of the Focus Awards. Benefits you will gain from this Focus Awards Level 5 Diploma in Education and Training (RQF): High-quality digital learning materials Intuitive e-learning platform Top-notch education standard Globally recognised certification Modules are available 24/7 for your convenience Exceptional customer support services DET: Level 5 Diploma in Education and Training (RQF) Curriculum Break Down and Credit Information for DET: Level 5 Diploma in Education and Training (RQF): The DET course has two unit groups in the curriculum. To achieve the qualification, learners must gain at least 120 credits (Group A - 75 credits and Group B - 45 credits). A minimum of 61 credits will have to be from Level 5. DET Group A-Mandatory Units: Unit 01: Teaching, Learning and Assessment in Education and Training [Achievement of the unit Theories, principles and models in education and training is a prerequisite for this unit.] Guidance to Achieving the Unit: Assignment Unit 02: Developing Teaching, Learning, and Assessment in Education and Training Guidance to Achieving the Unit: Assignment Unit 03: Theories, Principles and Models in Education and Training Guidance to Achieving the Unit: Assignment [Achievement of this unit is a prerequisite for the unit Developing Teaching, learning, and Assessment in education and training] Unit 04: Wider Professional Practice and Development in Education and Training Guidance to Achieving the Unit: Assignment DET Group B- Optional Units Unit 01: Developing, Using and Organising Resources in a Specialist Area Unit 02: Inclusive Practice Unit 03: Effective Partnership Working in the Learning and Teaching Context Guidance to Achieving the Units: Study Material Assignment Teaching Practice Requirement To get this level 5 DET qualification, you must practise for at least 100 hours and provide proof of your involvement in teaching groups of students. A crucial component of excellent beginning teacher preparation is the practice component. Each unit in this certificate has a unique practice requirement. Transfer of Practice There is no transfer of practice from a prior Level 3 Award in Education and Training(AET), including an approach that has been watched and assessed. Trainee teachers who have earned the Level 4 Certificate in Education and Training(CET) may apply twenty hours of practice and two hours of course that was observed and assessed towards the Level 5 Diploma in Education and Training's (DET) practice requirements. At least eight observations must be made, each lasting at least eight hours. Any observed practice finished as a part of the Level 3 Award in Education and Training is not included. Every single observation must last at least 30 minutes. Practice for the Education and Training units must occur in a classroom setting. A minimum of eight observations, of course, are required. The following necessary units must be connected to the eight observations: Teaching, learning, and assessment in education and training (Level 4) Developing teaching, learning, and assessment in education and training (Level 5). Qualification Study Time of Level 5 Diploma in Education and Training (DET - Previously DTLLS) Total Qualification Time of Level 5 Diploma in Education and Training (DET - Previously DTLLS): TQT is the approximate time a learner must complete all the course requirements to acquire his qualification. It entails preparing for classes, learning, researching, taking tests, etc. Total Qualification Time for this Level 5 Diploma in Education and Training (DET - Previously DTLLS) course - 1200 hours. Guided Learning Hours of Level 5 Diploma in Education and Training (DET - Previously DTLLS): GLH is the approximate duration a learner will require to meet all the course objectives for gaining his qualification under the presence of a supervisor or tutor. Total Guided Learning Hours for this course - 360 Who is this course for? DET: Level 5 Diploma in Education and Training (RQF) This DET: Level 5 Diploma in Education and Training (RQF) course is designed for those who want to work in the educational field as a competent professional. It provides excellent training to individuals who wish to obtain a sought-after educational and training qualification. Requirements DET: Level 5 Diploma in Education and Training (RQF) Learners must meet the following minimum criteria: Reading and communication skills should be adequate to meet the requirements of the training. Do not have a criminal background which prevents them working, with young people or vulnerable adults, as a teacher. Hold a relevant qualification at a level above that of their learners; ideally at least Level 3 in their area of specialism The minimum core of literacy, language, numeracy and ICT Career path DET: Level 5 Diploma in Education and Training (RQF) Lecturer / Teacher Assistant Teacher Coach or Trainer Teacher Primary School Teacher Secondary School Teacher Private Tutor Freelance Teacher/Trainer Certificates Hard Copy Certificate Hard copy certificate - Included

  Relationship Counselling in Kensington: Reconnect and Grow with Our 3-Session PackageEnhance your relationship with our personalized Relationship Counselling in Kensington. Our specialized package offers three intensive 1-hour sessions designed to improve communication, resolve conflicts, and build a deeper emotional connection.In these sessions, couples will learn and practice: Communication Skills: Develop the ability to express your thoughts and emotions clearly while improving your active listening skills. Conflict Resolution Strategies: Learn effective methods to address and resolve disagreements constructively, ensuring mutual respect and understanding. Emotional Intimacy: Strengthen your emotional bond by understanding each other’s needs and fostering empathy. Trust Building: Discover techniques to rebuild and maintain trust, an essential element of a healthy relationship. Stress Management: Gain tools to manage external stressors together, fostering a supportive and resilient partnership. Goal Alignment: Align your personal and relationship goals to create a harmonious and unified vision for your future. Our experienced therapists in Kensington provide a safe and supportive environment where couples can explore these critical aspects of their relationship. Each session is tailored to address your unique challenges and aspirations, ensuring personalized and effective guidance.Book your Relationship Counselling in Kensington today and take the first step towards a stronger, more fulfilling relationship. Relationship Counselling in Kensington and Chelsea | M.D.D Dating Coach, Couples Therapy, Breakup Counselling, Personal development Consultancy (relationshipsmdd.com)

  Relationship Counselling in Victoria: Strengthen Your Bond with Our Expert 3-Session Program   Revitalize your relationship with our bespoke Relationship Counselling in Victoria. Our expertly designed package includes three comprehensive 1-hour sessions aimed at improving communication, resolving conflicts, and fostering a deeper emotional connection.   Throughout these sessions, couples will explore and develop:   Effective Communication: Master the art of expressing your thoughts and feelings clearly while actively listening to your partner. Conflict Resolution Techniques: Learn to navigate disagreements constructively, ensuring mutual respect and understanding. Emotional Intimacy: Build a stronger emotional bond by understanding each other’s needs and cultivating empathy. Trust Enhancement: Implement strategies to rebuild and maintain trust, a cornerstone of any healthy relationship. Stress Management: Develop coping mechanisms to manage external stressors together, promoting a supportive partnership. Shared Goal Setting: Harmonize your personal and relationship goals to create a unified vision for your future. Our skilled therapists in Victoria provide a nurturing and confidential environment, allowing couples to address their unique challenges and grow together. Each session is tailored to your specific needs, ensuring personalized and impactful support.   Schedule your Relationship Counselling in Victoria today and embark on a journey towards a more resilient and fulfilling relationship. Marriage Counselling Victoria | M.D.D Dating Coach, Couples Therapy, Breakup Counselling, Personal development Consultancy (relationshipsmdd.com)

Adobe After Effects Training Fundamentals to Essentials. Learn essential techniques for creating visual effects and animations. Adobe After Effects Essentials VFX Course to learn auto-correction methods and tools, adjust video effects or presets to layers, and utilize 3D space for modifying composition. Click here for more info: Website Duration: 20 hours Approach: 1-on-1 personalized sessions and Tailored content. Flexibility: Book a time convenient for you, Monday to Saturday, between 9 am and 5 pm. Duration: 20 Hours Module 1: Introduction to After Effects (2 hours) Understanding the After Effects interface Project planning and organization techniques Module 2: Asset Preparation and Composition Setup (3 hours) Importing and organizing multimedia assets Setting up compositions for different media formats Module 3: Applying Transformations and Effects (5 hours) Animating images, videos, and text Applying diverse transformations and effects for dynamic visuals Module 4: Mastering Masking and Compositing (5 hours) Creating and refining masks for precise editing Advanced compositing techniques for seamless integration Module 5: Rendering High-Quality Videos (3 hours) Configuring rendering settings for various output formats Ensuring optimal quality in the final video output Module 6: Project Review and Q&A Session (2 hours) Reviewing projects and addressing individual queries Fine-tuning techniques based on participants' needs Course Benefits: Hands-on learning with personalized attention Mastering crucial After Effects skills for diverse media projects Access to recorded lessons for future reference Continuous email support for post-course inquiries After Effects Download  https://www.adobe.com Upon completing the Essential After Effects Skills Mastery course, participants will: Proficiency in After Effects: Master the After Effects interface, gaining confidence in navigating the software effectively. Strategic Project Planning: Acquire skills in project organization and planning, ensuring a systematic approach to video projects. Advanced Asset Management: Learn efficient techniques for importing, organizing, and managing multimedia assets within After Effects projects. Dynamic Composition Creation: Gain expertise in setting up compositions tailored to various media formats, understanding their intricacies and potential applications. Creative Animation Techniques: Apply diverse transformations and effects to images, videos, and text, enhancing the visual appeal of multimedia content. Precision in Masking and Compositing: Master the art of masking, enabling precise editing, and explore advanced compositing techniques for seamless visual integration. High-Quality Video Rendering: Understand rendering settings, ensuring optimal video quality for different output formats, whether for online platforms or professional presentations. Project Review and Refinement: Engage in project reviews and Q&A sessions, refining techniques and addressing individual queries for comprehensive learning. Confidence in Video Production: Develop confidence in producing high-quality videos, equipped with a robust skill set essential for various creative projects. Continuous Learning Support: Benefit from continuous email support, providing assistance with post-course inquiries, ensuring ongoing learning and skill refinement. In this course, you will learn: Efficient workflow planning and asset organization in After Effects projects. Creative project development techniques for engaging visuals. Image and video asset preparation using Photoshop. After Effects project setup, compositions, and asset integration. Animation of transformations and effects on layers. Advanced mask creation and animation for creative compositing. Dynamic text animation and 3D exploration. Keying and seamless visual integration techniques. Understanding export settings, project backup, and archiving. Learning Objectives: Upon completion, you will master asset organization, animations, masks, text effects, and seamless integration, ensuring proficiency in After Effects projects. Prerequisites: Basic computer skills and a fast-paced learning mindset are required. No prior experience is necessary, making this course suitable for beginners. Key Features: Personalized one-on-one or live online coaching sessions. Suitable for both beginners and professionals in motion graphics and animation. Tailored Training: Courses customized to meet your specific requirements. Flexible scheduling options to suit your availability. Industry Standard: Adobe After Effects, the industry-preferred software for visual effects, motion graphics, and compositing. Widely used in filmmaking, video games, and TV production. Learning Approach: Hands-on training with detailed, step-by-step demonstrations. Real-time feedback during sessions, along with access to session recordings. Course Benefits: Certificate of Attendance upon completion. Comprehensive practical training guide for reference. Lifetime email and phone support for continuous assistance. Help with software installation for a seamless learning experience. Lifetime Support: Ongoing email and phone/WhatsApp support for lifelong learning assistance. Elevate your motion graphics expertise with our Adobe After Effects Basic to Fundamentals Training Course. Open doors to exciting opportunities in the ever-evolving realm of visual effects.

  Relationship Counselling in Mayfair: Transform Your Partnership with Our Comprehensive 3-Session Package   Unlock the full potential of your relationship with our specialized Relationship Counselling in Mayfair. Our tailored package includes three intensive 1-hour sessions designed to strengthen your bond, enhance communication, and resolve conflicts effectively.   During these sessions, couples will delve into essential areas such as:   Communication Skills: Learn how to articulate your thoughts and feelings clearly and listen actively to your partner. Conflict Resolution: Discover strategies to manage disagreements constructively, ensuring both partners feel heard and respected. Emotional Intimacy: Enhance your emotional connection by understanding each other’s needs and fostering deeper empathy. Trust Building: Develop techniques to rebuild and maintain trust, a critical component of a healthy relationship. Stress Management: Learn how to handle external stressors together, creating a supportive and resilient partnership. Goal Setting: Align your personal and relationship goals to ensure a harmonious future together. Our experienced therapists in Mayfair are dedicated to providing a safe and supportive environment where couples can explore these vital aspects of their relationship. Each session is crafted to address your unique challenges and aspirations, ensuring personalized and effective guidance.   Book your Relationship Counselling in Mayfair today and take the first step towards a stronger, more fulfilling relationship. Relationship Coaching London (relationshipsmdd.co.uk) Relationship counselling Mayfair⭐⭐⭐⭐⭐ | M.D.D Dating Coach, Couples Therapy, Breakup Counselling, Personal development Consultancy (relationshipsmdd.com)