6971 Power courses delivered Online

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

Give a compliment to your career and take it to the next level. This HVAC, Fire Safety & First Aid will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this HVAC, Fire Safety & First Aid will help you keep ahead of the pack. The HVAC, Fire Safety & First Aid incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this HVAC, Fire Safety & First Aid will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the HVAC, Fire Safety & First Aid, you can equip yourself with the essentials to keep you afloat into the competition. Along with thiscourse, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Bundle Consists of the following Premium courses: Course 01: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Electricity & Circuit Analysis Level 3 Course 03: PAT Level 4 Course 04: Electric Power Metering for Single and Three Phase Systems Course 05: Energy Saving in Electric Motors Course 06: Electrical and Fire Safety Training - Level 2 Course 07: Digital Electric Circuits & Intelligent Electrical Devices Course 08: Fall Prevention During Working at Height Course 09: Manual Handling Level 2 Course 10: Emergency First Aid and Incident Management at Work Course 11: Time Management As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the HVAC, Fire Safety & First Aid to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this HVAC, Fire Safety & First Aid: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificates: Free (Previously it was £10*11= £110) Hard Copy Certificates: Free (Previously it was £20*11= £220) Curriculum of the Bundle Course 01: Level 3 Heating, Ventilation & Air Conditioning Technician Module 01: Introduction to Heating, Ventilation & Air Conditioning Module 02: Heating Fundamentals and Psychrometrics Module 03: HVAC Systems Module 04: Heating and Ventilation Module 05: Air Conditioning Systems for HVAC Technicians Module 06: Compressors, Water Chillers, and Fans Module 07: Piping for HVAC Technician Module 08: Duct System in HVAC Module 09: Refrigeration and Refrigerants Module 10: Special Applications Module 11: HVAC System Selection Module 12: Safety in the HVAC Industry Course 02: Electricity & Circuit Analysis Level 3 Ch - 00 Intro Basic Electricity Ch - 01 The Nature of Electricity Ch - 02 Conductors & Insulators Ch - 03 Current and Electric Circuits Ch - 04 Ohm's Law Ch - 05 Electric Power Ch - 06 Series & Parallel Circuits Ch - 07 Circuit Theorems Ch - 08 Electric Fields and Capacitance Ch - 09 Magnetism and Inductance Ch - 10 Transient Response Capacitors & Inductors Course 03: PAT Level 4 Module 01: Introduction to PAT Module 02: Relevant Statutory Provisions for PAT Module 03: Risk Assessment Module 04: Reducing and Controlling Risks Module 05: Electrical Units and Appliance Classification Module 06: Initial Visual Examination Module 07: Instruments for Testing and Equipment Inspection Module 08: Electrical Installation Testing Module 09: Safety Precautions in Electrical Testing Module 10: Reporting and Record-keeping Course 04: Electric Power Metering for Single and Three Phase Systems Module 01: Basic Metering Introduction Module 02: Power & Energy Module 03: AC Power Module 04: Instrumentation Module 05: Single Phase Metering Module 06: Instrument Transformers Module 07: Three Phase Metering Module 08: Cross Wattmeter Verification Course 05: Energy Saving in Electric Motors Module 01: Introduction Module 02: Classification Module 03: Terminologies Module 04: Losses Module 05: Energy saving in motors part I Module 06: Energy saving in motors part II Module 07: Energy saving in motors Part III Module 08: Energy saving in motors part IV Module 09: Energy saving in motors part V Module 10: Energy Efficient Motor Course 06: Electrical and Fire Safety Training - Level 2 Module 01: Introduction and Basics Module 02: Introduction to Fire Safety Module 03: Voltage and Resistance Module 04: Capacitance and Capacitors Module 05: Safety Precautions Module 06: Fire Safety Legislation And Much More..... Course 07: Digital Electric Circuits & Intelligent Electrical Devices Module 01: Introduction Module 02: Numbering Systems Module 03: Binary Arithmetic Module 04: Logic Gates Module 05: Flip-Flops Module 06: Counters & Shift Registers Module 07: Adders Course 08: Fall Prevention During Working at Height Fall Prevention During Working at Height Module 01: Introduction, Regulations and Duties Module 02: Risk Assessment and Prevention Module 03: Work at Height Equipment Course 09: Manual Handling Level 2 Introduction, Legislation and Guidance Manual Handling Hazards and Injuries Manual Handling Risk Assessments Controlling and Reducing the Risks Safe Lifting Techniques Course 10: Emergency First Aid and Incident Management at Work Introduction Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 11: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in thisbundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our HVAC, Fire Safety & First Aidis 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 Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

🚀 Unlock the Power of Steemit and Earn Steem with 'Cryptoception' 🌟 Are you ready to dive into the world of cryptocurrency and leverage the incredible potential of Steemit to earn Steem? Look no further! Introducing 'Cryptoception,' your gateway to mastering Steemit and maximizing your earnings in the ever-evolving crypto sphere. 🔥 What is 'Cryptoception' all about? 🔥     This comprehensive online course is your ultimate guide to harnessing the power of Steemit, the revolutionary social media platform built on blockchain technology. Led by industry experts and seasoned Steemit enthusiasts, 'Cryptoception' is designed to equip you with the knowledge and strategies needed to navigate Steemit effectively and earn Steem like a pro. 📈 What You'll Learn:   Understanding Steemit: Dive deep into the mechanics of Steemit, comprehend its blockchain structure, and grasp the dynamics of earning through content creation, curation, and engagement. Optimizing Your Content: Learn insider tips and tricks to create engaging and rewarding content that attracts attention, gains followers, and ultimately boosts your earnings. Monetization Strategies: Explore various monetization techniques, including leveraging Steem Power, exploring communities, and utilizing smart strategies to maximize your rewards. Navigating the Steemit Ecosystem: Gain insights into the diverse opportunities within Steemit, including DApps, tokens, and the broader crypto ecosystem connected to Steem. Risk Management and Security: Understand the importance of security measures, risk management, and safeguarding your assets in the crypto world. 💡 Why 'Cryptoception' Stands Out:   Expert Guidance: Learn from industry experts who have navigated the intricacies of Steemit and earned significant rewards. Practical Insights: Gain actionable strategies and practical advice you can implement immediately to enhance your Steemit journey. Community Support: Join a vibrant community of like-minded individuals, exchange ideas, and grow together on your Steemit journey. 🌐 Don't Miss Out on Your Chance to Earn with Steemit! Enroll in 'Cryptoception' Today! 🌐 Join the ranks of successful Steemit users who have unlocked the potential of earning Steem while engaging with a thriving online community. Take charge of your crypto journey and turn your content into valuable rewards! Course Curriculum

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Dive into the fascinating world of politics and international relations with our expansive course bundle, where the intricate dance of power, policy, and diplomacy comes alive. This collection offers a panoramic view of political studies, from the nuanced dynamics of UK and US politics to the global impact of international relations and human rights. It's an intellectual odyssey that stretches beyond borders, tapping into economics, environmental law, and even the echoes of military history. This bundle is a gateway to understanding the complex mechanisms that shape our world. Here, the pursuit of knowledge meets the mastery of skills, empowering you to navigate and influence the ever-evolving political landscape. Whether you're aspiring to be a policy maker, an advocate for change, or a connoisseur of global affairs, this course is your stepping stone. Embark on this educational journey, enrich your understanding, and be part of the change you wish to see. Enrol now and transform your curiosity into expertise. This Virtual Assistant, Digital Marketing & Social Media Manager Bundle consists of the following 20 CPD Accredited Premium courses - Course 01: Basic Social Media Marketing Course 02: Virtual Assistant Course 03: Digital Marketing Course 04: Unlocking the Power of Google Adwords for Digital Marketing Course 05: Facebook Marketing for Business Course 06: Instagram Marketing Course 07: ETSY Marketing and Business Course 08: Linkedin Marketing Course 09: Sales and Strategic Marketing Course 10: Sales Training: Practical Sales Techniques Course 11: Visual Merchandising Course 12: Affiliate Marketing Course 13: Email Etiquette Course 14: Lead Generation with Attraction Marketing for Business Course 15: Effective Remote Working Course 16: SEO Masterclass Course 17: Principles of Marketing Course 18: Shopify: A step by Step Guide to Creating an Online Store Course 19: Copywriting Course 20: Content Writing 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Effective Communication Skills Diploma Course 02: Business Networking Skills Course 03: Influencing and Negotiation Skills Course 04: Delegation Skills Training Course 05: Time Management Course 06: Leadership Skills Training Course 07: Decision Making and Critical Thinking Online Course Course 08: Emotional Intelligence and Social Management Diploma Course 09: Assertiveness Skills Course 10: Touch Typing Complete Training Diploma Learning Outcomes Here's what you'll gain from this comprehensive course bundle: Understand the key differences and similarities in UK and US politics. Acquire knowledge in international relations and global development. Gain insights into economic theories and their real-world applications. Explore the impact of environmental law on policy-making. Develop skills in self-esteem and assertiveness for effective leadership. Learn about the historical context and contemporary issues in human rights. Our course bundle provides a thorough grounding in political studies, equipping learners with a deep understanding of various political systems, especially focusing on the UK and USA. Through the Comparative Politics course, you'll delve into the workings of these two major political powerhouses. The UK Government Policies and Procedures course offers an inside look at the mechanisms of governance in the UK. The International Relations and International Development diplomas broaden your perspective, introducing you to the complexities of global politics and economics. The inclusion of Environmental Law and Environmental Health courses reflects the increasing importance of sustainable practices in policy-making. Moreover, the unique combination of courses like Self Esteem & Assertiveness and Organisation & People Management ensures that you're not just academically equipped but also personally prepared to lead and influence in the political arena. This comprehensive curriculum is designed to provide a well-rounded education in political studies, preparing you for a future as an informed and effective participant in the political and global landscape. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for: Individuals aspiring to careers in politics or government. Students and graduates in political science or international relations. NGO workers and activists focusing on human rights and development. Professionals in public relations and organizational management. Economists and environmental law enthusiasts. Those interested in military history and global affairs. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Virtual Assistant, Digital Marketing & Social Media Manager course, all you need is - A smart device A secure internet connection And a keen interest in Virtual Assistant, Digital Marketing & Social Media Manager Career path A range of rewarding career opportunities awaits in the UK: Political Analyst: •35,000 - •45,000 per annum International Relations Specialist: •30,000 - •40,000 per annum Human Rights Officer: •27,000 - •37,000 per annum Environmental Policy Advisor: •32,000 - •42,000 per annum Public Relations Manager: •28,000 - •40,000 per annum Economic Consultant: •33,000 - •48,000 per annum Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

In this course, you will learn how to perform data cleaning and data preparation with KNIME and without coding. You should be familiar with KNIME as no basics are covered in this course. Basic knowledge of machine learning is certainly helpful for the later lectures in this course.

Overview With the ever-increasing demand for Positive Psychology in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Positive Psychology may be. Learning about Positive Psychology or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Positive Psychology . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Positive Psychology is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Positive Psychology course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Positive Psychology course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Positive Psychology course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Positive Psychology , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Positive Psychology , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Positive Psychology , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Positive Psychology course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Introduction to Positive Psychology Introduction to Positive Psychology 00:00 Module 2 The Science of Positive Emotions The Science of Positive Emotions 00:00 Module 3 Understanding and Developing Character Strengths Understanding and Developing Character Strengths 00:00 Module 4 Positive Relationships and Social Connection Positive Relationships and Social Connection 00:00 Module 5 Cultivating a Growth Mindset Cultivating a Growth Mindset 00:00 Module 6 The Power of Mindfulness The Power of Mindfulness 00:00 Module 7 The Power of Gratitude The Power of Gratitude 00:00

This Digital Electronics Course is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment. Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.

Exhilarating and empowering dance classes based on neuroscience and designed specifically for individuals living with Parkinson's disease. These dynamic and fun-filled 8 week program aims to enhance physical mobility, mental well-being, and social interaction.

Analytical statistical elements are essential concepts in the design of clinical trials. This analysis helps us to understand whether a conclusion from a study of a sample of the target population applies generally to that population as a whole. In particular, it helps us to answer the question: Did the treatment effect in the given study occur just by chance? The statistical elements of a well-controlled study minimise the chances of drawing the wrong conclusions, by providing clear thresholds for such errors. The basic statistical elements of a clinical trial include eligibility criteria, randomisation, sample size, power, and blinding, and these are discussed in this short course.