851 Courses in Cardiff delivered Live Online

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Duration 1 Days 6 CPD hours This course is intended for This course is designed for a non-technical audience and doesn't require any prior coding or technical experience. The handson exercises will be done using pre-built OpenAI tools and interfaces that are user-friendly and easy to use. Overview Working in an interactive learning environment, led by our engaging expert, you will: Get comfortable with the basics of prompt engineering and discover how it can make a difference in various business tasks, such as enhancing customer support, creating content, and fine-tuning sales pitches. Develop the knack for crafting, refining, and perfecting prompts suited to specific business situations by understanding context, user intent, and what makes a prompt great. Learn how to smoothly incorporate prompt engineering solutions into your existing business workflows, including pinpointing the right processes, integrating with your current software, and keeping data privacy and security in check. Become proficient in advanced techniques and best practices in prompt engineering, like making use of APIs, customizing language models, and collaborating with your teammates across different departments. Keep up with the latest developments in prompt engineering and be ready to adapt to changing business needs and trends, ensuring that you stay relevant and continue to grow in the dynamic business world. Prompt engineering is the process of designing and refining input prompts to get desired output from advanced language models, such as OpenAI Codex or GPT-4. It involves creating effective questions or statements that guide the AI model to generate useful responses for a specific task or purpose, like enhancing customer support, generating content, and fine-tuning sales pitches, making it an essential skill set for a wide range of business applications. Quick Start to Prompt Engineering for Everyday Business Users is a one-day, workshop style hands-on course that where you'll learn how to create effective prompts, integrate prompt engineering solutions into existing workflows, and uncover advanced techniques and best practices. Guided by our engaging, expert instructor, you?ll experiment with innovative tools and develop practical skills that can be immediately applied to a variety of projects. Whether you're aiming to enhance customer interactions, simplify content creation, or refine internal communication, this immersive learning experience will equip you with the knowledge to make a meaningful impact on your organization. Introduction to Prompt Engineering Understand the fundamentals of prompt engineering and its applications in the business world. What is prompt engineering? Importance of prompt engineering in business Key concepts and terminology Examples of prompt engineering in business scenarios Overview of popular prompt engineering tools (e.g., OpenAI Codex, GPT-4) Activity: Hands-on exploration of prompt engineering tools: Participants will engage in a fun scavenger hunt activity, where they will experiment with different prompt engineering tools to answer a set of questions. Developing Effective Prompts Learn how to create and refine prompts for a variety of business applications. Anatomy of a good prompt Understanding context and user intent Techniques for prompt iteration and optimization Generating specific and creative responses Handling sensitive information and biases Activity: Prompt development workshop: Participants will practice developing and refining prompts in a collaborative, game-like environment, where they will compete to create the most effective prompts for given business scenarios. Integrating Prompt Engineering into Business Processes Discover how to incorporate prompt engineering solutions into existing workflows. Identifying business processes that can benefit from prompt engineering Integrating prompt engineering with existing software and tools Evaluating the success and impact of prompt engineering solutions Ensuring data privacy and security Scaling prompt engineering solutions across an organization Activity: Business process integration simulation: Participants will work in teams to create a plan for integrating a prompt engineering solution into a simulated business process, with a focus on creativity and practicality. Advanced Techniques and Best Practices Gain insights into advanced techniques and best practices for prompt engineering in a business context. Leveraging APIs for prompt engineering Customizing and fine-tuning language models Adapting to changing business requirements and trends Collaborating with cross-functional teams Staying up-to-date with prompt engineering advancements Activity: Advanced prompt engineering challenge: Participants will take part in a friendly competition, using advanced techniques to solve complex business-related prompt engineering challenges. Additional course details: Nexus Humans QuickStart to Prompt Engineering for Everyday Business Users (TTAI2009) 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 QuickStart to Prompt Engineering for Everyday Business Users (TTAI2009) 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.

A practical and inspiring women’s development coaching workshop giving you time to reflect and focus on yourself and what’s important to you.

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.

Ace Your Presentations: Public Speaking Masterclass Course Overview In the "Ace Your Presentations: Public Speaking Masterclass," learners will acquire essential skills to enhance their public speaking and presentation abilities. The course covers techniques for confident delivery, structuring engaging presentations, handling stage fright, and communicating effectively with diverse audiences. By the end, learners will have the tools to captivate any audience, whether in a business meeting, conference, or seminar. This course offers practical value for anyone seeking to improve their speaking abilities, with tangible benefits in personal confidence and professional success. Course Description This comprehensive course dives into various aspects of public speaking, including speech structure, voice modulation, body language, and audience engagement. It explores techniques for managing nerves, maintaining focus, and delivering persuasive presentations. Learners will also gain valuable insights into creating compelling visual aids and handling questions with ease. With a focus on clear, effective communication, this course equips participants with the skills needed to influence, inspire, and inform any audience, setting the stage for career advancement and personal growth. Ace Your Presentations: Public Speaking Masterclass Curriculum Module 01: Introduction to Public Speaking Module 02: Building Confidence and Overcoming Nervousness Module 03: Structuring Your Presentation Module 04: Mastering Body Language and Voice Modulation Module 05: Engaging Your Audience and Handling Questions Module 06: Creating Effective Visual Aids and Supporting Materials Module 07: Final Project: Delivering Your Own Presentation (See full curriculum) Who is this course for? Individuals seeking to boost their public speaking confidence Professionals aiming to enhance their communication skills Beginners with an interest in becoming effective presenters Anyone looking to refine their speaking abilities for career advancement Career Path Public Speaker Corporate Trainer Marketing and Sales Professional Event Speaker Communication Consultant

Duration 1 Days 6 CPD hours This course is intended for This course is intended for hiring managers who want to save company time and money recruiting and hiring the right candidates. Overview Upon successful completion of this course, participants will know how to present an open position, develop a workable hiring strategy, know how to find and select candidates for open positions. In this course, participants will gain skills and tools to help seek out great candidates that are a fit for your company. Learn to find the diamond in the rough. Getting Started Workshop Objectives Action Plan Defining and Knowing the Position Know the Position Needs Analysis Job Analysis Task Analysis Practical Illustration Hiring Strategy Company Information Salary Range Top Performers Be Prepared Practical Illustration Lure in Great Candidates Advertise Where Candidates Visit Develop Corporate Citizenship Treat Your Candidates Well Look at the Competition Practical Illustration Filtering Applicants to Interview Put Lots of Weight on Cover Letters Grading Resumes Internet Search Initial Phone Interview Practical Illustration The Interview (1) Introduce Everyone Use a Panel Match the Interview to the Job Types of Questions Practical Illustration The Interview (2) Tell Me About My Company Distractions Interview More Than Once Wrap Up Practical Illustration Selection Process (1) Testing Look for Passion and Enthusiasm Background Checks Trust Your Instincts Practical Illustration Selection Process (2) Education Level vs. Experience Have a Consensus Keep Non-Hires on File Checking References Practical Illustration Making an Offer Do it Quickly Employment Details Notify Rejected Candidates Be Creative Practical Illustration Onboarding Training and Orientation Mentoring 30-60-90 Day Reviews Make Them Feel Welcome Practical Illustration Wrapping Up Words From the Wise

BOHS P903 - Management and control of evaporative cooling and other high risk industrial systems is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in Evaporative Cooling and other high risk Industrial type systems. It is a requirement of this course that candidates have successfully completed P901 - Legionella- Management and Control of Building Hot and Cold Water Services. Where both P901 and P903 courses are run on subsequent days or as a combined course then this prerequisite is waived.

Duration 1 Days 6 CPD hours This course is intended for Everyone dealing with day to day work environment Overview Wherever two or more people come together, there is bound to be conflict. This course will give participants a seven-step conflict resolution process that they can use and modify to resolve conflict disputes of any size. Participants will also learn crucial conflict management skills, including dealing with anger and using the Agreement Frame. Participants will learn crucial conflict management skills, including dealing with anger and using the Agreement Frame. If left unchecked or not resolved it can lead to lost production, absences, attrition, and even law suits. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives An Introduction to Conflict Resolution What is Conflict? What is Conflict Resolution? Understanding the Conflict Resolution Process The Thomas-Kilmann Instrument Collaborating Competing Compromising Accommodating Avoiding Creating an Effective Atmosphere Neutralizing Emotions Setting Ground Rules Choosing the Time and Place Creating Mutual Understanding What do I Want? What Do They Want? What Do We Want? Focusing on Individual Needs Finding Common Ground Building Positive Energy and Goodwill Strengthening Your Partnership Getting to the Root Cause Examining Root Causes Creating a Cause and Effect Diagram The Importance of Forgiveness Identifying the Benefits of Resolution Generating Options Generate, Don't Evaluate Creating Mutual Gain Options and Multiple Option Solutions Digging Deeper into Your Options Building a Solution Creating Criteria Creating a Shortlist Choosing a Solution Building a Plan The Short Version of the Process Evaluating the Situation Choosing Your Steps Creating an Action Plan Using Individual Process Steps Additional Tools Stress and Anger Management Techniques The Agreement Frame Asking Open Questions Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans

Duration 2 Days 12 CPD hours This course is intended for This course is suited to marketeers, business analysts, and researchers who are interested in increasing their statistical knowledge. Overview After attending this course, delegates will understand how statistics can be used to provide valuable insight into their business, and be able to apply statistical methods to solve business problems. On returning to work delegates will immediately be able to make a difference to the way that their organisations make decisions. This course covers the statistical methods that analysts need to move from simple reporting on business problems to extracting insight to solve business problems. Course Outline The course will explore the following topics through a series of lectures and workshops: Summary statistics for both continuous data and categorical data Using and reporting confidence intervals Using hypothesis tests to answer business questions Using correlations to explore data relationships Simple prediction models Analysing categorical data Additional course details: Nexus Humans Data-driven Business Using Statistical Analysis 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 Data-driven Business Using Statistical Analysis 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.

Our courses have been designed by experienced teachers to make getting TEFL qualified as convenient as possible. These online courses are entirely self-paced, meaning you can fit study around your life in a way that works best for you. Throughout the course, you will have the support of your own personal tutor who is with you from beginning to end to mark your work, provide helpful feedback, and answer all your questions. 120-hour Premier Online TEFL Course: 50-hour Online TEFL Course Learn about classroom management, teaching styles and advanced TEFL methodology. Includes units on business English, young learners, and teaching English one-to-one. Study with a personal tutor and meet fellow students on our course forums. 30-hour Online Grammar Course Do not know your irregular verbs from auxiliary verbs? This course will improve your basic grammar and give you the grounding you will need to communicate complicated language rules to a student audience. 20-hour Online Video Course Seeing an English teacher in action is a potent learning tool and really brings the theory to life. Feel free to steal the ideas in these video courses to use in your first lessons. We do not mind! Two 10-hour specialist mini-modules. Two mini-modules designed for specific TEFL jobs, which will help your CV stand out. One 10-hour unit is about teaching online, and the other 10-hour unit will help you teach large classes. Included in the 120-hour Premier Online TEFL Course: Lifetime access to the TEFL Job Centre The TEFL Virtual Educators course doesn’t just train you to teach; it helps you find and be offered great TEFL jobs around the world. From exclusive access to our job vacancies to a lifetime of free TEFL career advice, we’re here to help you kick-start your new career. Internationally recognised TEFL certificate – hard copy & PDF A widely-recognised certificate posted straight to your door which shows your achievements on our course, something you can show to TEFL employers to secure you a job. Personal online TEFL tutor Work through your course with the help of an experienced and qualified TEFL tutor. Throughout the course, you’ll have the same tutor, so you have one point of contact for advice and assistance. Online TEFL Class breakdown Lesson Planning Teaching English Vocabulary Teaching Pronunciation Understanding English Grammar Teaching Receptive Skills: Listening and Reading Teaching Productive Skills: Speaking and Writing Teaching English Grammar Principles of Teaching English as a Foreign Language Materials and Aids for Teaching English/Classroom Management Strategies Using Resources Effectively when Teaching English as a Foreign Language Case Study, CV and Cover Letter, Job Sites and Resources You will explore the latest theories in topics such as second language acquisition and social discourse and have the chance to apply these to your own classroom practice and curriculum development. You will also learn to conduct your own research, compile and analyse qualitative and quantitative data and develop your critical-evaluative skills. These skills will be used on your own research project at the end of the course, as well as in your future career. Core modules: Second Language Acquisition You will focus on the major themes that have emerged from literature on second language learning over the last three decades. You will examine some of the research on the second-language acquisition process, look critically at reports of second-language research, and examine some of the theories which endeavour to interpret research evidence. You will be encouraged to use your own language learning and teaching experience to assess the relative merits of such materials. Discourse in Society You will examine the relationship between language and society and the construction of discourse in various domains. You will explore sociological and sociolinguistic models and theories, such as speech communities, communities of practice and ethnolinguistic vitality, with a particular focus on social variation and stratification across various linguistic levels (phonology, lexicon, syntax). You will explore discourse's notion (or notions) in both its linguistic and wider meaning and its construction in and through society and language use. You will study methods for collecting and transcribing data and discover various linguistic and discourse analysis approaches. These methods and approaches will then be put into context and used in the analysis of the relevant social spheres and domains, such as educational or institutional discourse. Research Methods in Applied Linguistics This module will provide you with an introduction to research methods in preparation for the MA dissertation. It will familiarise you with the basic processes of conducting research, including general methodological approaches as well as research ethics. You will analyse and discuss both qualitative and quantitative data in order to develop your critical-evaluative skills. Materials and Course Design You will explore the factors involved in the design of language courses and teaching materials, reflecting on one possible course design process. You will start with an analysis of the context in which the course will take place, the needs of the learners, and current theories of language and language learning. You will move on to consider how course content can be selected and ordered in a principled way, how assessment relates to course design, and how and when courses should be evaluated. Finally, you will consider the evaluation, adaptation, and creation of course materials. Classroom Theory and Practice You will examine current research on modern classroom operations, exploring key concepts and issues through relevant professional and academic literature. A more practical element will be realised through filmed observation of teachers in practice. You will also be encouraged to reflect on your teaching and learning experience and analyse and discuss your beliefs and attitudes towards learning and teaching. Major Project This module will support you in the preparation and submission of a master’s dissertation, allowing you to explore in-depth a particular topic that reflects your academic interest. Assessment You will show your understanding of theoretical issues and their practical application through a combination of portfolios, classroom observation tasks and critical essays. After completing your final module, you will also research and prepare a 15,000-word dissertation.