16844 Disc courses in Cardiff delivered On Demand

20 Prime Courses+ 5 Career Planning Courses| CPD Certified Diploma| Free 25 PDF+ Transcript Certificate| Lifetime Access

CompTIA Training | 25 Courses Programme | CPD Certified | Free PDF & Transcript Certificate | Lifetime Access

Level-4 QLS Endorsed | 30 in 1 Diploma Bundle | +Gifts: 30 Free CPD PDF Certificate | Lifetime Access

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  

Discover a streamlined pathway to obtaining your CSCS Health and Safety qualification with our online course and City & Guilds exam. Designed for construction workers, our program offers test-your-knowledge exercises, 200+ practice questions, and comprehensive mock exams, ensuring effective preparation for success.

Discover a streamlined pathway to obtaining your CSCS Health and Safety qualification with our online course and City & Guilds exam. Designed for construction workers, our program offers test-your-knowledge exercises, 200+ practice questions, and comprehensive mock exams, ensuring effective preparation for success.

Discover a streamlined pathway to obtaining your CSCS Health and Safety qualification with our online course and City & Guilds exam. Designed for construction workers, our program offers test-your-knowledge exercises, 200+ practice questions, and comprehensive mock exams, ensuring effective preparation for success.

Feeling Stuck in Your Career? The HR Management Bundle for HR Managers! Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the HR Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the HR Management Bundle for HR Managers! Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The HR Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the HR Management bundle on your job life and career growth! This HR Management Bundle for HR Managers! Bundle Comprises the Following CPD Accredited Courses: Course 01: HR Management Course Course 02: Recruitment Consultant Diploma Course 03: Safer Recruitment Training Course 04: UK Employment Law Course 05: Certificate in HR Audit Course 06: Operations Management: Enterprise Resource Planning Course 07: Operations Management: Resource & Workout Layout Course 08: HR Technology Implementation: Preparing Your Team for Success Course 09: Key Performance Indicators Professional Course 10: Employee Hiring and Termination Training Course 11: Virtual Interviewing for HR Course 12: Leadership and Management Course Course 13: Office Administration Course 14: Delegation Skills Course 15: Team Management Course 16: Organisation & People Management Course 17: Change Management Course 18: Performance Management Level 3 Course 19: Workplace Productivity Training Course 20: Motivation - Motivating Yourself & Others Course 21: Conflict Resolution Course 22: Corporate Risk And Crisis Management - Online Course Course 23: Workplace Stress Management Course 24: Crisis Communication for HR Course 25: Equality, Diversity and Discrimination Course 26: Cross-Cultural Awareness Training Course 27: Build HR Dashboard using Excel Course 28: Learn Advanced Fundamentals of HR Dashboard Course 29: Networking Skills for Personal Success Course 30: Decision-Making and Critical Thinking What will make you stand out? Upon completion of this online HR Management Bundle for HR Managers! Bundle, you will gain the following: CPD QS Accredited Proficiency with this HR Management bundle After successfully completing the HR Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this HR Management bundle The online test with immediate results You can study and complete the HR Management bundle at your own pace. Study for the HR Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The HR Management Bundle for HR Managers! bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience, designed to enrich both your personal and professional development. Advance the future of learning with the HR Management bundle, a comprehensive complete collection of 30 courses. Each course in the HR Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the HR Management bundle offers the flexibility and convenience to learn at your own pace. Make the HR Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The HR Management Bundle for HR Managers! is perfect for: Expand your knowledge and skillset for a fulfilling career with the HR Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the HR Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the HR Management bundle. Learn on your schedule, in the comfort of your home - the HR Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the HR Management Bundle for HR Managers! bundle. Certificates CPD Certificates Digital certificate - Included

Feeling Stuck in Your Career? The Leadership & Management - 30 CPD Courses Bundle! is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Leadership & Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the Leadership & Management - 30 CPD Courses Bundle!Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Leadership & Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Leadership & Management bundle on your job life and career growth! This Leadership & Management - 30 CPD Courses Bundle!Bundle Comprises the Following CPD Accredited Courses: Course 01: Leadership and Management Course Course 02: Building a Foundation for Leadership Success Course 03: Inspirational Leadership Skills: Practical Motivational Leadership Course 04: Creating an Innovation Culture Course 05: Day-to-Day Leadership Course 06: The Principles of Ethical Leadership Course 07: Leadership Skills For Organisational Development Course 08: Foundations of Leadership and Negotiation Skills Development Course 09: Supervisor Training Course 10: UK Employment Law Course 11: Delegation Skills Course 12: Personal Development Masterclass Course 13: Emotional Intelligence and Human Behaviour Course 14: Team Management Level 5 Course 15: Talent Management Level 3 Course 16: Diary Management Course 17: Business Management Course 18: Administrative Management Course 19: Project Management Course 20: Courageous Communication Strategies for Lead Course 21: Body Language Masterclass Communication Through Movement Course 22: Public Speaking: Presentations like a Boss Course 23: Equality, Diversity and Discrimination Course 24: Workplace Productivity Training Course 25: Legal Secretary and Office Skills Diploma Course 26: Conflict Resolution Course 27: Workplace Stress Management Course 28: Diploma in Risk Management Level 7 Course 29: Dealing With Difficult People In Life & Work Course 30: Decision-Making in High-Stress Situations What will make you stand out? Upon completion of this online Leadership & Management - 30 CPD Courses Bundle!Bundle, you will gain the following: CPD QS Accredited Proficiency with this Leadership & Management bundle After successfully completing the Leadership & Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Leadership & Management bundle The online test with immediate results You can study and complete the Leadership & Management bundle at your own pace. Study for the Leadership & Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Leadership & Management - 30 CPD Courses Bundle!bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience, designed to enrich both your personal and professional development. Advance the future of learning with the Leadership & Management bundle, a comprehensive, complete collection of 30 courses. Each course in the Leadership & Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Leadership & Management bundle offers the flexibility and convenience to learn at your own pace. Make the Leadership & Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Leadership & Management - 30 CPD Courses Bundle! is perfect for: Expand your knowledge and skillset for a fulfilling career with the Leadership & Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Leadership & Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Leadership & Management bundle. Learn on your schedule, in the comfort of your home - the Leadership & Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Leadership & Management - 30 CPD Courses Bundle! Certificates CPD Certificate Digital certificate - Included

Feeling Stuck in Your Career? The Facilities Management, Lean Six Sigma, Project Management & Business Management Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Six Sigma, Project Management & Business Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Facilities Management, Lean Six Sigma, Project Management & Business Management Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Six Sigma, Project Management & Business Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Six Sigma, Project Management & Business Management bundle on your job life and career growth! This Facilities Management, Lean Six Sigma, Project Management & Business Management Bundle Comprises the Following CPD Accredited Courses: Course 01: Facilities Management Diploma Course 02: Diploma in Lean Process and Six Sigma Course 03: Project Management Course 04: Operations Management Course 05: SAP Controlling (CO) - Product Costing S4HANA Course 06: Quality Management Course 07: Business Management Course 08: Leadership and Management Course Course 09: People Management Diploma Course 10: Performance Management Level 3 Course 11: Office Administration Course 12: Equality, Diversity and Discrimination Course 13: Compliance and Risk Management Course Course 14: Change Management Course 15: Commercial Law 2021 Course 16: Team Management Level 5 Course 17: Business Development Fundamentals: Lean Strategies for Business Course 18: Accounting and Finance Course 19: Financial Advisor Course 20: Financial Management Course 21: Payroll Management Course Course 22: Paralegal Training Course 23: Cross-Cultural Awareness Training Course 24: Time Management Training - Online Course Course 25: New Functions in Microsoft Excel 2021 Course 26: Learn to Make a Fresh Start in Your Life Course 27: Motivation - Motivating Yourself & Others Course 28: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 29: Decision-Making and Critical Thinking Course 30: Time Management Training - Online Course What will make you stand out? Upon completion of this online Facilities Management, Lean Six Sigma, Project Management & Business ManagementBundle, you will gain the following: CPD QS Accredited Proficiency with this Six Sigma, Project Management & Business Management Bundle After successfully completing the Six Sigma, Project Management & Business Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Six Sigma, Project Management & Business Management Bundle The online test with immediate results You can study and complete the Six Sigma, Project Management & Business Management bundle at your own pace. Study for the Six Sigma, Project Management & Business Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Facilities Management, Lean Six Sigma, Project Management & Business Management bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Six Sigma, Project Management & Business Management bundle, a comprehensive, complete collection of 30 courses. Each course in the Six Sigma, Project Management & Business Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Six Sigma, Project Management & Business Management bundle offers the flexibility and convenience to learn at your own pace. Make the Six Sigma, Project Management & Business Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Facilities Management, Lean Six Sigma, Project Management & Business Management is perfect for: Expand your knowledge and skillset for a fulfilling career with the Six Sigma, Project Management & Business Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Six Sigma, Project Management & Business Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Six Sigma, Project Management & Business Management bundle. Learn on your schedule, in the comfort of your home - the Six Sigma, Project Management & Business Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Facilities Management, Lean Six Sigma, Project Management & Business Management bundle. Certificates CPD Certificate Digital certificate - Included