39974 Learning courses in Belfast delivered On Demand

Master essential leadership skills and discover what it takes to become a great team manager or supervisor with the Team Management Skills course. This comprehensive course examines the characteristics and principles of effective leadership, from goal setting and providing feedback, to resolving conflict and managing your time. Our instructor-led training units are ideal for those who are new to their role and wish to fine tune their management style and approach to boos ttheir professional development. Master the art of public speaking, learn how to engage your audience and get your point across effectively with the Communication and Public Speaking Diploma. This training program will help you boost your confidence in delivering presentations and improve your body language to project confidence. This skills-based diploma also provides guidance on how to work with visual aids, plan your notes and overcome your fears and self-doubts. This course is ideal for those in customer or client-facing roles. Your Learning Goals: Develop your skills in time management, leadership and communication Understand how to provide constructive feedback and delegate work effectively Learn how to motivate teams and bring out the best in your employees Be able to resolve conflict and disagreements with professionalism Define your management style and understand which approach works for you Master the art of body language and learn how to project confidence in the workplace Improve your delivery in presentations and public speaking Know how to keep your audience engaged and use visual aids effectively Learn how to get your point across and express your ideas with conviction Discover practical mental exercises to help you remember your lines Who is this Course for? This course is ideal for line managers, supervisors and team leaders who are new to their role and wish to enhance their skillset. This masterclass is also suitable for anyone who wants to improve their public speaking and confidence in working with teams. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have the practical skills and knowledge to kickstart their career and explore opportunities in the following roles: Team Manager Team Leader/Supervisor Entrepreneur Motivational Speaker Coach/Mentor Course Curriculum **Team Management** Introduction Getting Started 00:01:00 Setting Expectations Setting Expectations 00:03:00 Setting Expectations Case Study 00:01:00 Setting Goals Setting Goals 00:06:00 Setting Goals Case Study 00:01:00 Assigning Work Assigning Work 00:04:00 Assigning Work Case Study 00:01:00 Degrees of Delegation Degrees of Delegation 00:03:00 Degrees of Delegation Case Study 00:01:00 Implementing Delegation Implementing Delegation 00:07:00 Implementing Delegation Case Study 00:01:00 Providing Feedback Providing Feedback 00:05:00 Providing Feedback Case Study 00:01:00 Managing Your Time Managing Your Time 00:05:00 Managing Your Time Case Study 00:01:00 Resolving Conflict Resolving Conflict 00:04:00 Resolving Conflict Case Study 00:01:00 Tips for Special Situations Tips for Special Situations 00:05:00 Tips for Special Situations Case Stud 00:01:00 A Survival Guide for the New Supervisor A Survival Guide For The New Supervisor 00:03:00 A Survival Guide For The New Supervisor Case Study 00:01:00 Wrapping Up Wrapping Up 00:01:00 **Effective Communication** Working on Basics 101 Skill Of The Mouth 00:09:00 Communication 00:04:00 It's In The Eyes 00:05:00 You Have 40 Seconds 00:02:00 Body Language 00:06:00 Art Of Speaking 00:06:00 Working On It 102 Putting It Together 00:05:00 Content Is Key 00:06:00 To Joke Or Not To Joke 00:02:00 Learn Your Lines 00:06:00 Visual Aids 00:03:00 Working On Me 103 Walk The Talk 00:05:00 What Gives You The Edge 00:05:00 It's The Heart That Counts 00:04:00 Mirror Time 00:05:00 How To Deal With Stress 00:04:00 Fake it Till You Make It 00:07:00 Preparation On The Day 00:05:00 Working On Them 104 People Don't Care How much you know until they know how much you care 00:04:00 They Really Are Naked 00:03:00 Sing The Right Song 00:06:00 Know Your Venue 00:04:00 Public Speaking - Why Do It? 00:04:00 Conclusion Hello and Goodbye 00:02:00 Goodbye HD Final Online 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Transform your customer service expertise with our Advanced Diploma in Customer Service. Gain a comprehensive understanding of industry best practices, advanced communication strategies, and cutting-edge customer-centric approaches. Elevate your skills, boost customer satisfaction, and propel your career to new heights. Enroll now for a specialized program designed to empower you with the knowledge and tools needed to excel in the dynamic world of customer service.

PAT Testing - Portable Appliance and Electronics Testing Training In many countries, PAT testing is not a legal requirement per se, but regulations such as the Electricity at Work Regulations 1989 in the UK require employers to ensure the safety of electrical equipment, which often involves PAT testing. The demand for PAT testing and Electronics Testing services has consequently grown, creating job opportunities for qualified individuals in this field. The average salary for PAT testing and Electronics Testing job in the UK ranges from £20,000 to £30,000 per year, depending on factors such as experience, qualifications, and the employer. With the increasing emphasis on safety and regulatory compliance, pursuing a career in PAT testing offers not only stability but also the satisfaction of contributing to public safety in the modern world. Key Features This PAT Testing - Portable Appliance and Electronics Testing Training course Includes: CPD Certified PAT Testing course Free Certificate from Reed CIQ Approved Developed by PAT Testing Specialist Lifetime Access to PAT Testing Training course Course Curriculum PAT Testing - Portable Appliance and Electronics Testing Training course: Module 01: Introduction To PAT Testing and Electronics Testing Module 02: Relevant Statutory Provisions For PAT Testing and Electronics Testing Module 03: Safety Responsibilities & Maintenance Provisions Module 04: Risk Assessment Module 05: Reducing And Controlling Risks Module 06: Electrical Units And Appliance Classification Module 07: Equipment Coverage & Maintenance Needs Module 08: Initial Visual Examination Module 09: Instruments For PAT and Electronics Testing And Equipment Inspection Module 10: Electrical Installation Testing Module 11: Lead & RCD Testing Module 12: Safety Precautions In Electrical Testing Module 13: Reporting And Record-Keeping Module 14: Testing For New Or Used Equipment Module 15: British Standards And Latest Changes Learning Outcomes PAT Testing - Portable Appliance and Electronics Testing Training course: Apply statutory provisions for PAT Testing in compliance with regulations. Demonstrate safety responsibilities and maintenance provisions in PAT testing. Conduct risk assessments and implement measures for risk reduction. Classify electrical units and appliances using appropriate criteria. Perform initial visual examinations and use PAT testing instruments effectively. Apply British Standards and stay updated on the latest changes of PAT Testing Accreditation All of our courses, including this PAT Testing - Portable Appliance and Electronics Testing Training course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in PAT Testing - Portable Appliance and Electronics Testing. Salaries in the UK The salaries for PAT Testing - Portable Appliance and Electronics Testing professionals vary depending on their experience and qualifications. However, most professionals in this field can expect to earn a competitive salary. The average salary for a PAT Testing Trainer in the UK is £45,000 per year. Satisfaction A recent survey found that 75% of PAT Testing - Portable Appliance and Electronics Testing Training professionals are satisfied with their jobs. The most common reasons given for job satisfaction were: Variety and autonomy in PAT Testing - Portable and Electronics Testing Testing Training Technical skills development Making a tangible difference as a PAT Testing - Portable and Electronics Testing Testing Training professional Potential for international work Requirements Learners do not require any prior qualifications to enrol on this PAT Testing - Portable Appliance and Electronics Testing Training course. You just need to have an interest in PAT Testing - Portable Appliance Testing Training. CPD 10 CPD hours / points Accredited by CPD Quality Standards PAT Testing - Portable Appliance Testing Training 3:44:00 1: Introduction to Portable Appliance Testing 17:00 2: Relevant Statutory Provisions for PAT 18:00 3: Safety Responsibilities & Maintenance Provisions 10:00 4: Risk Assessment 04:00 5: Reducing and Controlling Risks 11:00 6: Electrical Units, Appliance Classification 20:00 7: Equipment Coverage & Maintenance Needs 11:00 8: Initial Visual Examination 17:00 9: Instruments for Testing and Equipment Inspection 17:00 10: Electrical Installation Testing 35:00 11: Lead & RCD Testing 13:00 12: Safety Precautions in Electrical Testing 11:00 13: Reporting and Record-keeping 11:00 14: Testing for New or Used Equipment 11:00 15: British Standards and Latest Changes 16:00 16: CPD Certificate - Free 01:00 17: Leave A Review 01:00 Who is this course for? This PAT Testing - Portable Appliance and Electronics Testing Training course can be taken by anyone who wants to understand more about the topic. With the aid of this course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this complete PAT Testing - Portable Appliance Testing Training course is ideal for: Electrical technicians seeking PAT testing expertise. Health and safety professionals involved in equipment compliance. Facility managers responsible for appliance maintenance. Individuals transitioning to PAT testing roles. Electricians enhancing their knowledge in appliance testing. Career path After completing this PAT Testing - Portable Appliance and Electronics Testing Training course you will have a variety of careers to choose from. The following job sectors of PAT Testing - Portable Appliance Testing Training are: Appliance Tester Health and Safety Officer Facility Maintenance Manager Electrical Compliance Specialist Risk Assessment Consultant Testing and Inspection Engineer Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

About Course Environmental Engineering: A Career-Launching Course Are you passionate about protecting the environment? Do you want to make a difference in the world? If so, then environmental engineering is the perfect career for you. This online course will teach you the fundamentals of environmental engineering, from water and wastewater treatment to air pollution control and solid waste management. You will learn how to apply these principles to solve real-world problems, such as developing sustainable water systems, reducing air pollution, and managing hazardous waste. The course is developed by experienced environmental engineers who are passionate about their work. Their knowledge and expertise will help you develop the skills you need to succeed in this exciting field. Upon completion of this course, you will be well-prepared for a career in environmental engineering. You will have the knowledge and skills you need to design, implement, and manage environmental systems that protect our planet. Enroll today and start your journey to a more sustainable future! Here are some of the benefits of taking this course: Learn from experienced environmental engineers Gain the skills and knowledge you need for a career in environmental engineering Apply your knowledge to real-world problems Get hands-on experience with environmental engineering projects Network with other students and professionals in the field If you are interested in a career in environmental engineering, then this course is for you. Enroll today and start your journey to a more sustainable future! What Will You Learn? Understand the fundamentals of environmental engineering. This includes the basic principles of engineering, chemistry, and biology as they apply to environmental problems. Apply environmental engineering principles to solve real-world problems. This includes designing, implementing, and managing environmental systems such as water treatment plants, air pollution control systems, and solid waste management facilities. Communicate effectively about environmental issues. This includes being able to write reports, give presentations, and work with stakeholders to solve environmental problems. Work effectively in multidisciplinary teams. Environmental engineering problems often require the expertise of engineers, scientists, and other professionals. This course will teach you how to work effectively with others to solve these problems. Demonstrate professional and ethical behavior. As an environmental engineer, you will be responsible for protecting the health and safety of the public. This course will teach you the importance of professional and ethical behavior in environmental engineering. Course Content Introduction to Environmental Engineering Introduction to Environmental Engineering Environmental Chemistry and Microbiology Environmental Chemistry and Microbiology Water and Wastewater Treatment Water and Wastewater Treatment Air Pollution Control Air Pollution Control Solid Waste Management Solid Waste Management A course by Xpert Learning RequirementsBasic understanding of Chemistry and Biology. Audience Environmental Engineering Students Civil Engineering Students Individuals who have interest in Environmental Engineering Audience Environmental Engineering Students Civil Engineering Students Individuals who have interest in Environmental Engineering

Unlock the secrets to understanding and training dogs with our comprehensive Dog Behaviour and Training course. From the intricacies of dog communication to advanced training techniques and behavior modification, you’ll learn to foster a strong human-dog bond and promote both physical and mental well-being in canines.

Designing a garden requires a professional garden designer who can provide good design and know how to maintain these aesthetics. This course can assure that you will be skilled in knowing gardening design methods after taking it. If you want to become a professional garden designer or landscape artist then this Level 3 Diploma in Garden Design and Maintenance is perfect for you. You will learn to improve your skills in design and organizing the landscape of your client's garden to reach their high expectations. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Level 3 Diploma in Garden Design and Maintenance has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Level 3 Diploma in Garden Design and Maintenance is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £20,000. The sky really is the limit. Course Curriculum Module 1: Gardening Basics Organic Gardening Basics 00:30:00 Having a Plan 00:30:00 Having the Right Tools 01:00:00 Making your Own Mulch 01:00:00 Natural Pest Control 00:30:00 Organic Fertilizer 01:00:00 Planting 01:00:00 Harvesting 01:00:00 What To Avoid 00:30:00 Benefits of Organic Gardening 01:00:00 Module 2: Organic Gardening Why Garden Organically? 01:00:00 Planning Your Organic Vegetable Garden 00:30:00 Growing Your Organic Vegetable Garden 00:30:00 Why Grow an Organic Herb Garden? 00:30:00 Growing an Organic Herb Garden 00:30:00 You Have Organically Grown Herbs, Now What? 01:00:00 Organic Garden Fertilizers 00:30:00 Organic Gardening Compost 00:30:00 Why Use Organic Pest Control? 01:00:00 How to Control Garden Pests Organically 00:30:00 How to Bring Your Organic Plants Indoors; for Easy Year Round Growth 00:30:00 Organic Container Gardening 01:00:00 Organic Hydroponic Gardening 00:30:00 Module 3: Attracting Butterflies WHY SHOULD YOU ATTRACT BUTTERFLIES? 01:00:00 A BUTTERFLY'S LIFE 01:00:00 PLANNING YOUR BUTTERFLY GARDEN 01:00:00 PLANTS TO ATTRACT BUTTERFLIES 01:00:00 Module 4: Garden Maintenance How to Take Care of your Garden 00:15:00 Beginning Garden Care for the New Homeowner 00:30:00 At Home Remedies for Garden Care 00:30:00 Common Garden Problems And Easy Garden Care Solutions 00:15:00 Dogs Beware: Garden Care for the Dog Friendly Home 00:30:00 Garden Care for all Flower and Vegetable Life 00:30:00 Garden Care for the New Neighbor 00:15:00 Garden Care in All Seasons 00:30:00 What to Look for in Plant Selection 00:15:00 Herb Garden Care: Types, Tricks and Tips for Success 00:30:00 How Not to Care for your Garden: Common Garden Care Mistakes to Avoid 00:15:00 How to Choose and Maintain Annuals 00:30:00 How to Make your Seedlings Grow 00:30:00 How to Make Garden Care a Fun Filled Family Activity 00:15:00 Winter Garden Care 00:30:00 Garden Care for All Corners of Your Yard 00:15:00 Must Have Garden Tools for the Proper Garden Care Year Round 01:00:00 Preparing for a Garden 00:30:00 Proper Care to Garden 00:15:00 So, You Want to Start a Garden? Garden Care 00:30:00 The Best Conditions and Home Remedy Secrets to Rose Garden Care 00:30:00 The Different Kinds of Plant Gardens and How to Care for Each Type 00:15:00 What Type of Garden are you Destined to Have? 00:30:00 Top Nine Garden Care Tips from the Experts 00:15:00 Mock Exam Mock Exam - Level 3 Diploma in Garden Design and Maintenance 00:30:00 Final Exam Final Exam - Level 3 Diploma in Garden Design and Maintenance 00:30:00

Creating a compelling social media hook for your OneNote online course can significantly boost your visibility and attract more learners. Start by crafting a message that highlights the unique benefits of your course, such as its convenience, comprehensive content, and interactive features. Use engaging visuals and testimonials to showcase the value of your course. Leverage the power of storytelling to connect with your audience on an emotional level, making the learning experience relatable and desirable. Tailor your message to fit the platform you're using; for instance, a short and catchy hook for Twitter, a visually appealing post for Instagram, or a detailed and informative article for LinkedIn. Remember to include a clear call-to-action, encouraging potential students to sign up or learn more. By combining these elements, you can create a social media hook that resonates with your target audience and sets your OneNote course apart from the competition.

Overview This comprehensive course on IT Administration and Networking will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This IT Administration and Networking comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 IT Administration and Networking. It is available to all students, of all academic backgrounds. Requirements Our IT Administration and Networking is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 128 lectures • 00:55:00 total length •What is an Operating System: 00:48:00 •Configuring the Operating System: 00:06:00 •What is an Application: 00:10:00 •Using Control Panel: 00:18:00 •Software and Concepts: 00:11:00 •Licensing: 00:06:00 •Using Software: 00:07:00 •Software Tools: 00:10:00 •Software: 00:14:00 •Hardware, Devices, and Peripherals: 00:05:00 •Hardware and Peripherals: 00:07:00 •Storage: 00:12:00 •Connectivity Devices: 00:05:00 •Network Components: 00:09:00 •Identify the Importance of Risk Management: 00:11:00 •Assess Risk: 00:13:00 •Mitigate Risk: 00:24:00 •Integrate Documentation into Risk Management: 00:15:00 •Classify Threats and Threat Profiles: 00:08:00 •Perform Ongoing Threat Research: 00:13:00 •Resources that Aid in Research of Threats: 00:03:00 •Implement Threat Modeling: 00:10:00 •Assess the Impact of Reconnaissance Incidents: 00:11:00 •Performing Reconnaissance on a Network: 00:07:00 •Examining Reconnaissance Incidents: 00:08:00 •Assess the Impact of Social Engineering: 00:11:00 •Assessing the impact of Social Engineering: 00:08:00 •Assessing the Impact of Phishing: 00:03:00 •Types of Wireless Attacks: 00:30:00 •Intrusion Monitoring: 00:08:00 •Wireless Security Risks: 00:22:00 •Authentication Attacks: 00:21:00 •Rogue Devices: 00:04:00 •Public Hotspots: 00:07:00 •Wireless Security Monitoring: 00:21:00 •Device Tracking: 00:18:00 •WLAN Security Infrastructure: 00:38:00 •Management Protocols: 00:23:00 •Other RADIUS Solutions: 00:16:00 •Introduction: 00:30:00 •Child Safety Online: 01:00:00 •Secure Payment Sites: 01:00:00 •Online Banking: 00:30:00 •How To Keep Your Password Safe: 00:30:00 •Common Scams: 01:00:00 •How I Got Pharmed: 01:00:00 •Virus Protection: 01:00:00 •Self Maintenance: 00:30:00 •Personal Information Online: 01:00:00 •Is The Internet Safe?: 00:30:00 •Importance of Cyber Security: 00:30:00 •Spyware Can Destroy: 00:30:00 •How Does Spyware Spread?: 01:00:00 •How To Remove Spyware: 01:00:00 •Anti Spyware Program: 01:00:00 •The Anti Anti-Spyware Programs: 00:30:00 •Research And Learn More: 00:30:00 •Choosing The Best Anti Spyware Tool: 01:00:00 •Computer Security And Spyware: 01:00:00 •The Programs To Avoid: 00:15:00 •Is It Legal?: 00:30:00 •Checklist Of Protection: 00:15:00 •The Information Security Cycle: 00:37:00 •Information Security Controls: 00:36:00 •Authentication Methods: 00:09:00 •Cryptography Fundamentals: 00:56:00 •Security Policy Fundamentals: 00:11:00 •Social Engineering: 00:32:00 •Malware: 00:25:00 •Software-Based Threats: 00:22:00 •Based Threats: 00:39:00 •Wireless Threats and Vulnerabilities: 00:43:00 •Physical Threats and Vulnerabilities: 00:09:00 •Manage Data Security: 00:47:00 •Manage Application Security: 00:55:00 •Manage Device and Host Security: 01:08:00 •Manage Mobile Security: 00:10:00 •A Risk Analysis: 00:17:00 •Implement Vulnerability Assessment Tools and Techniques: 00:05:00 •Scan for Vulnerabilities: 00:27:00 •Mitigation and Deterrent Techniques: 00:19:00 •Respond to Security Incidents: 00:00:00 •Recover from a Security Incident: 00:10:00 •OSI Layers: 00:44:00 •LANs and WANs: 00:14:00 •Network Types: 00:07:00 •Transmissions: 00:36:00 •Cables: 00:41:00 •Fiber Optics: 00:17:00 •Converters and Connectors: 00:27:00 •Wireless Security: 00:15:00 •Authentication.prproj: 00:21:00 •Wireless Security Threats: 00:30:00 •TACACS: 00:10:00 •Keys: 00:26:00 •RADIUS: 00:07:00 •VPN Technologies: 00:16:00 •Tunneling Protocols.prproj: 00:05:00 •Acceptable Use: 01:00:00 •Common Problems: 00:32:00 •Troubleshooting: 00:28:00 •Network Technician Tools: 00:46:00 •Physical and Logical Issues: 00:19:00 •Open or Closed Ports: 00:09:00 •ARP Issues: 00:13:00 •Core Concepts in Healthcare IT: 00:06:00 •EMR EHR Issues: 00:05:00 •Regulations, Standards, and Stakeholders: 00:14:00 •HIPAA Controls and Compliance: 00:08:00 •Roles and Responsibilities: 00:10:00 •Manage Communication and Ethics Issues: 00:15:00 •Legal Best Practices, Requirements, and Documentation: 00:09:00 •Medical Document Imaging: 00:04:00 •Sanitation Management: 00:03:00 •Computing Essentials: 00:05:00 •Networking: 00:33:00 •Manage Servers and Software: 00:27:00 •Hardware Support: 00:14:00 •Set Up a Workstation: 00:08:00 •Troubleshoot Basic IT Issues: 00:15:00 •Troubleshoot Medical IT Issues: 00:20:00 •Implementation of an EMR EHR System: 00:34:00 •Change Control: 00:08:00 •Manage Physical and Logical Security: 00:36:00 •Implement Security Best Practices and Threat Mitigation Techniques: 00:13:00 •Manage Remote Access: 00:06:00 •Manage Wireless Security: 00:15:00 •Perform Backups and Disaster Recovery: 00:16:00

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Dive into the enriching world of Gardening and Horticulture. From landscaping design to hydroponics, plant nutrition, and pest management, this course offers comprehensive knowledge and practical skills. Unearth opportunities for a career in this green and growing field.