5034 Courses

Duration 3 Days 18 CPD hours This course is intended for This advanced course is designed for those individuals who are responsible for operating and managing the operation of an IBM i system. Overview Explain the concept of how LPAR works Explain the functions served by the HMC Explain how user versus resource security are implemented Explain the difference between group profiles and authorization lists Describe how adopted authority works Describe how work is managed on the system and the concepts of the performance tuning process on the system Explain how Management Central can be used to manage a single system or a network of System i servers Perform the steps to create a basic CL program using both the traditional (PDM and SEU) and the newer GUI (RSE and LPEX) application development tools Perform the steps to create a menu using SDA Provide some tips on how you can improve your operations This course is designed to enhance the skills of an IBM i System Operator. This course explains the concept of how LPAR works and discusses the functions provided by the HMC LPAR concepts and overview . Console options and HMC overview . IASP concepts and overview . Security concepts and overview . System values . User security (user and group profiles) . Resource security . Authorization lists and adopted authority . Management Central overview . Commands and tasks using Management Central . Inventory using Management Central . System values using Management Central . Other Management Central functions . Work management: Concepts and overview . Work management: Subsystem concepts and overview . Work management: Job processing concepts and interactive jobs . Work management: Job processing concepts of other job types . Work management: Submitting and tracking of batch jobs . Programming concepts . CL programming concepts . Using PDM and SEU to create a CL program . Starting and setting up RSE . Creating a CL program using RSE and LPEX Editor . Creating a menu using SDA . Tips for improved operation .

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.

Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course aims to provide practical guidance and specialist knowledge on topics such as housekeeping, catering, front office operations, quality of service, and staff training requirements. This Hospitality Management: Hospitality Management Course is an in-depth training program for new managers and aspiring professionals in the hospitality and tourism industries. This Hospitality Management: Hospitality Management Course will give you a solid understanding of the hospitality industry and its key areas, with a focus on different types of hotels and hospitality roles. This Hospitality Management: Hospitality Management Course will teach you how to manage all hotel operations as well as develop an effective service management program that incorporates safety, security, quality, and cutting-edge technology. By the end of this Hospitality Management: Hospitality Management Course, you will gain all of the necessary skills and knowledge to become a successful Hotel Manager and advance your career in the Hospitality sector. Main Course: Level 5 Hospitality Management Course Free courses included with Hospitality Management: Hospitality Management Course Course 01: Level 4 Time Management Course 02: Level 2 Food Hygiene and Safety for Catering Course 03: Food Allergen Awareness Training Course 04: Level 7 Diploma in Event Management Course 05: Level 3 HACCP Training Course Special Offers of this Hospitality Management: Hospitality Management Course: This Hospitality Management: Hospitality Management Course includes a FREE PDF Certificate. Lifetime access to this Hospitality Management: Hospitality Management Course Instant access to this Hospitality Management: Hospitality Management Course 24/7 Support Available to this Hospitality Management: Hospitality Management Course [ Note: Free PDF certificate will provide as soon as completing the Hospitality Management: Hospitality Management Course] Hospitality Management: Hospitality Management Course Online Course Curriculum of Hospitality Management: Hospitality Management Course Module 01: An Overview of the Hospitality Industry Module 02: Travel and Tourism Module 03: Forces Affecting Growth and Change in the Hospitality Industry Module 05: Understanding the Management of Food and Beverage Operations Module 06: Understanding Accounting in Hospitality Module 07: Restaurant Operations Module 08: Balance Sheet and the P&L Statement Module 09: Budgets Assessment Method of Hospitality Management: Hospitality Management Course After completing Hospitality Management: Hospitality Management 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 Hospitality Management: Hospitality Management Course After completing the Hospitality Management: Hospitality Management 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? Hospitality Management: Hospitality Management Course Online This Hospitality Management: Hospitality Management Course is ideal for anyone who works in or aspires to work in the hospitality industry, which includes the following professions: - Hospitality Manager, Hotel Manager, Housekeeping Manager, Catering Manager. Requirements Hospitality Management: Hospitality Management Course Online To enrol in this Hospitality Management: Hospitality Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Hospitality Management: Hospitality Management Course. Be energetic and self-motivated to complete our Hospitality Management: Hospitality Management Course. Basic computer Skill is required to complete our Hospitality Management: Hospitality Management Course. If you want to enrol in our Hospitality Management: Hospitality Management Course, you must be at least 15 years old. Career path Hospitality Management: Hospitality Management Course Online Candidates who successfully complete our Hospitality Management: Hospitality Management Course may pursue a wide range of careers, including: Manager of Maintenance Manager of Marketing Manager of Operations Manager of Sales Event Planner

It doesn't matter where you are in your web development journey, and you will benefit if you have at least a little knowledge of AJAX. If you have an interest in advancing in AJAX, getting better in the world of full-stack programming, and knowing how you can use AJAX in a practical way to perform CRUD operations-then this course is for you.

The AML, KYC & CDD Diploma is an in-depth, professional qualification designed to enhance your understanding of the crucial processes involved in anti-money laundering (AML), know your customer (KYC), and customer due diligence (CDD). This course provides a thorough exploration of the legal and regulatory frameworks, helping you stay ahead in a rapidly evolving financial landscape. You'll gain knowledge about recognising and preventing financial crimes, assessing risks, and understanding the key principles of maintaining robust systems in your business or organisation. This course is ideal for individuals looking to solidify their expertise in these critical areas, whether you're in finance, banking, or any sector requiring compliance oversight. With a focus on international standards and regulations, you'll be able to confidently navigate through complex situations and ensure the integrity of your financial operations. The QLS Endorsed Diploma offers you a flexible, online learning experience, tailored to equip you with valuable insights and knowledge that you can apply directly to your career or business without the need for physical attendance. Our AML, KYC & CDD Diploma course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. AML, KYC & CDD Diploma QLS Bundle Includes the following Courses Course 01: Diploma in AML, KYC & CDD at QLS Level 4 Course 02: Risk Assessment Training Course 03: Certificate in Compliance Course 04: CRM - Customer Relationship Management Course 05: GDPR UK Training Key Features of AML, KYC & CDD Diploma Eligibility for QLS endorsed certificate upon successful completion of the AML, KYC & CDD Diploma course Free CPD Accredited Course Fully online, interactive AML, KYC & CDD Diploma course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth AML, KYC & CDD Diplomatraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the AML, KYC & CDD Diploma course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This AML, KYC & CDD Diploma course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your AML, KYC & CDD Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the AML, KYC & CDD Diploma course, learners will be able to order an endorsed certificate, titled: Diploma in AML, KYC & CDD at QLS Level 4, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about AML, KYC & CDD Diploma basics. Requirements No prior degree or experience is required to enrol in this AML, KYC & CDD Diploma course. Career path This AML, KYC & CDD Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Navigate the maze of modern business responsibilities with confidence through our QLS Endorsed Certificate in Compliance and Risk Management. This professionally crafted course introduces the key principles and strategies behind regulatory responsibility and risk awareness—essential knowledge for anyone looking to stay ahead in today's shifting corporate landscape. Whether you're sharpening existing know-how or exploring new territory, this course provides a sharp, structured insight into how organisations maintain integrity while managing uncertainty. Presented entirely online for your convenience, the programme is thoughtfully arranged to support flexible learning without compromising depth. From corporate governance to ethical decision-making, you’ll explore vital topics that shape business operations worldwide. Ideal for those aiming to broaden their understanding, it offers a clear and focused route to career development—without the fluff or fuss. So, whether you’re looking to brush up or branch out, this is a smart move in the right direction. Compliance and Risk Management Certificate QLS Bundle Includes the following Courses Course 01: Certificate in Compliance and Risk Management at QLS Level 3 Course 02: Workplace Confidentiality Training Course 03: Anti Money Laundering (AML) Course 04: GDPR UK Training Course 05: Health and Safety at Workplace Key Features of Compliance and Risk Management Certificate Eligibility for QLS endorsed certificate upon successful completion of the Compliance and Risk Management Certificate course Free CPD Accredited Course Fully online, interactive Compliance and Risk Management Certificate course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Compliance and Risk Management Certificatetraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Compliance and Risk Management Certificate course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Compliance and Risk Management Certificate course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Compliance and Risk Management Certificate course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Compliance and Risk Management Certificate course, learners will be able to order an endorsed certificate, titled: Certificate in Compliance and Risk Management at QLS Level 3, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Compliance and Risk Management Certificate basics. Requirements No prior degree or experience is required to enrol in this Compliance and Risk Management Certificate course. Career path This Compliance and Risk Management Certificate Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

If you’ve ever questioned what’s really going on behind the kitchen doors, this course might just be your sort of thing. Supervising Food Safety in Catering isn’t just about stopping someone from dropping a lettuce on the floor and hoping no one notices — it’s about understanding exactly how to manage food safety from the top down. This course takes a closer look at what supervisors need to know to ensure hygiene standards are met, maintained, and not quietly brushed under the chopping board. Aimed at those with responsibility for staff and food handling processes, it covers everything from the science behind food hazards to managing documentation and ensuring your team knows a sneeze guard isn’t just there for decoration. It’s designed for those overseeing catering operations, whether you're supervising in a bustling hotel kitchen or managing a small events team. With sharp focus and a dash of good humour, this course puts you in the know — and keeps your food service operation on the right side of safe. Our Supervising Food Safety in Catering course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Supervising Food Safety in Catering QLS Bundle Includes the following Courses Course 01: Diploma in Supervising Food Safety in Catering at QLS Level 3 Course 02: Catering Management Course 03: Level 3 HACCP for Catering Course 04: Kitchen Manager Course 05: Customer Service Key Features of Supervising Food Safety in Catering Eligibility for QLS endorsed certificate upon successful completion of the Supervising Food Safety in Catering course Free CPD Accredited Course Fully online, interactive Supervising Food Safety in Catering course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Supervising Food Safety in Cateringtraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Supervising Food Safety in Catering course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Supervising Food Safety in Catering course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Supervising Food Safety in Catering course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Supervising Food Safety in Catering course, learners will be able to order an endorsed certificate, titled: [Diploma in Supervising Food Safety in Catering at QLS Level 3], as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Supervising Food Safety in Catering basics. Requirements No prior degree or experience is required to enrol in this Supervising Food Safety in Catering course. Career path This Supervising Food Safety in Catering Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Data Structure Level 5 is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Data Structure Level 5 and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 9 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training A Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Unit 01: Introduction Module 01: Promo Video 00:02:00 Module 02: Data Structure Introduction 00:05:00 Module 03: Computational Complexity Analysis 00:13:00 Unit 02: Arrays Module 01: Static and Dynamic Arrays 00:12:00 Module 02: Dynamic Arrays Source Code 00:07:00 Unit 03: Liked List Module 01: Singly and Doubly Linked Lists 00:15:00 Module 02: Doubly Linked Lists Source Code 00:10:00 Unit 04: Stack Module 01: Stack 00:12:00 Module 02: Stack Implementation 00:04:00 Module 03: Stack Source Code 00:04:00 Unit 05: Queues Module 01: Queues (Part-1) 00:06:00 Module 02: Queues (Part-2) 00:06:00 Module 03: Queue Source Code 00:04:00 Unit 06: Priority Queues (PQs) Module 01: Priority Queues (PQs) with an interlude on heaps 00:13:00 Module 02: Turning Min PQ into Max PQ 00:06:00 Module 03: Adding Elements to Binary Heap 00:10:00 Module 04: Removing Elements from Binary Heap 00:14:00 Module 05: Priority Queue Binary Heap Source Code 00:16:00 Unit 07: Union Find Module 01: Disjoint Set 00:06:00 Module 02: Kruskal's Algorithm 00:06:00 Module 03: Union and Find Operations 00:11:00 Module 04: Path Compression Union Find 00:07:00 Module 05: Union Find Source Code 00:08:00 Unit 08: Binary Search Trees Module 01: Binary Trees and Binary Search Trees (BST) 00:13:00 Module 02: Inserting Element into a Binary Search Tree (BST) 00:06:00 Module 03: Removing Element from a Binary Search Tree (BST) 00:14:00 Module 04: Tree Traversals 00:12:00 Module 05: Binary Search Source Code 00:13:00 Unit 09: Fenwick Tree Module 01: Fenwick Tree Construction 00:06:00 Module 02: Point Updates 00:05:00 Module 03: Binary Indexed Tree 00:14:00 Module 04: Fenwick Tree Source Code 00:06:00 Unit 10: Hash Tables Module 01: Hash Table 00:17:00 Module 02: Separate Chaining 00:08:00 Module 03: Separate Chaining Source Code 00:12:00 Module 04: Open Addressing 00:11:00 Module 05: Linear Probing 00:14:00 Module 06: Quadratic Probing 00:09:00 Module 07: Double Hashing 00:15:00 Module 08: Removing Element Open Addressing 00:08:00 Module 09: Open Addressing Code 00:15:00 Unit 11: Suffix Array Module 01: Introduction 00:03:00 Module 02: The Longest Common Prefix (LCP) Array 00:03:00 Module 03: Using SA/LCP Array to Find Unique Substrings 00:05:00 Module 04: Longest Common Substring (LCS) 00:11:00 Module 05: Longest Common Substring (LCS) Full Example 00:07:00 Module 06: Longest Repeated Substring (LRS) 00:05:00 Unit 12: AVL Trees Module 01: Balanced Binary Search Trees (BBSTs) 00:09:00 Module 02: Inserting Elements into an AVL Tree 00:10:00 Module 03: Removing an AVL Tree 00:09:00 Module 04: AVL Tree Source Code 00:17:00 Unit 13: Indexed Priority Queue Module 01: Indexed Priority Queue (Part-1) 00:25:00 Module 02: Indexed Priority Queue Source Code 00:09:00 Unit 14: Sparse Tables Module 01: Sparse Table 00:26:00 Module 02: Sparse Table Source Code 00:07:00

With our Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course, you can increase your earning potential in the UK's expanding HVAC industry. HVAC technicians in the UK earn an average salary of around £32,500, and with our thorough course, you'll be on your way to standing out in the market, enjoying opportunities for growth and better income.   Our expertly designed HVAC Technician course curriculum comprises twelve engaging modules that explore the ins and outs of HVAC systems. You will delve into the fundamentals of heating and ventilation, understand the intricacies of air conditioning systems, and learn about the practical aspects of compressors, water chillers, fans, and much more. Each module is tailored to equip you with valuable, industry-relevant knowledge and skills.   This course isn't just a learning experience; it's an investment in your future. Safety practices, system selection, and special applications are also covered, ensuring you are job-ready upon completion. Join us to take your HVAC expertise to the next level and stand out in this booming sector. Enrol in our Level 3 HVAC Technician Course today - let's get ready to change your life! What will you Learn? Upon completion of the HVAC Technician course, you should be able to: Understand the basics of Heating, Ventilation, and Air Conditioning (HVAC). Gain knowledge of heating fundamentals and psychrometrics. Get an overview of different HVAC systems and their operations. Learn about heating, ventilation, and air conditioning systems. Acquire skills related to compressors, water chillers, and fans. Master the techniques of HVAC piping and duct system. Deep dive into refrigeration principles and refrigerant types. Learn safety measures and system selection in the HVAC industry. Why buy this HVAC Technician course? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one-to-one assistance when needed Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript immediately Easily learn the skills and knowledge from the comfort of your home   Who is this Course for? This HVAC Technician course is perfect for: Aspiring HVAC technicians seeking a rewarding career. Skilled tradesmen looking to diversify their skill set. Engineers aiming to specialise in HVAC systems. Facility managers desiring improved building efficiency. Professionals in construction interested in HVAC knowledge. Career Path: Our HVAC Technician course will prepare you for a range of careers, including: HVAC Technician: Earning potential of £25,000 - £32,500. HVAC Engineer: Salaries can range from £33,000 - £40,000. Senior HVAC Technician: Can earn between £40,000 - £45,000. HVAC Project Manager: Salaries typically around £50,000 - £60,000. HVAC Service Manager: Potential earnings of £55,000 - £65,000. HVAC System Designer: Salaries range from £45,000 - £55,000. Certification After studying the course materials of the Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician course, there will be a written assignment test which you can take either during or at the end of the course. After passing the test, you will have a range of certification options. A CPD Accredited PDF Certificate costs £4.99, while a CPD Accredited Hardcopy Certificate is £8.00. We also offer transcript services. A PDF Transcript costs £4.99, and a Hardcopy Transcript is £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This expertly designed Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Course Curriculum Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Module 01: Introduction to Heating, Ventilation & Air Conditioning (HVAC) 00:16:00 Module 02: Heating Fundamentals and Psychrometrics 00:36:00 Module 03: HVAC Systems 00:18:00 Module 04: Heating and Ventilation 00:25:00 Module 05: Air Conditioning Systems for HVAC Technicians 00:26:00 Module 06: Compressors, Water Chillers, and Fans 00:28:00 Module 07: Piping for HVAC Technician 00:23:00 Module 08: Duct System in HVAC 00:31:00 Module 09: Refrigeration and Refrigerants 00:24:00 Module 10: Special Applications 00:27:00 Module 11: HVAC System Selection 00:21:00 Module 12: Safety in the HVAC Industry 00:30:00 Mock Exam Mock Exam - Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician 00:20:00 Final Exam Final Exam - Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician 00:20:00

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course 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 paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00