440 Chartered Institute of Personnel Development (CIPD) courses in Cardiff delivered On Demand

Course Overview Learn how to hire the right person for the position with this HR & Recruitment Consultant Professional Diploma. The role of HR is quite a tough one. You have to select the right applicant from a list of hundreds of applicants, you have to hold interviews and evaluate each applicant, and make sure that you hire the correct person for the job. All this can be quite daunting if you don't have the right skills and knowledge, which is why we are offering you this fantastic course. Our HR & Recruitment Consultant Diploma can help you gain the skills of an expert HR manager and make the hiring process easier. The course is divided into three sections where you start with HR management, recruiting, interviews, retention, health & safety and much more. In the next section, you learn about recruitment through its selection process, goal setting, interviews questions, background checks and other key topics. In the final section of the course, you will learn how to lure in great candidates, filter the process for applications, deepening your knowledge of the selection and onboarding process.  The course will teach you how you can make the recruitment process amazingly easy and simple. If you're already working in HR or are working towards a career in HR, then this course will help you get significantly ahead of your competition.  Enrol today and get skilled! What You Will Learn This is one of the best courses on HR & Recruitment consulting you'll find and it'll give you vast knowledge about this topic. Recruiting and Interviewing Interview Questions Making Your Offer Retention and Orientation Workplace Health & Safety Disciplining Employees Terminating Employees and many more Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

The Horticulture - CPD Accredited Course is designed for those with a keen interest in plant science, landscaping, or garden design, looking to broaden their knowledge and advance their career. This course provides an in-depth exploration of the various aspects of horticulture, from plant care and soil management to sustainable gardening practices. By completing this course, you will gain a solid understanding of horticultural principles that can be applied to a wide range of roles within the sector, whether you’re a beginner or looking to expand your expertise. Throughout the course, you will engage with well-researched material that covers important topics such as plant identification, growth cycles, and the importance of environmental factors. The course is structured to be flexible, enabling you to learn at your own pace, without the need for physical attendance, while ensuring you are fully equipped with the necessary knowledge to excel in the field of horticulture. Whether you are pursuing a career in garden design, groundskeeping, or another horticultural profession, this course will enhance your credentials and give you the confidence to progress in the industry. Course Curriculum: Module 01: Introduction to Horticulture Module 02: Structure and Function of Horticulture Plants Module 03: Growth of Horticulture Plants Module 04: Impact of Temperature Module 05: Impact of Light Module 06: Impact of Soil and Water Module 07: Plant Propagation Module 08: Plant Nutrition Module 09: Harvesting, Training and Pruning Module 10: Growing Plant Indoors Module 11: Ornamental Horticulture and Garden Design Module 12: Cut Floral Design and Landscaping Module 13: Plant Pathology, Entomology and Weed Control Module 14: Permaculture and Arboriculture Module 15: Professional Opportunities in Horticulture Module 16: Biotechnology Applications in Horticulture Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing Horticulture - CPD Accredited course. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Horticulture - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Horticulture - CPD Accredited training.

Diversity isn’t just a word—it’s the reality of every modern workplace. This CPD-accredited online course is designed to introduce learners to the true meaning and impact of diversity, with a focus on fostering respect, awareness, and understanding across teams. It explores how recognising different backgrounds, beliefs, and identities can lead to better collaboration, communication, and wellbeing across all sectors and industries. Whether you’re aiming to develop your personal insight or add value to your organisation, this course provides accessible, structured learning at your pace, on your terms. With clear explanations, interactive content, and a strong foundation in current UK equality legislation, it delivers both relevance and clarity. Gain the confidence to navigate diverse environments respectfully—and learn why appreciating difference is far more than good manners; it’s good sense. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Introduction to Diversity Module 02: Factors that Create Diversity Module 03: Prejudice, Stereotyping & Discrimination Module 04: Unconscious Biases Module 05: Avoiding Unconscious Biases at the Workplace Module 06: New Paradigms in Workplace Diversity Module 07: Diversity Training & Its Limitations Module 08: Dealing with Diversity Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Diversity - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Diversity - CPD Accredited training.

If you’re aiming to sharpen your recruitment expertise and elevate your career without leaving your desk, this CPD accredited Recruitment Consultant course is tailor-made for you. Designed to deliver essential knowledge on sourcing, engaging, and placing the right talent, the course offers insights into the recruitment lifecycle, candidate management, and client relationship building. Whether you’re a budding consultant or looking to refresh your skillset, this course provides the building blocks to succeed in today’s competitive recruitment landscape. Delivered entirely online, this course fits effortlessly around your schedule, allowing you to absorb key concepts at your own pace. Expect clear, engaging modules packed with up-to-date industry approaches and strategies to help you navigate recruitment with confidence. Plus, it’s CPD accredited, meaning you gain recognised professional development credentials that can enhance your CV and career prospects. In short, a clever way to sharpen your recruitment know-how without leaving the comfort of your favourite chair. Learning Outcomes: Demonstrate an excellent understanding of the recruitment process Develop a solid recruitment and hiring strategy for your company Understand best practices to lure in great candidates and attract talent Look after candidate welfare and assess the competition Review job applications, resumes and cover letters Conduct phone and face-to-face candidate interviews Carry out background checks on candidates and check references Explain the difference between education and experience Discuss the key principles of the Equality Act 2010 and the legal recruitment process It's your chance to start with our Office Skills course and give your resume the stamp of approval that employers are looking for. So, pick up your card now and fill up your virtual basket with this highly-rated Recruitment Consultant - CPD Accredited online training program from Training Express Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with HR , Recruit Officer profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Defining and Knowing the Position Module 02: Hiring Strategy Module 03: Lure in Great Candidates Module 04: Filtering Applicants to Interview Module 05: The Interview (I) Module 06: The Interview (II) Module 07: Selection Process (I) Module 08: Selection Process (II) Module 09: Making an Offer Module 10: Legal Recruitment Process Module 11: Employment Contracts Module 12: Onboarding Module 13: Employee Training and Development Process Module 14: Motivation and Counselling Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Recruitment Consultant - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Recruitment Consultant - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Recruitment Consultant - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Recruitment Consultant - CPD Accredited training.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever wondered how many employment law tribunals there are in the UK each year? The answer is a staggering 120,000. This highlights the crucial role HR professionals play in ensuring legal compliance and fostering positive workplace environments. But do you have the skills and knowledge to excel in this dynamic field? If you're looking to develop your expertise in both recruitment and employment law, this Employment Law & Recruitment Consultant bundle is your perfect launchpad. This Employment Law & Recruitment Bundle Contains Following Courses: Course 01: Diploma in Employment Law at QLS Level 5 Course 02: Recruitment Consultant Diploma Course 03: HR Management Diploma Course 04: Payroll Administrator Training This Employment Law & Recruitment Consultant diploma equips you with the legal and practical expertise to excel in HR and recruitment. Master employment law, become a recruitment consultant pro, gain HR management skills, and champion diversity & equality in the workplace. This Employment Law & Recruitment Consultant Diploma bundle covers essential aspects in order to progress in your chosen career. Why Choose Our Employment Law & Recruitment Consultant Bundle? Get a Free CPD Accredited Certificate upon completion of Employment Law & Recruitment Consultant Get a free student ID card with Employment Law & Recruitment Consultant Training Get instant access to this Employment Law & Recruitment Consultant course. The Employment Law & Recruitment Consultant is affordable and simple to understand This course is an entirely online, interactive lesson with voiceover audio Lifetime access to the Employment Law & Recruitment Consultant course materials The Employment Law & Recruitment Consultant comes with 24/7 tutor support Take control of your HR and recruitment future. Enrol today in Employment Law & Recruitment Consultant! Start your learning journey straightaway! This Employment Law & Recruitment Consultant Diploma's curriculum has been designed by Employment Law & Recruitment Consultant Diploma experts with years of experience behind them. This course is extremely dynamic and well-paced to help you understand Employment Law & Recruitment Consultant Diploma with ease. Assessment Process Once you have completed all the courses in the Employment Law & Recruitment Consultant Diploma bundle, you can assess your skills and knowledge with an optional assignment. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Employment Law & Recruitment Consultant This Employment Law & Recruitment Consultant Diploma bundle is suitable for everyone. Requirements Employment Law & Recruitment Consultant You will not need any prior background or expertise in this Employment Law & Recruitment Consultant Diploma. Career path Employment Law & Recruitment Consultant This Employment Law & Recruitment Consultant Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included You can order other PDF certificates at the cost of £10 (for each course). PDF certificates for the title course is Free. Hard copy certificate Hard copy certificate - £29 You can order your hard copy certificates at the cost of £29 (for each course).

***Equip Yourself for Conflict Resolution with Mediation Basics for Conflict Management*** Did you know that according to a recent [CIPD]( Chartered Institute of Personnel and Development) report, 90% of HR professionals believe strong conflict resolution skills are important for a successful workplace? This "Mediation Basics for Conflict Management" course provides a comprehensive foundation for navigating disputes and fostering collaborative solutions. This "Mediation Basics for Conflict Management" course is designed to equip you with the theoretical knowledge and understanding to excel in the field of mediation. Through a series of engaging modules, you'll gain a strong grasp of core concepts, essential skills, and ethical considerations involved in this dynamic process. Learning Outcomes By participating in "Mediation Basics for Conflict Management," you will be able to: Define mediation and explain its role in conflict resolution. Identify the core skills necessary for effective mediation. Describe the different stages of the mediation process. Analyze the ethical principles and professional standards that govern mediation practice. Recognize special considerations that may arise in various mediation contexts. Apply your knowledge of mediation to better manage conflict situations. Delve into the core principles of mediation, starting with an exploration of introductory concepts and gradually advancing to essential skills crucial for effective mediation. Gain insights into the nuances of the mediation process and develop a profound understanding of the ethical standards that guide every mediator's practice. Course curriculum : Module 1: Introduction to Mediation Gain an overview of mediation, including its history, purpose, and significance in conflict management. Module 2: Essential Skills for Mediators Learn about the critical communication and interpersonal skills required for successful mediation. Module 3: The Mediation Process Understand the step-by-step process of mediation, from preparation to resolution. Module 4: Mediation Ethics and Professional Standards Explore the ethical principles and professional standards that guide mediators in their practice. Module 5: Special Considerations in Mediation Examine the unique challenges and considerations in various mediation contexts, such as workplace, family, and community disputes. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Mediation 15:04 1: Introduction to Mediation 15:04 Essential Skills for Mediators 17:39 2: Essential Skills for Mediators 17:39 The Mediation Process 15:39 3: The Mediation Process 15:39 Mediation Ethics and Professional Standards 19:12 4: Mediation Ethics and Professional Standards 19:12 Special Considerations in Mediation 17:25 5: Special Considerations in Mediation 17:25 Order Your CPD Quality Standard Certificate (Optional) 01:00 6: CPD Certificate (Optional) 01:00 Who is this course for? Mediation Basics for Conflict Management is ideal for anyone interested in: Pursuing a career in mediation Enhancing their conflict resolution skills in the workplace Building stronger relationships through effective communication Developing a deeper understanding of alternative dispute resolution (ADR) processes This course is designed to provide a strong theoretical foundation, and does not require prior experience in mediation. Requirements There are no prerequisites for this course. All participants will have the opportunity to actively engage with the course materials and ask questions to solidify their understanding of mediation principles. Career path Mediation is a growing field with applications in various sectors, including human resources, law, community organizations, and more. By successfully completing "Mediation Basics for Conflict Management," you'll be well-positioned to take the next step in your career path, potentially pursuing further training and certification to become a qualified mediator. Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed. CPD Quality Standard Certificate Digital certificate - £7.99

Compliance and risk management are essential for businesses of all sizes in the UK. By complying with regulations and managing risks effectively, businesses can protect themselves from financial and reputational damage. The job market for compliance and risk management professionals in the UK is growing. According to the Chartered Institute of Management Accountants (CIMA), the number of compliance and risk management jobs in the UK is expected to increase by 15% over the next five years. The average salary for a compliance and risk management professional in the UK is £60,000 per year. Compliance and risk management skills are highly valued by employers across all industries. Professionals with these skills are in high demand and can command competitive salaries. They also have the opportunity to work for a wide range of organisations, from small businesses to multinational corporations. Our Compliance and Risk Management course starts with the basics of Compliance and Risk Management and gradually progresses towards advanced topics. Why would you choose the Certificate in Compliance and Risk Management Course: Lifetime access to Certificate in Compliance Compliance and Risk Management course materials Full tutor support is available from Monday to Friday with the Certificate in Compliance Compliance and Risk Management course Learn Compliance and Risk Management skills at your own pace from the comfort of your home Gain a complete understanding of Certificate in Compliance Compliance and Risk Management course Accessible, informative Certificate in Compliance Compliance and Risk Management learning modules designed by expert instructors Curriculum Breakdown of the Compliance and Risk Management Course Module 01: Introduction to Compliance Module 02: Five basic elements of compliance Module 03: Compliance Management System (CMS) Module 04: Compliance Audit Module 05: Compliance and Ethics Module 06: Risk and Types of Risk Module 07: Introduction to Risk Management Module 08: Risk Management Process Certificate in Compliance and Risk Management Learning Outcomes: Define compliance and identify key elements. Understand CMS and compliance audit. Explain importance of compliance and ethics. Define risk and identify different types. Understand risk management process. Apply risk management principles. Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £129 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Compliance and Risk Management course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Compliance and Risk Management. Requirements To enrol in this Compliance and Risk Management course, all you need is a basic understanding of the English Language and an internet connection. Career path The Compliance and Risk Management course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors. Compliance Officer: £30,000 to £45,000 per year Risk Manager: £45,000 to £60,000 per year Internal Auditor: £35,000 to £50,000 per year Forensic Accountant: £40,000 to £60,000 per year Cyber Security Analyst: £35,000 to £50,000 per year 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 QLS Endorsed Hard Copy Certificate Hard copy certificate - £109

An Introduction to Payroll Accounting   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to an Introduction to Payroll Accounting.   This course provides an overview of payroll accounting. It is aimed at accountants and business managers and owners new to payroll accounting and looking for straightforward coverage of the key elements and features of payroll. In this course we will cover the core elements of payroll; how gross pay is calculated; and issues when dealing with tips and benefits in kind. We’ll also look at tax-exempt deductions and the statutory deductions from pay. We’ll review the main elements of payroll taxation and social security contributions including the terminology used in the United States, Canada and the United Kingdom. And we’ll cover the calculation of Net Pay – that is the amount that the employee actually receives in their bank account. Finally we’ll explore the main journal entries required in the accounts. The principles and structure of payroll accounting are common across many jurisdictions, and the learning in this course applies in many countries of the world. For this reason, the course does not go into the detail of any country-specific legislation or regulations, and does not cover the particular tax rates, tax bands or deduction rates that apply in different jurisdictions. This course provides a grounding in the principles and structure of payroll accounting whatever your country of operation. I hope you enjoy it.     Key Learning Points  On completion of the course, delegates will be able to: Describe the main components of payroll including allowances, taxes and deductions. Explain the terms Gross Pay, Taxable Pay and Net Pay Identify the statutory taxes and deductions applicable in the United States, Canada and the United Kingdom Complete the main Journal Entries required to process payroll Describe the elements recorded in a Payroll Register     Curriculum Lesson 1: First Principles in Payroll Accounting Lesson 2: Getting to Gross Pay Lesson 3: Allowances and Deductions Lesson 4: Income Taxes and Social Security Contributions Lesson 5: The Calculation of Net Pay Lesson 6: Specific Payroll Terminology for the United States, Canada and the United Kingdom Lesson 7: Payroll Journal Entries Lesson 8: Final Thoughts on Payroll Accounting Appendix: The Payroll Register     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     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

Did you know that according to a recent study by the Chartered Institute of Marketing, businesses with a strong focus on Sales Administration Skills achieve a 15% higher sales growth compared to those who don't?Sales Administration Skills are the backbone of any successful sales operation, ensuring smooth processes and maximizing sales potential. Our extensive Sales Administration Skills course is designed to equip you with the theoretical knowledge and understanding to excel in a Sales Administration role. Through a series of engaging modules, you'll gain valuable insights into the world of sales, marketing, and customer interaction, all specifically tailored to the Sales Administration function. Learning Outcomes By the end of this Sales Administration Skills course, you will be able to: Demonstrate a strong understanding of the sales cycle and its various stages. Effectively manage customer inquiries and interactions. Utilize marketing principles to support sales efforts. Develop and maintain accurate sales records and data. Apply effective communication and negotiation skills in a Sales Administration setting. Contribute to the overall success of the sales team through strong administrative support. Why would you choose the Sales Administration Skills course from Compliance Central: Lifetime access to Sales Administration Skills course materials Full tutor support is available from Monday to Friday with the Sales Administration Skills course Learn Sales Administration Skills skills at your own pace from the comfort of your home Gain a complete understanding of Sales Administration Skills course Accessible, informative Sales Administration Skills learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Sales Administration Skills Study in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your course This Sales Administration Skills course delves into 17 modules, each packed with valuable knowledge to enhance your Sales Administration Skills. Module 01: Introduction to Sales This module establishes the foundation of Sales Administration Skills by exploring the core concepts of sales, its role within a business, and the various career paths available. Module 02: Sales Growth Delve into the strategies and techniques employed to achieve sustainable sales growth. This module explores market analysis, lead generation, and effective sales pipeline management. Module 03: Sales Hypnosis Learn the fundamentals of ethical persuasion techniques used in sales. This module explores the psychology of influence and how to build rapport with potential customers. Module 04: Sales Presentation Master the art of crafting compelling sales presentations. This module equips you with the skills to present product features, address customer needs, and deliver a persuasive closing argument. Module 05: Basics of Marketing Gain a solid understanding of marketing principles and their impact on sales success. This module explores market segmentation, branding strategies, and the elements of the marketing mix. Module 06: The Marketing Process Uncover the various stages involved in the marketing process, from market research and product development to promotion and distribution. Module 07: Strategic Marketing Explore the development and implementation of strategic marketing plans. This module delves into competitor analysis, target market identification, and the creation of a winning marketing strategy. Module 08: Marketing Environment Gain insights into the internal and external factors influencing the marketing environment. This module explores economic, social, technological, legal, and environmental factors impacting marketing strategies. Module 09: Market Segmentation Learn how to effectively segment markets to identify and target specific customer groups. This module explores various segmentation methods and their application in sales administration. Module 10: Consumer Buying Behaviour Unravel the mysteries of consumer buying behavior. This module explores the psychological, social, and cultural factors that influence purchasing decisions. Module 11: Business Markets and Buying Behaviour Gain a deeper understanding of business-to-business (B2B) markets and buyer behavior. This module explores the unique characteristics of B2B sales and the decision-making process involved. Module 12: Marketing Research Discover the importance of market research in developing effective sales and marketing strategies. This module explores various research methodologies and data analysis techniques. Module 13: Sales and Marketing Explore the vital link between sales and marketing functions within a business. This module emphasizes collaboration and communication to achieve organizational goals. Module 14: Leverage and Limitations Gain insights into the leverage and limitations of various Sales Administration Skills techniques. This module explores ethical considerations and responsible sales practices. Module 15: Sales Negotiations Develop your negotiation skills to effectively close deals and secure favorable outcomes. This module explores negotiation strategies, tactics, and effective communication techniques. Module 16: Dealing with Customers Master the art of exceptional customer service in a sales environment. This module explores communication techniques, building rapport, and handling customer objections. Module 17: Communication Skills Develop strong communication skills that are essential for success in Sales Administration. This module emphasizes active listening, clear and concise communication, and persuasive writing techniques. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Sales Administration Skills course is ideal for: Individuals seeking a career in sales administration. Those looking to enhance their existing Sales Administration Skills. Business professionals seeking to understand the sales process. Anyone interested in developing strong communication and negotiation skills. Those who want to gain a competitive advantage in the job market. Individuals seeking to contribute to a successful sales and marketing team. Requirements To enrol in this Sales Administration Skills course, all you need is a basic understanding of the English Language and an internet connection. Career path A strong foundation in Sales Administration Skills can open doors to a variety of exciting career paths, including: Sales Administrator Sales Operations Specialist Customer Service Representative Account Manager Business Development Representative Marketing Coordinator Sales Manager (with further experience and qualifications) 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

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