7087 Power courses delivered Online

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Implement OTA programming, FreeRTOS and deep sleep in the ESP32

Boost your career with our Diploma in Electrical Engineering! ⚡ This self-paced online course covers essential topics like circuits, electrical machines, and power systems, helping you gain industry-relevant skills and a certificate of completion. Enrol today and take the next step in your Electrical Engineering journey! 🔌📚

This personal development bundle is designed to help you enhance your communication skills, boost your motivation, and foster personal growth. With a focus on fundamental topics such as assertiveness, body language, and positivity, this bundle provides you with the necessary tools to achieve your objectives. By enrolling in these courses, you can experience the transformative power of personal growth and development. The bundle includes below courses: Improving Personal Effectiveness Emotional Intelligence Body Language Communication Basics Through these courses, you can acquire knowledge and practical skills to increase your effectiveness in your personal and professional life. You will learn how to manage your emotions, communicate effectively, and convey confidence through your body language. With these foundational skills, you can make meaningful progress towards your personal and career goals.

Embark on a journey of societal change through Sociowork. This course dives deep into the concept of intervention, spanning three levels of methods and traversing the phases of social work practice. Uncover the nuances of addressing privilege, power, and oppression, paving the way for a socially just practice. The course emphasizes evidence-based social work, guiding you to establish practices, explore real-world examples, and overcome barriers to implementation. After the successful completion of this lecture, you will be able to: Understand the concept of intervention in social work and its significance. Identify the three levels of social work intervention methods and their application. Comprehend the phases involved in the social work practice intervention process. Recognize the importance of addressing privilege, power, and oppression in social practice. Appreciate the significance of evidence-based social work and its role in improving practice. Learn how to establish evidence-based practices in the field of social work. Explore real-world examples of evidence-based practice in action. Gain insight into the barriers that can hinder the implementation of evidence-based practices. Develop innovative strategies to advance the field of social work. Delve into the intricacies of social work intervention, understanding its levels and phases. Address societal inequities through a lens of privilege, power, and oppression. Embrace evidence-based practices, learning to establish and implement them effectively. Gain insights from real-world examples and develop innovative strategies to propel the field of social work forward. Unlock the power of social intervention with Sociowork for Social Work Enhancement. From understanding intervention concepts to implementing evidence-based practices, this course empowers you to navigate societal complexities. Real-world examples and innovative strategies provide a holistic perspective, preparing you for impactful roles in various job designations. 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. Social Work Practice Enhancement Self-paced pre-recorded learning content on this topic. Social Work Enhancement 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. Social Intervention Specialist Practice Enhancement Coordinator Social Equity Advocate Intervention Program Manager Evidence-Based Practice Consultant Sociowork Innovator Social Justice Strategist Practice Improvement Officer 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.

The aim of this course is to provide an understanding of the intersection of law and ethics, including major ethical perspectives, ethical decision-making models, and the relationship between law and ethics. Students will learn about the importance of setting an ethical tone at the top of an organization and the ethical decision tree for business leaders. The course will cover the short- and long-term returns and the promotion of ethical behavior and social responsibility in the marketplace. Students will also gain knowledge about the history and basic framework of antitrust laws, including horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also explore antitrust enforcement, antitrust injury, limitations of antitrust enforcement, and antitrust considerations. After the successful completion of the course, you will be able to learn about the following, Law & Ethics: What Is Ethics? Major Ethical Perspectives. An Ethical Decision Model. Relationship b/w law and ethics. Ethical tone sets at the top. Ethical business leader decision tree. Tension b/w short- and long-term returns. Social Responsibility. Positive actions. Promoting ethical Behaviour. Moral of the marketplace. Antitrust: History and Basic Framework of Antitrust Laws. Horizontal Restraints of Trade. Vertical Restraints of Trade. Price Discrimination- The Robinson-Patman Act. Sherman Act, Section 2- Concentrations of Market Power. Acquisitions and Mergers under Section 7 of the Clayton Act. Unfair Methods of competition section 5 of the federal commission act. Antitrust enforcement. Antitrust injury. Limitations of antitrust enforcement. Antitrust considerations. This course aims to explore the intersection of law and ethics, with a particular focus on the major ethical perspectives and an ethical decision-making model. Students will examine the relationship between law and ethics and how ethical tone sets at the top of an organization. The course will cover topics such as the tension between short- and long-term returns, social responsibility, promoting ethical behaviour, and the morale of the marketplace. Additionally, students will learn about antitrust laws, including the history and basic framework of antitrust laws, horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also cover acquisitions and mergers under Section 7 of the Clayton Act, unfair methods of competition under Section 5 of the Federal Commission Act, antitrust enforcement, antitrust injury, and the limitations of antitrust enforcement. The aim of this course is to provide an understanding of the intersection of law and ethics, including major ethical perspectives, ethical decision-making models, and the relationship between law and ethics. Students will learn about the importance of setting an ethical tone at the top of an organization and the ethical decision tree for business leaders. The course will cover the short- and long-term returns and the promotion of ethical behavior and social responsibility in the marketplace. Students will also gain knowledge about the history and basic framework of antitrust laws, including horizontal and vertical restraints of trade, price discrimination, and concentrations of market power. The course will also explore antitrust enforcement, antitrust injury, limitations of antitrust enforcement, and antitrust considerations. VIDEO - 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. Concept and Implications of Ethics and Antitrust in Business Self-paced pre-recorded learning content on this topic. Concept and Implications of Ethics and Antitrust in Business 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. Ethics and Compliance Officer Antitrust Attorney Corporate Social Responsibility Manager Business Ethics Consultant Antitrust Investigator Compliance Analyst Risk Management Specialist Business Conduct and Ethics Trainer Antitrust Litigation Specialist Corporate Responsibility Coordinator 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.

Our training course is designed to equip you with the knowledge and skills needed to harness the full potential of LinkedIn.

Overview: Are you ready to elevate your expertise in high-voltage three-phase systems? Our comprehensive course, 'Short Circuit Analysis for HV Three Phase Systems,' is designed to empower electrical engineers, power system professionals, and anyone involved in the design and maintenance of high-voltage electrical networks.   Key Benefits: Specialized Knowledge: Gain in-depth insights into short circuit analysis specific to high-voltage three-phase systems. This course is tailored for professionals seeking specialized skills in analyzing and mitigating short circuits in complex electrical networks. Real-world Applications: Dive into practical scenarios and case studies, providing hands-on experience that directly applies to real-world situations. Acquire the skills needed to analyze short circuits in various industrial settings, ensuring you are well-equipped to handle challenges on the job. Cutting-Edge Techniques: Stay ahead of the curve by learning the latest techniques and methodologies in short circuit analysis. Understand how to use advanced software tools to simulate and analyze short circuits, allowing you to make informed decisions in system design and protection. Risk Mitigation: Learn strategies to identify potential risks associated with short circuits in high-voltage systems and implement effective protective measures. Minimize downtime, enhance system reliability, and ensure the safety of personnel and equipment within your electrical network. Expert Instruction: Benefit from the guidance of industry experts with extensive experience in high-voltage systems. Our instructors bring a wealth of knowledge to the table, providing valuable insights and practical tips to enhance your learning experience. Networking Opportunities: Connect with like-minded professionals, fostering valuable networking opportunities. Share experiences, exchange ideas, and build relationships within the industry, enriching your professional network for future collaborations and career advancements. Flexible Learning: Access the course content at your own pace with our online platform. Whether you're a working professional or a student, our flexible schedule allows you to balance your learning with other commitments.   Who Should Enroll: Electrical Engineers Power System Designers Maintenance Professionals Utility Engineers Electrical Consultants Students pursuing electrical engineering   Don't miss this opportunity to enhance your skills and become a go-to expert in Short Circuit Analysis for HV Three Phase Systems. Enroll now and power up your career! Course Curriculum Introduction To Short Circuit Analysis For Hv Three Phase Systems Course Introduction To Short Circuit Analysis For Hv Three Phase Systems Course 00:00 Short Circuit Fault Analysis Overview Short Circuit Fault Analysis Overview Per Phase Analysis Per Phase Analysis 00:00 Per Unit Analysis Per Unit Analysis 00:00 Change Of Base Change Of Base 00:00 Transformers Per Unit Analysis Transformers Per Unit Analysis 00:00 Symmetrical Components Symmetrical Components 00:00 Asymmetrical Three Phase Fault Analysis Asymmetrical Three Phase Fault Analysis 00:00 System Modeling System Modeling 00:00

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.