36297 Courses in Cardiff delivered Online

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 from our growing corporate clients 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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

Description: Workplace management provides insight into the features, resources, services, and processes that are necessary to create the best environment for employees of a company. Creating the best working environment will help your employees to become healthy and productive. You can provide this by learning how to manage civility, harassment, and violence in your workplace. It will also be helpful if you learn the dynamics on team networking to build strong working relationships among workers. Luckily, this advanced course in workplace management will be able to provide all of these. Who is the course for? Business professionals who want to create an ideal workplace environment Employees who want to learn about professional networking. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Workplace Management course is a useful qualification to possess, and would be beneficial for the following careers: Businessman Department Chief or Head Manager Network Adviser Supervisor Team Leader. Managing Health and Wellness in Workplace Module One - Getting Started 00:30:00 Module Two - Definition of a Health and Wellness Program 00:30:00 Module Three - Types of Health and Wellness Programs 00:30:00 Module Four - Health Behavior Programs 01:00:00 Module Five - Health Screenings and Maintenance Programs 00:30:00 Module Six - Mental Health Programs 01:00:00 Module Seven - Evaluate the Need 01:00:00 Module Eight - Planning Process 01:00:00 Module Nine - Implementation 01:00:00 Module Ten - Create a Culture of Wellness 01:00:00 Module Eleven - Evaluate Results 00:30:00 Module Twelve - Wrapping Up 00:30:00 Level 2 Certificate In Health and Wellness at Workplace- Activities 00:00:00 Team Networking Module One - Getting Started 01:00:00 Module Two - The Benefits of Networking at Work 00:15:00 Module Three - Networking Obstacles 00:30:00 Module Four - Networking Principles 01:00:00 Module Five - How to Build Networks 00:30:00 Module Six - Recognize Networking Opportunities 00:30:00 Module Seven - Common Networking Mistakes 01:00:00 Module Eight - Develop Interpersonal Relationships 01:00:00 Module Nine - Online Networking Tools 01:00:00 Module Ten - Time Management 00:30:00 Module Eleven - Maintaining Relationships Over Time 00:30:00 Module Twelve - Wrapping Up 01:00:00 Workplace Team Networking Diploma- Activities 00:00:00 Managing Civility Module One - Getting Started 00:30:00 Module Two - Introduction 01:00:00 Module Three - Effective Work Etiquette 01:00:00 Module Four - Costs and Rewards 01:00:00 Module Five - Conflict Resolution 00:30:00 Module Six - Getting to the Cause 01:00:00 Module Seven - Communication 01:00:00 Module Eight - Negotiation 00:30:00 Module Nine - Identifying Your Need 01:00:00 Module Ten - Writing a Civility Policy 01:00:00 Module Eleven - Implementing the Policy 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities 00:00:00 Managing Harassment Module One - Getting Started 01:00:00 Module Two - The Background 01:00:00 Module Three - Developing an Anti-Harassment Policy 01:00:00 Module Four - Policies in the Workplace 01:00:00 Module Five - Proper Procedures in the Workplace 01:00:00 Module Six - False Allegations 01:00:00 Module Seven - Other Options 00:30:00 Module Eight - Sexual Harassment 01:00:00 Module Nine - Mediation 01:00:00 Module Ten - Conflict Resolution 00:30:00 Module Eleven - The Aftermath 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities 00:00:00 Managing Violence Module One - Getting Started 00:30:00 Module Two - What Is Workplace Harassment 01:00:00 Module Three - Identifying the Bully 00:30:00 Module Four - How to Handle Workplace Violence 01:00:00 Module Five - Risk Assessment (I) 00:30:00 Module Six - Risk Assessment (II) 00:30:00 Module Seven - Being the Victim 02:00:00 Module Eight - Checklist for Employers 00:30:00 Module Nine - Interview Process 01:00:00 Module Ten - Investigation Process 00:30:00 Module Eleven - Developing a Workplace Harassment Policy 02:00:00 Module Twelve - Wrapping Up 00:30:00 Activities 00:00:00 Workplace Ergonomics: Injury Prevention Getting Started 00:30:00 The Role of Ergonomics in Your Workplace 00:15:00 The Ergonomic Assessment Cycle 00:05:00 Identifying and Assessing Ergonomic Hazards 00:30:00 Developing a Plan to Address Ergonomic Issues 00:15:00 Identifying and Implementing Solutions 00:15:00 Obtaining Employee Buy-In 00:15:00 Tips for Successful Implementation 00:15:00 Reviewing Your Ergonomics Program 00:15:00 Basic Ergonomic Principles 00:15:00 Optimal Sitting and Standing 00:15:00 Safe Lifting and Transporting 00:15:00 Ergonomic Workstations 00:15:00 Safe Tool Selection and Use 00:15:00 Creating an Ergonomic Environment 00:30:00 Mock Exam Mock Exam- Advanced Diploma in Workplace Management 00:30:00 Final Exam Final Exam- Advanced Diploma in Workplace Management 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Accelerate Your Software Developer Career: Fast-Track Program with Exams, TOTUM Card & 5-Year Support. Enrol Today! Study methodOnline Duration9 months · Self-paced Access to content5 years CertificationsCompTIA IT Fundamentals CertificationPearson IT Specialist Software DeveloperPearson IT Specialist HTML5 Application DevelopmentPearson IT Specialist HTML and CSSPearson IT Specialist JavaPearson IT Specialist PythonPearson IT Specialist AI (Artificial Intelligence) Additional info Exam(s) / assessment(s) is included in price Tutor is available to students TOTUM card included in price Job guarantee programme is included in this course Overview Learn the most in-demand digital skills in the world today with the Nuyew Tech Academy Demand for software developers is at an all-time high worldwide. Digital transformation affects every industry and developers are required to support the change. Global shortages of coders mean that those skilled in this area command excellent salaries and have limitless opportunities around the world. Certifications CompTIA IT Fundamentals Certification Awarded by CompTIA Pearson IT Specialist Software Developer Pearson IT Specialist HTML5 Application Development Pearson IT Specialist HTML and CSS Pearson IT Specialist Java Pearson IT Specialist Python Pearson IT Specialist AI (Artificial Intelligence) Awarded by Pearson Description With a national shortage of Software Developers, starting salaries of up to £25,000 per annum (average UK Salary £52,500) and amazing future employed and self-employed career prospects, take the next step today with our Fast Track Software Developer Programme. What you can expect from our Fast Track Programme: World Class Education Energetic and unlimited 24/7 Student Support Real, tangible Career Outcomes 5 Years Career Support and Course Access What our programme includes: Foundation Awards CompTIA ITF+ (IT Fundamentals) Industry Recognised Qualifications Pearson IT Specialist Software Developer Pearson IT Specialist HTML5 Application Development Pearson IT Specialist HTML and CSS Pearson IT Specialist Java Pearson IT Specialist Python Pearson IT Specialist AI (Artificial Intelligence) Exams Includes all Exams and Unlimited Re-Sits 5 Years Career Support Guarantee As part of our unique Support Guarantee, our Career Support Team will assist you with: CV writing Expert careers advice Interview preparation Identifying and applying for the best opportunities in your area As a student in the Nuyew Tech Academy you will also be given exclusive access to our Career Skills Academy which includes advanced courses on Employability, CV Preparation, Interview Skills and Technique and everything else you need to get ready for your new Career. Who is this course for? This course is open to anyone interested in pursuing a Career in Software Development. Our Foundation Level provides the flexibility for us to accommodate students with any level of previous knowledge and experience. Requirements This course is open to all and has no pre-requisites All you need is a passion for technology and a strong desire to succeed. Career path Our programme is designed to enable you to achieve an Entry Level/Helpdesk role during training (£18k-£24K) ensuring that you also have the vital work experience required to enter the Tech Industry at a higher level (Av Salary £52.5K). Our Career Support Guarantee gives you exclusive access to our dedicated Career Support Team and Advanced Career Skills Academy for 5 Years following Graduation.

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

The Practitioner in Emotional Intelligence course explores the concept of emotional intelligence in detail building upon what you know to give you a much deeper understanding. The course covers the experience of the inner world; how attitudes, beliefs, values and preferences drive behavioural responses and how feelings can be regulated with more effectiveness.

Aimed for GP reception staff and HCAs, who work face to face booking patients in or HCAs doing the initial triage/observations. Receptionists and HCAs working in the urgent care setting or walk in centres may also find this beneficial as they also book patients in and monitor the waiting room.

Description: As a manager it is your responsibility to create an environment for everyone that's safe and where they're able to focus on getting their work done. Sometimes it goes tough. In this Workplace Management: Personal Hygiene you will learn all details on this topic. At first, you will get a framework for having those tough conversations. You will also get some guidelines for customizing that framework for your organization. Then you will be introduced with some common conversations, like: body odor, flatulence, poor clothing and hair decisions, and bad breath. So, be prepared for any kind of challenging conversation by taking this course. Learning Outcomes: Recognise the advantages to deal with difficult conversations Narrate the elements for a behaviour rectification conversation Apply the organization's resources to help them handling hygiene issues Getting over obstacles that employees come upon in regard to discussing hygiene problems Make solutions to hygiene issues for example, bad hair days, inappropriate piercings and body art, poor clothing choices, odorous breath, body odours, excessive gas, as well as incontinence Annihilate poor hygiene habits a t the very outset Identify ways to encourage good hygiene in the workplace Locate paths to promote good hygiene at the workplace Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Workplace Management: Personal Hygiene is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Workplace Management: Personal Hygiene is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Modules Course Overview 00:15:00 Let's Talk About It! 00:15:00 Guidelines for Difficult Conversations 00:15:00 Overcoming Objections 00:30:00 Bad Hair Days (And Weeks and Months) 00:15:00 Addressing Piercings and Body Artwork 00:15:00 Helping Employees Dress for Success 00:15:00 Bad Breath 00:15:00 Body Odor 00:15:00 Gastrointestinal Issues 00:15:00 Mock Exam Mock Exam- Workplace Management: Personal Hygiene 00:20:00 Final Exam Final Exam- Workplace Management: Personal Hygiene 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Level 1 Certificate in Motor Vehicle Studies is designed to encourage and enable learners who have an interest in this area of study to acquire knowledge and skills to aid progression to further study or employment.

This Level 3 Diploma in Cyber Security Management and Operations (Fast Track) qualification (Accredited by Qualifi, UK) has been created to develop those learners who are looking to choose, or already have chosen, a career in a business-related sector. It is envisaged that this programme will encourage both academic and professional development so that your learners move forward to realise not just their own potential but also that of organisations across a broad range of sectors. The rationale of the programme is to provide a career path for learners who wish to develop their core capabilities within the cyber security sector. The outcome of this fast track Level 3 Diploma in Cyber Security Management and Operations, which is a recognised UK qualification, is for learners to develop the skills required by organisations globally. This qualification is especially designed for organisational executives and leaders who are tasked with responsibility for cyber security, digital risk management, or the oversight thereof. The Level 3 Diploma in Cyber Security Management and Operations fast track qualifications' primary focus is to prepare administrators and executives to manage and operate generic, nontechnical cyber security activities within a business, third sector or government organisation. This course is particularly suited for learners already in full-time work or those seeking to evolve their careers into cyber and information security fields. The qualification will identify and evaluate practical and lawful ways to safely and securely protect networks, information and assets from cyber-attacks and associated impacts. This fast track Level 3 Diploma in Cyber Security Management and Operations qualification is about 'cyber security' as a holistic discipline. It examines both 'cyber' and 'security' domains which relate to IT security. It is therefore in most parts a non-technical qualification that looks at both cyber-technical and cyber-physical security threats, risks, responses and risk treatments. The Diploma is accredited at Level 3 with a total equivalence of 60 credits. It is envisaged that learners completing this Level 3 programme will progress to Level 4 Diplomas including the Level 4 Diploma in Cyber Security. Key Highlights of this Level 3 Diploma in Cyber Security Management and Operations (Fast Track) qualification are: Program Duration: Fast Track 6 months (Regular 9 months course also available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option Requirements Level 3 Diploma in Cyber Security Management and Operations (Fast Track) This Level 3 Diploma in Cyber Security Management and Operations (Fast Track) (Accredited by Qualifi, UK) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Entry to the qualification will be through centre interview and learners will be expected to hold the following: Qualifications at Level 2 OR A Level 3 qualification in another discipline and want to develop their careers in Cyber Security or Information Technology. Career path Learners after completing this Fast Track course progress to: Diploma in Accounting and Business level -4 and level - 5, BEng (Hons) in Software Engineering, BSc (Hons) in Business Computing and Information Systems, BA (Hons) Business Management, BA (Hons) Tourism and Hospitality Managements, The First Year of Undergraduate study, Directly into employment in an associated profession. Certificates Certificate of Achievement Hard copy certificate - Included Qualifi courses: Once you complete the course, you would be receiving a Physical hard copy of your Diploma along with its Transcript which we would Courier to your address via DHL or Royal Mail without any additional charge

Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Online As the demand for adult social care continues to rise, care workers must have up-to-date knowledge and skills to provide the best care possible for the individuals they work with. If you want to work in adult social care, this comprehensive Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care course will give you an understanding of what it is like to work in the field. You will learn about person-centred care and safe work practices, as well as the significance of safeguarding, equality and diversity, and the duty of care. Why choose this Preparing to Work in Adult Social Care course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Preparing to Work in Adult Social Care Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Preparing to Work in Adult Social Care course. Courses you will get: Course 01: Preparing to Work in Adult Social Care Course 02: Adults Support Worker Course 03: Family Support Worker Course 04: Social Worker: Social Work Diploma [ Note: Free PDF certificate as soon as completing the Preparing to Work in Adult Social Care course] Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Online This Preparing to Work in Adult Social Care course consists of 09 modules. Assessment Method of Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care After completing Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care After completing the Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Online This Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care course is designed for those who want to start a career in social care or current caregivers who want to obtain a professional qualification in the care industry. Requirements Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Online To enrol in this Preparing to Work in Adult Social Care Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Preparing to Work in Adult Social Care Course. Be energetic and self-motivated to complete our Preparing to Work in Adult Social Care Course. Basic computer Skill is required to complete our Preparing to Work in Adult Social Care Course. If you want to enrol in our Preparing to Work in Adult Social Care Course, you must be at least 15 years old. Career path Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care Online After completing this Preparing to Work in Adult Social Care: Preparing to Work in Adult Social Care course, you will be able to advance your career in adult health and social care in a supervised job role.