1631 Courses delivered Online

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Set your business apart with the 'Branding Fundamentals for New Business' course, a comprehensive program designed to equip budding entrepreneurs and business owners with essential branding skills. This course is a journey through the core principles of effective branding, starting with an introduction to the psychological aspects of why people buy. Each section unfolds a new layer of branding knowledge, from understanding how to stand out as a business owner to mastering the art of storytelling in brand building. The curriculum intricately blends theoretical insights with practical applications, ensuring a well-rounded grasp of branding concepts. Delve into the nuances of brand personality through character typology, the Japanese concept of Ikigai, and the Big Hairy Audacious Goal (BHAG) framework. The course further explores the creation of a strong brand identity, including the development of core values, mission, vision, and their application in real-world scenarios. Learners will also uncover the secrets behind successful naming strategies and brand architecture. The latter sections focus on the power of storytelling and visual identity, including how to collaborate effectively with designers to create a compelling brand image. This course is an essential toolkit for anyone aspiring to create a brand that resonates deeply with its target audience. Learning Outcomes Understand the psychological factors influencing consumer purchases. Develop unique branding strategies to distinguish your business. Master the art of creating and communicating a compelling brand story. Learn the intricacies of visual identity and how to collaborate with designers. Acquire practical skills in naming and building a coherent brand architecture. Why choose this Branding Fundamentals for New Business course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Branding Fundamentals for New Business course for? Entrepreneurs looking to establish a strong brand presence. Business owners seeking to enhance their branding strategies. Marketing professionals aiming to deepen their branding knowledge. Start-up founders wanting to build a distinctive brand identity. Designers and creatives interested in understanding the business aspects of branding. Career path Brand Manager: £28,000 - £50,000 Marketing Strategist: £30,000 - £55,000 Creative Director: £35,000 - £60,000 Brand Consultant: £32,000 - £52,000 Entrepreneur: Variable Graphic Designer: £25,000 - £40,000 Prerequisites This Branding Fundamentals for New Business does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01 1.1 Introduction 00:02:00 1.2 Why Do People Buy? 00:05:00 Section 02 2.1 Standout as a Business Owner 00:03:00 2.2. Hybrid Model 00:01:00 2.3. Character Typology 00:04:00 2.4 Ikigai 00:02:00 2.5. BHAG 00:02:00 Section 03 3.1 Values 00:08:00 3.2 Abilities 00:04:00 3.3 Mission 00:08:00 3.4 Vision 00:03:00 3.5 How to Use Mission and Vision 00:03:00 Section 04 4.1. What are Archetypes 00:04:00 4.2. Paradise Archetypes 00:06:00 4.3. Structure Bringer Archetypes 00:07:00 4.4. Connection Seeker Archetypes 00:06:00 4.5. Mark Leaver Archetypes 00:06:00 Section 05 5.1. Importance of Naming 00:06:00 5.2. Basic Naming Approaches 00:05:00 5.3. Special Circumstances on Naming 00:04:00 5.4. Naming for Solopreneurs 00:03:00 5.5. Brand Architecture 00:06:00 Section 06 6.1. The Importance of Storytelling 00:02:00 6.2. How to Write and Use a Brand Story 00:09:00 Section 07 7.1. What is a Visual Identity 00:03:00 7.2. Visual Identity Booklet 00:05:00 7.3. Working with a designer and Final Notes 00:06:00 Resource Resource - Branding Fundamentals for New Business 00:00:00

JavaScript can interface with the Document Object Model and help make webpage elements come to life! Interact with web users through event listeners to make your web pages respond to users and code. This practical course will help you build modern, interactive, and dynamic web pages. You need to have previous experience with JavaScript and HTML to get started.

Are you someone wishing to learn the skills to analyze data professionally using Power BI? Do you want to learn to create impressive reports? Then this is the right course for you! Learn the complete workflow in Power BI from A-to-Z and advanced analytics with DAX-calculated columns and measures, forecasting, and advanced analytics.

The most comprehensive, concise and impactful 6 weeks online course available. 14 CPD Credits & CMI Certificate of Recognition Mapped to the leadership & management requirements of the UK’s Royal Colleges Duration: 6 weeks starting immediately Suitable for: All levels of seniority Language: English Effort: 13 hours of self-paced online learning Award: 14 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 16 video courses to watch. This includes 7 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Key learning areas: Leading innovation Understanding change Leading with strategic thinking Building and leading teams Building trust Leading through change Strategic thinking Managing virtual teams On completion of this course, you will receive: A certificate stating 14 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year World leading content supported by cutting edge technology. Made for healthcare professionals.  Did you know this course can be covered by the NHS study budget? The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here.  For the duration of this course, you will work through the content below to obtain your CPD Credits and CMI Certificate. You can track your progress on the platform. You can complete the course sooner than 6 weeks if you wish. Course curriculum Building and Leading Successful teams Leading with Values and Ethic Leadership Insights on Leading with Executive Presenc Leadership Insights on Building & Leading Team Leadership Toolkit: Facilitating a Workshop Leadership Toolkit: Facilitating a Brainstorming Sessio Leadership Toolkit: Running a Team Debrie The Characteristics of an Accountable Leade Leading through Shared Vision Evaluating Your Management Style The Adaptive Leader: Be an Iceberg The Collaborative Leader Leading through Problem Solving and Decision Making Leadership Insights on Leading Diversity Leadership Insights on Judgment and Decisiveness Leading with Judgment and Decisiveness Accountable Leadership Leadership Insights on Being Accountable Expert Insights on Networking & Building Relationships Building Your Professional Network Leadership Insights on Networking with your Peers Networking to Improve Leadership Effectiveness Empowering Employees MIT Sloan Management Review on New Leader Transitions All the Leader You Can Be: The Science of Achieving Extraordinary Executive Presence MIT Sloan Management Review on The Adaptive Leader MIT Sloan Management Review Article on Looking for Opportunity in the Midst of Crisis Executive Presence: The Art of Commanding Respect like a CEO, Second Edition MIT Sloan Management Review on Leader as Motivator The Accountable Leader: Developing Effective Leadership Through Managerial Accountability From Bud to Boss: Secrets to a Successful Transition to Remarkable Leadership Strategic Connections: The New Face of Networking in a Collaborative World The Courage Way: Leading and Living with Integrity Executive Presence: The Art of Commanding Respect Like a CEO

🌟 Unlock the Blueprint to Lifelong Happiness! 🌟 Ready to embark on a transformative journey towards true and lasting happiness? Introducing 'Constructing the Pillars of Happiness of Your Life,' an online course meticulously crafted to guide you toward a fulfilling and joyous existence.     🌈 Discover the Secrets of Lasting Happiness 🌈 In this comprehensive course, you'll delve into the fundamental pillars that form the bedrock of a truly fulfilling life. From cultivating a positive mindset to nurturing meaningful relationships, managing stress, finding purpose, and achieving life balance, each module is expertly designed to empower you with practical tools and insights.     🧘‍️ Expert Guidance for a Fulfilling Life 🧘‍️ Led by renowned experts in psychology and personal development, this course distills years of research and wisdom into actionable steps. Gain valuable strategies to navigate life's challenges with resilience, foster genuine connections, and craft a life that aligns with your deepest values and aspirations. 🚀 What You'll Gain: Proven techniques to cultivate happiness in your daily life Strategies to manage stress and enhance emotional well-being Tools for nurturing meaningful relationships Insights to discover and live your life's purpose Skills to create a balanced and fulfilling lifestyle   🎓 Your Journey to Happiness Starts Now! 🎓 Join a community of like-minded individuals committed to their personal growth and happiness. Access the course materials anytime, anywhere, and proceed at your own pace. Take the first step towards a happier, more fulfilling life today! 🌟 Enroll Now and Embrace a Life of Happiness! 🌟 Invest in yourself and construct the pillars of happiness that will support you for a lifetime. Don't wait any longer to embark on this transformative journey-unlock the secrets to true contentment and fulfillment today! Course Curriculum Module- 1 00:00 Module- 2 00:00 Module- 3 00:00 Module- 4 00:00 Module- 5 00:00 Module- 6 00:00 Module- 7 00:00 Module- 8 00:00 Module- 9 00:00 Module- 10 00:00

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. Basic SAP BusinessObjects Universe Design Describing Universes Defining the Components of a Universe Data Connections Defining connections Data Foundations Creating Data Foundations Using Joins Business Layers Accessing Data through the Business Layer Integrating the Business Layer Components Validating Objects Creating Measure Objects Creating Shortcut Joins Loops in a Data Foundation Resolving Loops with Joined Tables Resolving Loops Using Aliases Resolving Loops Using Contexts Detecting Contexts Editing Contexts Testing Contexts Resolving Recursive Loops Data Restrictions Defining Data Restrictions Applying Mandatory Data Restrictions Applying Optional Data Restrictions Lists of Values (LOV) Providing a List of Values Parameters Illustrating Runtime Parameters Object @functions Using Object @functions in Queries Applying the Aggregate Awareness Optimization Method Using Other @ Functions Navigation Paths Defining Drill Down Navigation Paths Derived Tables Creating Derived Tables Key Awareness Defining Numeric Keys Universe Management with Data Foundation and Business Layer Views Managing a Universe using the Data Foundation View Managing a Universe using the Business Layer View Universe Optimization Optimizing Universes Using Parameters Universe Deployment and Security Deploying a Universe Securing a Published Universe Creating Data Security Profiles Creating Business Security Profiles Assigning Security Profiles to Users Identifying the Priority of Security Settings Updating a Published Universe SQL Clause Processing Problems Determining How the Order of SQL Clauses Affects Data Returned Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Identifying Fan Traps Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Outer Join Problem Resolution Resolving an Ambiguous Outer Join Using @AggregateAware Universe Creation from Different Data Sources Identifying the Different Data Sources Creating an OLAP Universe Creating a Multi-source Universe Shared Projects Using Shared Projects Manipulating Other Designers' Resources Universe Conversion Converting Existing .unv Universes Translation Deploying Universes in Different Languages

Description Appreciative Inquiry Diploma Embark on a transformative journey with the Appreciative Inquiry Diploma. This online course is designed to offer learners a deep understanding of Appreciative Inquiry, a strength-based approach that focuses on uncovering what's working well, and how to make it even better. The Appreciative Inquiry Diploma starts with an introduction to Appreciative Inquiry, providing a foundational insight into this empowering philosophy. It explains the basics of Appreciative Inquiry and sets the stage for the exploration of more complex topics. A key part of this course is the 4-D Model of Appreciative Inquiry. This essential segment helps the students grasp the framework of Discover, Dream, Design, and Destiny. These four phases allow learners to gain insights into the collaborative process and inspire them to create a shared vision and strategy for change. As the course progresses, learners are guided through the understanding of the power of positive questioning. This vital aspect of Appreciative Inquiry helps in focusing on possibilities and potentials, and students will learn how to craft questions that inspire creativity and innovation. The role of Appreciative Inquiry in leadership is another pivotal part of the Appreciative Inquiry Diploma. It teaches how leaders can use Appreciative Inquiry to enhance organizational success, foster a positive work environment, and nurture growth. Appreciative Inquiry and Team Building are intricately connected. The course elaborates on how this approach can promote trust, collaboration, and collective problem-solving within teams. As for the application of Appreciative Inquiry in change, the course explores how to use this method in various aspects of organizational change. It helps in aligning core strengths, values, and strategic goals to promote a harmonious transformation within an organization. Integrating Appreciative Inquiry in organizational settings is a multi-dimensional aspect covered in the course. It helps learners to understand how to incorporate the principles of Appreciative Inquiry in various organizational functions. Community development is another area where Appreciative Inquiry is highly effective. The Appreciative Inquiry Diploma details how this approach can create positive social change, foster community resilience, and enhance collective well-being. Looking towards the future, the course presents the future perspectives of Appreciative Inquiry. It allows learners to explore how this approach is evolving and what future applications might look like. Lastly, the conclusion of the Appreciative Inquiry Diploma offers an embracing view of Appreciative Inquiry. It summarises the course and encourages learners to apply these valuable insights in their personal and professional lives. This online course provides interactive learning modules, real-world examples, and engaging content. It's an excellent choice for professionals in management, human resources, coaching, counseling, or anyone interested in positive organizational development and change management. Enroll in the Appreciative Inquiry Diploma today and join a community of learners committed to positive growth and change. Discover the transformative power of Appreciative Inquiry and leverage it to create lasting impacts in your organisation and community. This is not just a course, but a pathway towards a more appreciative and fulfilling way of living and working. What you will learn 1:Introduction to Appreciative Inquiry 2:The 4-D Model of Appreciative Inquiry 3:Understanding the Power of Positive Questioning 4:Role of Appreciative Inquiry in Leadership 5:Appreciative Inquiry and Team Building 6:The Application of Appreciative Inquiry in Change 7:Integrating Appreciative Inquiry in Organizational 8:Appreciative Inquiry in Community Development 9:Future Perspectives of Appreciative Inquiry 10:Conclusion: Embracing Appreciative Inquiry Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Description Business Ethics Diploma The course title 'Business Ethics' unveils a unique opportunity to delve into the intricate world of ethical decision-making within the realm of business. This online programme offers a comprehensive analysis of the ethical dimensions that permeate all aspects of business, from handling conflicts to the delicate balance of marketing ethics. In the volatile arena of today's global business, this course provides valuable insights into how to navigate the tricky waters of ethical decisions. An exploration of 'Ethics in Business' serves as the foundation, instilling in participants a robust understanding of the various ethical dilemmas businesses frequently encounter. The 'Ethically Handling Conflicts' unit emphasises effective resolution strategies when confronted with conflicts of interest. Here, participants learn to ensure fairness, maintain trust, and establish a win-win situation for all stakeholders involved. The importance of ethical considerations in marketing cannot be overstated. The 'Ethics of Marketing' unit delves into responsible marketing practices and enlightens participants about the power and responsibility they hold in shaping consumers' behaviours and decisions. 'Public and Government Relationship Ethics' provides an insight into the delicate balance of power, obligation, and diplomacy. This segment informs participants about managing relationships with various stakeholders, including the government, with transparency and integrity. In today's corporate world, remuneration is a hotly debated topic. The 'Ethics of Remuneration' unit encourages participants to critically analyse remuneration systems, ensuring they are fair, equitable, and rightly rewarding. 'Discrimination' is an unignorable ethical issue in modern society. This course urges participants to not only acknowledge its existence but also to devise strategies to combat it, promoting a diverse and inclusive workplace. Environmental concerns have leapt to the forefront of business ethics in recent years. The 'Environmental Protection' unit underlines the role businesses play in conserving our planet, discussing sustainable practices and their implications on the business model. An ethical culture is crucial to the success and reputation of any organisation. The 'Establishing Ethical Culture' unit offers tools to foster an environment where ethical conduct is the norm, guiding the moral compass of the entire organisation. When operating in a multinational arena, the complexity of ethical dilemmas often intensifies. The 'Ethics in an MNC' unit addresses this challenge, providing practical advice for maintaining ethical conduct in various cultural and legal environments. Last but not least, the 'Universal Guideposts of Ethics' unit offers a look at the broader moral principles that govern ethical decisions, regardless of geographical or cultural differences. Here, participants get the chance to evaluate and reassess their own ethical values, encouraging personal growth as well as professional development. In conclusion, the 'Business Ethics' course presents a powerful exploration of the complex world of ethical decision-making in business. By providing a solid grounding in each of these diverse aspects of ethics, it offers participants the tools they need to conduct business with integrity, professionalism, and respect for all stakeholders involved. It's an invaluable resource for anyone eager to understand and apply ethical principles in the contemporary business world. This online course is not just about learning; it's about transforming one's outlook towards the ethical dimensions of business. Embark on this fascinating journey to decipher the conundrums of Business Ethics. What you will learn 1:Ethics in Business 2:Ethically Handling Conflicts 3:Ethics of Marketing 4:Public and Government Relationship Ethics 5:Ethics of Remuneration 6:Discrimination 7:Environmental Protection 8:Establishing Ethical Culture 9:Ethics in an MNC 10:Universal Guideposts of Ethics Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.