2660 Courses in Cardiff delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Learn AutoCAD Evening Training Course. Clickhere for info This Autodesk AutoCAD 2D Introduction Evening Course is ideal for students who are completely new to the software and for those looking to produce advanced 2D plans, elevations and sections, as well as understanding all key tools in AutoCAD 2D. Call 02077202581 or WhatsApp 07970325184. Duration: 10 hrs. Method: 1-on-1, Personalized attention Schedule: Tailor your own slots, available from Mon to Sat between 9 am and 7 pm. Flexible Evening Sessions: Learn at your pace with evening classes. Comprehensive Skill Development: Master 2D Plans, Sections and Elevations. Industry-Standard Knowledge: Gain proficiency sought by employers. Practical Application: Apply skills to real-world design scenarios. Recorded Lessons for Review: Revisit course material anytime. Lifetime Email Support: Get ongoing assistance even after course completion. Course Duration: 10 hours Course Overview: AutoCAD 2D Training Course Designed for beginners, this course teaches the fundamentals of AutoCAD 2D software. Participants will learn essential tools and features to create, edit, and annotate 2D drawings. By course completion, students will confidently produce their own 2D drawings using AutoCAD. Introduction to AutoCAD 2D Overview of AutoCAD 2D software Understanding the user interface Navigating the drawing area Setting up drawing units and limits Creating basic shapes and lines Drawing Tools Utilizing Line, Circle, and Arc tools Implementing Polyline and Spline tools Adding dimensions and annotations Understanding layers and object properties Creating and inserting blocks into drawings Editing Tools Using Erase, Move, and Copy tools Implementing Rotate and Scale tools Understanding grips and grip editing Utilizing Trim and Extend tools Exploring fillets and chamfers Advanced Drawing Tools Utilizing Offset and Mirror tools Implementing Array and Divide tools Understanding hatching and gradient fills Adding text and multiline text Incorporating tables and fields into drawings Final Project Completing a final project using all learned tools and features Instructor-guided process to create a personal 2D drawing with AutoCAD Q&A and review of course material Assessment: Submission of the final project Active participation in class exercises and discussions Requirements: AutoCAD 2D software installed on the student's computer Basic computer skills and familiarity with the Windows operating system A laptop or desktop computer with a minimum of 4GB RAM and a 64-bit operating system.

Garden design face to face training customised and bespoke.

Basics to Essential Photoshop Skills Course, Master retouching, layers, color, correction, shapes, and symbols. Delve into graphic design, photo editing, and digital art. Elevate your skills from beginner to pro, gaining expertise in UX strategies, ensuring your websites are impactful and user-friendly. Click here for more info: Website Duration: 16 hours Method: Personalized 1-on-1 sessions ensure individual attention. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface and workspace Navigating tools, panels, and menus Essential keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Basic Image Editing Techniques (2 hours) Cropping, resizing, and straightening images Color adjustments and corrections using adjustment layers Removing blemishes and distractions with healing tools Introduction to layers and blending modes Module 3: Advanced Image Manipulation (2 hours) Creating composite images with layer masks Utilizing advanced selection tools for precise editing Applying filters and special effects for creative enhancements Mastering text and typography in Photoshop Module 4: Graphic Design and Layout (2 hours) Designing banners, posters, and social media graphics Working with shapes, gradients, and patterns Creating visually appealing typography compositions Introduction to vector graphics and custom shapes Module 5: Web and UI Design (2 hours) Designing user interfaces for websites and applications Creating web-ready graphics and optimizing images Prototyping interactive elements and buttons Designing responsive layouts for various devices Module 6: Introduction to 3D and Animation (2 hours) Creating 3D objects and text Basic 3D manipulation and lighting effects Introduction to animation with the Timeline panel Exporting animations and interactive multimedia Module 7: Project-Based Learning (2 hours) Applying learned techniques to real-world projects Designing a digital artwork, website mockup, or social media campaign Receiving instructor feedback for skill refinement Final presentation of completed projects and portfolio building Upon completing our personalized Photoshop Mastery course, you'll: Master Tools: Excel in Photoshop's essential and advanced tools, including image manipulation and graphic design techniques. Design Expertise: Develop skills in creating compelling graphics, web layouts, and interactive UI designs. 3D & Animation Skills: Understand 3D manipulation, lighting, and basic animation techniques. Career Opportunities: This course prepares you for roles such as Graphic Designer, Web/UI Designer, Digital Artist, Photo Retoucher, 3D Artist, or Entrepreneur in the design industry. Dive deep into the world of Photoshop with our exclusive 1-on-1 training program. Tailored to your pace and skill level, this course offers a comprehensive understanding of Photoshop's essentials and advanced features. From image editing to graphic design and 3D manipulation, master Photoshop with personalized attention and hands-on guidance. Key Details: Personalized Attention: Enjoy dedicated 1-on-1 sessions with an experienced Photoshop instructor, ensuring focused learning and personalized guidance. Tailored Curriculum: The course content is customized based on your goals, allowing you to explore specific areas of interest and address individual challenges. Flexible Scheduling: Schedule sessions at your convenience, accommodating your busy lifestyle. Choose from weekdays or weekends, morning or evening, for a flexible learning experience. Hands-on Learning: Engage in practical, real-time exercises and projects tailored to your interests, reinforcing your skills and boosting confidence. In-depth Exploration: Cover a wide range of topics, including image editing, graphic design, 3D manipulation, web design, and more, delving deep into each area for a thorough understanding. Interactive Q&A: Participate in interactive Q&A sessions during each class, clarifying doubts and gaining valuable insights from your instructor. Lesson Recordings: Access recordings of your sessions for review and reinforcement, ensuring you grasp every concept and technique thoroughly. Ongoing Support: Benefit from continuous email support even after the course completion, receiving guidance on projects and addressing any post-training queries. Solid Foundation: Develop foundational Photoshop skills, mastering essential techniques for image editing and graphic design. Versatile Editing: Learn retouching, color correction, and photo enhancement for professional-quality results. Efficient Workflow: Optimize your work with layer management, non-destructive editing, and time-saving tricks. Creative Mastery: Harness Photoshop's power to create digital art, manipulate images, and design stunning graphics. Real-world Application: Apply skills to diverse projects like photo editing, web design, and social media graphics. Flexible Review: Access recorded lessons for convenient review of specific techniques or workflows. Lifelong Support: Enjoy lifetime email assistance for guidance, questions, and clarifications even after course completion.

Training Trainers of Spiritual Directors Developing the abilities needed to facilitate Spiritual Direction formation programmes

LOOKING FOR: PICTURE BOOKS Perry Emerson is a Commissioning Editor at Little Tiger Press, where he works with authors and illustrators mostly on picture books and sometimes on novelty books. He is also a picture book author in his own right. Little Tiger Press publish a huge range of formats and genres, striving to create a diverse range of high-quality books, with something that will appeal to every reading taste, helping children develop a passion for books and a life-long love of reading. Authors who form part of the Little Tiger Picture Book Family include Bethan Clarke, Tracey Corderoy, Rachael Davis, Karl Newson, Jodie Parachini, Nima Patel, Steve Smallman, Stephanie Stansbie, Louie Stowell, Clare Helen Welsh, Becky Wilson and many more. When he’s not making books, he spends his time playing music and discovering new restaurants. Perry lives in London with his partner and their much-too-fluffy cat. For picture books, Perry would like you to submit a covering letter, and 1 complete manuscript, double-spaced, with spreads marked out, in a single word or PDF doc. By booking this session you agree to email your material to reach I Am In Print by the stated submission deadline to agent121@iaminprint.co.uk. Please note that I Am In Print take no responsibility for the advice given in your Agent121. The submission deadline is: Wednesday 20th August 2025

LOOKING FOR: ADULT FICTION, NON-FICTION Una is a Rights Agent at Susanna Lea Associates and am starting to build a client list. She grew up in London and graduated from the University of Cambridge with a BA in English in 2021. At university, Una was particularly interested in contemporary West African and South Asian literature. She started as an agent's assistant at SLA London in 2022 and now handles some translation rights and provides support with editorial work and submissions. Una's favourite reads always set her at ease right away and draws her in with impressive and accessible storytelling, memorable characters or an original hook. Una enjoys writing which expands her worldview, makes her laugh out loud or keeps her on her toes with its twists and turns. She welcomes submissions from debut authors and would be keen to read across a wide range of genres and styles. She is looking for literary, upmarket and book club fiction, and is always drawn to stories that explores the challenges and complexities of love and relationships in all its forms —within families, between friends or in romantic relationships. Una loves the way in which familial relationships are dissected in The Wren, The Wren by Anne Enright and the impact of the local community in Small Worlds by Caleb Azumah Nelson. She is always drawn to novels with a strong sense of community, whether they are unified by geography, culture, or in other unexpected ways. Una has always loved reading international and translated fiction and welcomes submissions from authors writing contemporary fiction that engages with cultures and traditions from around the world, such as in voices of the deities in Freshwater by Akwaeke Emezi or the subversive tales of Sayaka Murata. She is not looking for children’s or YA titles, science fiction or high-concept fantasy, but is open to submissions from authors writing in the speculative fiction space, and books with fantastical or otherworldly elements, be that magical realism or supernatural horror, such as Mona Awad's campus novel with a twist, Bunny. Una would also love to read more writing that engages with the natural world and reminds us of the limitations of human understanding. In non-fiction, Una enjoys books that furthers her understanding of wider societal issues — nature and the environment, culture, and little-known history. Her recent non-fiction favourites are Eve by Cat Bohannon, Doppelgänger by Naomi Klein and Unearthed by Claire Ratinon. Una would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Una is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Wednesday 20th August 2025

Aftereffects face to face training customised and bespoke.

LTE Architecture and Protocols course description This course provides a comprehensive tour of the LTE architecture along with services provided and the protocols used. What will you learn Describe the overall architecture of LTE. Explain the information flows through LTE. Describe the LTE security. Describe LTE mobility management. Recognise the next steps for LTE. LTE Architecture and Protocols course details Who will benefit: Anyone working with LTE. Prerequisites: Mobile communications demystified Duration 3 days LTE Architecture and Protocols course contents Introduction History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications. System Architecture LTE hardware architecture. UE architecture and capabilities. E-UTRAN and eNB. EPC, MME functions, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM, RRC state diagrams. Radio transmission and reception OFDMA, SC-FDMA, MIMO antennas. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and signals. Cell acquisition, data transmission and random access. MAC, RLC, PDCP protocols. LTE spectrum allocation. Power-on procedures Network and cell selection. RRC connection establishment. Attach procedure, including IP address allocation and default bearer activation. LTE detach procedure. Security in LTE networks LTE security features, identity confidentiality, ciphering and integrity protection. Architecture of network access security in LTE. Secure key hierarchy. Authentication and key agreement procedure. Security mode command procedure. Network domain security architecture. Security associations using IKE and IPSec. Mobility management RRC_IDLE, RRC_CONNECTED. Cell reselection, tracking area updates. Measurement reporting. X2 and S1 based handovers. Interoperation with UMTS, GSM and non-3GPP technologies such as cdma2000. QoS, policy control and charging QoS in LTE, EPS bearers, service data flows and packet flows. The architecture and signalling procedures for policy and charging control. Data transport using GPRS, differentiated services and MPLS. Offline and online charging in LTE. Delivery of voice and text messages over LTE Difficulties and solutions for Voice over LTE. Architecture and call setup procedures for circuit switched fallback. Architecture, protocols and call setup procedures in IP multimedia subsystem. Enhancements in release 9 LTE location services. Multimedia broadcast / multicast service and MBSFN. Cell selection, commercial mobile alert service. LTE Advanced and release 10 Impact of carrier aggregation on LTE air interface. Enhanced MIMO processing on uplink and downlink. Relaying. Release 11 and beyond. OAM and self organising networks Operation, administration, maintenance and provisioning for LTE. Self-configuration of base station parameters. Fractional frequency re-use, inter-cell interference co-ordination. Self-optimisation of base station procedures. Self-healing to detect and recover from faults.

In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to hospitality and community building – the Community Circle. The purpose of community circles is to bring people from a local community together to share their skills, talents, gifts and resources. This idea is based upon the premise that ALL of us need three things in our lives to make us happy and fulfilled: these are money, friendship and meaning. We believe that everyone needs community, everyone needs to be heard and everyone needs to have fun. Online Course now available via Teachable Platform – Creating Community Circles Learn at your own pace… lots of text and video support Category Inclusion Peer Support Parents and Carers   Description  Building Community Circles In this course we explore how we have attempted to build inclusive circles of support around individuals and contrast this with a radical approach to hospitality and community building – the Community Circle. The purpose of community circles is to bring people from a local community together to share their skills, talents, gifts and resources. This idea is based upon the premise that ALL of us need three things in our lives to make us happy and fulfilled: these are money, friendship and meaning. We believe that everyone needs community, everyone needs to be heard and everyone needs to have fun. Community Circles are based upon reciprocity and the assumption that EVERYONE has both gifts and needs – whether these are labelled or not. The circles adopt the fundamental value of inclusion that ‘all means all’, no one is excluded from community circles, instead the circle members work out how to include everyone equally and safely. A community circle is made up of participants and allies from the local community. The meeting starts with everyone sharing food and conversations. Next the group comes together in a circle so that everyone can see each other and shares what is good and new in their lives, everyone gets a turn to be listened to. ‘New and Good’ breaks the habit of thinking about and acting from what’s wrong, it is an exercise of giving and receiving attention with one another and it also provides a strong foundation of strengths from which we can think about and tackle difficulties. The group is then asked the question what do they want, need or have to offer. Community circles provide a great foundation or starting point from which to explore connections, build relationships, locate resources and share skills. These circles will be a particularly important resource for Brokers and the people that they work for. They provide a safe forum in which people can meet and friendships can start, a natural reservoir of people and relationships where people can be invited to offer their time and capacity. To be successful we have to start from a belief in inclusion. A belief that: 1 We are all born ‘in’. 2 All means all. 3 Everyone needs to belong. 4 Everyone is ready. 5 Everyone needs support. 6 Everyone can communicate. 7 Everyone can contribute. 8 Together we’re better. Learning Objectives For participants to learn how to create a Community Circle. For participants to understand the underlying rationale and ethos of this way of working. To explore ways of maximising an individual’s inclusion and connection with the wider community. To explore ways of helping with friendship, social connection and education. To increase confidence, social skills and presence of disabled adults and those with a wide range of need in their local community by focusing on their contribution. Who Is It For? Anyone interested in mobilising the community to make it more inclusive around disabled or challenging individuals. Course Content Understanding ordinary needs – plus the true dimensions of social inclusion Building relationships Creating natural circles of support Creating a community circle If you like this you will almost certainly enjoy: Person Centred Planning using PATH and MAPS