247 Courses in Cardiff delivered On Demand

EFT is a powerful tool that can be used to increase self-acceptance and self-love. And our EFT course may be exactly what you need if you want to improve your health and personal development. Our EFT course will teach you the principles and techniques of EFT, as well as practical advice on how to apply the technique to your specific needs. This EFT course will not only provide you with the knowledge and skills to effectively use the technique, but it will also assist you in developing a deeper understanding of how your emotions affect your health and well-being. With this knowledge, you will be better able to make positive changes in your life and achieve your objectives. So, if you want to improve your health and personal development, an EFT course could be the solution. EFT, which combines ancient Chinese medicine and modern psychology, can help you heal emotionally and physically and achieve long-term change. Along with this EFT - Emotional Freedom Technique course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This EFT - Emotional Freedom Technique Bundle Consists of the following Premium courses: Course 1: EFT - Emotional Freedom Technique Course 2: Emotional Intelligence and Human Behaviour Course 3: Applied Behaviour Analysis (ABA) Expert Training Certification Course 4: Biohacking Your Physical and Mental Health Course 5: Stress Management Training Course 3: Counselling Course Course 7: Coaching & Mentoring Course 8: Level 2 Mindfulness for Wellbeing Course 9: First Aid Training Course 10: Nutrition Level 2 Course 11: Time Management Learning outcomes Discover the fundamentals of EFT and its applications in health and care. Develop the ability to assess and identify appropriate contexts for using EFT. Develop your ability to create and deliver tailored EFT treatments. Explore how to incorporate EFT into evidence-based treatments for mental and physical health issues. Recognise the potential for personal development and growth offered by EFT practice. Understand the relationship between EFT and traditional medicine. Discover the ethical implications of using EFT. Learn about the legal frameworks and policies that govern the use of EFT. So, don't wait up. Enrol in our EFT course and be better. Curriculum Course 1: EFT - Emotional Freedom Technique Module 01: What Is EFT (Emotional Freedom Technique)? Module 02: EFT and Emotions, The Brain (EFT with the body) Module 03: EFT Procedure Module 04: Detailed Instructions of EFT Module 05: Applying EFT to Physical Issues Module 06: Treating Children with EFT Module 07: EFT That Can Improve/ Heal Life & Tips Module 08: Doing Business with EFT Course 2: Emotional Intelligence and Human Behaviour Module 01: Human Behaviour and Basic Psychological Process Module 02: Evolutionary Perspective of Human Behaviour Module 03: Human Intelligence Module 04: Intelligence Test and Variations in Intelligence Module 05: Learning and Conditioning Module 06: Language and Communication Module 07: Introduction to Emotion Module 08: Emotion Influences Cognition Module 09: Stress, Anger and Conflict Module 10: Emotional Intelligence Module 11: Self-Leadership Module 12: Neuro-Linguistic Programming (NLP) Course 3: Applied Behaviour Analysis (ABA) Expert Training Certification Introduction to ABA ABA Component Breakdown Rules when Applying ABA Foundation Techniques of ABA ABA for Motor Skills ABA for Language Skills ABA for Cognitive Skills ABA for Visuospatial Skills Generalization in ABA Theory Course 4: Biohacking Your Physical and Mental Health Module 01: Introduction Module 02: Sleep - So MUCH More Than Just Rest Module 03: Blue Light & Red Light Module 04: Mindfulness & Movement Module 05: What You Put In Your Mouth is KEY! Module 06: Hidden Secret - 'Cryotherapy' Module 07: Importance Of PURE Air Module 08: Final Thoughts & Recommendations Course 5: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies Still MORE Stress Reduction Techniques - Part 1 Still MORE Stress Reduction Techniques - Part 2 Still MORE Stress Reduction Techniques - Part 3 BONUS Video & Wrap Up! Special LIVE Bonus Video! Course 6: Counselling Course Introduction to the course Understanding Psychotherapy Starting Psychotherapy Practice Your Potential Clients in Therapy Different Types of Psychotherapy Internet Based Therapy Course 7: Coaching & Mentoring Module 1: Introduction to Coaching and Mentoring Module 2: Coaching and Mentoring: Objectives & Processes Module 3: Ethical Aspects of Coaching and Mentoring Module 4: Coaching and Mentoring Models Module 5: Effective Communication Skills Module 6: Personal Skills Module 7: Management Skills Module 8: Functional Skills Course 8: Level 2 Mindfulness for Wellbeing Introduction & First Concepts Understanding & Beating Anxiety More Anti-Anxiety Skills & Concepts Conclusion Course 9: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 10: Nutrition Level 2 Section 01: Nutrition Overview Section 02: Nutrition & Carbs Section 03: Nutrition & Proteins Section 04: Nutrition & Fat Section 05: Nutrition & Water Section 06: Micronutrients Section 07: Effortless Nutrition Section 08: Strategies to Do Today Section 09: Nutrition Myths Section 10: Bonus: Are Diet Foods Good For You? Course 11: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone looking to improve their mental and emotional well-being should consider taking this EFT course. EFT is a powerful, tried and tested tool for emotional healing and personal development. It can help alleviate anxiety, depression, phobias, and stress, as well as help individuals to overcome traumas and past negative experiences. It can also help to improve relationships, boost self-esteem, and increase happiness. Requirements Our bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path The following professions are most popular in this sector EFT Life Coach EFT Practitioner EFT Therapist EFT Energy Worker EFT Workshop Facilitator The salary range for EFT - Emotional Freedom Technique professionals in the UK is typically between £20,000 and £40,000 per year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Emotional Freedom Technique) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Description Do you need to lead one-on-one meetings in your workplace? If you do, then you will know it is your responsibility to make them comfortable for both of you, and also an effective use of time. One-on-One Meetings Serve Many Purposes They may be for Goal setting Performance review - formal and informal Tasking and progress monitoring Briefing Problem-solving and addressing issues Care and support Guidance Coaching or mentoring Performance feedback ...Even reprimands   But often, people get promoted to a level where they need to lead these kinds of meeting, without getting any training. So, in this course, we'll cover: The different types of one-on-one meeting Planning and preparing your meeting Putting together an effective agenda How to build rapport How men and women each perceive a mixed meeting - with advice for each How to listen well Questioning skills How to adapt to the range of meeting types you'll need as a manager, project manager, or team leader.   As a result, you'll be able to: Select the most effective style for your one-on-one meeting Plan and prepare for an effective meeting that puts both of you at ease, and allows you to make the progress you need Lead a meeting that flows naturally Choose the most suitable room layout for your meeting Build and strengthen professional rapport with the other person Avoid the traps of the male-female one-on-one dynamic Listen deeply, and ask insightful questions Lead a range of different types of one-on-one meeting, for: appraisal, progress checking, coaching, mentoring and reprimands.   Prior Experience The only prior experience you need is some exposure to organizational life. However, the people who may find this most valuable are those who have tried leading their first one-on-one meetings and so know what challenges you want to work on..   Who is this course for? Supervisors who need to guide and support colleagues Managers who need to set expectations, and monitor performance Professionals who need to meet with other professionals and workplace contacts Leaders who want to coach, mentor, and give feedback to colleagues ... anyone in the world of work who has to take the lead in a one-on-one meeting   Your Tutor: Dr Mike Clayton Your tutor is Dr. Mike Clayton. As a senior manager at international consulting firm, Deloitte, Mike had to deal with conflict among staff, and with clients, and even among clients. But more important, as a senior representative of his firm and a program leader, he needed to avoid escalation of conflict. Now, as a trainer and facilitator, he has been applying what he learned and teaching it to others. This course represents 15 years' experience of what tools students find most helpful, and 25 years experience in business, managing conflicts large and small. Mike is supported by Felicity Dwyer Felicity is an experienced management trainer and coach, whose Institute of Leadership and Management accredited courses have a justifiably high reputation across the UK. What Will I Learn? Select the most effective style for your one-on-one meeting Plan and prepare for an effective meeting that puts both of you at ease, and allows you to make the progress you need Lead a meeting that flows naturally Choose the most suitable room layout for your meeting Build and strengthen professional rapport with the other person Avoid the traps of the male-female one-on-one dynamic Listen deeply, and ask insightful questions Lead a range of different types of one-on-one meeting, for: appraisal, progress checking, coaching, mentoring and reprimands. Who is the target audience? Supervisors who need to guide and support colleagues Managers who need to set expectations, and monitor performance Professionals who need to meet with other professionals and workplace contacts Leaders who want to coach, mentor, and give feedback to colleagues ... anyone in the world of work who has to take the lead in a one-on-one meeting Requirements You should be a professional, manager, or supervisor who leads one-on-one workplace meetings ...or be expecting to lead them in the near future. Welcome and Introduction Welcome to the Course 00:03:00 Why One-on-One Meetings are so Important 00:03:00 Reasons to Meet 00:03:00 Meetings are Conversations: Types of Conversation 00:04:00 Preparation and Planning for Your One-onOne Meeting Planning your One-on-One Meetings 00:04:00 How to Prepare for Your Meeting 00:02:00 Preparing your Agenda 00:05:00 Running Your One-on-One Meeting The Five Stages of a Meeting 00:04:00 Meeting Room Layout 00:06:00 Rapport Building Skills 00:04:00 The Male-Female Dynamic 00:01:00 The Male-Female Dynamic - from His Perspective 00:05:00 The Male-Female Dynamic - from Her Perspective 00:02:00 Questioning Skills 00:08:00 Listening Skills 00:06:00 Particular Types of One-on-One Meeting Staff-focused One-on-One Meetings 00:05:00 Checkpoint Meetings 00:04:00 Informal Feedback Meeting 00:04:00 Formal Appraisal Meetings 00:06:00 Difficult Conversations 00:04:00 Coaching Meetings 00:06:00 Mentoring Meetings 00:04:00 Giving a Reprimand 00:03:00 Closing Last Thoughts 00:02:00

The course investigates unconscious bias to develop your awareness. Training in unconscious bias will not mean that you will not have biases. They will remain, by definition, unconscious. The course seeks to build your awareness of their existence and highlights when to look out for them.

This leadership course explores the application of emotional intelligence at work as a core underpinning skill of leadership. Your emotional intelligence helps you to manage your thinking along with your emotions to make authentic decisions and build quality relationships.

Developing and using our innate resources well is as integral to mental health as meeting our emotional needs – join HG co-founder Ivan Tyrrell and Diploma tutor Carol Harper to explore them further Accredited CPD Certificate: 5 hours Suitable for: All health and welfare professionals – and anyone interested in what makes us who we are A perfectly coordinated seminar, a ‘dance’ between psychotherapy geniuses Ivan Tyrrell and Carol Harper - I wouldn't have missed it for the worldIAKOVOS FLASKIS Why take this course Nature provided us with a wealth of inbuilt resources to help us get our innate physical and emotional needs met. They are a fundamental part of being human, what we call human ‘givens’, and can be usefully thought of as internal guidance systems that not only enable us to survive but to achieve remarkable things. They have been continuously refined over thousands of years and are still evolving. A lot of attention is given to the importance of ensuring that people’s innate emotional and physical needs are met well – but our resources are an integral part of this: if they are not fully developed, or are misused or even damaged, we can suffer greatly. A clear understanding of these guidance systems, how they work and what they do for us, is essential if you wish to help others, improve our society, or understand yourself and those around you better. This is especially true if you are an involved parent, teacher, manager, or any kind of therapist. If you work with, or for, others you need this knowledge – understanding what makes us all ‘tick’ should be at the heart of everything we do. Amazing! Incredibly fascinating subject delivered with a deep respect for the profound human resources with which we are endowed...DAMIAN FEARNS, TRAINER, FACILITATOR, COACH What you will gain A deeper understanding of yourself and others More insight into the holistic nature of the rich but incomplete patterns that we inherit from our genes How and why these patterns must seek their completion in the environment An increased understanding of how memory is involved in learning – from birth to old age Guidance about how malleable memory is and why forgetting is as important as remembering The unexpected science behind emotional arousal – how emotions are created moment by moment A deeper understanding of the APET model – and why metaphorical pattern matching is central to all human interactions and endeavours Greater insight into why emotions create trance states in us – and the role this plays in many disorders Why being able to go into trance is essential for learning A richer understanding of the important role imagination plays A better understanding of how dreaming preserves the integrity of our genetic inheritance The confidence and skills to build on the instinct for rapport and what happens when that instinct is only crudely met in infancy An understanding of how rapport plays an important part in language acquisition How to counter the blight of loneliness Why reasoning is important and so difficult for some people What it means to ‘know’ something How we can check out our own emotional responses and biases We also consider whether intuition is an innate resource and the role accessing the Observing Self has in spiritual development And much more… No prior knowledge of the human givens approach is needed to benefit from this course. What's included? 14 Videos 10 Multiple choice quizzes PDF Course Notes & downloads Life-long access CPD Certificate Course programme The ‘A closer look at our innate resources’ online course is split into 10 sections and covers the following: Resources: guidance systems for life and learning Emotions, dreaming, trance states, imagination The ability to build rapport Reason, how we know and the Observing Self This course has been independently accredited by the internationally recognised CPD Standards Office for 5 hours of CPD training. Meet your tutors Ivan Tyrrell Ivan Tyrrell worked for many years as a psychotherapist and now spends most of his time lecturing and writing. Read more Carol Harper Carol has 30 years’ experience in private practice, her holistic outlook and curiosity has influenced her professional development… Read more Good to know This new online course is based on live online training given during the pandemic. It gives you a unique opportunity to learn from Ivan Tyrrell, co-founder of the human givens approach, and co-author with Joe Griffin of best-selling books about our innate needs and resources. He is joined by senior tutor Carol Harper – and together they draw on their extensive knowledge and lifetimes’ experience to share key insights that will deepen your psychological understanding and increase your ability to help people.

Embark on a journey of empathy and understanding with our comprehensive 'Mental Health First Aid Certification' course. In a world where mental health is paramount, this course is your beacon, offering not just knowledge but the tools to make a difference. From unraveling the intricacies of various psychiatric disorders to exploring the vital connection between mental health and the workplace, each module is a step toward building a healthier and more compassionate community. Discover the art of approaching and reacting to people in mental health crisis, equipping yourself with the skills to provide essential aid. Our creatively crafted course goes beyond traditional learning, fostering a compassionate mindset that is at the heart of effective mental health support. Enroll now to become a certified Mental Health First Aider, making a positive impact on individuals and society as a whole. Learning Outcomes Develop a deep understanding of various psychiatric disorders. Acquire the skills to provide effective Mental Health First Aid. Recognize and respond to stress, anxiety, and mood disorders. Understand the impact of mental health on childhood and adolescence. Explore the correlation between mental health and the workplace. Why choose this Level 5 Mental Health First Aid Certification at QLS? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Level 5 Mental Health First Aid Certification at QLS for? Individuals passionate about mental health advocacy. HR professionals aiming to create a supportive workplace environment. Teachers and educators seeking tools to address mental health in schools. Community leaders fostering mental health awareness. Anyone interested in making a positive impact on mental health. Career path Mental Health Advocate: £25,000 - £35,000 Wellbeing Coordinator: £28,000 - £40,000 School Mental Health Facilitator: £30,000 - £45,000 Community Outreach Specialist: £32,000 - £50,000 Mental Health First Aid Trainer: £35,000 - £55,000 Workplace Wellbeing Consultant: £40,000 - £60,000 Prerequisites This Level 5 Mental Health First Aid Certification at QLS does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Level 5 Mental Health First Aid Certification at QLS was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 1: Introduction to Mental Health Introduction to Mental Health 00:13:00 Module 2: Overview of Mental Health First Aid Overview of Mental Health First Aid 00:14:00 Module 3: Childhood and Adolescent Psychiatric Disorders Childhood and Adolescent Psychiatric Disorders 00:13:00 Module 4: Stress and Anxiety Disorders Stress and Anxiety Disorders 00:22:00 Module 5: Schizophrenia Schizophrenia 00:25:00 Module 6: Personality Disorders Personality Disorders 00:36:00 Module 7: Mood Disorders Mood Disorders 00:20:00 Module 8: Eating & Sleeping Disorders Eating and Sleeping Disorders 00:41:00 Module 9: Self-Harm and Suicide Self-Harm and Suicide 00:18:00 Module 10: Medication and Therapy in the Treatment of Mental Illness Medication and Therapy in the Treatment of Mental Illness 00:30:00 Module 11: Social Attitudes to Mental Illness Social Attitudes to Mental Illness 00:12:00 Module 12: Mental Health Legislation and Services Mental Health Legislation and Services 00:28:00 Module 13: Mental Health in the Workplace Mental Health in the Workplace 00:22:00 Module 14: Approach and React To People in Mental Health Crisis Approach And React To People In Mental Health Crisis 00:27:00 Recommended Materials Workbook - Mental Health First Aid 00:00:00 Assignment Assignment - Level 5 Mental Health First Aid Certification at QLS 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Why Facility Management Training Course right for you? Whether you are self-taught or you want to fill in the gaps for better efficiency and productivity, this facility management course will set you up with a solid foundation to become a confident facilitator and develop more advanced skills. This comprehensive facility management course is the perfect way to kickstart your career in the field of facility management. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry experts, to enable you to learn quickly and efficiently and at your own pace and convenience. Facility Management Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction Introduction What is a Facility What is a Facility What is Facility Management What is Facility Management Why Facility Management Why Facility Management Function of Facility Management Function of Facility Management Principles of Facility Management Principles of Facility Management Triangle of Ps Triangle of Ps Key Facility Management Services Key Facility Management Services Role of a Facility Manager Role of a Facility Manager Types of Functions in FM Types of Functions in FM Models of Facility Management Models of Facility Management Who should take this course? This comprehensive facility management course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of facility management. Entry Requirements There are no academic entry requirements for this facility management course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Understand more about mindfulness and how to use it to develop your resilience and wellbeing. Learn the ability to pay attention to the present moment without judgement and use this skill in the volatile, uncertain, complex and ambiguous wo work.

This leadership course explores the application of emotional intelligence at work as a core underpinning skill of leadership. Your emotional intelligence helps you to manage your thinking along with your emotions to make authentic decisions and build quality relationships.