1356 Courses in Cardiff

Level 3 NVQ Diploma in Occupational Work Supervision

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

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on the core values of customer service.

This market-leading health and safety course enables companies to demonstrate compliance and embed health and safety into the company culture. Whilst anyone can attend, it is particularly beneficial for line managers, team leaders and supervisors. It is tried, tested and trusted.

A dynamic and interactive one-day or two-half-day live virtual workshop for women leaders in business, government and non-profit organizations.

Cognitive Behavioral Therapy (CBT) in couples counseling targets negative thought patterns and behaviors. This therapy provides practical solutions for improving communication and resolving conflicts, making it an effective approach for various relationship challenges. Key areas: negative thought patterns, behavior change, practical solutions, communication improvement, conflict resolution 3 x 1 hour sessions 

Introducing the Art Therapy and Expressive Therapies Package: Unleash Your Creativity, Heal, and Flourish Are you seeking a unique and powerful way to express your emotions, process experiences, and find healing? Miss Date Doctor’s Art Therapy and Expressive Therapies Package offers you a creative and transformative journey to explore your inner world, tap into your creativity, and promote emotional well-being. Art therapy and expressive therapies provide a non-verbal and imaginative outlet for processing emotions and experiences. Through various creative mediums, you’ll discover new insights, release emotional tension, and cultivate a deeper connection with yourself. Here’s how the Art Therapy and Expressive Therapies Package can benefit you: Creative Expression: Engage in various expressive art forms, such as drawing, painting, sculpting, and collage-making. These creative expressions allow you to communicate thoughts and feelings that might be challenging to put into words. Emotional Release: Through art, you can release emotions that may have been suppressed or difficult to express verbally. The creative process can be cathartic, enabling you to process complex feelings and experiences. Self-Exploration: Art therapy encourages self-reflection and introspection. As you create art, you’ll gain insights into your thoughts, emotions, and subconscious mind, fostering greater self-awareness. Empowerment and Agency: Art therapy emphasizes the process rather than the end result, empowering you to embrace imperfection and experiment without judgment. This approach can extend to other aspects of life, promoting a sense of agency and resilience. Stress Reduction: Engaging in creative activities can reduce stress and promote relaxation. The meditative aspects of art therapy can provide a welcome escape from daily pressures and anxieties. Healing Trauma: For individuals who have experienced trauma, art therapy can be a gentle and effective way to explore and heal from emotional wounds. The creative process can foster a sense of safety and control in processing traumatic memories. Enhancing Communication: For those who find it challenging to express themselves verbally, art therapy offers an alternative means of communication. It can improve verbal expression and interpersonal skills. Building Confidence: Creating art allows you to tap into your inherent creativity, fostering a sense of accomplishment and boosting self-confidence. As you witness the fruits of your artistic expression, you’ll gain greater confidence in your abilities. Participating in art therapy and expressive therapies at Miss Date Doctor is a journey of self-discovery and growth. Our skilled therapists will guide you in exploring various artistic mediums and techniques, tailoring the experience to suit your unique needs and preferences. Experience the transformative power of creativity, heal from emotional wounds, and flourish in the Art Therapy and Expressive Therapies Package. Embrace art as a powerful tool for self-expression and personal growth. Unleash your creativity and find healing in the beautiful world of art therapy. 3 X 1 hour sessions https://relationshipsmdd.com/product/art-therapy-and-expressive-therapies-package/

We will come to your school at a time that suits you and run a 2-hour workshop for all staff. We will present in clear and simple terms the school’s duties under the Equality Act, help you guard against discrimination, and leave you with useful resources. How will this workshop help your school? This is a practical, "hands on" workshop designed to be engaging and constructive. Over and above helping your school fulfil its legal duties, it will help ensure that nobody is left behind or discriminated against. The workshop will show how all protected characteristics covered by the Equality Act 2010 can be reflected positively in everyday school life. It will consider real-life examples and make this more meaningful and relevant by inviting participants to bring their own examples of equality challenges in school. We will show you how to get the best out of CSIE’s toolkit ‘Equality: Making It Happen’ – a succinct and user-friendly set of reference cards to help schools promote equality – and leave you with at least two complimentary copies. Above all, the workshop will help develop a shared understanding and build a consistent response to diversity and equality. We understand that all schools are at different stages of this journey, so this workshop will assist you in determining next steps and areas of specific focus for your setting. What will the workshop cover? The workshop will: provide an overview of the Equality Act 2010, including the Public Sector Equality Duty and what it means for all schools bring awareness to unconscious bias and how it can influence our interactions present strategies for removing barriers to learning and participation address intersectionality and how it affects people’s experiences help develop confidence and language for discussing sensitive equality issues add flesh to the bones of all the above, by considering real-life examples Who is it for? The workshop has been designed for all primary and secondary school staff and governors; delivery is adjusted to the context of each school. We encourage all teaching and non-teaching staff to attend, so that your school can develop a coherent and consistent response to diversity and equality. Feedback from previous CSIE equality workshops: Very knowledgeable presenter. I feel more empowered. Clear and concise. Very thought provoking. Clear, compassionate presentation.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

Gain comprehensive knowledge and practical skills in seizure first aid and rectal paraldehyde administration with our course. Ideal for caregivers, healthcare professionals, educators, and individuals.