Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report
ICA Certificate in Anti Money Laundering A practical, introductory-level course that will give you a solid understanding of core money laundering and terrorist financing risks. Through this qualification, you will: discover what money laundering and terrorist financing are and why sanctions are important appreciate the vulnerabilities of financial institutions to money laundering and terrorist financing explore what anti money laundering and combating terrorist financing is in practice and what the legal and regulatory structures look like understand management obligations and the risk-based approach to money laundering and terrorist financing Suitable for operational or front-line staff and those considering embarking on a new career in AML as a stepping-stone for study at a higher level. This course is awarded in association with Alliance Manchester Business School, the University of Manchester. What are the benefits of undertaking this qualification?: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate This ICA Certificate in Anti Money Laundering is awarded in association with Alliance Manchester Business School, the University of Manchester. Upon successful completion of this course, students will be awarded the ICA Certificate in Anti Money Laundering - Cert (AML) What will you learn? Understanding Money Laundering, Terrorist Financing and Sanctions Vulnerabilities of financial institutions to money laundering and terrorist financing Anti money laundering and combating terrorist financing in practice Anti money laundering and combating terrorist financing - legal and regulatory structures Management obligations and the risk-based approach to money laundering and terrorist financing How will you be assessed? Assessed by online multiple-choice exam
Well-being isn't just a 'nice to have' - it should be a core part of your employee strategy.
ACCA is ideal if you’re looking to progress your career and become a chartered accountant, or work in an accountancy, audit or tax firm. Access all subjects with one flexible, affordable subscription. Progress your studies and reach your career goals with Eagle. Career benefits of an ACCA distance learning course Our courses are accredited by the ACCA ( Association of Chartered Certified Accountants). An ACCA qualification can open doors to great careers and amazing salaries across the world. There are so many roles you could go into – nothing is out of reach for an ACCA member. You don’t need any qualifications to start with ACCA, just a willingness to learn. The Foundation level is a great place to start if you’re new to accountancy, or work in finance and have no accountancy credentials. Once you reach the final level you can become a chartered accountant with a world-leading ACCA designation, and an internationally recognised MSc. ACCA Accounting qualifications Diploma in Accounting and Business (Foundation Level) Do you want to learn about the fundamentals of accounting? Ready to get your career started in finance? The ACCA Foundation Diploma in Accounting and Business is the level for you. It’s the perfect place to start if you are new to accountancy, or if you’re already working in finance but have no formal qualifications. You can get certificates and diplomas along the way before going on to the ACCA qualification. Applied Knowledge ACCA Applied Knowledge gives you the essential building blocks for a successful career in accountancy and finance. You’ll get a broad understanding of accountancy techniques – just what you need to get started. ACCA Applied Knowledge is for you if you want to develop the skills to become a professional accountant. Applied Skills Ready to build on your existing knowledge and understanding? Applied Skills develops that knowledge and gives you the strong and practical finance understanding that professional accountants need, no matter what sector or industry they are in. ACCA Applied Skills is for you if you’ve already got some finance experience and learning under your belt and are serious about advancing in accountancy. The subjects that you will learn are essential if you’re wanting to become a strategic accountant in any sector or industry. Strategic Professional If you want to be seen as a strategic, forward thinking professional accountant, with opportunities all over the world – then this is the qualification for you. Strategic Professional can open doors to the most sought after jobs, and you’ll become part of the largest network of professional accountants in the world. By doing Strategic Professional, as well as satisfying the practical experience element and completing the Ethics module, you’ll end up getting the world-leading ACCA designation. What’s included in an ACCA course subscription Tutor led knowledge and application modules: Delivered by our partner Kaplan, every module and topic has been through a detailed design process to make sure each area is explained clearly, and gives you the knowledge you need to pass your exams Integrated Workbook: Interactive learning guide that you will use alongside your online tutor led videos. The integrated workbook helps you keep all your notes in one place, making revision easier and more efficient Study Text: Kaplan ACCA Approved Ebook with full syllabus coverage Exam Kit: Kaplan ACCA Approved Ebook with hundreds of practice questions to get you exam ready Study programme: A guide to give you structure to your studies, bringing together all elements of your learning. Made by expert tutors, it will guide you through the whole syllabus Online practice questions: Interactive practice questions for every subject plus an auto marked mock exam. Realistic case studies provide context of how concepts will be seen in real life Tutor support*: Receive responses to your queries from a dedicated tutor team, all accountancy qualified and accountancy experts Mentor support*: You will have a designated mentor who will be with you throughout your studies making sure your course runs as smoothly as possible. Why choose an Eagle distance learning course? Distance Learning with Eagle provides you with great flexibility compared to a classroom course. You decide where and to study, fitting it around your family, work or other life priorities. It’s also cheaper, unlike classroom studying where you often pay a course fee for each level, an Eagle subscription gives you unlimited access to all levels of the ACCA qualification. Only pay for access for as long as you need it, with the option to pause anytime with no fees. Partnering with the best, you’ll always have access to market-leading interactive online content powered by Kaplan and ACCA-approved material from Kaplan Publishing, all-day, every day for as long as you subscribe. Your subscription includes all the online content you need to succeed, but if you want to supplement your learning with books, Eagle students get an exclusive 50% off hard copy study materials. We are one of the most experienced online distance learning providers, and our students’ success rate speaks for itself, consistently exceeding the national average. If you have any questions about studying with Eagle, or need some guidance on where to start, you can contact us for a free consultation.
Level 4 CET course is a first stage teaching qualification which has a teaching/training practice requirement. This qualification designed for those working or wishing to work as teachers/trainers. Formerly this courses was known as CTLLS. Candidates who successfully complete this qualification will have a fundamental understanding of the roles and responsibilities of a teacher/trainer in relation to legislation, equality, diversity, inclusivity and meeting the needs of learners. They will be able to use initial and diagnostic assessments and plan and deliver inclusive teaching and learning. They will also be able to assess learning and use appropriate resources to support effective learning.
ITIL® 4 Strategist: Direct, Plan and Improve: Virtual In-House Training The ITIL® 4 Strategist: Direct, Plan, and Improve course is based on the ITIL® 4 Strategist Direct, Plan, and Improve candidate syllabus from AXELOS. This course is based on the ITIL® 4 Strategist: Direct, Plan and Improve IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This course provides the practical skills necessary to create a 'learning and improving' IT organization, with a strong and effective strategic direction. It was designed to provide practitioners with a practical and strategic method for planning and delivering continual improvement with necessary agility. It covers both practical and strategic elements, making it the universal module that is a key component to both ITIL® 4 Managing Professional and ITIL® 4 Strategic Leader streams. What You Will Learn At the end of this course, participants will be able to: Understand the key concepts of direction, planning, improvement Understand the scope of what is to be directed and/or planned and know how to use key principles and methods of direction and planning in that context Understand the role of GRC and know how to integrate the principles and methods into the service value system Understand and know how to use the key principles and methods of continual improvement for all types of improvements Understand and know how to use the key principles and methods of Communication and Organizational Change Management to direction, planning and improvement Understand and know how to use the key principles and methods of measurement and reporting in direction, planning, and improvement Understand and know how to direct, plan, and improve value streams and practices Course Introduction Let's Get to Know Each Other Course Overview ITIL® 4 Certification Scheme Course Learning Objectives Course Components Course Agenda Exercises Case Study: Axle Car Hire Case Study: HandyPerson on Demand Exam Details Core Concepts of DPI Key Terms Covered in the Module Module Learning Objectives Basics of Direction Basics of Planning Basics of Improvement Other Core Elements DPI through Service Value Chain and Guiding Principles Key Terms Covered in the Module Module Learning Objectives DPI of the SVS DPI of Guiding Principles Role of Direction in Strategy Management Key Terms Covered in the Module Introducing Strategy Management Developing Effective Strategies Implementation of Strategies Key Terms Covered in the Module Module Learning Objectives Managing Risks Making Decisions through Portfolio Management Directing via Governance, Risk, and Compliance (GRC) Introduction to Assessment and Planning Key Terms Covered in the Module Module Learning Objectives Core Concepts of Assessment Conducting Effective Assessments Core Concepts of Planning Assessment and Planning through VSM Key Terms Covered in the Module Module Learning Objectives Introducing VSM Developing Value Stream Maps Knowing More About VSM Measurement, Reporting, and Continual Improvement Key Terms Covered in the Module Module Learning Objectives Measurement and Reporting Alignment of Measurements and Metrics Success Factors and Key Performance Indicators Continual Improvement Measurements and Continual Improvement through Dimensions and SVS Key Terms Covered in the Module Module Learning Objectives Measurements for the Four Dimensions Continual Improvement of the Service Value Chain and Practices OCM Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of OCM OCM throughout DPI and Service Value Chain Resistance and Reinforcement Communication Principles and Methods Key Terms Covered in the Module Module Learning Objectives Basics of Effective Communication Communication with Stakeholders SVS Development Using Four Dimensions Key Terms Covered in the Module Module Learning Objectives Organizations and People in the SVS Partners and Suppliers in the SVS Value Streams and Processes in the SVS Information and Technology in the SVS
ITIL® 4 Specialist: Drive Stakeholder Value: Virtual In-House Training The ITIL® 4 Specialist: Drive Stakeholder Value module is part of the Managing Professional stream for ITIL 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: Drive Stakeholder Value exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn The learning objectives of the course are based on the following learning outcomes of the ITIL® 4 Specialist: Drive Stakeholder Value exam specification: Understand how customer journeys are designed Know how to target markets and stakeholders Know how to foster stakeholder relationships Know how to shape demand and define service offerings Know how to align expectations and agree on details of services Know how to onboard and offboard customers and users Know how to act together to ensure continual value co-creation (service consumption / provisioning) Know how to realize and validate service value Customer Journey Purpose of the Module Purpose of Mastering the Customer Journey Touchpoints and Service Interactions Module Topics Mapping the Customer Journey Designing the Customer Journey Measuring and Improving the Customer Journey Customer Journey Step 1: Explore Purpose of the Module Purpose of the Explore Step Module Topics Understanding Service Consumers Understanding Service Providers Understanding and Targeting Markets Customer Journey Step 2: Engage Purpose of the Module Purpose of the Engage Step Aspects of Service Value Module Topics Service Relationship Types Building Service Relationships Building and Sustaining Trust and Relationships Analyzing Customer Needs Managing Suppliers and Partners Customer Journey Step 3: Offer Purpose of the Module Purpose of Shaping Demand and Service Offerings Module Topics Managing Demand and Opportunities Specifying and Managing Customer Requirements Designing Service Offerings and User Experience Selling and Obtaining Service Offerings Customer Journey Step 4: Agree Purpose of the Module Purpose of Aligning Expectations and Agreeing on Services Module Topics Agreeing on and Planning Value Co-Creation Negotiating and Agreeing on a Service Customer Journey Step 5: Onboard Purpose of the Module Purpose of Onboarding and Offboarding ITIL® Management Practices Module Topics Planning Onboarding Fostering Relationships with Users Providing User Engagement and Delivery Channels Enabling Users for Service Elevating Mutual Capabilities Offboarding Customer Journey Step 6: Co-create Purpose of the Module Purpose of Service Provision and Consumption Module Topics Service Mindset Ongoing Service Interactions Nurturing User Communities Customer Journey Step 7: Realize Purpose of the Module Measuring Service Value Purpose of Value Capturing and Customer Journey Improvement Realizing Service Value in Different Settings Module Topics Tracking Value Realization Assessing and Reporting Value Realization Evaluating Value Realization and Improving Customer Journeys Realizing Value for the Service Provider
Duration 1 Days 6 CPD hours This course is intended for This course is intended for customer service professionals with any level of experience who want to expand their knowledge, improve their skill set, and increase the understanding of customer benefits. This course teaches basic communication terms and organization basics. Students will learn how to communicate effectively, motivate employees, overcome communication barriers, develop leadership habits, understand how communication flows within an organization, develop networks, and identify the roles that individuals fulfill in an organization. Course activities also cover applying technology to organizational communication, discussing innovation and change, examining how environmental context affects communication, and discussion how power and politics affect an organization. Students will also learn how to manage change, stress, conflict, and empower individuals. The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success. Prerequisites This course is intended for customer service professionals with any level of experience who want to expand their knowledge, improve their skill set, and increase the understanding of customer benefits. 1. Communication basics Effective communication Organizational management Organization types and characteristics Communication flow 2. Leadership and motivation Communication and leadership Communication and motivation 3. Relational context and organizations Relational context Relationships and organizations 4. Technology in the workplace Workplace technology Impact of technology Technology guidelines 5. Context, stress, and managerial tools Environmental context Stress and communication 6. Innovation and change Aspects of innovation Aspects of change 7. Power, politics, and diversity Power and communication Diversity and communication Empowerment and communication Additional course details: Nexus Humans Organizational Communication training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Organizational Communication course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
This training is for lawyers and covers key topics to ensure compliance with the Lexcel standard and other regulations.