520 Courses in Cardiff

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

Introducing Trauma-Informed Therapy Package: Healing, Empowerment, and Renewed Well-Being Have you experienced past traumas that continue to impact your daily life and relationships? Miss Date Doctor’s Trauma-Informed Therapy Package is designed to provide you with a safe and supportive environment to heal from trauma, regain a sense of empowerment, and foster renewed well-being. Trauma can leave deep emotional scars that affect your mental health, self-esteem, and capacity to form healthy connections. Our experienced and compassionate therapists are here to help you navigate the healing journey with trauma-informed care. Here’s how the Trauma-Informed Therapy Package can support you: Safe and Non-Judgmental Space: Our therapists create a safe, non-judgmental space where you can freely express yourself and explore the impact of trauma on your life. Trust and confidentiality are paramount as we work together on your healing journey. Trauma Processing: Through evidence-based techniques, we’ll gently guide you through trauma processing, helping you gradually process and release the emotions and memories associated with the traumatic experience. This process can reduce the emotional intensity of trauma and foster emotional healing. Empowerment and Resilience: Our trauma-informed therapy empowers you to reclaim your strength and resilience. By addressing the effects of trauma, you’ll find inner resources to cope with life’s challenges, enabling you to move forward with renewed hope. Coping Strategies: We’ll equip you with practical coping strategies to manage triggers and stressors that may arise from trauma-related memories. You’ll learn healthy ways to regulate emotions and navigate difficult situations. Rebuilding Self-Esteem: Trauma can significantly impact self-esteem. Our therapists will work with you to rebuild a positive self-concept and develop a healthy self-image, fostering self-compassion and self-acceptance. Strengthening Relationships: Trauma can affect how you relate to others. In the Trauma-Informed Therapy Package, you’ll explore relational patterns and develop healthier ways of connecting with others, nurturing fulfilling relationships. Mindfulness and Grounding: Practicing mindfulness and grounding techniques can help you stay present and connected to the here and now, reducing anxiety and hypervigilance associated with trauma. Understanding Triggers: We’ll help you identify triggers and understand their origins. By gaining insight into your triggers, you can better manage their impact on your emotional well-being. The Trauma-Informed Therapy Package at Miss Date Doctor prioritizes your healing and well-being. Our therapists have extensive experience in trauma recovery, ensuring that your therapy journey is individualized and tailored to your unique needs. Release the burden of trauma and embrace a future filled with hope and empowerment. Enroll in the Trauma-Informed Therapy Package today, and let our skilled therapists guide you towards healing and renewed well-being. You don’t have to face trauma alone; we’re here to walk with you on your journey to recovery and growth. 3 X 1 hour sessions https://relationshipsmdd.com/product/trauma-informed-therapy-package/

English courses for all levels are available through Mac International

Spanish language courses

Heart centred Qi-Gong with Emma Sunday 9th June 2024 10am-1pm Price: £40  Welcome to the Sunhouse for another blissful morning of Qi-Gong and meditation. In this summer session we will be exploring the FIRE element through heart centred Qi-Gong.  Imagine bare-feet on the grass, absorbing the morning sunlight on your skin, serenaded by the sounds of the forest and smells of fresh blossom filling the air. Let yourself be supported and grounded by nature all around us.  Emma will guide us through a gentle yet powerful Qi-Gong practice, a form of movement meditation helping to clear out energetic blockages so you can feel more connected with your deeper self.  In this summer session we will explore what is know as the three treasures; Jing (Essence), Qi (Energy), Shen (Mind-Spirit). We will begin with active dynamic Qi-Gong exercises working with our ‘Jing’ energy opening our physical body with tapping, self massage and stretches, we will then access the ‘Qi’ energetic level with a focus on our heart Qi through slow flowing movements and breathing practices. We will finish with a ‘Shen’ meditation connecting to our own light body and its natural connection to the abundant Qi of the universe.  Lets invite a little more joy in to our everyday Price includes nourishing drinks and delicious summer treats

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

MASTERCLASS 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! CLINICAL PRP • Sports medicine • Traumatology • Ophthalmic • Burn trauma • Wound healing –diabetic foot • Skin grafting • Dentistry-sinus lift • Tooth implants.   PRP theory & equipment: Training Online Theory will enable you to understand: Anatomy Vascular Supply, Contraindications Patient consultation Complications Management Post treatment advice Dealing with equipment A certification of training will be provided upon completion of the course. Aesthetic PRP • Skin rejuvenation • Hair restoration • Fat grafting in combination PRP • Post laser •Acne & Rosacea •Acne scar •TissueVolumisation alternative of HA fillers •Aesthetic gynecology /urology.   Plathelet Rich Plasma We will cover pertinent information including mechanism of action, safety and efficacy issues, management and treatment of complications, dilution guidelines, and more. Hands on practical session – skin rejuvenation and hair loss Extraction, Preparation and Dosage Management Injection techniques – face, neck and head (hair loss); also the use of cannula Upon successful completion of the course, you will receive a certificate and title of PRP Certified Practitioner.   MASTER CLASS PRP & PRF During the course we are providing . Taking blood and how to use a Centrifuge . PRP injecting techniques in face neck and décolletage hands. PRP Microneedling using a DERMAPEN. Combination treatment PRP with Mesotherapy. MECHANISM OF ACTION Platelets + Leucocytes form 3D mesh release of GF Chemo attraction and migration of macrophages and stem cells Stem cells proliferates by mitosis Stem cells undergo differentiation process BENEFIT FROM PRP TREATMENT & THERAPYExperience the advantages of PRP treatment and therapy, utilizing autologous blood with natural growth factors for disease-free and hypoallergenic benefits. Boost wound healing by regulating mitosis, proliferation, and differentiation, enhancing tissue with collagen, elastin, and hyaluronic acid. Benefit from improved tissue oxygenation, nutrition flow, and support for procedures like hair transplants, fat transfers, and skin grafts.PRP works effectively in skin rejuvenation, facial resurfacing, microneedling, and combines well with HA, PDO threads, skin boosters, peeling, or CO2 lasers. It also proves beneficial for hair restoration, showing positive results in various protocols for Androgenic alopecia and age-related hair loss.PRP where works .Skin rejuvenation-facial resurfacing.application-injection alone. Microneedling Combination with HA,Combination with PDO threads,Skin boosters , peeling or CO2 lasers Hair restoration, Multiple protocols with positive results Evidence for improvement of: Androgenic alopecia-male and females, “spot hair lost” Improvement of age related hair loss. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL EXPERT | Masterclass Course

Communication Skills 1 Day Training in Cardiff

Gain a deep understanding of Production Sharing Contracts (PSC) and related agreements through our expert-led course. Enroll now and excel in your field with EnergyEdge.

Customer Service Essentials 1 Day Training in Cardiff