5773 Courses 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

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.

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

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.

Are you ready to elevate your decision-making skills to new heights? Introducing our comprehensive Critical Thinking & Decision Making Training Course, designed to empower you with the tools and strategies necessary to navigate today's complex challenges with clarity and confidence. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this Critical Thinking & Decision Making Training Course, learners will explore the fundamentals of critical thinking, including its significance and steps involved. They will learn to identify critical thinkers and understand various strategies employed in critical thinking. Through practical examples, learners will develop problem-solving skills using critical thinking techniques. They will also delve into the evaluation of claims and judgments using critical thinking principles. Moreover, learners will discover the benefits of critical thinking and ways to overcome barriers that may hinder it. Lastly, the course will equip learners with the tools and techniques necessary for making informed decisions by integrating critical thinking into the decision-making process. By the end of the training, learners will possess a comprehensive understanding of critical thinking and its application in various aspects of life and work. Course Curriculum Module 01: Introduction to Critical Thinking Module 02: Importance of Critical Thinking Module 03: What Are the Critical Thinking Steps Module 04: Recognising a Critical Thinker Module 05: Critical Thinking Strategies Module 06: Problem-Solving Through Critical Thinking Module 07: Critical Thinking and the Judgment of Claims Module 08: Benefits and Barriers of Critical Thinking Module 09: Decision Making with Critical Thinking Learning Outcomes: Identify key principles and theories in critical thinking processes. Apply critical thinking steps to analyse and evaluate complex situations. Utilise critical thinking strategies to solve problems effectively and efficiently. Evaluate claims and arguments using critical thinking tools and techniques. Recognise the benefits of critical thinking and overcome common barriers. Make informed decisions by integrating critical thinking principles into decision-making. CPD 10 CPD hours / points Accredited by CPD Quality Standards Critical Thinking & Decision Making Training Course 2:09:44 1: Module 01: Introduction to Critical Thinking 16:13 2: Module 02: Importance of Critical Thinking 08:28 3: Module 03: What Are the Critical Thinking Steps 10:42 4: Module 04: Recognising a Critical Thinker 15:13 5: Module 05: Critical Thinking Strategies 16:22 6: Module 06: Problem-Solving Through Critical Thinking 16:28 7: Module 07: Critical Thinking and the Judgment of Claims 13:07 8: Module 08: Benefits and Barriers of Critical Thinking 17:41 9: Module 09: Decision Making with Critical Thinking 14:30 10: CPD Certificate - Free 01:00 Who is this course for? Professionals seeking to enhance analytical and decision-making skills. Students aiming to develop critical thinking abilities for academic success. Managers and leaders striving to foster a culture of strategic thinking. Individuals navigating complex environments requiring sound judgment and reasoning. Anyone interested in honing problem-solving skills through critical analysis. Career path Policy Analyst Risk Manager Data Analyst Strategy Consultant Quality Assurance Manager Research Scientist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

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

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...

This course covers the commitments that should be laid out in your company’s anti-harassment and bullying policy so as to comply with UK law. It explains the differences between harassment and bullying, the steps that can be taken if either of these occur in or out of work, and some case studies to illustrate the points covered throughout the course.

Unleash Your Project Meeting Potential Project managers spend a significant amount of time leading meetings but rarely leverage these valuable opportunities to their full potential. Instead, meetings provide the greatest source of anxiety, frustration and stress. Meetings fail to produce optimal results; participants feel that their time isn't valued; and project managers often miss opportunities to advance initiatives or demonstrate skills in leadership and communication. High-functioning meetings drive value, build collaborative relationships, and successfully move organizational priorities forward. As project managers, we need to take accountability for maximizing these opportunities to achieve successful outcomes and meet the needs of our stakeholders. In this session, we'll focus on key activities, a practical methodology, and best practices that you can adopt to consistently and skillfully plan, lead and follow up on effective meetings. You'll walk away with actionable steps that they can be implemented immediately to unleash your own meeting potential.b What You Will Learn: A mindset shift around how you think about and approach meetings to strengthen key skills, build collaborative relationships, and be recognized for your leadership Standardized methodology to consistently plan, lead and follow up on high-functioning, effective meetings for all of your projects Highly actionable steps and best practices that you can implement right away and set yourself up for success

Artificial neural networks (ANNs) are the most powerful machine learning algorithms available today. They are capable of learning complex relationships in data, and they have been used to achieve state-of-the-art results in a wide variety of fields, including image recognition, natural language processing, and speech recognition. The Future of Machine Learning is Here! This Project on Deep Learning - Artificial Neural Network course will teach you how to build and train ANNs from scratch. You will learn about the different components of an ANN, such as the input layer, hidden layers, and output layer. You will also learn about the different activation functions that can be used in ANNs, and you will see how to optimise ANNs for different tasks. In addition to the theoretical concepts, you will also get experience with ANNs. You will work on a project where you will build an ANN to classify images. You will use the TensorFlow library to build your ANN, and you will see how to train your ANN on a dataset of images. By the end of this Project on Deep Learning - Artificial Neural Network course, you will have a deep understanding of ANNs and how to use them. You will be able to build your own ANNs to solve a variety of problems. You will also be able to use the TensorFlow library to build and train ANNs. So what are you waiting for? Enrol in this course today and start learning about the future of machine learning!   Learning Outcomes: Through this comprehensive course, you should be able to: Understand the fundamental concepts of deep learning and artificial neural networks. Install and configure an artificial neural network framework. Preprocess and structure data for optimal model performance. Encode data effectively for neural network training and predictions. Build and deploy artificial neural networks for real-world applications. Address data imbalance challenges and optimise model accuracy.   Who is this course for? This Project on Deep Learning - Artificial Neural Network course is ideal for: Data scientists and machine learning practitioners seeking to expand their knowledge. Software engineers interested in leveraging deep learning techniques. Students pursuing a career in artificial intelligence and machine learning. Professionals looking to enhance their skills in neural network development. Individuals with a passion for exploring advanced machine learning techniques.   Career Path  Our course will prepare you for a range of careers, including: Deep Learning Engineer: £40,000 - £100,000 per year. Machine Learning Researcher: £45,000 - £120,000 per year. Data Scientist: £50,000 - £110,000 per year. Artificial Intelligence Specialist: £55,000 - £130,000 per year. Software Engineer (specialising in AI): £45,000 - £100,000 per year. Research Scientist (Machine Learning): £50,000 - £120,000 per year. AI Consultant: £60,000 - £150,000 per year. Certification After studying the course materials of the Project on Deep Learning - Artificial Neural Network (ANNs) 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Project on Deep Learning - Artificial Neural Network (ANNs) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Project on Deep Learning - Artificial Neural Network (ANNs) was made by professionals and it is compatible with all PC's, Mac's, 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.   Course Curriculum Section 01: Introduction Introduction of Project 00:03:00 Section 02: ANN Installation Setup Environment for ANN 00:11:00 ANN Installation 00:09:00 Section 03: Data Preprocessing Import Libraries and Data Preprocessing 00:11:00 Data Preprocessing 00:07:00 Data Preprocessing Continue 00:10:00 Section 04: Data Encoding Data Exploration 00:10:00 Encoding 00:07:00 Encoding Continue 00:06:00 Preparation of Dataset for Training 00:04:00 Section 05: Steps to Build ANN Steps to Build ANN Part 1 00:06:00 Steps to Build ANN Part 2 00:06:00 Steps to Build ANN Part 3 00:06:00 Steps to Build ANN Part 4 00:09:00 Section 06: Predictions and Imbalance-Learn Predictions 00:11:00 Predictions Continue 00:08:00 Resampling Data with Imbalance-Learn 00:09:00 Resampling Data with Imbalance-Learn Continue 00:08:00