3780 Courses

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

In this workshop, you will learn how to create two unique pieces of art – a turtle and a crab – using the vibrant and Chameleon water colours by Marilyn Allis. These paints are not only fun to use but also bring a and exciting element to your artwork. You may be new to using these water colours, but fear not! Marilyn Allis products are designed to make the creative enjoyable and accessible for all levels of artists. So, whether you're a beginner or more experienced, you'll guided through the steps to create beautiful and whimsical pieces. Throughout the workshop, you will be working with the Chameleon water colours to bring your turtle and crab to life on paper. The unique nature of these paints allows for seamless blending and layering, giving your artwork a dynamic and eye-catching finish. You'll enjoy experimenting with the colours and techniques, and maybe even surprise yourself with the results. By the end of the workshop, you'll not only have two stunning pieces of artwork to take home but also a newfound confidence in working with Chameleon water colours. So get your box and immerse yourself in a creative and rewarding activity that will leave you inspired and eager to explore more artistic possibilities.

Make this beautiful berry collecting basket with a smooth tactile wrapped handle, just in time for collecting blackberries. During the day you will learn about how the willow is grow, harvested and processed. You will learn several key weaving techniques and choose from a selection of natural willow colours. Refreshments provided please bring your own lunch. 

The Sales Accelerator programme is a fresh approach to improving business development productivity. It focuses on identifying and using a series of business productivity metrics in order to build a clear action plan for improving sales results - typically within 90 days. The metrics are grouped under three headings: The basic principle is that a small improvement in each area can lead to a significant increase in sales results and productivity. And the object of the programme is to show how best to achieve that. The programme therefore looks at each of these three areas in turn, spending a day on each. Suitable for any and all businesses and all levels of experience and expertise, this is a remarkably practical and hands-on programme. During the workshop, participants discuss, review and apply many proven sales and marketing techniques and personal selling ideas. The goal is to generate and commit to changes and actions that can lead to a 10-30% increase in the next three to six months. There's also a consultancy option, rather than the workshop-based programme. See below for details. Day one - Activity Key objective This first module introduces the Sales Accelerator model. The goal here is to show participants how to increase their pro-active activity levels by around 10%. It covers all aspects of creating new business opportunities, from existing customers and non-customers alike, and is linked to personal activity improvement goals. Main elements Improve the productivity, accuracy and effectiveness of your business approach by using new and unique models and techniques. Different methods of creating and generating new business opportunities in the short, medium and long term. This includes sourcing new business, up-selling, cross-selling, warm calling and gaining referrals. Using organised persistence to track and build new customer revenue. Managing your sales time effectively. Key learning points Sales productivity - understand the dynamics of increasing the combination of activity levels, deal value and conversion rate of proposals/quotations to orders and implement an improvement plan. Sales goal setting: setting business development objectives for quantity and quality - plus tips and tricks of top performers. Maintain a peak activity level, on a consistent basis using 'organised persistence' and structured business development tracking methodology. How to prioritise opportunities and manage your time when sourcing new business. Identify potential new customers - and particularly the decision-makers and influencers - with greater accuracy. Make outbound business or appointment calls with improved confidence, control and results. Day two - Value Key objective To be able to better anticipate, identify, create, and develop business opportunities using a customer / client-focused communication-based business model and consultative skills. Main elements How to develop sales more effectively from new and existing customers; and managing the first appointment with a new customer. Use structured and assertive drawing-out skills to identify, develop and formalise business opportunities and to gain commitment. How to better position your company and your products and services against your main competitors. Create and deliver persuasive business messages based on specific need areas, criteria and value. Key learning points Advanced consultative selling - use a variety of structured and advanced questioning techniques to confidently and efficiently uncover opportunities, need areas and business criteria - confidently and efficiently. Involve the customer/client at all times, and to a far greater degree, and keep better control of business development process. Value message - differentiate your solutions clearly and accurately with customer/client-matched value statements. Presenting the right USPs, features and benefits and making them relevant and real to the customer. Qualification and reading buying signals. Day three (held around four weeks after the first module) - Conversion Key objective This module looks at how to improve the final qualification, progression and conversion of opportunities in your sales pipeline. Also includes price negotiation, overcoming objections and obstacles to gaining agreement. The module begins with a learning review, sharing participants' experiences over the last four weeks in applying the new techniques and skills acquired during the first two modules. This is an opportunity to revisit particularly challenging areas as well as to share and celebrate successes. Main elements Structuring and preparing for negotiating a deal and knowing when and how to move into the 'end-game' mode. Anticipate and answer customer objections and questions more confidently. Build more credibility and proof into your business process to reduce 'buyer's remorse' and speed-up decision-making. Being more assertive and developing better instincts and strategic thinking in progressing quotations and proposals. Key learning points Smart ways to position price, emphasise value and be a strong player without being the cheapest. Becoming more assertive in closing deals, and the importance of organised follow-up on the telephone. Qualify pipeline opportunities with more accuracy, using a proven check-list. Use an 'option generator' to simplify complex proposals, increase business value and close business faster. Writing more effective sales proposal documents and quotations. How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns. Practical methods of asking for agreement and closing a sale

Understand the needs and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks. Course overview Duration: 2 day (13 hours) Our Project Risk Management course addresses risk management throughout the project lifecycle. This course is designed for project staff, including project leaders, sponsors, project team members, support staff and functional staff involved in project activity. The workshop is especially suited to teams working on bids, feasibility and project start up. The workshop covers the need and benefits arising from a structured project risk management approach, the process and supporting methods for identifying analysing and responding to risks, human behavioural factors affecting risk management performance, and organisational interfaces and governance requirements. Objectives  By the end of the course you will be able to: Describe success factors and benefits arising from effective risk management Explain human behaviour factors affecting risk management Establish the project context and conduct an initial risk assessment Define an appropriate strategy and produce a risk management plan Define risk identification strategies and apply appropriate identification methods Identify and record important risk information including ownership Establish risk probability and impact levels; produce probability impact charts and severity time charts Establish exposure levels and contingency requirements Explain the principles of quantitative analysis Define and evaluate response options Implement effective risk management process control Content Principles of risk management Terminology Purpose Success factors Benefits and overall process Human factors that impact on risk management Initiate Analyse and determine context factors relevant to risk management Develop a robust risk management strategy for the life of the project How to conduct an initial risk assessment and define an outline strategy Identification Development of a risk identification strategy Appropriate methods and their strengths and weaknesse Determine an appropriate strategy and identify risks in a given case study Animating text Slide titles Bullet points Applying animation to Slide Master Assessment Methods commonly used for assessing and prioritising risks Evaluating exposure and contingency requirement Demonstration of quantitative methods and exercises to assess risks and contingency levels Planning and implementing responses Appropriate methods for responding to risks Defining implementation and control plans Assigning ownership Defining appropriate plans Conducting net benefits analysis and examining effectiveness Manage process Organisational interfaces and specific requirements to ensure appropriate controls Improvements and compliance with governance requirements

Duration 5 Days 30 CPD hours The Implementing Cisco Application Centric Infrastructure (DCACI) v1.1 course shows you how to deploy and manage the Cisco© Nexus© 9000 Series Switches in Cisco Application Centric Infrastructure (Cisco ACI©) mode. You will learn how to configure and manage Cisco Nexus 9000 Series Switches in ACI mode, how to connect the Cisco ACI fabric to external networks and services, and the fundamentals of Virtual Machine Manager (VMM) integration. You will gain hands-on practice implementing key capabilities such as fabric discovery, policies, connectivity, VMM integration, and more. This course earns you 40 Continuing Education (CE) credits towards recertification. Additional course details: Nexus Humans Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Implementing Cisco Application Centric Infrastructure - Advanced v1.2 (DCACIA) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Motivations: Use and manage containers from first principles & architect basic applications for Kubernetes Roles: general technical audiences & IT professionals CN251 is an intensive cloud native training bootcamp for IT professionals looking to develop skills in deploying and administering containerized applications in Kubernetes. Over the course of five days, students will start with learning about first principles for application containerization followed by learning how to stand up a containerized application in Kubernetes, and, finally, ramping up the skills for day-1 operating tasks for managing a Kubernetes production environment. CN251 is an ideal course for those who need to accelerate the development of their IT skills for a rapidly-changing technology landscape. Additional course details: Nexus Humans Cloud Native Operations Bootcamp training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cloud Native Operations Bootcamp course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. Course Outline The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: Fundamentals of data visualisation Data characteristics & dimensions Mapping visual encodings to data dimensions Colour theory Graphical perception & communication Interaction design Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text Designing effective dashboards

Duration 5 Days 30 CPD hours This advanced course teaches the design principles for creating a Citrix Virtual Apps and Desktops virtualization solution. In this training, you will also learn how to assess existing environments, explore different scenarios, and make design decisions based on business requirements. This course covers the Citrix Consulting approach to design and covers the key design decisions through lectures, lab exercises, and interactive discussions. You will also learn about additional considerations and advanced configurations for multi-location solutions and disaster recovery planning. This training will help you prepare for the Citrix Certified Expert in Virtualization (CCE-V) exam. Additional course details: Nexus Humans CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CWS-415 Citrix Virtual Apps and Desktops 7 Assessment, Design and Advanced Configuration course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

🔧 Unlock the Power of Safety: Hand & Power Tool Safety Training Course! 🔨 Are you ready to revolutionize the way you handle hand and power tools? Welcome to the ultimate safety training experience designed to empower you with the knowledge and skills needed to work confidently and safely with a wide range of tools. Whether you're a seasoned professional or just starting your journey in the workshop, our comprehensive course is your key to unlocking a world of safety and efficiency.   ️ Why Hand & Power Tool Safety Matters In the fast-paced world of construction, manufacturing, and DIY projects, hand and power tools are indispensable assets. However, without proper safety training, these tools can pose significant risks to users, leading to accidents, injuries, and even fatalities. By investing in hand and power tool safety training, you're not just protecting yourself - you're safeguarding your colleagues, your projects, and your future.   🛠️ Benefits of Taking Our Course ✅ Enhanced Safety: Learn essential safety practices and protocols to prevent accidents and injuries while using hand and power tools. ✅ Increased Efficiency: Master efficient techniques for using tools safely and effectively, boosting productivity and minimizing downtime. ✅ Confidence Building: Gain the confidence to tackle any task with the assurance that you have the skills and knowledge to handle tools safely. ✅ Industry Recognition: Earn a certification that demonstrates your commitment to safety and professionalism, enhancing your credibility in the workplace. ✅ Peace of Mind: Enjoy peace of mind knowing that you have the skills and know-how to protect yourself and others from potential hazards.   🔍 Who is this for? 👷‍️ Construction Workers: Whether you're working on a skyscraper or a residential home, safety should always be your top priority. Our course equips construction workers with the essential skills to navigate the hazards of the job site safely. 🛠️ Maintenance Technicians: From repairing machinery to performing routine maintenance tasks, maintenance technicians rely on hand and power tools every day. Our course ensures they have the knowledge and skills to do their job safely. 👨‍🔧 DIY Enthusiasts: Even DIY projects around the house can pose risks if proper safety precautions aren't followed. Our course is perfect for DIY enthusiasts looking to protect themselves and their loved ones while tackling home improvement projects.   🚀 Career Path 🔩 Construction Industry: In the construction industry, safety is paramount. By completing our Hand & Power Tool Safety Training Course, you'll position yourself as a safety-conscious professional, opening doors to new opportunities and advancement. 🔧 Manufacturing Sector: Manufacturing facilities rely on skilled workers who prioritize safety. With our certification in hand, you'll stand out as a safety-conscious candidate in the competitive manufacturing sector. 🛠️ Maintenance and Repair: From automotive repair shops to industrial maintenance departments, safety is a top priority. Our course equips maintenance technicians with the safety skills needed to excel in their field and advance their careers.   🔍 FAQs ❓ Q: Is this course suitable for beginners? A: Absolutely! Our course is designed to cater to individuals of all skill levels, from beginners to seasoned professionals. We start with the basics and gradually progress to more advanced topics, ensuring that everyone can benefit from the training. ❓ Q: How long does the course take to complete? A: The duration of the course may vary depending on your pace and schedule. On average, most students complete the course within a few weeks, but you're free to progress at your own pace and revisit modules as needed. ❓ Q: Is the certification recognized in the industry? A: Yes, our certification is widely recognized in the industry and demonstrates your commitment to safety and professionalism. Many employers value candidates who have completed accredited safety training courses like ours. ❓ Q: Are there any prerequisites for enrolling in the course? A: There are no specific prerequisites for enrolling in the course. However, a basic understanding of hand and power tools and a willingness to prioritize safety are beneficial. ❓ Q: How can I access the course materials? A: Once you enroll in the course, you'll gain access to our online learning platform, where you'll find all the course materials, including videos, tutorials, quizzes, and downloadable resources. You can access the platform anytime, anywhere, using a computer or mobile device with internet access.   🌐 Don't Leave Safety to Chance - Enroll Today! Don't take chances with your safety or the safety of those around you. Invest in your future by enrolling in our Hand & Power Tool Safety Training Course today and unlock a world of safety, efficiency, and professionalism. Your tools are your allies - let us help you harness their power safely! 🔒🔧✨ Course Curriculum Module 1 Introduction to Hand and Power Tool Safety Introduction to Hand and Power Tool Safety 00:00 Module 2 Hand Tool Safety Hand Tool Safety 00:00 Module 3 Power Tool Safety Power Tool Safety 00:00 Module 4 Pneumatic Tool Safety Pneumatic Tool Safety 00:00 Module 5 Electrical Tool Safety Electrical Tool Safety 00:00 Module 6 Personal Protective Equipment (PPE) Personal Protective Equipment (PPE) 00:00