378 Courses in Cardiff

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

A whole day of workshops for groups of pupils throughout your school, delivered by a dedicated ally of disabled people. Engaging and thought-provoking, these workshops are a must for schools that want to challenge prejudice and promote disability equality. Workshops will help pupils to: learn more about disability and human rights hear disabled people’s perspectives identify common stereotypes and some of the prejudices disabled people face consider what disability is and how it arises understand the difference between impairment and disability review terminology and its effect on disabled people’s identities learn about disabled people who have made a difference ask sensitive questions anonymously become advocates for disability equality 95-100% of participants say that they found our workshop helpful Some of the reasons pupils have given for finding the workshop helpful are: “Until today I had always been scared of disabled people but today I have learnt that disabled people have a heart and emotions too.” “I now understand more about disabilities. My sister and brother has disabilities.” “It shows that although disabled people have limits they can do many things.” “Because presenter told in very simply way about complicated things and used interesting examples.” “Now I know that disabled people do things differently.” FAQs: How long is each workshop? 40-45 minutes; this can be adjusted to fit in with your school day. How many workshops will you deliver? We can deliver up to six workshops in a day. How many pupils should there be in each group? The workshops are interactive, so they are more effective with groups of around 20 pupils. We are often asked to work with larger groups and this still generates excellent feedback from pupils and staff. What year groups are these workshops for? The workshops are suitable for all year groups in primary and secondary schools; we adapt the content and presentation according to the age of pupils. Does a member of staff need to stay with the group? Yes, we ask that a member of staff is present at each workshop. Will you need any equipment? We ask for a computer, projector and access to the internet. Pupils will need a pen to write with. How are the workshops evaluated? At the end of each workshop we ask all (except the youngest) pupils to write down if they have found it helpful or not and why; we may also offer them an opportunity to ask a question anonymously.If schools have opted for this (please see optional extras below) we will send the school written responses to questions and a transcript of pupils’ feedback as evidence of impact. Cost: CSIE price: £800+vat plus expenses Optional extras: a) written responses to pupils’ anonymous questions (£50+vat) b) transcript of pupils’ feedback, as evidence of impact (£50+vat)

This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects.

Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.

Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.

Overview This one day course is designed for anyone that deals with telephone sales in either an inbound or outbound call environment. Description The telephone has become a critical tool in obtaining sales in today’s competitive market, and yet it is often an area we pay little attention to, and consequently it becomes a negative aspect of our business rather than the highly positive one it can be. This course sets out to enable the attendees to sell effectively over the phone. The tools that are covered will help generate sales and whether they take inbound or receive outbound calls they will find that if they apply the techniques in this session, their success rate will increase immensely. Topics covered: Advantages and Disadvantages – A look at how the phone can work for and against us in a sales environment. An Introduction to Selling on the Telephone – Understanding the key points that encourage a customer to purchase from us. Structuring and the Sales Process – Defining a set process for structuring a sales call with a chance to demonstrate understanding. Why People Buy – A look at the reasoning behind people’s purchasing decisions. How People Buy – An insight into the emotional factors behind how people arrive at purchasing decisions. Turning Inbound Calls into Sales – Gauging the level of interest of a caller in order to establish the likelihood of a sale. Making Effective Outbound Calls – A set process of ensuring you gain the best advantage with this type of call. Getting Past the Gatekeeper – Understanding the role of the gatekeeper and developing methods of dealing with them in order to speak to the decision maker. Using scripts and techniques that are proven and effective. Sounds Interesting? – Studying three key communication factors when projecting the voice over the phone. Including a chance to review how the participant’s voice comes across over the phone. Methods of Improving the Way You Sound – 10 key tips on vocal improvement. Telephone Questioning Techniques – Giving the delegates the chance to fully understand the different questioning techniques that can be used during a sales call. Features and Benefits – How to practically apply them in a sales scenario. Logical and Emotional Purchasing – A further look at the reasons we buy. Overcoming Objections – Practical use of a set process and ways to apply it in the workplace. Closing the Sale – Clear methodology with a chance to practice the skills in a fun way. Post-course Assignment – A method of carrying the learning into the workplace and ensure continual review. Who should attend the course? Anyone who handles inbound or outbound sales calls over the telephone. Requirements for Attendance No prerequisites required.

Leading People through Change: In-House Training Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications

Embark on a journey to become a workplace hero with our comprehensive one-day First Aid course. This dynamic and engaging training program is designed to equip you with the essential skills and knowledge needed to handle emergency situations confidently and effectively.

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling- Locator Operator