17066 Other courses in Stonehaven delivered Online

In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Exploiting the opportunity The world of digital media means there are lots of opportunities to appear online, on radio or on TV, as an expert or commentator and gain invaluable exposure for your business and organisation. You may meet journalists at industry events or be contacted for a comment on an issue. You may also need media training because you have to protect your business’ reputation by reacting proactively if you become involved in a news story. Media training will help you handle interviews with journalists, content creators and other media professionals. You need to communicate positively and effectively and make sure your message reaches the audience. It means speaking consistently, and with style and confidence. You’ll also need to know how to handle challenging questions and make sure you positively manage your reputation. Contemporary Media Training Our media training is interactive, engaging and importantly, carried out by experienced journalist trainers. Our team has worked at the highest levels of journalism and broadcasting and will give you an invaluable insight into how to maximise the opportunity of a media appearance. We will take you through the background of what journalists want and need, and give you a clear understanding of how to prepare and deliver your messages and ideas. We will then carry out a number of media style interviews which our technical team will record and playback so you can see and hear yourself. We will then support you with practical, inclusive and useful feedback for you to put into practice for the next interview. We provide copies of all your recordings and useful notes after the training. Locations that suit you We deliver training at our facilities in Birmingham or London or at your location, bringing our technical equipment and cameras with us. You can have a half day training session for up to 4 people or a full day training for a larger group. We also deliver training online for small groups which can be useful when teams are spread around the country. Expert Journalist Trainers We pride ourselves on two things at Coherent Comms – delivering contemporary media training and our supportive inclusive feedback. We know there are lots of media training companies out there but our clients tell us they work with us because we listen. We don’t tell you what training you need or hark back to the old days. We take on board your communication needs and deliver bespoke training. Our associates are working in digital communications, carrying out interviews for news online sites and our contacts are producing digital content for a 21st century audience. We’ll talk to you about TV and radio but we understand the wider media landscape and how to navigate it. And we’re really proud of our feedback – we want to take you from good to great and believe confidence building with tips and ideas that will work for you is the best way to develop your skills. We will help you design the course you want All our media training is bespoke and designed to exactly suit your needs. We have lots of ideas of how it might work but we want to hear from you and what you want! So get in touch with our friendly team by phone on 0754 533 4269 or fill in our contact form and we will get back to you. We’d love to hear how you hope to improve your media and communication skills.

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. They may be hired on a full-time basis and carry a full CFO workload or can be recruited on a part-time or interim basis to focus on a specific merger or acquisition. This flexibility is ideal for start-ups and SMEs who don’t have the budget to recruit a full external team to oversee an M&A or to hire a full-time CFO. The CFO is a link between both companies engaged in the M&A, acting as the eyes and ears for both the board and CEO. Their financial skills enable them to identify potential M&A opportunities and incorporate risk management into their strategy to get the most value out of their deal. Most companies evolve their approach to mergers and acquisitions organically, especially those who rely on an M&A specialist instead of having a dedicated team that works solely on M&A. The CFO is responsible for considering any potential acquisitions, crunching the numbers involved, and ensuring due diligence. They’ll be responsible for determining the value of a potential M&A and presenting it to the company’s board and leadership team to determine whether to make the purchase. An M&A specialist is responsible for gathering the data – including both positive and negative factors – to present an objective look at the other organisation and the potential value the acquisition could bring. CFOs will spend most of their time getting to grips with the numbers involved, long before presenting the M&A proposal to the board. This exercise also requires them to have real-time insight into their own company’s performance, value, and finances to paint a wider picture. An M&A specialist will take the critical steps of ensuring that the numbers presented to them are correct. CFOs who don’t specialise in M&As will still have the skill set required to oversee the process but may lack the efficiency and unique insight of an M&A specialist. Companies that are exploring the option of a merger or being acquired by another company may also decide to recruit an M&A specialist to prepare their accounting. The organisation will want to ensure they present the correct numbers to get the correct valuation and prevent any delays further in the process if incorrect numbers pop up. Getting on top of the data early can enable CFOs to plan accordingly. Most will want to provide extra time within their strategy for any potential hiccups along the way. Spending more time on the data early on can speed up the process while still ensuring due diligence is met. Visit our website to learn more https://www.fdcapital.co.uk/mergers-and-acquistions-specialist/ Tags Online Events Things To Do Online Online Networking Online Business Networking #finance #insights #cfo #mergers #acquisitions

Do you want to be more successful? To have a better quality of life? If so, then discover how NLP can help you to achieve this.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The world of medical science relies heavily on the skilled hands of laboratory technicians. Did you know that in the UK alone, there are over 100,000 laboratory technicians working across various healthcare settings? They play a vital role in diagnosing diseases, monitoring treatment progress, and ensuring public health. If you're interested in a career in a fast-paced, science-driven environment, then this Lab Technician course bundle might be the perfect first step for you. This Lab Technician Bundle Package includes: Course 01: Laboratory Technician Course 02: Microbiology Lab Technician Course 03: Infection Prevention Training Course 04: Phlebotomist Training Course 05: Forensic Psychology This comprehensive Lab Technician bundle equips you with the knowledge and practical skills needed to excel as a laboratory technician. You'll gain a strong foundation in human anatomy and physiology, the cornerstone of medical science. You'll also gain practical skills in phlebotomy, the process of blood collection, and essential infection prevention practices to keep yourself and others safe in a lab setting. Learning Outcomes of Lab Technician Perform basic laboratory procedures with accuracy and precision. Apply knowledge of microbiology to identify and analyse pathogens. Practice safe phlebotomy techniques for blood sample collection. Implement infection prevention protocols to maintain a sterile environment. Explain human anatomy and physiology concepts relevant to lab testing. Demonstrate first aid skills to ensure workplace safety. Take the first step towards your future in medical science - enrol today in Lab technician! Why Choose Our Lab Technician Course? Get a Free CPD Accredited Certificate upon completion of Lab Technician Get a free student ID card with Lab Technician Training Get instant access to this Lab Technician course. Learn Lab Technician from anywhere in the world The Lab Technician is affordable and simple to understand The Lab Technician is an entirely online, interactive lesson with voiceover audio Lifetime access to the Lab Technician course materials The Lab Technician comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Laboratory Technician Introduction to the Course Medical Laboratory Services Laboratory Equipments (Part-01) Laboratory Equipments (Part-02) Microscope and How to Use It Solutions Used in ClinicalMedical Laboratory Sterilisation, Disinfection and Decontamination Basic Haematology Basic Haemostasis (Coagulation) Basic Immunology and Immunohematology Course 02: Microbiology Lab Technician Module 01 : Introduction to Microbiology Module 02 : Cell Structure and Organisation Module 03 : Microbial Diversity Prokaryote Diversity Module 04 : Microbial Diversity Eukaryote Diversity Module 05 : Viruses, Viroids, and Prions Module 06 : Interactions between Microbes and Humans Module 07 : Human Microbial Diseases Module 08 : Microorganisms in the Environment Module 09: Laboratory Equipments (Part-01) Module 10: Laboratory Equipments (Part-02) Course 03: Infection Prevention Training Module 01: Introduction To Infection And Infection Control Module 02: Legislation And Policies Module 03: Infection Risk & Management Module 04: Personal Protective Equipment (PPE) Module 05: PPE Practical Uses Module 06: Understanding Person-To-Person Spread Of Disease =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Lab Technician bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! School leavers Career changers Science graduates Requirements No prior background or expertise is required to enrol in this Lab Technician bundle. Career path This Lab Technician bundle aims to help you get the job or even the long-awaited promotion of your dreams. Lab Technician Research Assistant Clinical Technologist Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Have you ever considered a career dedicated to helping others? In the UK alone, social workers play a vital role in supporting vulnerable children, families, and adults. With an aging population and rising social complexities, the demand for skilled social workers is high, with over 98,000 social workers employed across various sectors. Do you have the passion and compassion to make a positive impact? This Social Work Training Bundle equips you with a holistic understanding of social work principles and practices. You'll gain the knowledge and skills to assess needs, develop interventions, and effectively communicate with clients. The bundle also explores youth work and coaching techniques, broadening your professional skillset. Our bundle Course includes 5 of our Popular courses for one discounted price: Course 01: Social Work Studies Course 02: Social Worker Course 03: Youth Work Course 04: Life Coaching Course 05: Public Speaking Enrol today and take the first step towards a rewarding path in social work! Learning Outcomes of Social Work Training Gain a comprehensive understanding of social work principles and ethics. Develop effective communication skills for working with diverse clients. Master intervention strategies for social work practice. Learn how to empower young people and support their development. Build strong life coaching skills to guide individuals towards their goals. Enhance your public speaking abilities to advocate for vulnerable populations. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Social Work Get a free student ID card with Social Work Training program (£10 postal charge will be applicable for international delivery) The Social Work is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Social Work course materials The Social Work comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Social Worker course: Course 01: Social Work Studies Module 01: An Overview Of Social Work Module 02: Social Work Basics Module 03: Theories Of Social Work And Sociology Module 04: Casework Process And Teamwork Module 05: Dimensions Of Social Work / Models Of Intervention Module 06: Practice Contexts And Application Module 07: Working With Adults Module 08: Principles Of Conduct And Role As Social Care Worker Course 03: Youth Work Section 01: Introduction To Youth Work Section 02: Youth Work And Responsibilities Section 03: Youth Work And Social Care Section 04: Youth Work And Mental Health Section 05: Youth Work And Safeguarding Section 06: Youth Work And Internet Safety Section 07: Youth Work And Importance Of Communication Section 08: Youth Work And Legalities Course 04: Life Coaching Module 01: Introduction to Life Coaching Module 02: History of Life Coaching Module 03: Listening as a Coach Module 04: The Language of Coaching Module 05: Coaching as a Developmental Change Process Module 06: Empowering the Client Module 07: Ethics in Coaching Module 08: Becoming an Effective Leader and Coach =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Social Worker course. This course is open to everybody. Aspiring Social Workers Youth Workers Life Coaches Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Social Worker Youth Worker Life Coach Social Care Manager Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Are you feeling overwhelmed by the constant changes in your organisation? Do you struggle to keep your team motivated and compliant during times of transition? In the UK, 70% of change initiatives fail to achieve their desired goals. If so, this Change Management bundle is exactly what you need. This Change Management bundle will provide you with a comprehensive understanding of change management principles and frameworks. You'll learn how to assess the need for change, develop a clear vision and implementation plan, and effectively communicate the transition to your team. The course will also cover strategies for overcoming resistance, managing stakeholder expectations, and embedding the change for long-term success. This Change Management Bundle Contains 5 of Our Premium Courses for One Discounted Price: Course 01: Change Management Course 02: New Manager Course 03: Leadership and Management Course 04: Compliance Management Course 05: Diploma in Workplace Safety Take control of change and become a leader who empowers others to embrace new initiatives. This Change Management bundle is your key to a successful and fulfilling career. Learning Outcomes Of Change Management Understand the key drivers and challenges of organizational change. Apply change management frameworks to real-world scenarios. Develop effective communication strategies for change initiatives. Build employee buy-in and overcome resistance to change. Evaluate the success of change initiatives and make adjustments as needed. Craft a compelling vision for the future to motivate your team. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Change Management Get a free student ID card with Change Management Training program (£10 postal charge will be applicable for international delivery) The Change Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Change Management course materials The Change Management comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Change Management Part 1 - Course Overview Part 2 - What is Change? Part 3 - The Change Cycle Part 4 - The Human Reaction to Change Part 5 - The Pace of Change Part 6 - The Four Room Apartment Part 7 - Dealing with Resistance Part 8 - Adapting to Change Part 9 - Strategies for Dealing with Anger Part 10 - Managing Stress Course 02: New Manager Module One: Managers Are Made, Not Born Module Two: Create A Management Track Module Three: Define And Build Competencies Module Four: Managers Learn By Being Managed Well Module Five: Provide Tools Module Six: Provide Support Module Seven: Identify Strong Candidates Early Module Eight: Clearly Define The Management Track Module Nine: Empower New Managers Module Ten: Provide Growth Opportunities Course 03: Leadership and Management Module 01: Principles Of Management Module 02: Applied Theories On Leadership Module 03: Leadership And Management Differences & Applications Module 04: Obstacles In Leadership And Management Module 05: Different Leadership Styles Module 06: Impact Of Different Leadership Style And Mentoring How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Managers Team Leaders HR Professionals Project Managers Change Agents Requirements You will not need any prior background or expertise to enrol in this Change Management bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Change Leader Project Manager Consultant Business Analyst HR Manager Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

A masterclass on becoming a confident hypnotherapist! In this transformative masterclass, we will empower you with the knowledge and techniques needed to inspire confidence in both yourself and your clients.

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.