20728 Courses

Delve into the world of electronics with our 'Electronic Device Maintenance and Troubleshooting Course.' This programme is meticulously crafted to transform beginners into proficient troubleshooters and maintenance experts of electronic devices. Starting with an introductory section, the course familiarises learners with the basics, setting a strong foundation for more complex topics. As you progress, the curriculum delves deeper into the intricate world of electronic and electrical maintenance, equipping you with the knowledge to handle a wide array of electronic devices. The course is segmented into comprehensive sections, each focusing on a critical aspect of electronic maintenance. You will learn about essential tools, dive into the complexities of electronic components, and master the skills of testing and troubleshooting. The highlight of the programme is a detailed guide on electronic components, presented in an easy-to-follow, step-by-step format. This course is not just about theoretical knowledge; it's an invitation to a hands-on journey where each module builds your confidence and skills, preparing you for real-world applications. Learning Outcomes Gain foundational knowledge in electronic device maintenance. Understand the various tools required for electronic repairs. Learn about different electronic components and their functions. Develop skills in testing electronic devices and components. Master the techniques of troubleshooting electronic malfunctions. Why choose this Electronic Device Maintenance and Troubleshooting 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 Electronic Device Maintenance and Troubleshooting Course for? Enthusiasts eager to delve into the field of electronic maintenance. Individuals aspiring to build a career in electronic device repair. Hobbyists looking to enhance their skills in electronics troubleshooting. Professionals seeking to update and expand their electronic repair knowledge. Students and apprentices aiming to gain practical insights into electronic maintenance. Career path Electronic Repair Technician: £20,000 - £30,000 Maintenance Engineer: £25,000 - £35,000 Technical Support Specialist: £22,000 - £32,000 Field Service Technician: £23,000 - £33,000 Electronics Engineer: £28,000 - £38,000 Instrumentation Technician: £24,000 - £34,000 Prerequisites This Electronic Device Maintenance and Troubleshooting Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electronic Device Maintenance and Troubleshooting 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 1: Introduction & Getting Started Unit 1: Introduction 00:02:00 Unit 2: Instructor's Introduction 00:05:00 Section 2: Electronic and Electrical maintenance Repair Unit 1: Becoming a Troubleshooter 00:02:00 Section 3: Tools Needed Unit 1: Tools Needed 00:01:00 Unit 2: Multimeters 00:07:00 Unit 3: Wire Cutter and Stripper 00:03:00 Unit 4: Wiring Tools Soldering Iron 00:02:00 Unit 5: Screw Drivers 00:03:00 Unit 6: Pliers 00:02:00 Unit 7: Wrench 00:02:00 Unit 8: Oscilloscope and Function Generator 00:03:00 Section 4: Electronic Components Unit 1: Passive Electronic Components 00:03:00 Unit 2: Active Electronic Component Diode 00:03:00 Unit 3: Active Electronic Component Transistor 00:03:00 Unit 4: Common Electronic and Electrical Components 00:05:00 Section 5: Testing Unit 1: Testing a Fuse 00:03:00 Unit 2: Testing a Bulb or Lamp 00:02:00 Unit 3: Testing a Switch 00:01:00 Unit 4: Testing a Transformer 00:04:00 Unit 5: Testing a Resistance 00:08:00 Section 6: Troubleshooting Unit 1: Safety Concerns 00:05:00 Unit 2: Main Concerns - Maintenance 00:02:00 Unit 3: Main Concerns - Servicing 00:02:00 Unit 4: Troubleshooting Part - 1 00:03:00 Unit 5: Troubleshooting Part - 2 00:04:00 Section 7: Introduction to Electronic Components: A Step by Step Guide Unit 1: Introduction 00:05:00 Unit 2: Voltage Current and Resistance 00:06:00 Unit 3: Types of Current 00:03:00 Unit 4: Types of Circuits 00:02:00 Unit 5: Practical: Introduction to Digital Multimeter DMM 00:07:00 Unit 6: Volt Ohm Meter Basics 00:05:00 Unit 7: Measuring Voltage 00:13:00 Unit 8: Practical: How to Measure DC Voltage 00:03:00 Unit 9: Measuring Current 00:05:00 Unit 10: Measuring Currents - Lab Experiment Explained 00:11:00 Unit 11: Practical 1: How to Measure Current 00:04:00 Unit 12: Practical 2: How to Measure Current 00:01:00 Unit 13: Measuring Resistance 00:08:00 Unit 14: Practical: How to Test Resistors 00:05:00 Unit 15: Circuit Diagram Basics and Basic Symbols 00:12:00 Unit 16: Introduction to Resistor and Color Band Coding 00:09:00 Unit 17: Power Dissipation + Parallel and Series Resistors 00:12:00 Unit 18: Ohm's Law 00:14:00 Unit 19: Introduction to Capacitors 00:11:00 Unit 20: Capacitors Behavior + Capacitors in Series and Parallel 00:07:00 Unit 21: Practical 1: How to Test a Capacitor 00:03:00 Unit 22: Practical 2: How to Test A Capacitor 00:02:00 Unit 23: Introduction to Inductors 00:07:00 Unit 24: Practical: How to Test and Measure Coils 00:06:00 Unit 25: Introduction to Diode + Zener Diode and LED 00:08:00 Unit 26: Practical 1: How to Test a Diode 00:02:00 Unit 27: Practical 2: How to Test a Diode 00:02:00 Unit 28: Introduction to Transistors 00:10:00 Unit 29: Practical 1: How to Test a Transistor 00:04:00 Unit 30: Practical 2: How to Test a Transistor 00:04:00 Unit 31: Practical 3: How to Test a Transistor 00:03:00 Assignment Assignment - Electronic Device Maintenance and Troubleshooting Course 00:00:00

Are you looking to improve your current abilities or make a career move? Our unique Screenwriting and Screenplay Training Course might help you get there! Expand your expertise with high-quality training - study the Screenwriting and Screenplay Training and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through this online training course. This course is CPD accredited, and this program allows you to get trained at your own pace and get accredited in just 6 hours. This course is designed for both part-time and full-time students. Tons of learners around the UK have taken this course to boost their knowledge and skill to work in the related field. This course is developed by industry experts and packed with several insightful modules to give you a proper understanding of this topic and accelerate your career. Expert tutor support and 24/7 customer support are what you're going to get with this premium quality course. You will get help and answers to all your queries throughout the comprehensive syllabus of this training. Anyone can easily verify your skill by checking the validity of your certificate from our dedicated website. Key Topics to Be Covered How to find motivation and ideas Structure and format of screenwriting character building and dialogue How to conduct research and development for screenwriting Screenwriting and the British Film industry explained How much UK screenwriters earn explained Learning Outcomes Learn how to turn ideas into a screenplay Ability to find motivation and ideas for screenwriting Understand the importance of research and development in screenwriting Learn techniques to structure and format screenwriting Learn step by step techniques to polish your screenplay Develop an in-depth understanding of the British film industry and screenwriting This Screenwriting and Screenplay Training is designed by industry experts and will give you a thorough understanding of that industry. Our courses are designed with easy to understand modules that break down each topic and gives our learners proper training on the subject. If you want to work in this sector and stand out from the rest of the competition, then our training course is the perfect place to start. We guarantee that you will gain relevant skill and will gain tremendous knowledge of Screenwriting and Screenplay. And the skillset that you achieve after completing the course will help you greatly in procuring a job in the relevant field. Enjoy a pleasant learning experience with the Academy for Health & Fitness. Enrol in our Course Today! Skills You Will Gain Excellent ability to write a compelling screenplay Ability to structure and format screenwriting Ability to market screenwriting ideas successfully Develop skills to turn ideas into a screenplay Excellent ability to create compelling characters and dialogue Why should you choose the Screenwriting and Screenplay Training course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this training course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging contents and activities Assessments that measure higher-level thinking and skills Complete the training program in your own time, at your own pace Each of our students gets full 24/7 tutor support Course Curriculum: Module 1: Introduction to Screenwriting Backstory Cinematic Vs. Televisual On The Road Module 2: Motivation & Ideas Motivation Finding Your Voice Art vs Craft Discipline Routine For Whom Do You Write? Script Readers Ideas The Value of Ideas Inspiration Generating Ideas Capturing Ideas Ideas & Marketing Module 3: Research & Development Research Never Stops Know Your Market Research Tools The Language Barrier Development Developing Your Research Premise High Concept & Low Concept Pre-writing Module 4: Genre The Importance of Genre Familiar Genres Genre Evolution Conventions & Motifs Using Genre Five Genre-Defining Movies Module 5: Story & Plot Understanding Story & Plot Story, Character, Incident, Structure Theme Conflict & Tension Building & Releasing Tension Reversing Expectation Ellipsis Screen Time & Narrative Time Start at the End Great Scenes Plot Sub-Plots Exposition Five Great Plots to Study Module 6: Character & Dialogue The Puppet Master Giving Characters Life Protagonist & Antagonist Example: Quiz Show Goal-Driven Protagonist Passive Protagonist Insiders Outsiders Example: Made In Heaven Empathy & Sympathy Credibility Fears and Ghost Plural- & Multiprotagonists Protagonist & Structure Antagonist Character Intros Character Traits & Accessories Dialogue First Things Last Less Is More No Conversation Do & Don'ts Module 7: Structure & Format Structure Art-Film Narrative Three-Act Structure Act I: Set-Up/Situation/Establishment Act II: Complication/Development/Plot Act III: Climax & Resolution/Conclusion Utilising Structure Scenes & Sequences Format Screenplay Format Expectations Title Page Layout Module 8: Synopses, Outlines & Treatments Problems of Semantics Synopses Outlines Treatments Module 9: Drafts First Draft Counterfeit Copyright Rewriting Second Opinions Final Polish Module 10: Marketing Selling Yourself UK & US Markets Approaching the Business: Agents Other Business Pitching Deals Best Wishes Module 11: Troubleshooting Self-Diagnosis Script Appraisals Ten Common Problems Ten Handy Hints Five Common Problems Troubleshooting 10-Point Checklist Module 12: Glossary Section: Screenwriting in the UK Module 13: Screenwriting and the British Film Industry British Film Industry - A Writer's View Key Relationships Agent Director Producer Working Together In Development Module 14: Agreements Existing Agreements Definitions Business Terms Writing Terms Screen Credit Arbitration Other Disputes New Media Comparison of New Media Agreements Joint Venture Agreement Module 15: How Much Do UK Screenwriters Earn? Components of a Deal UK Film Pay The Bbc ITV Module 16: Greatest British Screenwriters of All Time Bruce Robinson Michael Powell and Emeric Pressburger Jane Goldman Peter Morgan Christopher Nolan (& Jonathan Nolan) Mike Leigh Julian Fellowes Tom Stoppard Richard Curtis Dennis Potter (1935-1994) Assessment Process Once you have completed all the modules, your skills and knowledge will be tested with an automated multiple-choice assessment, after which you will receive instant results. Show off Your New Skills: Get a Certification of Completion The learners have to successfully complete the assessment of this course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Who is this course for? This Course is ideal for People looking to develop their understanding and expertise in Screenwriting and Screenplay People aspiring to work as a professional creative writer Anyone looking to learn a new skill or acquire some knowledge Is This Screenwriting and Screenplay Training Course Right for You? This Training course is ideal for anyone who's interested in screenwriting and wants to learn more about it. This Training will help you get a strong understanding of the core concepts and will allow you to gain in-depth knowledge of the subject matter. This course is suitable for everyone. There are no specific entry requirements and you can access the course materials from anywhere in the world. Requirements There are no previous knowledge requirements for the Screenwriting and Screenplay program; this is open to anyone! Any learning enthusiast from anywhere in the world can enrol in this course without any hesitation. All students must have a passion for learning and literacy, as well as being over the age of 16. Browse this course 100% online from any internet device, including your computer, tablet or smartphone. Study at your own pace and earn an industry-recognised skillset with this Screenwriting and Screenplay course. Career path This course will help you to kickstart or take your career in the screenwriting sector to the next level. It will help you achieve a position of respect and dignity and you will be able to get ahead of the competition. The Training certificate will add significant weight to your CV and will help you in procuring jobs in the relevant sector.

If you want to get a deep insight into this topic and start a career in this sector, this popular Epidemic and Pandemic: Awareness & Safety Course is a perfect choice. This Epidemic and Pandemic: Awareness & Safety Course is approved by CPD. You can study at your own pace and get accredited in just 6hours. This course is designed for both part-time and full-time students. Tons of learners around the UK have taken this course to boost their knowledge and skill to work in the related field. This is developed by industry experts and is packed with several information-rich modules to properly understand this topic and accelerate your career. Expert tutor support and 24/7 customer support are what you're going to get with this premium quality course. You will get help and answers to all your queries throughout the comprehensive syllabus of this Epidemic and Pandemic: Awareness & Safety Course. You or your employer can check the validity of your certificate with ease on our dedicated website. Key Topics to Be Covered in this Epidemic and Pandemic: Awareness & Safety Course What are pandemics and epidemics? An introduction to coronavirus SARS & MERS transmission, prevention & treatment Zoonotic diseases explained HIV, influenza, Ebola & other pandemic outbreaks Learning Outcomes of this Epidemic and Pandemic: Awareness & Safety Course Understanding of the differences between epidemics and pandemics Excellent understanding of coronavirus symptoms and prevention measures Awareness of how zoonotic diseases are transmitted to humans Knowledge of HIV, SARS, MERS, ebola and other widespread diseases Ability to implement correct safety measures for infection prevention understanding of how diseases spread and the global impact of pandemics This Epidemic and Pandemic: Awareness & Safety Course is designed by industry experts and will give you a thorough understanding of this topic. Our courses are designed with easy to understand modules that break down each topic and give our learners proper training on the subject. If you want to work in this sector and stand out from the rest of the competition, then our Epidemic and Pandemic: Awareness & Safety Course is the perfect place to start. We assure you that you will gain relevant skills and acquire tremendous knowledge on the subject. The certification you achieve after completing the course will help you greatly in procuring a job in the relevant field. Enjoy a pleasant learning experience with the Academy for Health & Fitness. Enrol in our Epidemic and Pandemic: Awareness & Safety Course Today! Skills You Will Gain Up-to-date knowledge and information Healthcare and hygiene awareness Disease prevention & control Why should you choose the Epidemic and Pandemic: Awareness & Safety Course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this Epidemic and Pandemic: Awareness & Safety Course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the Epidemic and Pandemic: Awareness & Safety Course program in your own time, at your own pace Each of our students gets full 24/7 tutor support Course Curriculum: Module 01: Introduction to Pandemics Topics to be Covered: What are Pandemics and Epidemics? Coronavirus: Pandemic or Epidemic? Pandemic, Epidemic Dilemma Suitable Fields for the Diseases to Spread Approaches to Stop the Outbreaks from Various Ends Module 02: Pandemics: Risks, Impacts, and Mitigation Topics to be Covered: Definition of Pandemics Risks of Pandemics Impacts of Pandemics Mitigation of Pandemics Module 03: The SARS - MERS Factors Topics to be Covered: SARS (Severe Acute Respiratory Syndrome) SARS Transmission Risk for Travelers Nature of the Disease Risk Factors for SARS MERS (Middle East Respiratory Syndrome) Symptoms of MERS Source of the Virus MERS Transmission Prevention and Treatment Healthcare Facilities Travel Similarities and Differences in Disease Camels may not be to Blame Virus's Comfort Zone Approach to the Epidemic Module 04: The Novel Coronavirus (2019-nCoV) 2020 Version of the SARS Topics to be Covered: Brief Details on Nov Corona The Naming The Inventor We are Responsible Risk Assessment Ro, Reproductive Number Fatality Rate (case fatality ratio or CFR) of the Wuhan Coronavirus How does it Spread? If a case is Identified in the Community New Coronavirus may Spread through Poop Precautions Symptoms The Best Ways to Protect Yourself from this Deadly Virus More Prevention Tips Following more Tips will Decrease Health Risk Hand Washing: Easy Hacks Module 05: Zoonotic Diseases Topics to be Covered: Zoonotic Diseases: Disease Transmitted from Animals to Humans Types Examples of Zoonotic Diseases How they are Transmitted: What to do if you have a zoonotic disease? High-risk Individuals Include: Transmission rate Why do the Zoonotic Infections Matter? Challenges of Managing Zoonotic Infections Upcoming Perspectives Module 06: Pandemic Outbreaks from History(HIV/Aids) Topics to be Covered: What is HIV? Origin of HIV How did the Virus Spread? Risk Assessment Facts of HIV Transmission Symptoms HIV Prevention Module 07: Pandemic Outbreaks from History (Influenza) Topics to be Covered: Definition of Influenza History of the Viral Outbreak Causes Symptoms of the Disease Treatment Prevention Procedures Module 08: Pandemic Outbreaks from History (Nipah Virus) Topics to be Covered: Origin and History of the Virus Caused Outbreak Transmission Process Signs and Symptoms Risk of Exposure Diagnosis Methods Treatment for the Disease Prevention of the Virus Module 09: Pandemic Outbreaks from History (Smallpox) Topics to be Covered: What is Smallpox? History of Smallpox Transmission of the Smallpox Virus Signs and Symptoms Prevention and Treatment Module 10: Pandemic Outbreaks from History (Viral Meningitis) Topics to be Covered: What is Viral Meningitis? Causes People at Risk How it Spreads Symptoms Diagnosis Treatment Prevention Module 11: Pandemic Outbreaks from History (Ebola Virus) Topics to be Covered: What is Ebola Virus Disease? History of Ebola Virus Disease Transmission Process Signs and Symptoms of Ebola Prevention and Vaccine Module 12: Pandemic Outbreaks from History (Zika Virus) Topics to be Covered: What is Zika? Symptoms, Testing, & Treatment Zika Transmission Protect Yourself & Others from Zika Virus Module 13: Pandemic Outbreaks from History (Plague) Topics to be Covered: Key Facts about the Plague Signs and Symptoms Where is Plague Found? Diagnosing Plague Managing Plague Outbreaks Surveillance and Control WHO Response Module 14: Mild Threats to Human-Being Topics to be Covered: Hendra Virus Infection Lassa fever Rift Valley Fever Dengue Yellow Fever Hantavirus Anthrax Module 15: Pandemic Risks and Consequences Topics to be Covered: Pandemic Risk Factors Burden of Pandemics Consequences of Pandemics Module 16: Pandemic Mitigation: Preparedness and Response Topics to be Covered: Situational Awareness Preventing and Extinguishing Pandemic Sparks Risk Communications Care and Treatment to Reduce the Severity of Pandemic Illness Risk Transfer Mechanisms Conclusions and Recommendations for Prioritising Investments to Mitigate Pandemic Risk in Resource-Limited Settings Assessment Process Once you have completed all the modules in this course, your skills and knowledge will be tested with an automated multiple-choice assessment, after which you will receive instant results. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to complete the assessment of this Course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Epidemic and Pandemic: Awareness & Safety Course Right for You? This course is essential for everyone - a must for those who wish to gain a deeper understanding of how pandemics and epidemics occur, disease awareness and best practices. There are no specific entry requirements for the course; it is for anyone who wishes to gain and spread awareness of disease outbreak prevention. Career path On successful completion, you will be able to demonstrate an in-depth understanding of disease prevention and control, with knowledge of how diseases spread and the different types of pandemic diseases. You will also have the opportunity to work in a broad range of professions, including: Nurses, Healthcare professionals, Pharmacists Caregivers etc.

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 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. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Overview This DevOps Fundementals: Maven and SonarQube for Engineers course will unlock your full potential and will show you how to excel in a career in DevOps Fundementals: Maven and SonarQube for Engineers. So upskill now and reach your full potential. Everything you need to get started in DevOps Fundementals: Maven and SonarQube for Engineers is available in this course. Learning and progressing are the hallmarks of personal development. This DevOps Fundementals: Maven and SonarQube for Engineers will quickly teach you the must-have skills needed to start in the relevant industry. In This DevOps Fundementals: Maven and SonarQube for Engineers Course, You Will: Learn strategies to boost your workplace efficiency. Hone your DevOps Fundementals: Maven and SonarQube for Engineers skills to help you advance your career. Acquire a comprehensive understanding of various DevOps Fundementals: Maven and SonarQube for Engineers topics and tips from industry experts. Learn in-demand DevOps Fundementals: Maven and SonarQube for Engineers skills that are in high demand among UK employers, which will help you to kickstart your career. This DevOps Fundementals: Maven and SonarQube for Engineers course covers everything you must know to stand against the tough competition in the DevOps Fundementals: Maven and SonarQube for Engineers field.  The future is truly yours to seize with this DevOps Fundementals: Maven and SonarQube for Engineers. Enrol today and complete the course to achieve a DevOps Fundementals: Maven and SonarQube for Engineers certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the DevOps Fundementals: Maven and SonarQube for Engineers course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the DevOps Fundementals: Maven and SonarQube for Engineers course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the DevOps Fundementals: Maven and SonarQube for Engineers course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This DevOps Fundementals: Maven and SonarQube for Engineers is suitable for anyone aspiring to start a career in DevOps Fundementals: Maven and SonarQube for Engineers; even if you are new to this and have no prior knowledge on DevOps Fundementals: Maven and SonarQube for Engineers, this course is going to be very easy for you to understand.  And if you are already working in the DevOps Fundementals: Maven and SonarQube for Engineers field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this DevOps Fundementals: Maven and SonarQube for Engineers course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This DevOps Fundementals: Maven and SonarQube for Engineers course has no prerequisite.  You don't need any educational qualification or experience to enrol in the DevOps Fundementals: Maven and SonarQube for Engineers course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online DevOps Fundementals: Maven and SonarQube for Engineers course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Introduction to Maven 00:01:00 Topics Covered in this Course 00:03:00 How Maven Helps to a DevOps Engineer 00:02:00 Resource to Start 00:01:00 Setup Maven Environment on Windows Setup Maven Environment on Windows 00:01:00 Java Installation on Windows 00:05:00 Eclipse Installation 00:03:00 Create 1st Maven Project 00:04:00 Maven Coordinates 00:07:00 Default Directory Structure 00:03:00 Steps Involved to Build a Java Project 00:02:00 Maven Goals 00:06:00 Maven Goals in Action 00:07:00 Maven Goals, Repositories What is pom.xml and How it Works 00:05:00 About the Section 00:02:00 Maven Repositories 00:06:00 Maven goals - Deploy Goal for Local Repository 00:03:00 Push Maven Project onto GitHub 00:08:00 Maven on Linux Create an EC2 Instance 00:04:00 Prerequisites to Setup Maven 00:05:00 Setup Maven 00:04:00 Build Maven Project on Linux 00:10:00 Common Maven Goals 00:03:00 Create a Project with Maven Archetype 00:06:00 Plugins and dependencies in pom.xml 00:09:00 Settings.xml file 00:03:00 Tomcat Server Configurations 00:05:00 Deploy war on Tomcat Server 00:10:00 Maven in DevOps workflow Maven in DevOps workflow 00:01:00 Jenkins Installation 00:07:00 Add Maven Build Server as an Agent to Jenkins 00:07:00 Build Jenkins Job on Slave Node 00:07:00 Build a war file on Agent Node (Maven Server) 00:04:00 Additional Resources Create an AWS account 00:06:00 Install Git bash 00:03:00 Connect to a Linux with Mobaxterm 00:04:00 Install Tomcat 00:11:00 SonarQube SonarQube Introduction 00:07:00 SonarQube Installation 00:11:00 SonarQube Console Overview 00:14:00 SonarQube Installation with PostgreSQL Database 00:29:00 SonarQube Integration with Jenkins 00:15:00

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00

Overview This The Complete SQL : Bootcamp course will unlock your full potential and will show you how to excel in a career in The Complete SQL : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in The Complete SQL : Bootcamp is available in this course. Learning and progressing are the hallmarks of personal development. This The Complete SQL : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry. In This The Complete SQL : Bootcamp Course, You Will: Learn strategies to boost your workplace efficiency. Hone your The Complete SQL : Bootcamp skills to help you advance your career. Acquire a comprehensive understanding of various The Complete SQL : Bootcamp topics and tips from industry experts. Learn in-demand The Complete SQL : Bootcamp skills that are in high demand among UK employers, which will help you to kickstart your career. This The Complete SQL : Bootcamp course covers everything you must know to stand against the tough competition in the The Complete SQL : Bootcamp field.  The future is truly yours to seize with this The Complete SQL : Bootcamp. Enrol today and complete the course to achieve a The Complete SQL : Bootcamp certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the The Complete SQL : Bootcamp course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the The Complete SQL : Bootcamp course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the The Complete SQL : Bootcamp course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This The Complete SQL : Bootcamp is suitable for anyone aspiring to start a career in The Complete SQL : Bootcamp; even if you are new to this and have no prior knowledge on The Complete SQL : Bootcamp, this course is going to be very easy for you to understand.  And if you are already working in the The Complete SQL : Bootcamp field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this The Complete SQL : Bootcamp course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This The Complete SQL : Bootcamp course has no prerequisite.  You don't need any educational qualification or experience to enrol in the The Complete SQL : Bootcamp course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online The Complete SQL : Bootcamp course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum overview 00:04:00 Overview of Databases 00:08:00 SQL Environment Setup PostgreSQL Installation 00:13:00 Connecting to PostgreSQL using psql 00:04:00 Connecting to PostgreSQL using PgAdmin 00:07:00 Creating Database and Tables Basic of Database and Tables 00:06:00 Data Types 00:07:00 Primary Keys and Foreign Keys 00:04:00 Create Table in SQL Script 00:17:00 Insert 00:05:00 Update 00:05:00 Delete 00:03:00 Alter Table 00:05:00 Drop Table 00:02:00 Check Constraint 00:12:00 NOT NULL Constraint 00:04:00 UNIQUE Constraint 00:06:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:07:00 SELECT Statement 00:12:00 SELECT DISTINCT 00:10:00 Column AS Statement 00:07:00 COUNT 00:07:00 SELECT WHERE Clause - One 00:06:00 SELECT WHERE Clause - Two 00:11:00 ORDER 00:05:00 LIMIT 00:04:00 BETWEEN keyword usage on real time 00:08:00 IN Operator 00:06:00 LIKE and ILIKE 00:10:00 GROUP BY Statements Overview of GROUP BY 00:03:00 Aggregation Function 00:12:00 GROUP BY - One 00:05:00 GROUP BY - Two 00:06:00 HAVING on SQL Statement 00:04:00 JOINS Overview of JOINS 00:07:00 Introduction to JOINS 00:06:00 AS Statement table 00:05:00 INNER Joins 00:14:00 Full Outer Joins 00:04:00 Left Outer join 00:03:00 Right Outer Join 00:05:00 Union 00:05:00 Advanced SQL Commands Basic of Advanced SQL Commands 00:04:00 Timestamps 00:17:00 Extract from Timestamp 00:05:00 Mathematical Functions 00:06:00 String Functions 00:16:00 SubQuery 00:08:00 Databases and Tables Overview of Databases and Tables 00:02:00 Creating a Database backup 00:03:00 Restoring a Database from backup 00:04:00 Mock Exam Mock Exam - The Complete SQL from Scratch: Bootcamp 00:20:00 Final Exam Final Exam - The Complete SQL from Scratch: Bootcamp 00:20:00

Overview This Legal Secretary course will unlock your full potential and will show you how to excel in a career in Legal Secretary. So upskill now and reach your full potential. Everything you need to get started in Legal Secretary is available in this course. Learning and progressing are the hallmarks of personal development. This Legal Secretary will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Legal Secretary skills to help you advance your career. Acquire a comprehensive understanding of various Legal Secretary topics and tips from industry experts. Learn in-demand Legal Secretary skills that are in high demand among UK employers, which will help you to kickstart your career. This Legal Secretary course covers everything you must know to stand against the tough competition in the Legal Secretary field.  The future is truly yours to seize with this Legal Secretary. Enrol today and complete the course to achieve a Legal Secretary certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Legal Secretary course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Legal Secretary course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Legal Secretary course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Legal Secretary is suitable for anyone aspiring to start a career in Legal Secretary; even if you are new to this and have no prior knowledge on Legal Secretary, this course is going to be very easy for you to understand.  And if you are already working in the Legal Secretary field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Legal Secretary course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Legal Secretary course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Legal Secretary course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Legal Secretary course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Legal Secretary Module 01: Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems 00:35:00 Module 03: The Legal Workplace & Professionals 00:47:00 Module 04: Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice 00:17:00 Module 06: Property Law & Conveyancing Practice 00:21:00 Module 07: Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents 00:30:00 Module 09: Document Proofreading and Editing 00:07:00 Module 10: Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping 00:16:00 Module 13: Other Essential Skills for Secretarial Role 00:22:00 Module 14: Professional Conduct and Ethics 00:24:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Powerpoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00

Overview This Agile Scrum course will unlock your full potential and will show you how to excel in a career in Agile Scrum. So upskill now and reach your full potential. Everything you need to get started in Agile Scrum is available in this course. Learning and progressing are the hallmarks of personal development. This Agile Scrum will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Agile Scrum skills to help you advance your career. Acquire a comprehensive understanding of various Agile Scrum topics and tips from industry experts. Learn in-demand Agile Scrum skills that are in high demand among UK employers, which will help you to kickstart your career. This Agile Scrum course covers everything you must know to stand against the tough competition in the Agile Scrum field.  The future is truly yours to seize with this Agile Scrum. Enrol today and complete the course to achieve a Agile Scrum certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Agile Scrum course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Agile Scrum course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Agile Scrum course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Agile Scrum is suitable for anyone aspiring to start a career in Agile Scrum; even if you are new to this and have no prior knowledge on Agile Scrum, this course is going to be very easy for you to understand.  And if you are already working in the Agile Scrum field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Agile Scrum course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Agile Scrum course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Agile Scrum course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Agile Scrum course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum OBJECTIVES AND TARGETS Objectives and Targets 00:09:00 Download: course curriculum in pdf 00:05:00 FROM THE TRADITIONAL DEVELOPMENT MODEL TO THE AGILE Waterfall. Typical challenges 00:05:00 Agile history and 2001's Manifesto 00:11:00 Agile. A different approach 00:04:00 Agile benefits 00:02:00 When agile is best applied + success factors 00:03:00 Download: Agile Vs Waterfall. Overview diagram 00:01:00 Download: Agile Vs Waterfall side by side by project stage 00:04:00 2020 SCRUM GUIDE: WHAT'S NEW! 2020 SCRUM GUIDE: WHAT'S NEW! 00:22:00 BONUS: FULL EBOOK OF THE COURSE! BONUS - Full eBOOK of the Course 00:01:00 SCRUM Download: the Scrum Guide 00:14:00 Download: the Scrum Glossary 00:08:00 Download: Framework Navigator 00:01:00 Scrum introduction 00:12:00 Theory and values 00:08:00 THE SCRUM TEAM The Scrum Team - Introduction 00:08:00 Product, Product Goal and Product Owner 00:14:00 Developers 00:03:00 The scrum master 00:08:00 Characteristics of a perfect scrum master 00:23:00 SCRUM EVENTS Introduction 00:03:00 The Sprint 00:06:00 Download: Diagram of a typical Sprint (with events, roles, artifacts) 00:01:00 The sprint planning 00:10:00 The daily scrum 00:04:00 The sprint review 00:06:00 The sprint retrospective 00:05:00 SCRUM ARTIFACTS Product backlog 00:08:00 Sprint backlog 00:02:00 Increment and definition of done 00:04:00 Commitments 00:04:00 SCALING SCRUM Introduction 00:02:00 Scrum of scrums 00:02:00 Nexus framework 00:05:00 Download: the Nexus Framework poster 00:01:00 SCRUM IN PRACTICE ! A day in the life of a typical Sprint 00:32:00 AGILE REQUIREMENTS Products, Initiatives, Epics, Features, Stories and Tasks 00:11:00 ESTIMATION TECHNIQUES Underlying theory, t-shirt sizing, planning poker 00:09:00 Bucket system, affinity mapping, time unit 00:04:00 AGILE METRICS Underlying theory. Velocity 00:07:00 Sprint burn-down 00:08:00 Release burn-up, cumulative flow, other metrics 00:06:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS How to best prepare for PSM I Certification 00:09:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS PSM I EXAM SIMULATOR #1 and #2 (80+80 HIGH QUALITY QUESTIONS. REAL MODE) 00:01:00

Enhance your CV with one of the most in-demand skills in the UK. Covering all the key techniques in and understanding of providing good customer service, expert communication skills, time management and document preparation, this Office Skills and Receptionist Course has been designed to give you the skills to succeed in a variety of business areas and industries. Through video lessons, PDF handouts, mock exams and online assessments, you will learn how to improve your verbal and nonverbal communication skills, write and prepare expert documents and effectively manage your time. You also gain role-specific competencies in keeping a good telephone manner, gatekeeping and providing excellent customer service. Many of the skills you learn through this course are transferable across a range of fields, giving you even more chances to build yourself a new career. Why Choose This Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? This Office Skills and Receptionist course is ideal for people who want to start working as a Receptionist, Office Administrator, Office Manager, Administration Assistant, or Secretary, as well as people who want to enhance their office skills in general.