2345 Courses delivered Online

Description: Society is comprised of everyone, including children and the elderly. These two groups of people require a lot care

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

Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: Appreciate the role and importance of Finance within organisations Be able to recognise and describe some of the common items and jargon used Identify the elements of the Profit & Loss and the Balance Sheet Understand cashflow Make better decisions Manage budgets 1 Introduction Expectations Terminology Key financial principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/S format Cashflow Statement Financial and management information systems 3 Budgets and forecasts Why budget? Types of budget - incremental or zero-based Budgeting for costs - fixed and variable Budgeting for income An eight point plan for budgeting for your department Case study: Small Brother Ltd Problems and solutions 4 Accruals Accruals - what and why? Prepayments 5 Open forum

Course Overview: The global automotive industry is booming, and with technological advancements, the demand for skilled car mechanics has never been higher. This Car Mechanic and Repair Training Diploma caters to the needs of professionals and enthusiasts, offering comprehensive knowledge on safety, maintenance, and advanced automotive systems. Our meticulously designed curriculum covers various topics, from the essential introduction to safety and maintenance in Module 01, restoring engines in Module 14, to more advanced topics in Module 21, Maintenance of Work Equipment. The course's structure ensures an in-depth understanding of each segment of car mechanics, essential for mastering the art of automobile repair and maintenance.Enrol in the Car Mechanic and Repair Training Diploma today and drive your career to new heights! Key Features of the Course: CPD certificate upon successful completion. Access to 24/7 learning assistance for continuous support. Who is This Course For? This Car Mechanic and Repair Training Diploma is perfect for individuals who aspire to pursue a career as a car mechanic, automobile enthusiasts looking to gain in-depth knowledge, or existing mechanics aiming to upgrade their skills and stay ahead in the competitive automotive industry. What You Will Learn: In our Car Mechanic and Repair Training Diploma, you will gain a wealth of knowledge and practical expertise through our engaging modules. From safety protocols and general maintenance techniques to understanding vehicle warning lights and mastering brake maintenance, this course covers all the essential aspects of car mechanics.You'll explore the intricacies of the engine, cooling system, fuel system, electrical system, and drivetrain, gaining in-depth insights into their functioning and maintenance. Additionally, you'll learn the step-by-step process of car restoration, including the interior, exterior, and engine.With modules focusing on workplace safety and equipment regulations, you'll also develop a comprehensive understanding of maintaining a safe and efficient working environment. Why Enrol in This Course: Enrolling in our Car Mechanic and Repair Training Diploma gives you access to a top-reviewed course that stays updated with the latest industry trends. With practical expertise and a comprehensive skill set, you'll be ready to take on the challenges of the automotive industry head-on. Additionally, the CPD certificate you receive upon completion will be a valuable credential, showcasing your dedication and expertise to potential employers or clients. Requirements: No prior experience or qualifications are necessary to join this course. All you need is a passion for cars and the desire to learn. Career Path: Completing this Car Mechanic and Repair Training Diploma course is helpful for numerous exciting career opportunities in the automotive industry. Some potential professions and their corresponding average UK salaries include: Automotive Technician - £25,000 per annum Garage Mechanic - £28,000 per annum Service Advisor - £22,000 per annum Parts Advisor - £20,000 per annum Vehicle Diagnostic Technician - £30,000 per annum Workshop Supervisor - £35,000 per annum Automotive Electrician - £27,000 per annum Certification: Upon completing the Car Mechanic and Repair Training Diploma, you will receive a CPD certificate, internationally recognised and highly regarded in the automotive industry. Course Curriculum 1 sections • 21 lectures • 11:21:00 total length •Module 01: Introduction to Safety and Maintenance: 00:12:00 •Module 02: General Maintenance for Car Mechanics: 00:38:00 •Module 03: Vehicle Warning Lights: 00:31:00 •Module 04: Tyres and Wheels: 00:40:00 •Module 05: The Engine: 00:36:00 •Module 06: The Cooling System: 00:29:00 •Module 07: The Fuel System: 00:30:00 •Module 08: The Electrical System: 00:31:00 •Module 09: The Drivetrain: 00:33:00 •Module 10: The Braking System: 00:29:00 •Module 11: Car Restoration Plan: 00:49:00 •Module 12: Restoring the Car's Interior: 00:30:00 •Module 13: Restoring the Car's Exterior: 00:34:00 •Module 14: Restoring the Engine: 00:31:00 •Module 15: Reassemble & Test Drive: 00:30:00 •Module 16: Hearing Conservation at Workplace: 00:47:00 •Module 17: Provision and Use of Work Equipment Regulations: 00:48:00 •Module 18: Selection and Conformity of Work Equipment: 00:25:00 •Module 19: Safe Functionality of Work Equipment: 00:36:00 •Module 20: Monitoring and Evaluation of Work Equipment: 00:28:00 •Module 21: Maintenance of Work Equipment: 00:14:00

Gain essential training skills and earn a CPD Certified Diploma with our Train the Trainer course. Learn effective communication, engagement techniques, and how to establish credibility with your audience. Perfect for aspiring trainers or professionals looking to enhance their training abilities. Enrol now for expert guidance and a recognised certification.

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.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special 3D Printing 101 for Absolute Beginners Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The 3D Printing 101 for Absolute Beginners Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This 3D Printing 101 for Absolute Beginners Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This 3D Printing 101 for Absolute Beginners Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this 3D Printing 101 for Absolute Beginners ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the 3D Printing 101 for Absolute Beginners there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This 3D Printing 101 for Absolute Beginners course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This 3D Printing 101 for Absolute Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning. This 3D Printing 101 for Absolute Beginners was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This 3D Printing 101 for Absolute Beginners is a great way for you to gain multiple skills from the comfort of your home. Intro & Motivation Chapter 01: Intro: What do you learn in this course and what equipment do you need? 00:03:00 Chapter 02: Motivation: Awesome 3D printing examples 00:04:00 3D Printing Basics (Hardware) Chapter 03: How does a 3D Printer work? & 3D Printer Components 00:03:00 Chapter 04: 3D printer purchase advice (incl. accessories) 00:06:00 Chapter 05: Setting up a 3D printer (incl. leveling of the printing bed) 00:02:00 Chapter 06: First 3D printing job with the CR-10 3D printer 00:02:00 3D Printing Software Chapter 07: Overview on file formats & slicing software 00:04:00 Chapter 08: Editing of '.stl' files with Autodesk Meshmixer (e.g.: carabiner) 00:06:00 Chapter 09: Introduction to the slicing program 'Cura': Creating a '.gcode' (e.g. snap hook) 00:11:00 Chapter 10: Upgrade parts for the 3D printer 00:02:00 Chapter 11: Slicing of the upgrade parts in Cura 00:05:00 Step-by-step slicing and 3D printing of examples Chapter 12: Example 1: Low-poly dog statue 00:06:00 Chapter 13: Example 2: Honeycomb vase 00:04:00 Chapter 14: Example 3: Fill patterns 00:03:00 Chapter 15: Final tips on Slicing 00:01:00 Filaments & Materials Chapter 16: Overview on 3D printing materials 00:04:00 Maintenance and Troubleshooting Chapter 17: General Maintenance 00:03:00 Chapter 18: Troubleshooting for poor 3D printing results 00:06:00 3D Scanning Chapter 19: Introduction to 3D scanning: 3D scanners and a simple scanning method 00:02:00 Chapter 20: Conclusion of the workshop and credits 00:01:00

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

CPD certified, digital study session, 24-hour postural care training, learning new ways to bring excellence to 24-postural care, focussing on supported lying.

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.