1177 Courses in Cardiff delivered Live Online

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

Introducing the “Why Do I Always End Up in Situationships?” Package: Your Solution to Avoid Heartbreak, Deception, and Being Used in Relationships Are you tired of constantly finding yourself in confusing and unfulfilling situationships? Do you long for a genuine and committed relationship but seem to attract partners who only want to keep things casual? Miss Date Doctor is here to empower you with the ultimate relationship coaching package designed specifically to break the cycle of situationships and protect your heart from being broken, used, or deceived. With our “Why Do I Always End Up in Situationships?” package, you will gain invaluable insights, practical tools, and personalized guidance to transform your dating life. Our team of experienced relationship coaches understands the complexities of modern dating and will help you navigate the treacherous waters to find genuine love and fulfillment. So, why should you invest in this package? Because it’s time to reclaim your power and create the love life you truly deserve. Here’s what you can expect: Comprehensive Relationship Assessment: Our expert coaches will conduct a thorough assessment to understand your dating history, patterns, and the factors that contribute to your attraction to situationships. By delving deep into your past experiences, we’ll identify any underlying issues that may be hindering your path to a committed relationship. Personalized Strategy Development: Based on the assessment results, we will create a customized action plan tailored to your specific needs and goals. This plan will serve as your roadmap, guiding you through each step of the process to break free from situationships and establish healthier relationship dynamics. Relationship Education and Skills Building: Knowledge is power, especially when it comes to relationships. Our package includes comprehensive educational resources and materials that cover a range of topics, including effective communication, setting boundaries, recognizing red flags, and fostering emotional intimacy. Armed with this knowledge, you’ll be equipped to make informed choices and build strong, lasting connections. Emotional Support and Guidance: Navigating the complexities of relationships can be emotionally challenging. That’s why our coaches are here to provide you with ongoing support and guidance throughout your journey. We’ll be by your side, offering compassionate guidance, helping you overcome setbacks, and celebrating your successes along the way. Role-Playing and Scenario-Based Coaching: To reinforce your newly acquired skills, we’ll engage in role-playing exercises and scenario-based coaching sessions. This hands-on approach will empower you to handle challenging situations confidently and make decisions that align with your relationship goals. Continuous Progress Monitoring: We believe in accountability and progress tracking. Throughout the coaching process, we’ll monitor your progress, provide feedback, and make adjustments to your strategy if needed. This ensures that you stay on track and continue making strides towards breaking the cycle of situationships. Don’t let situationships define your love life any longer. Invest in the “Why Do I Always End Up in Situationships?” package from Miss Date Doctor and take control of your romantic destiny. Say goodbye to heartbreak, deception, and being used in relationships, and say hello to genuine love, connection, and fulfillment. Enroll today and unlock the keys to a healthier and more satisfying love life. Contact Miss Date Doctor now to book your package and embark on a transformative journey towards building meaningful, committed relationships. Your happily ever after is within reach! 3 X 1 HOUR https://relationshipsmdd.com/product/why-do-i-always-end-up-in-situationships-package/

Learn the Art and Science of EFT (Emotional Freedom Techniques or “The Tapping Technique”) in this EFT workshop and join millions worldwide who are learning this life-changing technique. EFT, commonly referred to as Tapping, has gained rapid popularity because it has been demonstrated to quickly and effectively resolve dysfunctional feelings, thoughts, behaviors and beliefs which can lead to challenges in relationships, health, work and more. Basically, if there are negative emotions and stress involved, EFT may well be able to resolve those aspects that can lead to significant relief and ease in one’s life. Learn to implement this powerful mind-body approach which is supported by peer-reviewed research, drawing from the fields of interpersonal neurobiology, neuroplasticity models and the field of epigenetics. If you are ready to transform your health, your relationships and your vision of who you truly are, then come join us to learn EFT Tapping techniques. If your life is grounded in being of service to others, then EFT will quickly become your tool of choice. Whether you are curious about EFT for self-help or you are in the healing/helping professions, this training will give you confidence in the art of its delivery. From the professional working with clients to the laymen looking for self-application, everyone walks away having the skills to succeed with this extraordinary healing modality. This online format did not at all hinder the delivery of the content and technique whatsoever and we were able to do everything that we could have done in person. Alina and Craig created a very safe space, gave us plenty of demos, lots of practice time and welcomed all of our questions. They also broke up the day with ample breaks and Eden energy exercises to help avoid screen fatigue. Alina and Craig are experts in their field and top-notch EFT instructors. I highly recommend their online courses.— CARSON HILL EFT LEVEL 1 The Basics The preparation for the EFT Level 1 includes approximately 3 hours of advance work, including watching several short online videos and the reading of 2 articles that explore both the history of EFT and the scientific premises for how EFT works. Note that last minute signups will not be allowed without contacting us due to this requirement. EFT Level 1, The Basics, is the foundation of any EFT training. It covers the core aspects of EFT with a focus on how you can use tapping as a self help tool and how to teach your clients how to apply it as a self-regulating technique. Learn how to apply EFT for issues related to physical symptoms, for cravings and addictions and more. See below for an outline of materials covered. An outline of subject matter covered in this first day include: The Science Behind EFT Understanding Shifting Aspects The Importance of Being Specific Psychological Reversal & Secondary Gain Cognitive Belief Shifts How Traumatic Events Imprint on the Brain Finding the Right Words to Use An introduction to both Tell the Story and the Movie Techniques for working with traumatic events The Movie Technique Working with Pain and Physical Symptoms EFT for Cravings and Aspects of Addictions Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 1. This is the first step along the path to obtain Certified EFT Practitioner through EFT International, but should not be put forth as a certification in itself. I wholeheartedly recommend training in EFT with Craig and Alina. I recently took their EFT level 1 and 2 live online training and it was a fantastic experience. The virtual environment in Zoom was great and everything worked perfectly, and I learned so many things. I appreciate the way they break down important concepts and share their many years of experience, and the emphasis they put on generating and maintaining safety and rapport with the client at all times.— BRUNO SADE, PSYCHOLOGIST EFT LEVEL 2 Foundational Skills The two-day EFT Level 2 workshop is designed for those practitioners who have taken the pre-requisite EFT Level 1 and are either in practice or preparing to be and will be able to apply EFT when working with clients. This may include but not be limited to social workers, counselors, therapists, health care practitioners, life coaches and those who may be wishing to pursue EFT certification. It reviews and expands upon the basic aspects of the Art and Science of EFT taught in the EFT 1 course. Additional techniques are taught to expand your repertoire and offer skillful and effective ways of working with different client populations and expanding your ability to work with deeper issues. Of course, as in all EFT Tapping Training workshops, new material is presented using a variety of learning styles including partnered teaching methods, demonstrations, paired and small group experiential applications, video examples and more to ensure that no one walks away without fully understanding everything that is taught. Most importantly, this EFT Level 2 workshop will hone your practice skills. Greater attention and time will be spent on personal observation to assist you in mastering the techniques learned. Enhanced instruction on asking key questions for uncovering core issues will be provided. The following subject matter will be taught in Level 2 with an emphasis on personal practice of techniques learned with direct observation and support from the trainers: The Gentle Techniques for Intense Issues including Sneaking Up on the problem, Tearless Trauma and the somato-emotional process of Chasing the Pain (Sensation) Understanding the Nature of and working with Traumatic Events Clearing Limiting Beliefs Questions for Uncovering Core Issues Core Issues and Physical Symptoms Working over the Telephone or Internet EFT in Groups Using EFT with Children Scope of Practice, Informed Consent and the EFT Ethics Code Participants who take this program will be issued a Certificate of Attendance that they have completed EFT Level 2. This is the second instructional step along the certification path for EFT International Accredited Certified EFT Practitioner, but should not be put forth as a certification in itself. Read about EFT and course descriptions Presenting Certified Trainers Alina Frank and Craig Weiner, DC Cost For the combination three day Level 1 and 2 combined training, the tuition is $799 ($749 early bird special if purchased 30 days prior to the workshop start date). Both EFT Levels 1 and 2 are pre-requisites for EFT International EFT certification. Location Online Hours Both EFT Level 1 and 2 training courses begin promptly at 9 am with registration beginning at 8:30 am Seattle/Los Angeles time zone. A 15 minute break is provided in the morning and afternoon. A 90 minute lunch break is offered beginning at approximately 12:30 pm. The class ends each day at 6 pm. EFT International Certification Process Attendance and completion of this training in no way constitutes “certification” and no attendee should consider themselves or promote themselves as a Certified EFT Practitioner based solely upon attendance of this training. All the requirements for completing certification will be discussed during the workshop and can be found on our EFT Certification page. Alina Frank and Dr Craig Weiner have taught and mentored thousands of individuals and professionals throughout the North America and Europe and are sought after speakers and presenters in the field of EFT instruction and EFT practice development and are EFT International Accredited Master Trainers and EFT International Supervising Mentors. CEUs, Certificates & Letters of Completion Approved Continuing Education Hours 24 CEUs have been pre-approved for NY LMHCs and may be available through 716CEU, LLC which is recognized by the New York State Education Department’s State Board for Mental Health Practitioners as an approved provider of continuing education for licensed mental health counselors. #MHC-0241. Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. 24 CE hours for NY Social Workers have been pre-approved and may be available through Tree of Hope Counseling, an approved NYS Continuing Education Contact Hours (CEU) provider for Social Workers (#SW0322). Please inquire for further details regarding whether this specific training will have CEs offered and any requirements and costs involved for receiving CEs. The EFT Tapping Training Institute, with Craig Weiner and Alina Frank as trainers, have been pre-approved for 24 continuing education credit hours for online Emotional Freedom Techniques Level 1-2 training for the Canadian Counselling and Psychotherapy Association. Members of CCPA will receive transcripts at no cost listing all attended events assessed as Continuing Education Credit. Non‐members must attach a cheque for $30.00 payable to CCPA to have CEC’s recorded and to have a transcript issued. Every person who fully attends the workshop training will receive a completion certificate with the course hours listed. Certificates of Completion Official Letters of Completion are available upon request for courses. They are signed by our Trainers, has the attendees name, date of completion and the number of educational hours. The letter will be sent to the course participant as a PDF email attachment. It is the responsibility of each participant to submit the letter to the appropriate certifying board in order to determine if they will receive any type of credit. Certificates of Completion for Courses Participants of the following courses offered by the EFT Tapping Training Institute may receive a Certificate of Completion upon graduation (provided in a PDF format and sent via email): EFT Levels 1-2 EFT Level 3 Matrix Reimprinting Foundational Training Other courses may be able to provide either a Certificate of Completion or a Letter of Completion upon graduation. BIPOC Scholarship Program Please visit our Scholarship Guidelines & Application page for details. Cancellation Policy A complete refund, minus $150 administration fee, is given up to 3 weeks (21 days) prior to workshop’s start date. If cancellation occurs for any reason within the 3 weeks prior to the event, the student may apply the tuition paid towards any future EFT or Matrix Reimprinting workshops offered by us. AS THERE IS MATERIAL TO REVIEW PRIOR TO THE FIRST DAY OF TRAINING, REGISTRATION CLOSES 24 HOURS BEFORE THE START OF THE TRAINING SO THAT YOU CAN REVIEW THE MATERIALS IN ADVANCE. IF YOU DO NOT RECEIVE THE LINK OF THIS MATERIAL VIA EMAIL WITHIN 24 HOURS OF REGISTERING, PLEASE CONTACT US IMMEDIATELY.

Solution-Focused Therapy is a short-term, goal-oriented approach that helps couples find practical solutions to specific issues. This therapy is ideal for couples looking to resolve particular problems quickly and effectively.   Key areas: goal-oriented, practical solutions, specific issues, short-term therapy, effective resolution 3 x 1 hour sessions 

Imago Relationship Therapy (IRT) focuses on identifying how unmet childhood needs and unhealed wounds impact adult relationships. This therapy promotes empathy and understanding, helping couples address deep-rooted issues and improve their emotional connection. Key areas: childhood needs, unhealed wounds, empathy, emotional connection, deep-rooted issues 3 x 1 hour sessions