885 GRE courses in Cardiff delivered Live Online

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Join the Historical Association and the Royal Geographical Society at this special online twilight forum event specifically for primary teachers of history and geography. The theme this time will be climate education and how primary teachers can develop this through their history and geography lessons. With a keynote speaker and workshop sessions from Ailsa Fidler and Emma Espley, plus an opportunity to network and share ideas, this event will support primary teachers to better understand how history and geography can feed into the responsibility of every curriculum subject to educate our young people about the climate crisis and sustainable futures.

Project Communication Skills: In-House Training Communication is the single most critical project success factor. When effective, projects get executed on time, within budget, and with objectives being met. But that isn't all. Strong communication also nurtures healthy team relationships. And in today's highly diverse world, where projects are often fast-paced, complex, and virtual, that is more important than ever. Strong communication skills foster cultural awareness, trust, and empathy. Together, they contribute greatly to project success-and ultimately, to future project success. In this course, participants will actively explore best communication practices from a variety of perspectives: in-person, virtual, electronic, and via formal project documentation. In order to be transformative, however, those perspectives will be filtered further through the lens of their formal, personalized assessment. It is a powerful tool which identifies individuals' internal needs and priorities. It translates those into descriptive profiles and reports, gifting users with valuable information about themselves and others. Paired with the course's real-world activities, it will provide uniquely strategic opportunities for communicating effectively and meaningfully-and with less conflict, both personally and professionally. What You Will Learn At the end of this program, you will be able to: Identify basic elements of communication and explain how they affect teams Explore how your assessment style impacts you and how you communicate with people of other styles Infer how your style impacts the way(s) you send and interpret emails and instant messages Analyze real world email and instant messaging practices to determine how they affect communication and relationships Explore best practices for formal project communications and presentations Analyze how your assessment style and global diversity can contribute to both strong team communication and conflict Identify solutions for virtual team work communication challenges Getting Started Foundation Concepts Communication as a foundation skill Elements of communication Communicating across media Targeting your audience How communication impacts team performance The Assessment Framework Overview of the assessment's approach Exploring assessment report Increasing your effectiveness with other assessment styles Email and Instant Messages Preferred communications and assessment styles The email brands we create Assessment styles and email Emotion and email Email guidelines and best practices Anatomy of an email The seven deadly email sins Instant messages and other interfaces Project Communications and Presentations Communicating across the project lifecycle Project templates Structuring a presentation Delivering a presentation Interpersonal and Team Communication Skills Communication styles and techniques Managing conflict in a project environment Styles and conflict Communication and global team leadership Virtual Communication Leading global virtual teams Virtual processes and technology Virtual team leadership

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

3DS MAX AND AFTER EFFECTS ONE DAY face to face training customised and bespoke. Online or Face to Face

This is a beginners level course and will take you through the basics of Graphic Design. This is a great way to start if you have no prior knowledge of graphic design and want to start at the beginning.

Build confidence & capability and engage in meaningful dialogue about race.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

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.

Women in Banking Leadership Workshop Workshop Overview: Unleash your potential - The Banking and Financial Services industry is a constantly changing sphere that calls for emerging leaders to adapt and grow in order to thrive and succeed. Often those wanting to take the next step in the field find it hard to see their full value and potential, slowing their progress in a world full of opportunities. Emerging leaders will need to understand their professional values and know how to cultivate a growth mindset to stand out and fulfil their career desires.  This interactive virtual workshop will provide emerging leaders within the field the skills to understand the strengths that they are able to bring to the corporate table to confidently unleash their potential. It will particularly benefit those who aspire to move beyond early management to broader leadership roles. Kat will guide attendees to unlock their potential through releasing self-doubt, connecting to their unique contribution and forming a confident, strategic leader that will drive an organisation to success. Our Aims for the Workshop: Navigate key challenges and change in fast-paced work-places Understand the value of embracing complexity, uncertainty and diversity Negotiate diversity and inclusion biases, enablers and blocker Topic 1 Define your leadership style What are the capabilities, attributes and skills of an influential leader? What is your unique contribution? Is this congruent with your personal brand? Align your leadership strengths and values with the expectations and culture of your organisation. Topic 2 Leading with Emotional Intelligence (EQ) Understand your EQ and its impact on the way you are perceived as a leader Leverage your EQ in the workplace both in person and online Embrace qualities of empathy and authenticity to become a better leader Topic 3 Interactive Panel Q&A Discussion: Open Q&A with Senior Female leaders within the banking sector. Please see below the panel and biographies of each panellist. Topic 4 How to be known as a strategic leader Understand the uplevel from management to leadership and how to articulate your strategy How to translate broad leadership tools and tactics into practical, personalised results Move from transactional to transformational leadership Topic 5 Strengthen your resilience and resolve What is stress and how do you “show-up” on a bad day? Bounce back from challenging situations and predicaments Effectively manage conflict and turn negativity into an opportunity Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in the banking sector that wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centred group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code?  Your Facilitator Kat Hutchings Kat coaches Executives and senior leaders in scale businesses to develop their leadership capability, build high-performing teams and create a culture that motivates and delivers. She works with them to identify their unique contribution and lead in a way that's aligned with who they are. Clients that work with Kat connect to their sense of purpose and how they contribute to the organisation. This creates a ripple effect through their team as they step into more powerful and impactful leadership. Kat coaches for insight - because a single insight can inspire action that changes everything.  Client outcomes include improved sales performance, successful delivery of change & transformation programmes and greater employee engagement & wellbeing.  Kat is an accredited Professional Executive Coach with the Association for Coaching and a Master NLP Practitioner. She has studied neuroscience, mindfulness and resilience, often bringing these insights to her coaching and training.  Combined with her experience as a leader in Financial Services, Kat’s clients find her to be commercially minded, knowledgeable and positively challenging. Her background as a corporate banker means Kat is quickly able to understand the context, including a firm’s strategy, vision and drivers. As a former Head of Coaching for the London & South East region of a FTSE 100 organisation, Kat is also well versed in leadership development programmes – their design, delivery and embedding through coaching. Outside of her coaching work, Kat spends lots of time with her husband and 2 young children. She enjoys trying different wines, talking to interesting people, having new experiences and buying flowers. THE PANEL The final panel is coming soon ⏳