17137 Other courses delivered Online

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that the UK's Equality, Diversity and Inclusion Act of 2010 protects individuals from discrimination based on nine characteristics, including age, disability, gender reassignment, race, religion or belief, sex, sexual orientation, and marriage or civil partnership? In the UK, 21% of employees believe they have been discriminated against at work based on a protected characteristic. Creating a fair and inclusive workplace benefits everyone. This Equality, Diversity and Inclusion Bundle equips you with the knowledge and skills to build a positive and respectful work environment. This Certificate in Equality, Diversity and Inclusion at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development & career progression more accessible than ever! This Equality, Diversity and Inclusion course bundle equips you with the knowledge and skills to create a more positive and productive work environment. Learn about human rights legislation and how to prevent discrimination. Develop your cultural awareness and communication skills to bridge cultural divides. Identify and challenge unconscious biases that can hold you and others back. Explore techniques for dealing with difficult people and maintaining confidentiality. With a single payment, you will gain access to Equality, Diversity and Inclusion course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Equality, Diversity and Inclusion Bundle Package includes: Main Course: Certificate in Equality & Diversity at QLS Level 3 10 Additional CPD Accredited Premium Courses related to Equality, Diversity and Inclusion: Course 01: Human Rights Course 02: Cross-Cultural Awareness Training Course 03: Unconscious Bias Training Course Course 04: Workplace Harassment Course 05: Workplace Confidentiality Course 06: Youth Work & Leadership Course 07: Dealing With Difficult People Training Course Course 08: Social Anxiety Therapy Course 09: Self Confidence & Self Esteem Course 10: Motivation Skills Enrol now in Equality, Diversity and Inclusion and enhance your professional profile, foster a more harmonious and productive work environment, and contribute positively to a more just and equitable society. Learning Outcomes of Equality, Diversity and Inclusion Course Define equality, diversity, and inclusion concepts for better comprehension Identify discrimination types, exploring their impact on equality, diversity and inclusion Understand the UK legal framework for fostering equality, diversity, and inclusion Develop strategies integrating equality, diversity, and inclusion into organisational practices Recognise and challenge unconscious bias, promoting equality, diversity and inclusion Implement effective practices for promoting equality, diversity, and inclusion. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Equality, Diversity and Inclusion Get a free student ID card with Equality, Diversity and Inclusion Training program (£10 postal charge will be applicable for international delivery) The Equality, Diversity and Inclusion is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Equality, Diversity and Inclusion course materials The Equality, Diversity and Inclusion comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Main Course: Certificate in Equality & Diversity at QLS Level 3 Module 01: Introduction to Equality, Diversity and Discrimination Module 02: Equality & Diversity Legislation Module 03: Integrating Equality & Diversity into Policy Module 04: Human Rights Module 05: Promoting Diversity and Social Inclusion Module 06: Equality Analysis Module 07: Links between Values, Attitudes and Beliefs Module 08: Basics of Discrimination Module 09: Stereotypes, Prejudice, Discrimination and Bias Module 10: Institutional Discrimination Module 11: Unconscious Bias Module 12: Affirmative Action Module 13: Monitoring Equality & Diversity Course 01: Human Rights Module 01: Basic Concept Of Freedom And Human Rights Module 02: Classification Of Human Rights Module 03: Women's And Children's Right Module 04: Various Aspects Of Freedom Module 05: Various International Human Rights Organisations Course 02: Cross-Cultural Awareness Training Module 01: Introduction To Cross-Cultural Awareness Module 02: Cross-Cultural Communication Module 03: Corporate Cross-Cultural Awareness Module 04: Cross-Cultural Design Module 05: Cross-Cultural Competency Module 06: Cultural Values Module 07: Working With And Managing A Culturally Diverse Team =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £89) CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Equality, Diversity and Inclusion course is ideal for you: Individuals interested in Equality, Diversity Inclusion issues HR professionals Managers and team leaders Public sector workers Educators Anyone looking to make a difference in their community Requirements No prior background or expertise is required to enrol in this Equality, Diversity and Inclusion course. Career path After completing this Equality, Diversity and Inclusion bundle, you are to start your career or begin the next phase of your career. Diversity and Inclusion Manager Human Rights Officer Equality and Diversity Advisor Social Inclusion Officer Diversity Trainer Community Development Worker Certificates Certificate in Equality & Diversity at QLS Level 3 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Diet and Nutrition: Diet and Nutrition Course Online With this exclusive Diet and Nutrition: Diet and Nutrition Course, you can learn about the increasingly important role of the professional nutrition adviser while also developing valuable life skills. Discover why qualified nutritionists are in higher demand globally than ever before and start working toward a fulfilling profession for life. The general public is becoming more aware of the importance of dietary choices to overall human health all around the world. We are what we eat, and how we approach our daily diets has a significant impact on all aspects of health and wellness. Because of the importance of dietary balance, millions of individuals worldwide have begun to take their eating habits more seriously, proactively monitoring and managing what they put into their bodies. Nonetheless, expert nutritionists' guidance and assistance are required to guide health-conscious individuals in the right direction. This Diet and Nutrition: Diet and Nutrition Course provides learners with a thorough introduction to one of the world's most important and fascinating contemporary professions. The Diet and Nutrition: Diet and Nutrition Course curriculum focuses on important areas of nutrition and dietetics of practical value in a working scenario, laying a solid basis for a satisfying lifelong career. Among the core topics covered include how various key nutrients affect human health, the role nutrition plays in building and strengthening the immune system, the connection between dietary choices and disease risk, an overview of detoxification digestion, an introduction to women's health issues, and many more. Courses you will get: Course 01: Level 1 Diet and Nutrition Course 02: Diet and Nutrition (Diploma Level 5) Course 03: Level 2 Award in Nutrition and Health Course 04: Level 1 Certificate in Well-being Course 05: Level 5 Diploma in Nutrition Course 06: Level 5 Nutritional Therapy Course 07: Diploma in Sports Nutrition Course 08: Nutrition Course (Level 3 Certificate) Course 09: Personal Trainer Course 10: Sports First Aid Course 11: Level 2 Certificate in Understanding Nutrition and Health Course 12: Level 2 Award in Improving Personal Exercise, Health and Nutrition [ Note: Free PDF certificate as soon as completing the Diet and Nutrition: Diet and Nutrition Course] iet and Nutrition: Diet and Nutrition Course Online This Diet and Nutrition: Diet and Nutrition Course consists of 15 modules. Assessment Method of Diet and Nutrition: Diet and Nutrition Course After completing Diet and Nutrition: Diet and Nutrition 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 of Diet and Nutrition: Diet and Nutrition Course After completing the Diet and Nutrition: Diet and Nutrition 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? Diet and Nutrition: Diet and Nutrition Course Online This Diet and Nutrition: Diet and Nutrition Course is suitable for anyone who wants to get to the top of the profession and requires no prior knowledge or experience. The Diet and Nutrition: Diet and Nutrition Course is ideal for both newcomers and existing members of the workforce. This Diet and Nutrition: Diet and Nutrition Course is also highly recommended for anyone interested in freelancing or self-employment opportunities all around the world. Requirements Diet and Nutrition: Diet and Nutrition Course Online To enrol in this Diet and Nutrition: Diet and Nutrition Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Diet and Nutrition: Diet and Nutrition Course. Be energetic and self-motivated to complete our Diet and Nutrition: Diet and Nutrition Course. Basic computer Skill is required to complete our Diet and Nutrition: Diet and Nutrition Course. If you want to enrol in our Diet and Nutrition: Diet and Nutrition Course, you must be at least 15 years old. Career path Diet and Nutrition: Diet and Nutrition Course Online Diet and Nutrition: Diet and Nutrition Course is a field with limitless scope for self-employment and freelance job opportunities. Successful candidates with this Diet and Nutrition: Diet and Nutrition Course can pursue a more formal position such as: Sports Nutritionist Health Coach Holistic Nutritionist Public Health Nutritionist

Duration 5 Days 30 CPD hours This course is intended for Red Hat Certified System Administrator (RHCSA) who wants to learn how to provision and configure IdM technologies across both Linux and Windows applications Identity management specialist or engineer Access management specialist or engineer Web application developer DevOps specialist Overview As a result of attending this course, you will gain an understanding of the architecture of an identity management realm and trusted relationships using both Red Hat Enterprise Linux Identity Management and Microsoft Active Directory. You will be able to create, manage, and troubleshoot user management structures, security policies, local and remote secure access methods, and implementation technologies such as Kerberos, PKI, and certificates. You should be able to demonstrate these skills: Create and manage a scalable, resilient Identity Management realm, including both Linux and Microsoft Windows clients and servers. Create and manage secure access configurations, including managing and troubleshooting Kerberos, certificate servers, and access control policies. Integrate IdM as the back end for other major enterprise tools in the Red Hat portfolio, including Satellite Server and Tower. This course will empower you with the skills to configure and manage IdM, the comprehensive Identity Management solution bundled with Red Hat© Enterprise Linux.You will master these skills on the most requested Red Hat Identity Management (IdM) capabilities, including Active Directory trusts, multi-product federation, configuration management with Ansible, integrated certificate management, single sign-on, one-time passwords, and cybersecurity policy conformance. This course covers the same material as RH362, but includes the Red Hat Certified Specialist in Identity Management exam (EX362). Install Red Hat Identity Management Describe and install Red Hat Identity Management (IdM). Centralize Identity Management Explain the IdM server services, explore IdM clients access methods, and install an IdM client. Authenticate identities with Kerberos Define the Kerberos protocol and configure services for Kerberos authentication. Integrate IdM with Active Directory Create a trust relationship with Active Directory. Control user access Configure users for authorized access to services and resources. Manage a public key infrastructure Manage certificate authorities, certificates, and storing secrets. Maintain IdM operations Troubleshoot and recover Identity Management. Integrate Red Hat products with IdM Configure major services to share the IdM authentication database. Install scalable IdM Construct a resilient and scalable Identity Management topology.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for project team members and other key users (persons from special departments) responsible for creating and optimizing a cross location supply plan including production, procurement and distribution plans. In this course, students gain an understanding of how to create cross-location production plans, distribution resource plans, and procurement plans taking into account work center capacities, supplier capacities, and transportation capacities in SAP APO. Course Outline Overview of Supply Chain Planning in SAP SCM (APO), Integration with Demand Planning (DP) and Production Planning (PP/DS) Overview of exchanging master and transaction data with SAP ECC Master data for supply network planning, interchangeability and shelf live Configuring Supply Network Planning and interactive planning using planning books and macros Introduction to the Planner Home Page (EhP 3) Collaborative Supply Planning (supplier and manufacturer exchange data over the Internet) Integrated exception management in the alert monitor Discussions about the different planning methods: Heuristic including capacity leveling, optimization, capable-to-match, and VMI. Standard and advanced Cross-location safety stock planning Deployment: Implementing stock transport requisitions into manageable stock transport orders. Calculating and optimizing short-term replenishment plans for distribution centers and customers Transport Load Builder (TLB): Grouping stock transfers by threshold values for volumes, weight and pallets. Additional course details: Nexus Humans SCM230 SAP Supply Network Planning (APO-SNP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SCM230 SAP Supply Network Planning (APO-SNP) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

The Health and Wellbeing establishes a solid foundation for encouraging movement, improving nutrition, and increasing human function. You will gain an understanding of how physical activity and nutrition actually impact how we feel. Do you want to learn more about the science that characterizes our health? Would you like to work in wellness or healthcare? Then this Certificate in Wellbeing curriculum is for you. This Diploma course provides a solid foundation in well-being in health principles. This Certificate in Wellbeing program will teach you about health and social issues such as addiction, mood disorders, and nutrition. This course is a comprehensive guide that will prepare you to help others as a Social Worker, Counsellor, or Mental Health Worker. Furthermore, the skills and knowledge you will gain by taking this Certificate in Wellbeing course will help you move one step closer to your professional goals and develop your skills for a successful career. The Certificate in Wellbeing course emphasizes how to improve your competency as a person in your chosen field while also outlining important career insights in the relevant job sector throughout. This Certificate in Wellbeing course is a one-of-a-kind educational opportunity that will prepare you to work as a competent social worker or health worker. You could be a lifeline for people who struggle with health disorders and have a significant impact on their quality of life. The skills you learn here could lead to a lifelong career in which you can help those in need while also feeling proud of your accomplishments. The Certificate in Wellbeing course covers all of the most recent topics to keep you up to date with all the necessary information. This excellent course covers basic to advanced relevant topics, allowing you to improve your skills. You will be more productive at this work after completing this course. You will also receive easy-to-digest modules and learning materials in this masterfully designed course, allowing you to stand out in your future career. Furthermore, the relevant skills you will gain after completing this Health and Wellbeing course will add value to your resume. Learning Outcomes After completing this Certificate in Wellbeing course, the learner will be able to: Understand Stress and Stress Management. Gain a thorough understanding of Mental Health. Understand substance misuse. Understand the importance of healthy eating and drinking for adults. Gain in-depth knowledge about Dementia. Why Choose Certificate in Wellbeing Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Well-being Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Courses are included in this Certificate in Wellbeing Course MAIN COURSE: Diploma in Health and Wellbeing *** Additional Courses *** Safeguarding Vulnerable Adults Training Level 2 Certificate in Awareness of Mental Health Problems ***Other Benefits of Include in this Certificate in Well-being Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Certificate in Wellbeing course] This comprehensive and accurate Certificate in Wellbeing course is a great way to start your career as a social worker. You will gain a practical and theoretical understanding of this course, which will boost your employability in this field, help you stand out from the crowd, and boost your potential in no time. So, once you've finished this Certificate in Wellbeing course, you'll have the practical knowledge and skills to pursue a variety of career opportunities in the field. This Health and Wellbeing course can help you improve your reputation. You can tell the difference from the first lesson. This complete course includes all of the teachings that you can easily understand and apply to your abilities. Individuals attempting to make a career in this field will benefit from this course's understanding of the fundamentals and comprehensive education. Whether you are new to this field or want to improve your skills and have a successful career, our course can help you get there. This course covers all relevant topics. We are committed to providing you with the best educational experience possible as one of the leading course providers and most renowned e-learning specialists online. This Certificate in Wellbeing course was created in collaboration with experts and mentors to help you learn quickly and efficiently, at your own pace and ease. Enrol in our Certificate in Wellbeing course today to pursue your dreams and gain the experience, skills, and knowledge required to advance your professional development. Our Certificate in Wellbeing course will help you with the qualities you need to work towards your dream job. Course Curriculum of- *** Certificate in Wellbeing *** [ COURSE 01] >> Certificate in Well-being ** Curriculum Module 1: Introduction to Stress and Stress Management Understand what is meant by stress Know the effects of stress Understand possible causes of stress Understand how to recognise stress Know ways to prevent and reduce the effects of stress Module 2: Develop an Awareness of Mental Health Be aware of what is meant by mental health Be aware of some of the social and personal effects of mental ill-health Be aware of some of the responses to mental health issues Be aware of cultural diversity in relation to mental health issues Module 3: Develop an Awareness of Substance Misuse Know what substances are commonly misused and why Recognise possible signs of substance misuse Be aware of the social and personal effects of substance misuse Be aware of perceptions of and responses to substance misuse Module 4: Introductory Awareness of the Importance of Healthy Eating and Drinking for Adults Understand the importance of healthy eating Understand the importance of drinking enough to stay healthy Module 5: Dementia Awareness Know the most common types of dementia Know the signs and symptoms of common types of dementia Know about good practice in caring for an individual with dementia [ COURSE 02] >> Safeguarding Vulnerable Adults Training Curriculum Module 1: Basic Knowledge of Safeguarding Vulnerable Adults What is Adult Safeguarding? Who is a Vulnerable Adult? Who is Responsible for Safeguarding? Aims of Adult Safeguarding How to Safeguard a Vulnerable Adult Why is it Important to Protect Vulnerable Adults? What are the Safeguarding Vulnerable Adults Legislations? The Care Act 2014 & Mental Capacity Act Module 2: Vulnerability What Do You Understand by Vulnerable Adult People? Recognizing Vulnerable Adult at Risk Who is in Danger of Being Abused or Neglected? Module 3: Abuse of Vulnerable Adult What is Adult Abuse? Types & Symptoms of Adult Abuse Recognizing the Potential Abuser What Can You Do If You Recognize Abuse? An Overview of Human Trafficking Module 4: Responding To Concerns in Adult Safeguarding Raising a Safeguarding Concern Consent and Empowerment of the Adult When Raising a Safeguarding Concern Responding to Abuse and Neglect Professionals Concerns Module 5: Whistleblowing on Safeguarding Adult What is Whistleblowing in Adult Safeguarding? Why is Whistleblowing Important in Healthcare? The Whistleblowing Procedure for Safeguarding Adults Who Can You Blow the Whistle to in Healthcare? Are Whistleblowers Legally Protected? Module 6: Reporting & Procedure After Reporting Process for Reporting Safeguarding Concerns Recording & Reporting Safeguarding Issues Procedure After Reporting [ COURSE 03 ] >>Level 2 Certificate in Awareness of Mental Health Problems Curriculum Module 1: Understanding Mental Health Know what is meant by mental health and mental ill-health Understand how mental health care has changed over time Understand the social context of mental ill health Understand the legal context of mental ill health Module 2: Understanding Stress Understand the term 'stress' Understand possible causes of stress Understand how stress can affect an individual Understand how stress may be managed Module 3: Understanding Anxiety Understand the terms 'anxiety' and 'panic attack' Understand possible causes of anxiety Understand how anxiety can affect the individual and others Understand how anxiety may be managed Module 4: Understanding Phobias Understand the term 'phobias' Understand the possible causes of phobia Understand how a phobia can affect the individual and others Understand how phobias may be managed Module 5: Understanding Depression Understand the term 'depression' Understand the possible causes of depression Understand how depression affects the individual and others Understand how the demands of daily life can affect depression Understand how depression can be managed Module 6: Understanding Postnatal Depression Understand the term 'postnatal depression' Understand the causes of postnatal depression Understand puerperal psychosis Understand how postnatal depression can affect the mother and others Understand how preparation for the birth can help reduce the risk of postnatal depression Understand how postnatal depression may be managed Understand how puerperal psychosis may be managed Module 7: Understanding Bipolar Disorder Understand the term 'bipolar disorder' Understand the causes of bipolar disorder Understand how bipolar disorder can affect the individual and others Understand how bipolar disorder may be managed Module 8: Understanding Schizophrenia Module 9: Understanding Dementia Module 10: Understanding Eating Disorders Module 11: Understanding Attention Deficit Hyperactivity Disorder Module 12: Understanding Obsessive-Compulsive Disorder - OCD Module 13: Understanding Post-Traumatic Stress Disorder - PTSD Assessment Method After completing each module of the Certificate in Wellbeing, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Certificate in Wellbeing course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Certificate in Wellbeing course is ideal for individuals who want to learn more about their own and others' well-being. Certificate in Well-being course provides learners with flexible modules to suit their circumstances and interests. Requirements There are no specific requirements for this Certificate in Wellbeing course because it does not require any advanced knowledge or skills. Career path This Certificate in Wellbeing course will improve your CV and employability. After completing this course, you will have a competitive advantage when entering the relevant job field: Social Care Worker Recovery Worker Community Wellbeing Officer Counsellor Mental Health Care Worker Certificates Certificate of completion Digital certificate - Included

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the 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 The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:04:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:04:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:07:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excel's IF() Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 INDEX() Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:14:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Lopps For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn to build an amazing REST API with Spring Boot and understand what all this hype about microservices is about.

Secure any Linux server from hackers and protect it against hacking. The practical Linux Administration security guide.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Do you dream of helping others unlock their potential? In the UK Coaching market is booming, expected to reach £5.5 billion by 2025. Are you ready to be part of this exciting and rewarding Coaching & Mentoring field? This Coaching & Mentoring bundle equips you with the knowledge and skills to become a successful coach or leader. You'll gain a deep understanding of coaching and mentoring principles, explore effective leadership styles, develop your communication skills to a masterclass level, and learn to manage stress and anxiety in yourself and others. Additionally, you'll gain the tools to boost your own time management and critical thinking abilities - essential skills for any successful coach or mentor. This Performance Coaching at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 150 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Coaching & Mentoring course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Performance Coaching & Mentoring Bundle Package includes: Course 01: Diploma in Performance Coaching at QLS Level 5 10 Additional CPD Accredited Premium Courses Related to Coaching & Mentoring - Course 01: Supervisor training Course 02: Mindfulness for Wellbeing and Peak Performance Course 03: The Manager: Management and Leadership Development Programme Course 04: Leadership Skills Course Course 05: Resilience Training Course 06: Personal Development Coach Online Course Course 07: Communication Skills Masterclass Course 08: Anxiety Management Course Course 09: Critical Thinking Training Course 10: Online Time Management Training Invest in your future, invest in this Coaching & Mentoring Bundle. Enrol in our Coaching & Mentoring bundle today and Take control of your career and help others reach their full potential. Learning Outcome of this Coaching & Mentoring Bundle: Understand and apply Coaching & Mentoring principles for personal and professional growth. Develop effective relationships and enhance your skills in Coaching & Mentoring. Utilise Coaching & Mentoring models to guide individuals and organisations. Navigate ethical aspects of Coaching & Mentoring with responsibility. Improve communication skills for impactful sessions. Acquire essential personal, management, and organizational skills for success. Gain insights into motivation, mindset, stress, and leadership. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Coaching & Mentoring Get a free student ID card with Coaching & Mentoring Training program (£10 postal charge will be applicable for international delivery) The Coaching & Mentoring is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Coaching & Mentoring course materials The Coaching & Mentoring comes with 24/7 tutor support Start your learning journey straight away with this Performance Coaching & Mentoring Bundle and take a step toward a brighter future! *** Course Curriculum *** Course 01: Diploma in Performance Coaching at QLS Level 5 Module 01: Introduction to Performance Coaching Module 02: The Coach/Client Relationship Module 03: Coaching & Mentoring Models Module 04: Ethical Aspects of Coaching & Mentoring Module 05: Effective Communication Skill Module 06: Personal Skills Module 07: Management Skills Module 08: Organisational Skills Module 09: Motivation and Mindset Module 10: Key Themes of NLP Module 11: The Relationship Between Stress and Performance: The Inverted-U Theory Module 12: Leadership Under Pressure Module 13: Setting Up as a Coach Course 01: Supervisor training Module 01 - Fundamentals Of Supervisor Training Module 02 - Understanding The Role Of Supervision Module 03 - Essential Skills In Supervision Module 04 - Recruitment And Dismissal Module 05 - Employee Management Module 06 - Communication Skill Development Module 07 - Interactive Training For New Supervisors Module 08 - Conflict Management Module 09 - Cybersecurity For Employees Course 02: Mindfulness for Wellbeing and Peak Performance Introduction & First Concepts Introduction To Mindful Meditation Understanding Mindful Meditation How To Practice Mindful Meditation Understanding & Beating Anxiety Still More Mindful Meditation Techniques Mindful Meditation & Your Brain Why Is Awareness So Important More Anti-Anxiety Skills & Concepts Mindful Meditation & Work Mindful Meditation & Relationships Mindful Meditation & Happiness Famous & Successful People Who Meditate Great Mindful Meditation Apps The Many Benefits Of Mindful Meditation How To Create A Mindful Life Conclusion Conclusion - Final Thoughts & Tips =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 285 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Performance Coaching & Mentoring bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want. This bundle is ideal for: Aspiring Coaches Team Leaders Managers HR Professionals Educators Requirements No prior background or expertise is required in this Coaching & Mentoring bundle. Career path The Coaching & Mentoring bundle aims to help you get the job or even the long-awaited promotion of your dreams. Coach Mentor Trainer Consultant Leader Manager Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Performance Coaching at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.