863 Courses in Cardiff delivered Live Online

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Public Speaking and Presenting - a one-day interactive training taught in small groups. On this page: What participants of this course say Tutoring Booking Information Refund policy Industry-specific public speaking training Follow-up training options Enquiries This is a one-day interactive course on the delivery of public speaking – a beautiful art that can be mastered with quality training and practice. What participants of this course say "10/10. Excellent trainer. Found most useful : - the Feedback session; tutor being very patient in asking/teaching us to pause and repeat with correct tone. - Link to Psychology and Genetics, rather than just techniques." “This course struck the perfect balance of theory/practice application for me. I appreciate the individual feedback and Fatos was a fantastic teacher. Very knowledgeable." Tutoring This course is directed by Fatos Selita, a multidisciplinary trained communication expert. Booking Information Group bookings To book this 'Public Speaking and Presenting' course for a group, please email us info(@technotruth.co.uk). The price for group bookings starts from £1,925, covering a maximum of 8 people. Refund policy For this training course, where the number of participants is capped at 8, we offer you the following flexibility: If you cannot attend on the date booked, we will be happy to move your booking to a new date or provide you with a refund of our fee - if you notify us more than 7 days ahead of the start date. If you need to cancel the course within 7 days ahead of the start date - we will be happy to offer you one change to a future date. 10% discount when a participant enrols for more than one of our courses at the same time. 20% discount for UK students. 20% for members of the Society for Personality and Social Psychology (SPSP) (spsp.org). 25% discount for Members of the UK Law and Society Association (UKLSA) (uklsa.co.uk). Goldsmiths students, staff, or alumni, please email us for current discounts. Sponsored places: We are currently offering a number of sponsored places on all AIR Courses for those in extremely difficult financial circumstances. Please email us for details: For all enquiries, and to be regularly updated on upcoming AIR courses, please email: info (@technotruth.co.uk). Industry-specific public speaking training Public Speaking for Diplomacy Interview Skills Public Speaking for Academics / Researchers Public Speaking for Business Professionals (Bankers, Lawyers, Media Professionals) Find out more about all of the AIR courses available to you. Enquiries For all enquiries, and to be regularly updated on upcoming AIR courses, please email: info (@technotruth.co.uk). For anything urgent, or if emailing is not a good option for you, you can also call us via WhatsApp or phone on +44 (0)7908 566 949.

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to: Travel the world and be paid for it Work in a friendly, collaborative atmosphere, 5000 metres above the sea level Build a global network This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board.  98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lesson per week for 18 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment. Individual support on the journey from the course to a job placement Receive constant updates on recruitment and news from Aviation the world We will enhance your CV Full support on your job application process Gain an insight into the airline selection process and final one-to-one interview What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 14 March 2024 – 11 July 2024, Thursday classes 10 June 2024 – 7 October 2024, Monday classes 17 September 2024 – 14 January 2025, Tuesday classes 18 November 2024 – 17 March 2025, Monday classes Course duration – 18 weeks Classes – once a week Lesson Time – 6:30pm to 9pm – GMT (London time) Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

Course summary This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course.

Course Overview This Life Coaching course offers an empowering and transformative learning experience designed to help learners develop the essential skills and insights needed to guide others towards personal growth and achievement. Covering the core principles of life coaching, emotional intelligence, communication techniques, and client management, this course equips learners with the tools to inspire change and foster resilience. By developing self-awareness and understanding behavioural patterns, learners will be able to create structured coaching plans tailored to individual client needs. Whether aiming to pursue a career in coaching or seeking to enhance leadership and mentoring capabilities, learners will finish the course with a clear understanding of ethical practices and business growth fundamentals. Upon completion, participants will be prepared to confidently support clients in achieving personal and professional goals while advancing their own personal development. Course Description The Life Coaching course delves into the essential aspects of professional coaching, beginning with its purpose, principles, and the critical role of self-awareness. Learners will explore the development of core beliefs, fear management, and the foundations of emotional intelligence to better understand client motivations and behaviours. Communication skills, including body language techniques, are covered in depth to enhance client engagement and rapport-building abilities. The course also introduces effective goal-setting frameworks, methods for structuring client sessions, and key attributes of successful life coaches. Additionally, learners will receive an introduction to basic business development strategies, helping them to establish and grow their own coaching practices. Ethical considerations form a crucial part of the training, ensuring learners are equipped to protect both themselves and their clients. With a balance of theoretical foundations and real-world application, learners will gain valuable skills to thrive in the coaching profession. Course Modules Module 01: Life Coaching: The Purpose and Fundamentals Module 02: Develop Your Self-Awareness Module 03: The Development of Core Beliefs and Managing Fears Module 04: Life Coaching Types and Key Attributes of a Life Coach Module 05: Understanding Emotional Intelligence Module 06: Body Language and Communication Techniques Module 07: A Structure for Client Work and Goal Setting Module 08: Basic Principles for Business Development and Growth Module 09: The Ethical Coach: Protect Yourself and Your Clients (See full curriculum) Who is this course for? Individuals seeking to guide others towards personal and professional success. Professionals aiming to enhance leadership, mentoring, and coaching capabilities. Beginners with an interest in life coaching, personal development, or behavioural sciences. Entrepreneurs looking to establish a career in coaching or consultancy. Managers and HR professionals wishing to develop stronger coaching techniques within their teams. Career Path Life Coach Career Coach Executive Coach Leadership Development Specialist HR and Talent Development Professional Business Consultant Wellbeing Coach Mentoring Programme Coordinator

weave together the enchantment of tarot cards with the magic of altars, candles, and incantations, creating a tapestry of transformation

Join our Immigration Case Law Updates Webinar and keep up to date with the latest changes in Immigration Law. Each webinar is between 30 – 45 minutes. Join Lawyers, Solicitors, Immigration Advisors and Organisations keeping up with these changes. Immigration Case Law Updates Webinar   Stay ahead of the curve in the dynamic landscape of immigration law! Our Lunch and Learn Webinar Series is tailored for legal professionals, including lawyers, solicitors, immigration advisors, and organisations navigating the complexities of immigration law. Bring your lunch and join us for our bitesized webinar keeping you updated on major changes in Immigration Law. This monthly session ranges from 30 minutes to 45 minutes depending on the changes announced.   🔍 Highlights: In-Depth Case Law Analysis: Explore the latest updates and rulings shaping immigration law, providing you with a comprehensive understanding of recent changes. Interactive Discussions: Engage in interactive discussions with industry experts, sharing insights, best practices, and practical strategies to enhance your proficiency in handling immigration cases. Stay Current: Keep abreast of the ever-evolving legal landscape, ensuring you’re equipped with the knowledge to deliver the best possible outcomes for your clients. Monthly Sessions: Join us on the first Thursday of each month for an enriching and informative lunchtime session that fits seamlessly into your schedule.   🎓 Who Should Attend: Lawyers Solicitors Immigration Advisors Immigration Organisations   📚 Key Takeaways: Deepened understanding of recent case law developments Enhanced practical skills for effective immigration case management Networking opportunities with fellow legal professionals   📆 Save the Date: Mark your calendar for the first Thursday of every month and elevate your expertise in immigration law.   Links to the webinar will be sent out 24hours before the start time to the email address used at the time of booking.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for business leaders and decision makers, including C-level executives, project and product managers, HR leaders, Marketing and Sales leaders, and technical sales consultants, who have a vested interest in the representation of ethical values in technology solutions. Other individuals who want to know more about data ethics are also candidates for this course. This course is also designed to assist learners in preparing for the CertNexus DEBIZ™ (Exam DEB-110) credential. The power of extracting value from data utilizing Artificial Intelligence, Data Science and Machine Learning exposes the learning differences between humans and machines. Humans can apply ethical principles throughout the decision-making process to avoid discrimination, societal harm, and marginalization to maintain and even enhance acceptable norms. Machines make decisions autonomously. So how do we train them to apply ethical principles as they learn from decisions they make? This course provides business professionals and consumers of technology core concepts of ethical principles, how they can be applied to emerging data driven technologies and the impact to an organization which ignores ethical use of technology. Introduction to Data Ethics Defining Data Ethics The Case for Data Ethics Identifying Ethical Issues Improving Ethical Data Practices Ethical Principles Ethical Frameworks Data Privacy Accountability Transparency and Explainability Human-Centered Values and Fairness Inclusive Growth, Sustainable Development, and Well-Being Applying Ethical Principles to Emerging Technology Improving Ethical Data Practices Sources of Ethical Risk Mitigating Bias Mitigating Discrimination Safety and Security Mitigating Negative Outputs Data Surveillance Assessing Risk Ethical Risks in sharing data Applying professional critical judgement Business Considerations Data Legislation Impact of Social and Behavioral Effects Trustworthiness Impact on Business Reputation Organizational Values and the Data Value Chain Building a Data Ethics Culture/Code of Ethics Balancing organizational goals with Ethical Practice Additional course details: Nexus Humans CertNexus Data Ethics for Business Professionals (DEBIZ) 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 CertNexus Data Ethics for Business Professionals (DEBIZ) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Course Overview This comprehensive First Aid at Work course is designed to equip learners with the knowledge needed to effectively manage health-related emergencies in professional settings. Covering a wide range of workplace incidents, it explores the role of appointed persons, emergency protocols, and how to respond to common injuries and illnesses. Learners will develop confidence in managing both physical and mental health-related situations at work, including remote support and procedures adapted for the COVID-19 era. Whether you are an employee, manager, or business owner, this course provides essential guidance that aligns with UK regulations and first aid expectations in modern work environments. By the end of the course, learners will be familiar with key emergency response procedures and legal requirements, contributing to a safer and more responsible workplace culture. Course Description The First Aid at Work course offers in-depth learning across a structured series of modules that cover everything from primary and secondary assessments to CPR, AED usage, and mental health support. It examines various types of injuries and illnesses such as fractures, dislocations, breathing problems, and minor workplace injuries. The course also discusses the legal framework for first aid at work, risk assessments, and the importance of mental health awareness. Additionally, it addresses recent considerations such as pandemic-specific protocols and remote psychological support. Learners will gain theoretical insight into emergency handling, including when and how to contact emergency services. With up-to-date content aligned with UK standards, this course is ideal for those looking to support a health-conscious and safety-oriented work environment. Course Modules: Module 01: Introduction to Workplace First Aid Module 02: Appointed Persons in the Workplace First Aid Module 03: Incident Management at Work Module 04: Classifications and Abbreviations Module 05: Emergency Management Module 06: Primary Survey Module 07: Secondary Survey Module 08: Basic First-Aid Techniques Module 09: AED Module 10: Minor Injuries at Workplace Module 11: Loss of Responsiveness and CPR Module 12: Breathing Problems Module 13: Secondary Illnesses and Injuries Module 14: Fractures and Dislocations Module 15: Call for an Emergency Module 16: Things to Keep in Mind for A First Aider Module 17: Legal Framework for Workplace First Aid Module 18: Mental Health First Aid in the Workplace Module 19: First Aid during Coronavirus Pandemic Module 20: First Aid Qualifications During the Pandemic, Risk at Work and PPE Regulations Module 21: Remote Psychological First Aid (See full curriculum) Who is this course for? Individuals seeking to understand workplace first aid responsibilities. Professionals aiming to support health and safety compliance in the workplace. Beginners with an interest in health and safety protocols. Managers, HR personnel, or safety officers seeking foundational knowledge in first aid. Career Path Workplace Health & Safety Officer HR and Compliance Manager Office Administrator with Safety Responsibilities Site or Facility Supervisor Community Support Worker Mental Health Support Facilitator Risk Management and Corporate Safety Advisor