4728 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

Give Your Puppy The Best Start With Wolfgang's Way Award Winning Online Puppy Training Programme. Effective And Fun; Learning Together In The Comfort Of Your Own Home With Programmes Tailored To You And Your Puppy’s Needs.

Learn how to create a supportive and open environment for mental health and wellbeing at work, helping everyone thrive and perform at their best.

Introducing the Dating Profile Consultant Package: Expert Guidance for an Outstanding Online Dating Presence Are you looking to maximize the impact of your online dating profile and improve your chances of connecting with compatible matches? Miss Date Doctor’s Dating Profile Consultant Package offers you personalized support and insights from experienced consultants who specialize in optimizing online dating profiles. Crafting an effective online dating profile requires a strategic approach and understanding of what resonates with potential matches. Our dedicated dating profile consultants are here to assist you in creating a profile that showcases your unique qualities and attracts genuine connections. Here’s how the Dating Profile Consultant Package can support you: Personalized Evaluation: Our dating profile consultants will conduct a thorough evaluation to understand your personality, preferences, and dating objectives. Strategic Profile Enhancement: We’ll collaborate with you to strategically enhance your profile text, photos, and overall presentation. Photo Selection and Arrangement: Our experts will guide you in selecting and arranging photos that project a genuine and appealing image. Compelling Bio Creation: We’ll assist you in creating a compelling and authentic bio that piques the interest of potential matches. Showcasing Your Uniqueness: Our consultants will work with you to emphasize your unique qualities and values that make you stand out. Initiating Engaging Conversations: We’ll provide insights into starting conversations and maintaining engaging communication with your matches. Boosting Self-Confidence: The Dating Profile Consultant Package aims to boost your confidence by helping you create a polished and attractive profile. Attracting Compatible Matches: We’ll focus on attracting matches who align with your dating preferences and aspirations. The Dating Profile Consultant Package at Miss Date Doctor is designed to empower you with a refined and attention-grabbing online dating profile. Our experienced dating profile consultants offer personalized guidance and practical tips to help you make a lasting impression in the online dating world. Invest in your online dating success and take the first step towards an optimized dating profile with the Dating Profile Consultant Package. Embrace the opportunity to present your best self and attract matches that resonate with your personality and interests. Let our consultants guide you towards an elevated online dating experience filled with meaningful connections. 15 pictures AI approved dating app high standard excellence photos 4×1 hour sessions https://relationshipsmdd.com/product/dating-profile-consultant/

Face to Face training customised and bespoke. One to One Online or Face to Face

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Discover how to elevate your career as an executive assistant or personal assistant with our comprehensive EA Mastery Workshop. Gain new skills, strategies, and tools to maximize your impact and achieve success.

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 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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

“Light makes photography. Embrace light. Admire it. Love it. But above all, know light. Know it for all you are worth, and you will know the key to photography.” – George Eastman" - Photography For Parents - Shooting With Flash Next course starts on Monday 12th Feb 2024 Scared of Flash? Never got good results from it? Not sure how it works with your camera? Thinking it’s bound to be complicated and just for studio work? This is the course for you! We show you how to work your flash and your camera – on and off camera! - to get great, natural looking results. In this course you'll discover how to use flash not just to supplement light in dim spaces, but to use it creatively, to help you create images you wouldn't be able to capture with just natural light.  KEY COURSE INFO: Course type: Instructor-led Course duration: 4 weeks Course format: Online course with interactive live webinar classes, feedback on your learning and support group WHAT YOU LEARN: You will learn how to make your flash work with your camera and how to control it so that it gives you beautiful, natural looking light You will learn to work with the flash off camera - giving you the freedom to position your light wherever it will most suit your subject rather than relying on what you have with natural or indoor light You will learn to play with flash to capture a variety of creative outcomes and apply it to lots of shooting situations - from learning to fake pretty window light to freezing motion with Flash understanding flash equipment learning to shoot with on-camera flash earning to shoot with off-camera flash learning to bounce the light for natural looking results using flash as a sole or supplementary light source freezing movement with flash where the shutter speed wont allow it THIS IS THE COURSE FOR YOU IF : You find yourself struggling with light especially in the darker autumn / winter months, and there never seems to be enough ISO or aperture to get you what you want You can already use your camera in manual and want to add mastery of detachable flash to your skillset - so you can never worry about insufficient or poor light wherever you are, or whatever unknown space you go into You want to be able to make flash images look natural rather than sporting that famous 'deer in the headlights look. A good flash image never 'looks' like a flash image You want to learn how to capture creative images using a flash - such as freezing motion, creating dramatic shadows, or adding a splash of light to specific areas of the frame. You want to add this versatile skill to your toolbox so you can adapt it to different shooting scenarios. ESPECIALLY if you're considering taking up photography professionally or semi professionally, this is an immensely useful skill to have. Next Shooting with Flash course starts on 12 Feb 2024  4 core course modules Support Facebook group Weekly live webinar Weekly practice assignment Feedback on your images Why shoot with flash in the first place?  “Don’t use Flash – it will wash out your child”“Flash will make your photos look horrible”‘You can’t control flash – no control over what your photos will look like” You may have heard those statements, maybe even uttered them yourself. And to a degree – they can be true – but only because, if you don’t know how to control and work any tool, it’s likely to give you terrible outcomes – remember how much poorer your photos were when you first started with your camera on full auto? Here is how I see Flash, and what this course is about: Flash lets me bring light where there would normally be not enough light available to take a well exposed photo – and let me tell you – in glorious British weather, that’s more often that I would like! Flash lets me shape the light to suit my needs – I can make it moody or bright, I can even make it look like natural light ( yes really) Flash lets me neutralise ugly light and make it look good ( anybody else cursed with ugly spotlight lights in their home? no? just me? ) Flash lets me be in control, especially in unknown venues and locations, spaces where I won’t get a chance at that second shot. Flash helps me fill in shadows when shooting in very bright light – the goal is not to stop using natural light, but to help create a balanced image where natual light alone can't cut it COURSE PREREQUISITES YOUR SKILLS: We recommend that you are comfortable in shooting in full manual mode. It's possible to use flash in priority modes of course, but you don't have full control of its strength and level. YOUR EQUIPMENT: You will need to have a detachable flash for your camera make. This could be the same brand as your camera or a compatible third party flash manufacturer.  You will also need a way of triggering your flash OFF camera - in some cases, you may be able to do this directly from camera or via an additional remote trigger / controller. Click here to see our Flash buying guide below Shooting with FLASH Book your space now: COURSE STARTS : 12th Feb 2024 ( 4 weeks)COURSE COST : £179 ( payment plans available )What’s included: 4 weekly modules with step by step tutorials weekly live class online class ( also recorded) - on Tuesday evenings feedback and advice on your photos private support group PDF workbook Join our next group to learn how to never have to deal with insufficient light and discover a whole new area of photography! INSIDE THE MODULES - aka WHAT DO YOU LEARN? Module 1: Getting Started with Flash In this module we introduce you to the principles of making your flash work with your camera. We show you how the two work together in layering exposures, how you can control both the flash and natural light side and how to achieve predictable outcomes from your flash. This is the biggest learning curve because the way you work your camera with flash is very different to how you do this with just natural light and understanding the control side of things will let you get creative afterwards.  Major Takeaways: At the end of the module you will have gained an understanding of how to work your flash ON your camera. With that, you will have learned how to balance your key light and your fill light, how to combine flash exposure with a natural light exposure, how to supplement or even replace light with flash light. You will also make first steps into bouncing the light to give it a more natural appearance.  Module 2: Taking your flash OFF camera  In this module we teach you how to make your flash work when detached from your camera. We look at different techniques and methods or shooting off camera as well as any additional equipment you may need for this. We teach you how to use that off camera flash for a number of practical and creative examples Major Takeaways: You will be able to use the flash off camera - whatever your preferred off camera methos. We will explore using off camera flash as the key light - creating low key and high key images, as fill light and as a supplementary light to provide additional dimension to the images.  Module 3: Making flash look natural  In this module we learn to recognise how you can adjust the very quality of your flash to create natural looking images. We learn how to bend - or bounce the light - on and off camera, to create the kind of images that noone would ever suspect of being taken with flash. We also introduce you to a number of light modifiers and show you what you can expect from them as well as what might work in the way you take the photos.  Major Takeaways: Learn how to modify your flash to achieve soft or hard light look. Discover how to bounce your flash and where from and how the angle of those flash bounces will give your subject very different looks. Learn about light fall-off and how to apply this principle to achieve more or less contrast filled images when using flash/  Module 4:Flash and motion In this module we show you how to use flash when trying to freeze your subject - whether it is your child bouncing on the soufe in dim Novemeber light or an inanimate object making a splash. We also introduce you to a few way you can play with flash and your shutter speed to achieve fun and creative outcomes. Major Takeaways: You will learn how to freeze movement with flash - even on very slow shutter speeds or in very poor light. You will learn how shutter and flash work together and how you can achieve great creative outcomes such as high speed photography or freezing rain.  Next course starts on 12 Feb 2024

Project Leadership Skills: Virtual In-House Training To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What You Will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity Summary and Next Steps Key concepts review Creating your personal action plan