4197 Courses

Get ready for an exhilarating journey at Citadel Business School this November 2024! Our CIMA Case Study Exam classes are designed to propel your career forward. Experience dynamic workshops, hands-on case analysis, and expert-led discussions that dive deep into real-world business scenarios. Collaborate with aspiring professionals, honing your critical thinking and strategic decision-making skills. With our tailored resources and personalized support, you’ll be able to tackle any of the CIMA Operational, Management, and Strategic case study exams confidently. Don’t miss this opportunity to elevate your knowledge and join a vibrant community dedicated to your success. Sign up today and transform your future! 4o mini

This Leisure management course will teach you how to manage and maintain a leisure facility, including a six-stage facility life cycle, benchmarking, quality management, asset management, operations, and activities. Furthermore, with modules packed with in-depth knowledge, this leisure management course lets you become acquainted with travel and tourism features. This Level 4 Leisure Management course is endorsed by The Quality Licence Scheme and accredited by CPD,(with 120 CPD points) to make your skill development and career progression related to Leisure Management substantial and easier than ever! After finishing this leisure management course, you will learn about managing hotels and accommodations as well as making choices to ensure the efficient running of the firm. In addition, after completing this leisure management course, you will have a better grasp of how to use human resources in the leisure business and how to apply leisure management or tourism marketing tactics. This leisure management course provides the learners with the knowledge of: Leisure industry and its management Discussion of the hotel and lodging sector and how to manage it Leadership skills in the leisure business to their full potential leisure industry's health and safety aspects The methods for managing and maintaining a recreational facility The essential characteristics of high-quality travel, tourist, and leisure facilities How to run a hotel or lodging business The fundamentals of leisure service planning Human Resource Management in the leisure industry leisure and recreation marketing Procedures for health and safety in recreational activities Why Prefer This Leisure Management Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another certificate accredited by CPDQS after completing this course Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. ****Course Curriculum**** Here is the curriculum breakdown of this course: Module 01: Introduction In this module, we will cover the following topics: Origin of Leisure in History Leisure in the 21st Century Understanding the Leisure Sector Tourism, Heritage and LeisureThe Environment, Countryside and Open SpaceThe Arts, Museums and LibrariesSport, Physical Recreation and Physical Activity Management Functions in Leisure Sector Career Opportunities in Leisure Sector Module 02: Managing and Maintaining a Leisure Facility In this module, we will cover the following topics: Six-Stage Facility Life-Cycle Benchmarking Steps of Benchmarking Customer Service: Expectations and Perceptions Customer Evaluation Criteria Quality Management Facility Asset Management Goals of Facility Asset Management Operations and Maintenance Sustainable Design Module 03: Travel, Tourism and Leisure In this module, we will cover the following topics: Characteristics of the Tourism Industry Core Industry SectorsTourism Business Factors Affecting Travel and Tourism EconomyPolitics and Government PoliciesSocio-Cultural ConflictsEnvironmentTechnology Tourism Destinations Elements of Influence in Destination Selection The Economic Significance of Tourism Module 04: Managing Hotel and Lodging In this module, we will cover the following topics: Classifications of Hotel Properties Hotels Classified by PriceHotels Classified by FunctionHotels Classified by LocationHotels Classified by Market Segment Major Functional Departments The Front OfficeHousekeepingSecuritySales and MarketingAccountingHuman ResourcesEngineering The Economics of the Hotel Business Dimensions of the Hotel Investment DecisionHotel Cycles and Financial Performance Module 05: Planning for Leisure Services In this module, we will cover the following topics: Planning In Organisations Some Planning Concepts Goal Setting Characteristics of Well-Thought-Out GoalsGoal CongruenceGoals and Policies Planning in Operations Strategic IssuesFrom Strategy to Tactics Individual Worker as Planner Planning as a Personal Process Long-Range Planning Tools Return on InvestmentCost-Benefit Analysis Module 06: Leadership in Leisure Industry In this module, we will cover the following topics: Characteristics of an Ideal Leader Deciding How to Lead Team Leading Goals and Skills Decision Making The Decision-Making Process Coaching, Mentoring and Motivational Leadership Motivational Leadership Module 07: Human Resource Management in Leisure Industry In this module, we will cover the following topics: Importance of HRM Tourism and HRM Human Resource Development Strategy Training Types and Levels of TrainingFuture Training Needs Rewards, Bonus, and Compensation Human Resource Information System Module 08: Marketing of Leisure and Recreation In this module, we will cover the following topics: Understanding the Marketing Process Understanding the Marketplace and Customer NeedsDesigning Customer Value-Driven Marketing StrategyPreparing an Integrated Marketing PlanBuilding Customer RelationshipsCapturing Value from Customers Developing Marketing Opportunities and Strategies Gaining Knowledge about the Marketing EnvironmentManaging Customer Information to Gain Customer InsightsConsumer Markets and Consumer Buying BehaviourOrganisational Buyer Behaviour Developing the Marketing Value-Driven Strategy and Mix Designing and Managing Products and BrandsInternal MarketingPricingDistribution Channels Delivering Customer ValueEngaging Customers and Communicating Customer Value and AdvertisingPromoting Products Managing Leisure and Tourism Marketing Marketing Tourism DestinationsCommunicating with the Tourist MarketOrganising and Managing Tourism Marketing Module 09: Health, Safety and Welfare In this module, we will cover the following topics: Health and Safety for Leisure Activities The Purpose of the Health and Safety Regulations The Basics of Health and Safety in an Organisation Health and Safety Law for Leisure Activities Health and Safety Law for Swimming Pools Health and Safety Law for Sports Club Organisers Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Travel Agency Owner Airline customer service agent Tourist information centre assistant Care escort Requirements The Leisure Management software does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path Travel agent (£18,000 to £27,000) Travel agency manager (£20,000 to £40,000) Tourist guide (£18,000 to £30,000) Tour manager (£16,000 to £30,000) Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Leisure Management at QLS Level 4 Hard copy certificate - £99 After successfully completing the Diploma in Leisure Management at QLS Level 4 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Asbestos, COSHH and Waste Management Diploma Master the complexities of COSHH regulations, asbestos awareness, and waste management. Elevate your expertise in COSHH risk assessments. Make informed decisions in waste management with this comprehensive diploma. Learning Outcomes: Identify types and usages of asbestos in line with COSHH. Evaluate the health risks of asbestos under COSHH guidelines. Conduct a COSHH risk assessment for hazardous materials. Implement effective waste management strategies, following COSHH. Analyze challenges in waste collection within a COSHH framework. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Asbestos, COSHH, and Waste Management Diploma: Asbestos Usage: Recognise common applications of asbestos and related COSHH regulations. Effects of Asbestos: Understand the health implications of asbestos exposure in line with COSHH guidelines. COSHH Awareness: Gain a robust understanding of COSHH fundamentals and its relevance to asbestos and waste management. COSHH Risk Assessment: Conduct in-depth COSHH risk assessments for substances hazardous to health, including asbestos. Understanding Waste Management: Acquire a nuanced understanding of waste management practices through a COSHH lens. Waste Collection and Challenges: Tackle the complexities and challenges of waste collection, governed by COSHH regulations.

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Data Analysis in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 31 lectures • 04:46:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Businesses will always require sharp minds to navigate the intricate maze of regulations and predict potential threats. Acting as the watchdogs of an organisation,Compliance and Risk Management professionals ensure all procedures align with legislative standards and anticipate risks that could threaten business stability. According to UK statistics, there's a soaring 15% demand for experts in Compliance and Risk Management. In fact, the salary range lies between £40,000 to £100,000 per annum, depending on experience and roles. Our Compliance and Risk Management course dives deep into the fundamental topics of this discipline: from understanding the basics of compliance to the intricacies of compliance and risk management. With a Compliance and Risk Management comprehensive curriculum covering eight vital modules, including Compliance Audit, Ethics, and the Risk Management Process, our course offers a thorough theoretical grounding. By the end of your journey with us, you'll have a robust understanding, preparing you for a prosperous career in Compliance and Risk Management. Compliance and Risk Management Course Learning Outcomes: Master key concepts in Compliance and Risk Management. Comprehend Compliance's Five Essential Elements. Explore the intricacies of Compliance Management System (CMS). Decode the Compliance Audit methodology. Emphasise Ethics within Compliance and Risk Management frameworks. Identify diverse Risk categories in Compliance and Risk Management. Understand the Compliance and Risk Management procedural flow. Join today, be skilled, learn Compliance and Risk Management with positive energy and enthusiasm, create an excellent career using your full potential! Become the best in the Compliance and Risk Management business. Get Started Now. Upon completing this comprehensive Compliance and Risk Management course, you will be able to: Gain in-depth knowledge on what compliance is and the importance of compliance Get familiar with the five basic elements of compliance and processes Get introduced to Compliance Management System along with the elements of CMS Know the compliance audit in detail and acquire the skills to conduct a audit Explore the differences between ethics and compliance Be aware of what risk is and all the different types of risks Have a deep understanding of risk management, its objectives and concepts Gain intensive knowledge and skills to carry out a risk management process Diploma in Compliance and Risk Management Course Curriculum Course Curriculum : Module 1: Introduction to Compliance Module 2: Five Basic Elements of Compliance Module 3: Compliance Management System (CMS) Module 4: Compliance Audit Module 5: Compliance and Ethics Module 6: Risk and Types of Risk Module 7: Introduction to Risk Management Module 8: Risk Management Process CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Compliance and Risk Management. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a Employee Employer Manager Supervisor Entrepreneur Business Professional Company Leader HR Professional Requirements This Compliance and Risk Management course has no requirements. Career path This Compliance and Risk Management course will help you with the fundamentals of compliance and risk management. This course will provide all the essential competencies to explore a plethora of exciting work opportunities, such as - Consultant Officer Risk Manager Risk & Compliance Investigator These opportunities pay an average of £20,000 to £65,000 a year in the UK. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00

Overview This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course. Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry. In This Microsoft Excel: Master Power Query Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Microsoft Excel: Master Power Query skills to help you advance your career. Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts. Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career. This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.  The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.  And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Microsoft Excel: Master Power Query course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Microsoft Excel: Master Power Query 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