877 Courses in Cardiff delivered Live Online

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

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.

Course Overview This comprehensive Workplace Safety – Asbestos & COSHH Training course is designed to equip learners with essential knowledge of hazardous substances, safety regulations, and risk assessment procedures. It covers critical subjects such as asbestos awareness, COSHH regulations, fire safety, and chemical spill response, empowering individuals to uphold safety standards in any professional environment. Whether you're new to workplace safety or looking to reinforce your compliance knowledge, this course ensures you understand how to identify, report, and manage potential hazards in line with UK health and safety legislation. By completing this training, learners will gain the confidence to support a safer workplace, meet employer and legal requirements, and contribute to a healthier work culture across sectors such as construction, manufacturing, education, and care. This course is also valuable for those pursuing roles with responsibility for safety assessments or compliance monitoring within their organisation. Course Description The Workplace Safety – Asbestos & COSHH Training course offers in-depth guidance on handling hazardous materials and navigating high-risk scenarios. Topics include the dangers and regulations surrounding asbestos, COSHH assessments, confined space awareness, chemical spill response, and essential workplace first aid. Additionally, learners will study broader workplace health and safety practices, ensuring a well-rounded understanding of legislative duties, hazard control, and preventative measures. Throughout the course, learners will develop the ability to interpret health and safety protocols, implement best practices, and support regulatory compliance. The training is aligned with UK industry requirements, offering insights into effective safety planning and emergency procedures. This course suits both those with responsibilities in health and safety and those looking to improve their knowledge to support safe operational standards in various workplace settings. Course Modules: Module 01: Asbestos Awareness & Safety Module 02: COSHH Training for Assessors Module 03: Working in Confined Spaces Module 04: Chemical Spill Module 05: Spill Management Training Module 06: Fire Safety Module 07: Workplace Health and Safety Diploma Module 08: First Aid at Work (See full curriculum) Who is this course for? Individuals seeking to understand health and safety obligations in the workplace. Professionals aiming to improve compliance knowledge and safety awareness. Beginners with an interest in occupational health and safety practices. Supervisors, HR personnel, and compliance officers responsible for workplace risk. Career Path Health and Safety Officer Compliance Coordinator Site Supervisor Risk Assessor Facilities Manager Warehouse or Construction Safety Personnel HR and Operations Manager

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.

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.

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

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

With Director Sue Dunderdale Introduction Sue Dunderdale is giving you the chance to work with her on this intimate online workshop to discover her detailed process in building a Cinematic performance with actors. Over this three hour workshop you will transform your approach to building a character from text. You will learn to breakdown the structure of a script to understand what a character is doing, enabling you to play the scene in any number of given circumstances and to always deliver it fresh with every take. Meet Your Tutor Sue Dunderdale Director Sue Dunderdale has an impressive background in the world of Theatre, Film and TV Directing. Her commitment to fostering both new talent and working with BAFTA award-winning actors underscores her versatility and dedication to the craft. Having coached and directed acclaimed actors such as Helena Bonham Carter and Clarke Peters, Sue has worked with BAFTA-winning performers, contributing to their success on screen. Course Outline You will cover a scene that’s broken into units of action and work out what is happening in each unit. You will then work with a partner and breakdown a scene on your own to work out the character journey, applying each segment to a performance to gauge how it guides you through the scene. You will then summarise and understand how these techniques apply to filming. Additional Information Features A strong internet connection is required to join our live online courses and workshops. Please test your internet connection before booking as we cannot refund due to technical issues. Please familarise yourself with Zoom before attending your workshop. Your camera will be required to be switched on during the workshop. Students will receive a Zoom link via email to join the workshop. Please log on at least 10 mins before the workshop begins. Learning Outcomes Key questions you need to ask of any character you might play. Extract facts about a character and understand what can be built from these. Scene structure & Character Journey. You will cover a scene that’s broken into units of action. Course Location Held Online Via Zoom