4457 Courses delivered On Demand

Overview This comprehensive course on Excel PowerQuery and PowerPivot will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel PowerQuery and PowerPivot 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 Excel PowerQuery and PowerPivot. It is available to all students, of all academic backgrounds. Requirements Our Excel PowerQuery and PowerPivot 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 3 sections • 28 lectures • 01:50:00 total length •pivot table power query power pivot - 1: 00:09:00 •pivot table power query power pivot - 2: 00:01:00 •pivot table power query power pivot - 3: 00:02:00 •pivot table power query power pivot - 4: 00:03:00 •pivot table power query power pivot - 5: 00:01:00 •pivot table power query power pivot - 6: 00:04:00 •pivot table power query power pivot - 7: 00:08:00 •pivot table power query power pivot - 8: 00:05:00 •pivot table power query power pivot - 9: 00:03:00 •pivot table power query power pivot - 10: 00:04:00 •pivot table power query power pivot - 11: 00:04:00 •pivot table power query power pivot - 12: 00:02:00 •pivot table power query power pivot - 13: 00:03:00 •pivot table power query power pivot - 14: 00:05:00 •pivot table power query power pivot - 15: 00:02:00 •pivot table power query power pivot - 16: 00:03:00 •pivot table power query power pivot - 17: 00:03:00 •pivot table power query power pivot - 18: 00:08:00 •pivot table power query power pivot - 19: 00:02:00 •pivot table power query power pivot - 20: 00:04:00 •pivot table power query power pivot - 21: 00:05:00 •pivot table power query power pivot - 22: 00:09:00 •pivot table power query power pivot - 23: 00:04:00 •pivot table power query power pivot - 24: 00:03:00 •pivot table power query power pivot - 25: 00:04:00 •pivot table power query power pivot - 26: 00:09:00 •Resources - Excel PowerQuery and PowerPivot: 00:00:00 •Assignment - Excel PowerQuery and PowerPivot: 00:00:00

The Power of Constructive Feedback Few of us even know what constructive feedback is, so it's no surprise that employees say they don't get enough and managers say they don't have the time or expertise to provide it. This video explores the importance of constructive feedback and how to give and get feedback that improves performance. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Lean Tools and Processes: How to Use Them in Your Business This presentation provides an overview of the most common, traditional Lean tools and methods that can be applied to any business -- from the shop floor to the back office, and from retail businesses to service industries. Topics covered will include Standard Work, 5S, Error Proofing, and others. The required culture change within a company and adoption of a "Lean Mindset" will also be discussed. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

The Power of Constructive Feedback Few of us even know what constructive feedback is, so it's no surprise that employees say they don't get enough and managers say they don't have the time or expertise to provide it. This video explores the importance of constructive feedback and how to give and get feedback that improves performance. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

This comprehensive, hands-on course empowers beginners with essential web development skills. From HTML, CSS, and JavaScript to GitHub and Bootstrap, master the tools of the trade. Learn to build, style, and deploy websites effortlessly. No prior knowledge of programming or web development is needed.

The Operational Officer Training Course is designed for those who aspire to sharpen their leadership and decision-making capabilities within demanding environments. This course offers a robust understanding of operational frameworks, emphasising strategic thinking, communication, and effective coordination. Perfectly suited for individuals keen to enhance their capacity to manage complex situations with confidence and clarity, it blends theoretical knowledge with scenario-based learning—minus the need for physical attendance, of course. Participants will gain insight into the essential responsibilities of operational officers, including risk assessment, resource allocation, and team management. With a focus on clear, decisive action and the ability to maintain composure under pressure, this course prepares learners to navigate dynamic challenges with professionalism and poise. Whether you’re advancing your career or simply curious about operational leadership, this training provides a sharp, engaging pathway to boost your expertise. All delivered with a touch of wit to keep you both informed and entertained. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Operations Management Module 02: Project Management Module 03: Business Development and Succession Planning Module 04: Process Management Module 05: Supply Chain Management Module 06: Planning & Forecasting Operations Module 07: Procurement & Purchasing Management Module 08: Manufacturing & Delivery Operations Module 09: Quality Management Module 10: Managing Risk and Recovery Module 11: Performance Management Module 12: Talent Management Module 13: Communication Skills Module 14: Negotiation Techniques Module 15: Conflict Management Module 16: Stress Management Module 17: Time Management Module 18: Business Environment Module 19: Business Writing Skills 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%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Operational Officer 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 Operational Officer training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

This course provides a comprehensive understanding of operational risk and its pivotal role in financial management. Delve into the various categories of operational risk in a banking context, exploring different approaches for assessment and management. Uncover the principles and key aspects of the standardised approach, while gaining insights into quantitative standards under the Advanced Measurement Approach (AMA) for operational risk management. After the successful completion of the course, you will be able to learn about the following,⦁ The concept of operational risk and its significance in financial management.⦁ Identify and differentiate between the various categories of operational risk in a banking context.⦁ The different approaches to assess and manage operational risk in banking operations.⦁ The principles and key aspects of the standardised approach for operational risk management.⦁ Quantitative standards when utilizing the Advanced Measurement Approach (AMA) for operational risk management.⦁ The different types of credit risk assessment approaches used in banking and their respective implications. Gain in-depth knowledge of operational risk's conceptual significance in financial management, distinguishing between diverse risk categories in banking operations. Explore various approaches for assessing and managing operational risk, emphasizing the principles and key aspects of the standardised approach. Additionally, delve into quantitative standards when employing the Advanced Measurement Approach (AMA) for operational risk management, unraveling the nuances of credit risk assessment approaches used in banking and their implications. This course equips participants with a profound understanding of operational risk's conceptual significance in financial management and its diverse categories in a banking context. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Standards And Approaches Of Operational Risks Self-paced pre-recorded learning content on this topic. Standards and Approaches of Operational Risks Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Operational Risk Analyst Risk Management Specialist Compliance Manager Quantitative Analyst Operational Risk Consultant Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Master the art of hybrid team management with our comprehensive course. Learn effective techniques for transitioning, team building, and driving high performance in a hybrid work environment. Elevate your leadership skills and optimize your team’s effectiveness in today’s dynamic work landscape.

From beginner to expert, this course will help you advance your career using Microsoft Excel skills.