5873 Courses in Cardiff delivered Online

Find out how to: Connect to your Authentic Self Find your Blocks Get out of Your Own Way Make the Shift and Move Forward

IASSC lean six sigma yellow belt course. Online, 24/7 access to content and exam. Fee includes learning content, tutor support, and official IASSC exam.

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

Zero Java programming experience? No problem. Do you want to take the first steps to becoming a great Java programmer? This beginner-friendly course will teach you each topic and concept of Java programming in detail, which will help you boost your knowledge of Java. It will also give you a deep understanding of the internal working of the Java program.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Do you dream of transforming unforgettable occasions into reality? The UK events industry is booming, expected to reach a staggering £70 billion by 2025! If you have an eye for detail, a knack for organisation, and a love of bringing people together, then a career in event planning could be your perfect match. But where do you begin? This comprehensive Event Planner program equips you with the skills and knowledge to plan and execute exceptional events of all kinds, from weddings and social gatherings to corporate conferences and children's parties. You'll master essential skills like marketing, project management, and client communication. Specialised courses cover in-demand areas like wedding planning, party planning, and social event coordination. Additionally, you'll gain valuable insights into hospitality, catering, and compliance, ensuring you're prepared for any situation. With a single payment, you will gain access to Event Planner course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Event Planner Bundle Package includes: Main Course: Diploma in Event Planner at QLS Level 5 10 Additional CPDQS Accredited Premium Courses - Course 01: Event Planning Course 02: Kids Party Planner Certificate Course 03: Party and Event Planning Course 04: Wedding Planner Course 05: Social Events Planning Diploma Course 06: Catering Management Course 07: Hotel Concierge Certification Course 08: Restaurant Management Course 09: Receptionist Diploma Course 10: Hospitality Compliance Management Course Elevate your skills and open doors to exciting opportunities in the event industry. Enrol today and become a sought-after event planner! Learning Outcomes of Event Planner Bundle Master advanced event management principles and industry best practices. Develop expertise in planning diverse events, from parties to weddings. Acquire skills in creating enchanting experiences for children's events. Understand catering management and menu planning for exceptional dining experiences. Explore hotel concierge services and restaurant management for seamless hospitality. Gain knowledge of hospitality compliance standards for professional event execution. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Event Planner course Get a free student ID card with Event Planner Training program (£10 postal charge will be applicable for international delivery) The Event Planner course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Event Planner course materials The Event Planner course comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course: Diploma in Event Planner at QLS Level 5 Module 01: Introduction To Event Management Module 02: Role Of An Event Planner Module 03: Event Classification Module 04: Events And Clients Module 05: Steps To Plan An Event Module 06: Invitation To The Event Module 07: Event Marketing Module 08: Catering At Events Module 09: Event Decorations Module 10: Cleaning And Waste Disposal Module 11: Event Security Module 12: Developing An Event Planning Business Course 01: Event Planning Module 01: Introduction To Event Management Module 02: Role Of An Event Planner Module 03: Event Classification Module 04: Events And Clients Module 05: Steps To Plan An Event Module 06: Invitation To The Event Module 07: Event Marketing Module 08: Catering At Events Module 09: Event Decorations Module 10: Cleaning And Waste Disposal Module 11: Event Security Module 12: Developing An Event Planning Business Course 02: Kids Party Planner Certificate Module 01: Planning a Kids' Party Module 02: Improvement Module 03: Types of Kids' Parties Module 04: Management Review Meetings Module 05: Choosing a Theme Module 06: Planning the Entertainment Module 07: Focusing on Catering Module 08: Making the Day Memorable =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring planners Event coordinators Venue managers Party planners Hospitality professionals Business owners Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Event planner Wedding planner Conference organizer Party planner Venue manager Entrepreneur Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Event Planner at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Course Description The Hospitality Management: Part 1 course is designed to give you a deeper understanding of different aspects of hospitality management. In this course, you will learn the importance of hospitality management and how, as a manager, you can deliver the best quality hospitality to your customers. In addition, you will gain a greater understanding of the hotel industry. This Hospitality Management: Part 1 course will help you explore the ideal recruitment procedure. You will also learn about the different steps you need to take to develop a training program. If all these sound good, what are you waiting for? Enrol today and start learning! Learning outcome  Learn the importance of hospitality management Gain a greater understanding of the hotel industry Explore the ideal recruitment procedure Understand the different steps you need to take to develop a training program How Much Do Restaurant Managers Earn? Senior - £32,000(Appx.) Average - £29,000(Appx.) Starting - £26,000(Appx.) Requirement Our Hospitality Management: Part 1 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. Hospitality Management: Part 1 Module 01: Introduction to Hospitality Management 00:21:00 Module 02: An Overview of Hotel Industry 00:15:00 Module 03: The Process of Selection and Recruitment in Hospitality Industry 00:18:00 Module 04: The Process of Development and Training in Hospitality Industry 00:21:00 Assignment Assignment - Hospitality Management: Part 1 00:00:00

In the business world, challenges related to discrimination and understanding diversity and inclusion are pervasive. Common problems include biases, prejudices, and a lack of awareness about the importance of fostering a diverse and inclusive workplace. Discrimination can manifest in various forms, from unequal opportunities to exclusion and stereotypes. By understanding the impact of discrimination and learning to foster a more inclusive environment, individuals can contribute to a healthier workplace and a stronger, more harmonious business culture. Learning Objectives The following are some of the key outcomes in this course: Defining respect and illustrating what it looks like Benefits of a respectful workplace and unpack some basic steps for building one Understand what harassment and discrimination are and explore some examples of each behavior type Practical actions you can take to help those who are targeted by sexual harassment Target Audience Human Resources Professionals. Managers, Team Leaders, Young Professionals

The Negative Thought Pattern Interrupt does exactly what it says Course curriculum 1 Welcome to the course What is the Negative Thought Pattern Interrupt? About the Course Creator How to Navigate this course 2 1. Why Is this Technique So Useful Lesson 1.1: Outcomes and Their Effect Lesson 1.2: Cause and Effect Lesson 1.3: The Mind-Body Connection Lesson 1.4: Neurological Connections 3 2. How We Process Information and Communicate Lesson 2.1: A Communication Model Lesson 2.3: Behavioural Profiling Aide Memoire Lesson 2.3: How the Limbic System Affects Memory Lesson 2.4: Memory Graphics - Downloads Lesson 2.5: Influences on Your State of Mind Lesson 2.6: Emotional Response vs Decisions Lesson 2.7: The Behavioural Change Learning Cycle Behavioural Change Learning Cycle - Video Explanation Behavioural Change Learning Cycle PDF 4 3. Negative Thought Pattern Interrupt Lesson 3.1: Negative Thought Pattern Interrupt - What Is It? Lesson 3.2: NTPI - The Process Overview Lesson 3.3: NTPI - The Process in Detail Lesson 3.4: NTPI - Live Video Demo with Client Lesson 3.5: Assignment - Download the PDF and answer the questions on the video demo 5 Next Steps... More resources for you A few Feedback Questions Before you go...

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Nail Technician Diploma CPD Accredited is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Nail Technician Diploma CPD Accredited for? This Nail Technician Diploma CPD Accredited is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Nail Technician Diploma CPD Accredited ? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result The UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for 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. However, you can 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 £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Nail Technician - Updated Version Module 01: Nail Technician 101 Nail Technician 101 00:43:00 Module 02: General Anatomy General Anatomy 00:32:00 Module 03: Skin Structure, Growth, And Nutrition Skin Structure, Growth, And Nutrition 00:27:00 Module 04: Anatomy Of Nail Anatomy Of Nail 00:44:00 Module 05: Equipment For The Technician Equipment For The Technician 00:35:00 Module 06: Tools And Techniques Tools And Techniques 00:30:00 Module 07: Basics Of Chemistry And Chemicals Basics Of Chemistry And Chemicals 00:27:00 Module 08: Nail Product Chemistry Nail Product Chemistry 00:35:00 Module 09: Manicure Manicure 00:43:00 Module 10: Pedicure Pedicure 00:46:00 Module 11: Nail Diseases And Skin Problems Nail Diseases And Skin Problems 00:32:00 Module 12: Artificial Nails Artificial Nails 00:40:00 Module 13: Nail Art Nail Art 00:42:00 Module 14: Safety Practices Safety Practices 00:28:00 Module 15: Career Prospect And Business Preparations Career Prospect And Business Preparations 00:31:00 Module 16: UK Legislations And Pandemic Implications UK Legislations And Pandemic Implications 00:27:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Amp up your project management skills to meet your project requirements and shape your organisation's success. Project managers are responsible for the successful planning and execution of projects. This Online Cupcake and Baking Diploma is designed to help you learn the proven project management skills and techniques to manage projects from beginning to end. The course will give you clear ideas on project management basics, different project types, and the techniques applied to project activities for successful project completion. During the course, you'll gain insights into project management steps, such as project initiation, execution, monitoring, and closing. On top of that, you'll explore the steps involved in project team building and acquire knowledge of earned value management to measure project performance. Learning Outcomes Discover the crucial steps to project success Familiarise yourself with different types of projects Identify the steps involved in project initiation, execution, monitoring and closing Understand what makes a successful project management team Learn about Earned Value Management (EVM) for project performance measurement Determine what is a change control process in project management Who is the Online Cupcake and Baking Diploma for? This Online Cupcake and Baking Diploma is perfect for aspiring professionals in the relevant industry, such as people with careers in: Project Manager Project Executive Project Administrator Project Co-ordinator Project Lead It will deepen their knowledge and help them establish the fundamental skills for project management. Why Choose this Diploma in Online Cupcake and Baking Diploma ? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result The UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for 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. However, you can 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 £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Module 01: Basic Concepts of Baking Basic Concepts of Baking 00:16:00 Module 02: Basic Ingredients of Baking Basic Ingredients of Baking 00:28:00 Module 03: Glossary and Equipment Used in Baking Glossary and Equipment Used in Baking 00:34:00 Module 04: Types of Cakes Types of Cakes 00:14:00 Module 05: Baking the Cake Baking the Cake 00:20:00 Module 06: Baking Principles Baking Principles 00:25:00 Module 07: Cake Decorating Recipes Cake Decorating Recipes 00:26:00 Module 08: Cake Decorating Ideas Cake Decorating Ideas 00:21:00 Module 09: Frosting and Icing Frosting and Icing 00:24:00 Module 10: Working with Different Pastes Working with Different Pastes 00:20:00 Module 11: Working with Glazes Working with Glazes 00:28:00 Module 12: How to Stack a Cake How to Stack a Cake 00:21:00 Module 13: Piping and Writing Piping and Writing 00:24:00 Module 14: Health, Safety and Food Hygiene Health, Safety and Food Hygiene 00:20:00 Module 15: Troubleshooting Troubleshooting 00:20:00 Module 16: Cake Decorating Business Cake Decorating Business 00:19:00 Assignment Assignment - Online Cupcake and Baking Diploma 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00