20677 Education courses delivered On Demand

Youth workers plan, organise and supervise community programs for young people. It enables young people to naturally develop their voice, influence, and place in society, allowing them to reach their full potential. Young people need to develop strong interpersonal and social skills. This Level 2 Youth Work Certificate course will teach you how to organise youth work and youth engagement activities. The fundamentals of outdoor management and the skills and responsibilities of youth workers will be discussed. In addition, you will learn how to plan, organise, and supervise community programs aimed at young people. You will be introduced to various methodologies and models that have influenced modern youth work practices through both practical and theoretical training. This Level 2 Youth Work Certificate course's lessons have been designed so that anyone with no prior knowledge of the subject can easily dive into them. So enrol now and successfully start your career. Why choose this Level 2 Youth Work Certificate course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. >> Main Course: Level 2 Youth Work Certificate >> Free Courses*** Course 01: Social Worker Course 02: Adults Support Worker Course 03: Mental Health Support Worker >> Others benefit Included with This Level 2 Youth Work Certificate Course Free 4 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Level 2 Youth Work Certificate Course] Learning Objectives After completing this Level 2 Youth Work Certificate course, the learner will be able to: Understand the fundamentals of youth work. Recognise who are youth workers. Know the role and approaches of youth workers. Explain the ethical conduct and principles in youth work. Describe the social change in youth development work. Know the National Youth Agency (NYA). Explain youth work according to the EU. Know the mental health of youth workers. Deal with stress. Describe youth justice and social work Course Curriculum >> Level 2 Youth Work Certificate Module 01: Overview to Youth Work Module 02: Youth Workers: Who Are They? Module 03: Role and Approaches of Youth Worker Module 04: Ethical Conduct and Principles in Youth Work Module 05: Career as a Youth Worker (Social Work) Module 06: Social Influences on Youth Worker Module 07: The National Youth Agency (NYA) Module 08: The EU on Youth Work Module 09: Mental Health of Youth Worker Module 10: Dealing with Stress Module 11: Youth Justice and Social Work Assessment Method After completing Level 2 Youth Work Certificate Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification After completing the Level 2 Youth Work Certificate course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? This Level 2 Youth Work Certificate is open to people of all backgrounds. Individuals in related professions can also enrol in this course to refresh or strengthen their skills. In addition, students can take this course to gather professional knowledge besides their study or for the future. Requirements There are no particular requirements for this Level 2 Youth Work Certificate Course because it doesn't call for any specialized training. To enroll in this Level 2 Youth Work Certificate course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated Basic computer Skill You must be at least 15 years old Career path Enrol in the Level 2 Youth Work Certificate course today to learn the skills and knowledge required to work with young people and organise youth activities. Opportunities in this field are: Youth Worker Working within a community organisation PE Teacher Social Worker

Overview The Invisible Engine: Mastering the Art of Supply Chain Management Picture this: a seamless flow of goods, from raw materials to your doorstep, a silent symphony ensuring everything you need arrives when you want it. This, my friend, is the magic of Supply Chain Management (SCM), the invisible engine driving the modern world. In the UK alone, the logistics industry contributes a staggering £116 billion to the economy, employing over 4.8 million people. It's a dynamic, ever-evolving field with opportunities for those who master its intricacies. Ready to unlock the hidden potential of your supply chain management skills? Enrol today and embark on a journey that will equip you with the knowledge and skills to thrive in this dynamic and rewarding field. You Will Learn Following Things: Unravel the intricacies of Supply Chain Management (SCM), grasping its core principles and the crucial role of logistics. Discover the art of customer response, crafting systems that exceed expectations and build loyalty. Navigate the complexities of global operations, ensuring smooth flow across borders and continents. Master inventory strategies, minimising waste and maximising efficiency. Become a warehouse maestro, optimising operations and mastering storage techniques. Design and monitor resilient supply chains, prepared for any disruption or challenge. Evaluate and optimise your network, ensuring agility and cost-effectiveness. Embrace the future of Supply Chain Management (SCM), exploring new business concepts and cutting-edge technologies. Align your supply chain with your business goals, driving growth and profitability. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Supply Chain Management Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Supply Chain Management Course course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Aspiring Supply Chain Management (SCM) professionals seeking a comprehensive foundation. Business owners looking to streamline their operations and gain a competitive edge. Procurement specialists are eager to hone their sourcing and negotiation skills. Logistics professionals aiming to elevate their careers to leadership positions. Anyone fascinated by the invisible forces shaping our world and eager to become a part of it. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Supply Chain Management Course 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 course. Career Path Procurement Officer: £28,000 to £40,000/year. Logistics Coordinator: £25,000 to £35,000/year. Inventory Controller: £26,000 to £38,000/year. Supply Chain Analyst: £30,000 to £45,000/year. Purchasing Manager: £35,000 to £55,000/year. Course Curriculum Module 01: An overview of Supply Chain Management An Overview of Supply Chain Management 00:17:00 Module 02: Role of logistics of Supply Chain Role of logistics of Supply Chain 00:19:00 Module 03: Customer Response Principles and Systems Customer Response Principles and Systems 00:15:00 Module 04: Supply Chain System and Principles Supply Chain System and Principles 00:15:00 Module 05: Global Supply Chain Operations Global Supply Chain Operations 00:17:00 Module 06:Inventory Strategies for Supply Chain Inventory Strategies for Supply Chain 00:15:00 Module 07: Warehouse Management and Operations Warehouse Management and Operations 00:13:00 Module 08: Supply Chain Design and Monitoring Supply Chain Design and Monitoring 00:15:00 Module 09: Supply Chain Network and Evaluating Supply Chain Network and Evaluating 00:18:00 Module 10: Supply Chain Planning and New Business Concepts Supply Chain Planning and New Business Concepts 00:17:00 Module 11: Aligning your supply chain process with your business Aligning Supply Chain Process with Your Business 00:18:00

Cyber threats are rising exponentially, with over half of UK businesses suffering a breach last year alone. As cyber-attacks become more sophisticated, the cyber security industry has a massive skills shortage. This comprehensive cyber security course equips you with the latest knowledge and tools to start an exciting and rewarding career in this cutting-edge field. Learn to implement robust cyber defences, identify phishing scams, prevent malware attacks, and gain insights from experts on the ground. With practical skills applicable across industries, this cyber security course opens doors to varied roles with salaries averaging £50k and higher. The UK cyber security industry is projected to grow by 10% annually, with starting salaries rising by 7-15% yearly.  Ready to join the vanguard of the digital defence? Enrol now and let the Cyber Security Advanced Training course equip you with the knowledge and skills to thrive in this exciting and ever-evolving field. You will Learn The Following Things: Comprehend the cyber threat landscape and its evolving tactics. Master defensive strategies against malware, phishing, and hacking attempts. Implement cutting-edge security tools and best practices for optimal protection. Develop the critical skills and knowledge sought after by cyber security employers. Craft a robust security strategy tailored to your business or personal needs. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Cyber Security Advanced Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Cyber Security Advanced Training course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? IT professionals are seeking to specialise in cyber security. Business owners and managers are concerned about online threats. Individuals are curious about the world of cybercrime and its countermeasures. Students are aspiring to build a career in this high-demand field. Anyone with a passion for technology and a desire to make the digital world safer. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Cyber Security Advanced Training 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 course. Career Path Security Analyst: £28K to £50K/year. Penetration Tester: £35K to £65K/year. Cyber Security Consultant: £40K to £70K/year. Ethical Hacker: £30K to £55K/year. Chief Information Security Officer (CISO): £80K+/year. Course Curriculum Cyber Security Advanced Training Introduction 00:04:00 Cyber Security Everything You Need to Know 00:10:00 Types of Cyber Attacks 00:11:00 What is Hacking and How to Prevent It 00:10:00 Types of Hackers 00:08:00 Types of Malwares and How to Recognize Them 00:10:00 How to Detect and Protect Your Business From Malware Attacks 00:09:00 How to Identify, Prevent and Recover from Crypto Jacking 00:08:00 What is Phishing and Tips to Protect from Phishing Attacks 00:07:00 How to Guard Yourself from Visiting Unsafe Websites 00:10:00 Reduce the Risk of Cyber Attacks - Top Cyber Security Practices to Prevent a breach 00:08:00 Latest Cyber Security Tools You Should Know 00:10:00 Skill Needed for Cyber Security Expert 00:09:00 Tips to Create an Ideal Budget in Covid Era 00:06:00 How Should Companies Adapt their new Security Strategy post Pandemic? 00:05:00

'Leadership Skills for The Future': Ignite Your Potential in a Changing World! Imagine steering a diverse team through uncharted waters of innovation, fostering inclusion, and driving success in a dynamic landscape. This dynamic reality is the domain of future leaders, and the Leadership Skills for The Future course empowers you to claim your place within it. The UK's leadership landscape is bustling, with industries worth £31 billion and 5.5 million professionals navigating its exciting currents. From tech giants shaping the future to ethical AI development and the rise of remote working, the need for adept leaders who can inspire, adapt, and thrive has never been higher. This comprehensive Leadership Skills for The Future course equips you with the essential skills to seize these opportunities. You'll delve into the core principles of leadership, honing your abilities to communicate effectively, negotiate productively, and cultivate an inclusive, engaging environment. We'll explore your creativity, organisational prowess, and emotional intelligence, empowering you to evolve as a leader and navigate the ever-changing terrain of modern management. Ready to step into your leadership power? Equip yourself with the skills to navigate the dynamic UK landscape and carve your path to success. Join the Leadership Skills for The Future course and unlock your potential to lead, inspire, and make a lasting impact. You will Learn The Following Things: Understand the principles of effective leadership and management. Develop key leadership skills such as communication, creativity, and emotional intelligence. Learn how to motivate and inspire teams and cultivate inclusion. Gain insights into leadership styles and competencies for career development. Explore best practices in leadership for organisations in the UK. Apply leadership techniques to drive innovation, change and growth. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Leadership Skills for The Future. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Leadership Skills for The Future course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Aspiring leaders looking to advance their management careers. Experienced professionals wanting to improve their leadership abilities. Individuals seeking to learn skills like creativity, communication and inclusion. Anyone interested in understanding leadership foundations and emotional intelligence. Those looking to gain knowledge on leadership and management, specifically in the UK. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Leadership Skills for The Future 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 course. Career Path Business Manager - £25k to £60k. Team Leader - £20k to £40k. Project Manager - £30k to £70k. Operations Manager - £35k to £60k. Recruitment Manager - £30k to £50k. Course Curriculum Leadership Skills for The Future Module 01: Introduction to Leadership 00:23:00 Module 02: Qualities of a Good Leader and Leadership 00:13:00 Module 03: Creativity in Leadership 00:19:00 Module 04: Organisational Skills 00:26:00 Module 05: Leadership Skills and Competencies 00:30:00 Module 06: Communication Skills 00:27:00 Module 07: Negotiation Techniques 00:15:00 Module 08: Cultivating Inclusion, Belonging, and Engagement 00:25:00 Module 09: Leadership Foundations 00:24:00 Module 10: Emotional Intelligence 00:19:00 Module 11: Evolve as a Leader 00:14:00 Module 12: Leadership & Management in the UK 00:17:00 Assignment Assignment - Leadership Skills for The Future 00:00:00

Description People who have learned to respond to the high level of stress in a positive and very balanced way are the happiest and successful people. Stress - related disorders have become very common in today's world. The wear and tear caused by chronic stress can contribute to physical and mental breakdown. Disorders such as hypertension have reached almost epidemic proportions. due to increase in stress and we deal with it, have become areas of major concern. This advanced diploma course provides the student with the advanced skills of stress management.  Who is the course for? This advanced diploma course is for anyone who is going through a high level of stress, feels constantly fatigued, feels angry constantly and feels hopeless and helpless. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: This online stress management course provides you with the knowledge to recognize the symptoms and sources of stress and it will introduce you to different ways to manage stress which will benefit you, your colleagues and your organization. Stress Management Basics What Is Stress? 00:30:00 Causes Of Stress 01:00:00 The Effects Of Stress 00:30:00 Recognise The Warning Signs 00:15:00 Lingering Stress 00:15:00 Stress And Panic Attacks 00:30:00 Solutions On Living A Stress-Free Life 01:30:00 Conclusion 00:15:00 Advanced Stress Management Introduction 00:15:00 Recognizing your stress Levels & triggers 01:00:00 Why do these changes occur frequently? 00:15:00 What does stress do to you? 00:15:00 Beware! Before seeking medical attention 00:30:00 Medical stress solutions analyzing 00:30:00 The importance of stress management 01:00:00 Other things that might help in Stress Management 00:30:00 The Uses of Herbs and supplements in stress Management for stress relief 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Stress Management 00:20:00 Final Exam Final Exam- Advanced Diploma in Stress Management 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Microsoft Excel is a powerful and easy to use spreadsheet program that almost all businesses use on a day-to-day basis. It is used to store and retrieve numerical data and it is ideal for entering, calculating and analysing company data such as sales figures, sales taxes or commissions. This Level 3 Diploma in Microsoft Excel 2016 is a course which will help you learn the various features incorporated in the software. This course has been specially designed to cover everything from the basic concepts to the advanced levels. This course allows you to take advantage of the online aspect of training by learning at your own pace. As long as you have access to an eligible device, such as a laptop, or smartphone, and an internet connection, you can access this Level 3 Diploma in Microsoft Excel 2016 from anywhere, and anytime. Learning Outcomes: Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time-dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Microsoft Excel 2016 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Microsoft Excel 2016 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Module : 2 Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00 Module : 3 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Module : 4 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 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Module : 5 Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Excel 2016 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Baking & Cake Decorating Diploma Overview  Master the skills to bake cakes that only feast your eyes but create a carnival inside the mouth with our Baking & Cake Decorating Diploma course. This course is perfect for baking enthusiasts who wish to acquire more professional skills. From baking the cakes to decorating, this course will cover the essentials.  In this comprehensive course, you will be able to level up your cake-baking skills. The course will help you learn the secrets of baking the perfect cake. Then, you will develop the skills to use different techniques like piping, glazing and icing for decorating cakes. Also, the course will provide useful techniques and ideas for cake decoration. You will also learn the steps to maintain food hygiene and safety. Along with the baking skills, the course will also educate you on creating your own baking business. So, if you are ready to work on your dream career, enrol today! Course Preview Learning Outcome Familiarise yourself with the basic concepts and ingredients of baking Learn how to work with different types of pastes Understand the techniques of icing, glazing, frosting and more Grasp effective cake decorating techniques Know how to maintain food safety while working Build the competence to start your own cake-decorating business Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient assessment system with instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Baking Frosting and icing Piping and glazing Cake business Who Should Take This Baking & Cake Decorating Diploma Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Baking & Cake Decorating Diploma course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Baking & Cake Decorating Diploma Certification After completing and passing the Baking & Cake Decorating Diploma course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path This exclusive Baking & Cake Decorating Diploma course will equip you with effective skills and abilities and help you explore career paths such as  Baker Chef Caterer Bakery Owner Cake Business Owner Module 01: Basic Concepts of Baking Basic Concepts of Baking 00:16:00 Module 02: Basic Ingredients of Baking Basic Ingredients of Baking 00:34:00 Module 03: Glossary and Equipment Used in Baking Glossary and Equipment Used in Baking 00:34:00 Module 04: Types of Cakes Types of Cakes 00:14:00 Module 05: Baking the Cake Baking the Cake 00:20:00 Module 06: Baking Principles Baking Principles 00:25:00 Module 07: Cake Decorating Recipes Cake Decorating Recipes 00:26:00 Module 08: Cake Decorating Ideas Cake Decorating Ideas 00:21:00 Module 09: Frosting and Icing Frosting and Icing 00:24:00 Module 10: Working with Different Pastes Working with Different Pastes 00:20:00 Module 11: Working with Glazes Working with Glazes 00:28:00 Module 12: How to Stack a Cake How to Stack a Cake 00:21:00 Module 13: Piping and Writing Piping and Writing 00:24:00 Module 14: Health, Safety and Food Hygiene Health, Safety and Food Hygiene 00:20:00 Module 15: Troubleshooting Troubleshooting 00:20:00 Module 16: Cake Decorating Business Cake Decorating Business 00:19:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Overview of Admin, Secretarial & PA Training In the bustling business landscape of the UK, office administration remains an indispensable cornerstone, employing thousands. The rise in demand for adept administrative specialists is palpable, with companies valuing precision, efficiency, and stellar communication. This Office Skills for Admin, Secretarial, PA (Executive PA) course offers a springboard into office skills, equipping learners with a competitive edge in tasks spanning data analysis to top-tier executive support. Dive deep into the intricacies of Excel, master the finesse of business writing, and step up your organisational prowess. As businesses evolve, so does the role of administrative professionals; stay ahead with the Office Skills for Admin, Secretarial, PA (Executive PA) course. This Admin, Secretarial & PA Training Course will help you to learn: Acquire core competencies in administrative support roles. Enhance organisational efficiency through effective tools and techniques. Cultivate superior business writing and communication skills. Develop expertise in time management and meeting arrangements. Master the basics of Excel and PowerPoint for efficient data handling. Understand and apply proper telephone etiquette in professional settings. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Admin, Secretarial & PA Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Admin, Secretarial & PA Training course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Those aspiring to establish a foothold in the world of office administration will find this Office Skills for Admin, Secretarial, PA (Executive PA) course invaluable. From those just starting, wishing to comprehend the breadth of administrative tasks to those eyeing roles that demand advanced organisational skills, this curriculum caters to a broad spectrum. Individuals keen on mastering business communication, whether it’s through crafting persuasive emails or presenting data-driven insights, will benefit immensely. The Office Skills for Admin, Secretarial, PA (Executive PA) course also appeals to those aiming to work alongside top-tier executives, understanding the nuanced responsibilities of a Personal Assistant. With a special emphasis on tools like Excel and PowerPoint, it’s tailored for those who seek fluency in these ubiquitous office tools. Requirements You don’t need any educational qualification or experience to enrol in the Admin, Secretarial & PA Training 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 course. Career Path Executive Personal Assistant - £30K to £45K/year. Office Manager - £25K to £35K/year. Administrative Coordinator - £20K to £28K/year. Receptionist - £18K to £25K/year. Data Entry Clerk - £19K to £24K/year.

Overview of Employment Law The UK workplace is a complex landscape. Employment law governs everything from recruitment to dismissal, ensuring fairness for both employers and employees. This employment law uk course equips you with the knowledge to thrive in this environment. Gain a solid understanding of your rights and responsibilities with this comprehensive Employment Law course. According to the Ministry of Justice, employment tribunal claims rose by 27% in 2020/21, underscoring the need for professionals who can navigate these legal challenges. Furthermore, with the UK's exit from the European Union, employment law is undergoing significant changes, creating a surge in demand for specialists who can interpret and apply new regulations. Our UK employment law course covers everything from the basics to advanced concepts, including recruitment processes, employment contracts, disciplinary procedures, wage regulations, parental rights, workplace discrimination, and health and safety. By the end of this Employment Law UK course, you'll be equipped to handle dismissals, grievances, and employment tribunals with confidence, positioning yourself as an invaluable asset in the UK's dynamic employment landscape. This Employment Law Course will help you to learn: Understand the fundamental principles of employment law in the UK Identify and apply the relevant legal requirements to everyday HR practices Develop effective strategies for managing a diverse workforce in a compliant manner Address workplace issues such as discrimination, harassment, and disciplinary matters Handle dismissal procedures and represent the organisation in employment tribunals This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Employment Law. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Employment Law course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? HR professionals who want to deepen their understanding of UK employment law. Managers who need to make informed decisions on HR matters. Business owners who want to protect their organisation from legal risks. Anyone who is interested in a career in employment law UK. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Employment Law 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 course. Career Path The certification and skills you get from this Employment Law Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. HR Officer - £25K to 37K/year Employment Law Advisor - £30K to 40K/year HR Manager - £40K to 70K/year Employment Law Solicitor - £48K to 60K/year Human Resources Director - £70K to 120K/year Course Curriculum Module 01: Basics of Employment Law 00:24:00 Module 02: Legal Recruitment Process 00:43:00 Module 03: Employment Contracts 00:25:00 Module 04: Employee Handbook 00:23:00 Module 05: Disciplinary Procedure 00:15:00 Module 06: National Minimum Wage & National Living Wage 00:37:00 Module 07: Parental Right, Sick Pay & Pension Scheme 00:43:00 Module 08: Discrimination in the Workplace 00:39:00 Module 09: Health & Safety at Work 00:19:00 Module 10: Dismissal, Grievances and Employment Tribunals 00:36:00 Module 11: Workplace Monitoring & Data Protection 00:15:00

Overview of Domestic Appliance Repair With over 45 million households in the UK relying on appliances like refrigerators, washing machines and ovens, there is always demand for skilled domestic appliance repair technicians. This comprehensive Domestic Appliance Repair course unlocks the skills and knowledge needed to diagnose and fix faults in all common household appliances. Gain practical, hands-on experience repairing and maintaining refrigerators, air conditioners, washers, cooking appliances and more. Develop electrical, mechanical and troubleshooting abilities following best practice safety procedures. Whether you want to start a lucrative appliance repair business, become a skilled appliance servicer, or fix appliances in your own home, this Domestic Appliance Repair course provides the perfect foundation. With the UK appliance repair industry expected to grow 5% annually, this is the ideal time to gain skills in this essential trade. Get a Quick Look at The Course Content: This Domestic Appliance Repair Course will help you to learn: Diagnose faults in common domestic appliances. Repair refrigerators, air conditioners and washing machines. Service and maintain cooking appliances. Follow safety procedures when working on appliances. Repair electrical wiring and circuits in appliances. Replace parts and components in appliances. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Domestic Appliance Repair. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Domestic Appliance Repair course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals looking to start a career in appliance repair. Existing appliance repair technicians looking to expand their skills. Handymen and DIY enthusiasts interested in appliance maintenance and repair. Aspiring entrepreneurs wanting to start an appliance repair business. Anyone wishing to save money by repairing their appliances. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Domestic Appliance Repair 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 course. Career Path The certification and skills you get from this Domestic Appliance Repair Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Appliance Repair Technician - £20K to £32K per year. Refrigeration Mechanic - £20K to £35K per year. Washing Machine Repairer - £16K to £25K per year. Electrical Appliance Servicer - £22K to £32K per year. Self-Employed Appliance Repairer - £30K to £60K per year Frequently Asked Questions (FAQ's) Q. How do I purchase a course? 1. You need to find the right course on our IOMH website at first. You can search for any course or find the course from the Courses section of our website. 2. Click on Take This Course button, and you will be directed to the Cart page. 3. You can update the course quantity and also remove any unwanted items in the CART and after that click on the Checkout option and enter your billing details. 4. Once the payment is made, you will receive an email with the login credentials, and you can start learning after logging into the portal. Q. I have purchased the course when will I be able to access the materials? After purchasing the course, you should receive an email with the login credentials within 24 hours. Please check your spam or junk folder if you didn't receive it in your inbox. You can access your courses by logging into your account. If you still need any assistance, please get in touch with our Customer Support team by providing the details of your purchase. Q. I haven't received my certificate yet. What should I do? You should receive your Digital Certificate within 24 hours after placing the order, and it will take 3-9 days to deliver the hard copies to your address if you are in the UK. For International Delivery, it will take 20-25 days. If you require any assistance, get in touch with our dedicated Customer Support team, and your queries/issues will be dealt with accordingly. Q. I don't have a credit/debit card, what other methods of payment do you accept? You can make the payment using PayPal or you can Bank Transfer the amount. For Bank transfer you will require an invoice from us and you need to contact our Customer Support team and provide details of your purchase to get the invoice. After that, you will receive an email with the invoice and bank details and you can make the payment accordingly. Q. Can I do the courses from outside UK? We are an online course provider, and learners from anywhere in the world can enrol on our courses using an internet-connected device. Q. When I log into the account it says 'Contact Administrator'. To resolve this issue, please log out of your account and then log back in. Course Curriculum Domestic Appliance Repair Introduction to Domestic Appliances 00:25:00 Repairing a Refrigerator 00:30:00 Repairing an Air Conditioner 00:10:00 Repairing a Washing Machine 00:10:00 Repairing a Coffee Maker 00:10:00 Repairing a Dishwasher 00:15:00 Repairing a Vacuum Cleaner 00:10:00 Repairing a Water Heater 00:10:00 Repairing a Television 00:10:00 Repairing Electrical Wiring 00:10:00 Repairing Cooking Appliances 00:15:00 Repairing a Cloth Dryer 00:10:00 Safety Precautions during Repairing Appliances 00:15:00