3571 ETC courses

Excel in your career by learning one of Microsoft's most popular spreadsheet programs Microsoft Excel is claimed as the most used spreadsheet program in the world, and rightly so as it is applicable in multiple different fields including but not limited to, engineering, accounting, banking etc. Microsoft Excel 365 Essentials course will help you propel your career forwards as you will learn to use the software to solve problems and present your data stream in a structured manner. This Microsoft Excel course will help you realize the potential of this program as you will learn to edit your files from anywhere in the world using web apps. You will also learn to use the program on your internet browser. You will also be able to understand functions, build formulas, format data and so much more. It doesn't matter what level you are currently at, this course will help both novice and advanced users of MS Excel as it introduces a new platform in the user interface. So if you are looking to advance your career excel in your career, get this course now. Course Highlights Microsoft Excel 365 Essentials is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel 365 Essentials into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 19 hours, 40 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel 365 Essentials Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel 365 Essentials is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Microsoft Excel 365 Essentials 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started 01:00:00 Module Two - Welcome to Office 365 Web Apps 01:00:00 Module Three - Worksheets and Workbooks 02:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Editing in the Browser (I) 02:00:00 Module Six - Editing in the Browser (II) 02:00:00 Module Seven - Building Formulas 02:00:00 Module Eight - Understanding Functions 02:00:00 Module Nine - Working with Data 02:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - The Insert Tools 02:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft Excel 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft Excel 365 Essentials 00:20:00

SharePoint Foundation, launched by Microsoft, is an excellent solution for the business company if you need a secure, manageable, web-based collaboration platform. A solid foundation of the program will help you to run an organisation efficiently. The SharePoint Foundation Basics and Advanced - Complete Video Training course is the best solution if you want to be an expert user of SharePoint Foundation. The course is divided into two parts. At first, you will be introduced to basics of SharePoint Foundation and learn how to use lists, libraries, view, account information, etc. You will learn the procedures of organising, managing and sharing information. The second part will explain the contents of the first part elaborately. For example, you will learn the use of lists elaborately that includes the knowledge of announcements, events, link lists, task lists, contacts, and deleting list items. Similarly, the course explains about libraries, accounting information in detailed. In short, the course will make you a pro user of SharePoint Foundation and help you to work in this browser-based collaboration and document management platform. 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? SharePoint Foundation Basics and Advanced - Complete Video Training 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 SharePoint Foundation Basics and Advanced - Complete Video Training 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 01 : SharePoint Foundation Basics Getting Started Getting Started 00:20:00 Lists Announcements 00:15:00 Events 00:10:00 Link Lists 00:07:00 Task Lists 00:11:00 Contacts 00:11:00 Deleting List Items 00:12:00 Libraries Document Libraries 00:30:00 Picture Libraries 00:23:00 Wiki Pages 00:15:00 Asset Libraries 00:03:00 Form Libraries 00:08:00 Team Communication Discussion Boards 00:16:00 Surveys 00:08:00 Blog Pages 00:15:00 Views Page Views 00:14:00 Personal Views 00:11:00 Account Information and Notifications Personal and Regional Settings 00:11:00 Alerts 00:15:00 RSS Feeds 00:16:00 Module 02 : SharePoint Foundation Advanced SharePoint Libraries SharePoint Libraries FREE 00:25:00 SharePoint Lists 00:44:00 Changing the Look and Feel Navigation 00:23:00 Site Themes 00:12:00 Customizing a Site Changing Site Components 00:18:00 Managing Item Controls 00:25:00 Editing Pages 00:14:00 Controlling Information Display Public Views 00:13:00 RSS Feed Settings 00:09:00 Creating Workflows Workflows 00:31:00 Adding to Site Galleries Site Galleries 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

11-in-1 Premium Bundle | CPD QS Certified | 110 CPD Points | Gifts Hardcopy+PDF Certificate+SID - Worth £180 | Tutor Support | Lifetime Access

Spill Management Training course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Spill Management Training. Our course starts with the basics of Spill Management Training and gradually progresses towards advanced topics. Therefore, each lesson of this Spill Management Training is intuitive and easy to understand. So, stand out in the job market by completing the Spill Management Training course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Spill Management Training course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Course Curriculum: Module 01: Introduction to Spill Management Topics to Be Covered: Introduction Dealing With Spills Key Points Regulatory Authorities Pollution Prevention: Do's and Don'ts Module 02: Hazardous Substances Topics to Be Covered: What are Hazardous Substances? Know Your Hazards Identify All the Hazardous Substances Human Health Effects Physical Damage to Property Module 03: Pollution Incident Response Planning Topics to Be Covered: Prepare Plan Practice Pollution Control Equipment Module 04: Managing a Spill Topics to Be Covered: Pollution Control Options and Equipment Contain at Source Contain Close to Source Contain on the Surface Contain in the Drainage System Pipe Blockers Improvised Equipment Module 05: Spill Clean-Up Guideline Topics to Be Covered: The Clean-Up Process Waste Management and Legal Duty of Care Sewer Jetting Road and Highway Clean-Up Residue Clean-Up Neutralising Agents Animal Carcass Removal Site Remediation Module 06: Spills on a Road or Highway Topics to Be Covered: Incident Response Plan Correct Signage Vehicle Spill Kits and Training Emergency Responders Module 07: Diesel Spillages: An Overview Topics to Be Covered: Causes of Diesel Spillages Effect of Diesel Spillages Traditional Clean-Up Using Sand Spillage Reporting System General Clean-Up Procedure Step By Step Clean-Up Procedure Module 08: Site-Specific Pollution Control Options Topics to Be Covered: Containment Lagoons and Ponds Tanks Sacrificial Areas Pits and Trenches Module 09: Spill Prevention & Control Checklist Topics to Be Covered: Risk Assessment Control Measures Storage Site Planning and Design Transport and Handling Management Review & Inspections Module 10: Ways to Encourage Best Practice Topics to Be Covered: Enforcement Information and Training Business Benefits Rewards Using the Influence of Larger Organisations Environmental Certification CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Spill Management Training course. Requirements To enrol in this Spill Management Training course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Spill Management Training. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Course Overview: Step into the dynamic world of adult nursing with our comprehensive Adult Nursing Diploma. The course covers various essential topics, including legal and professional standards of practice, health and safety, hygiene, infection control, medication administration, and various stages of adult care. It ensures that aspiring nurses are well-equipped to excel in diverse healthcare settings worldwide.You will also learn the necessary skills and knowledge for health care, such as Medication Administration, disease prevention, risk reduction, Pain Management, electrolyte control, etc. The demand for qualified adult nursing professionals continues to soar in today's rapidly evolving healthcare sector. Enrol now in the Adult Nursing Diploma and take the first step towards a fulfilling career that makes a real difference in the lives of adults needing care and support. Key Features of the Course: Accredited & 24/7 learning assistance Self-paced online learning Interactive quizzes and assessments Certificate of completion Who is This Course For? This course is for anyone wanting to pursue a nursing career or advance their skills and knowledge. Whether you are a fresh graduate, a working professional, or a career changer, this course will help you achieve your goals. What You Will Learn: Throughout the course, you will dive into a comprehensive range of modules that cover crucial aspects of adult nursing. From understanding legal and ethical standards of practice to developing effective communication skills, you will gain the necessary tools to provide compassionate and evidence-based care to adult patients. Other topics include infection control, medication administration, pain management, nutrition, Oxygenation, Assisting with Elimination, Understanding Immune System and more. By the end of the program, you will have a well-rounded understanding of adult nursing and be equipped with the skills to deliver exceptional care across different life stages. Why Enrol in This Course: This course will help you grab many career opportunities in the dynamic healthcare industry. The course holds accreditation, ensuring you receive a high-quality education recognised by employers. With top reviews and recent updates, you can be confident in the relevance and quality of the curriculum. Requirements: To enrol in this course, you need: Passion for healthcare & dedication to providing exceptional patient care. A computer or mobile device with internet access. Career Path: After completing this course, you will get edges in various career paths in nursing, such as: Staff Nurse: £24,000 - £38,000 per year Clinical Nurse Specialist: £35,000 - £50,000 per year Nurse Practitioner: £35,000 - £55,000 per year Nurse Educator: £30,000 - £45,000 per year Nurse Manager: £35,000 - £60,000 per year Community Health Nurse: £25,000 - £40,000 per year Palliative Care Nurse: £28,000 - £45,000 per year Certification: After completing the course, you will receive a CPD certificate to download and print. You can also add it to your resume and portfolio to showcase your achievement. Course Curriculum 1 sections • 19 lectures • 09:04:00 total length •Module 1: Introduction to Nursing: 00:15:00 •Module 2: Working in Different Healthcare Settings: 00:14:00 •Module 3: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1: 00:51:00 •Module 4: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2: 00:49:00 •Module 5: Effective Communication in Nursing: 00:46:00 •Module 6: Health and Safety in Nursing: 00:46:00 •Module 7: Hygiene in Nursing: 00:29:00 •Module 8: Infection Control: 00:59:00 •Module 9: Asepsis in Nursing: 00:15:00 •Module 10: Medication Administration in Nursing: 00:17:00 •Module 11: Adult Care in Different Life Stages: 00:16:00 •Module 12: Understanding Immune System in Nursing: 00:27:00 •Module 13: Rest and Sleep Management in Nursing: 00:18:00 •Module 14: Mobility and Immobility Issues of Patients in Nursing: 00:16:00 •Module 15: Pain Management for Nurses: 00:24:00 •Module 16: Nutrition in Nursing: 00:23:00 •Module 17: Fluid and Electrolyte Balance: 00:22:00 •Module 18: Assisting with Elimination: 00:28:00 •Module 19: Oxygenation in Nursing: 00:29:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Assessment Assessment - Microsoft Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Attracting candidates and matching them to temporary or permanent job positions with client companies.

English is the dominant language in industries such as Education, Media, Aviation, Finance, Manufacturing, Tourism, Hospitality, Healthcare, etc. and it is the language of choice for business communication, especially in today's interconnected, globalized marketplace. It is also used across multiple mediums to educate, entertain and inform people globally. The Complete English Course - Intermediate Level is designed to take your English language skills to the next stage with high-quality lessons. This course will develop greater control of English grammar, including more sophisticated areas like conditionals. You will be able to express and understand key information about typical situations such as work, school or leisure. You will learn to use English to describe experiences and events, dreams, hopes and ambitions and briefly give explanations for opinions and plans. The course covers vocabulary for holidays, people in your life, food, numbers, cell phones, describing events and more. The course also teaches you present simple perfect, modals and the first conditional. What You'll Learn The #1 Interactive English Course for Intermediate. At the end of this course, you will have a deep knowledge of English - Intermediate Level. Reach your English language goals now and in the future, increasing your opportunities for both personal and professional success. English speaking, English pronunciation, English writing, English grammar rules and patterns including English verbs with the accent on English tenses, English vocabulary, English conversation and communication skills. The interactive board helps the visual learners and the immersion method used for teaching accelerates the learning speed, the comprehension of spoken English and fluency. Speaking real, grammatically correct English fluently, effortlessly and confidently. Improve your listening and comprehension skills with native English through ear training and visual learning thanks to the native English speaking teacher, interactive board and included .pdf materials. Be confident regarding your English skills (B1 level, intermediate English) with lots of practice after every lesson. Requirements Beginner Level of English is required. Videos are in English. Native English Speaking Teacher. Included Free Demo Lessons and .pdf materials. Who Is This Course For? Anyone who wants to learn English fast and easy. This course is designed for students with Beginner Level of English. Anyone who wants to master the intermediate level of the English language. We strongly recommend taking our 'Complete English Course - English Speaking - English Grammar' before taking this course. Introduction English Intermediate- Possession FREE 00:17:00 English Intermediate- Spelling FREE 00:11:00 English Intermediate- Zero conditional 00:08:00 English Intermediate- First conditional 00:07:00 English Intermediate- Demonstrative Pronoun and Adjective 00:10:00 English Intermediate- Contractions 00:17:00 English Intermediate- Exploring Adjectives 00:12:00 English Intermediate- Age 00:05:00 English Intermediate- Making offers and suggestions 00:07:00 English Intermediate- Making a request 00:05:00 English Intermediate- Want 00:09:00 English Intermediate- Expressing Time 00:07:00 English Intermediate- Like 00:08:00 English Intermediate- Phrasal Verbs 00:10:00 English Intermediate- Say and tell 00:06:00 English Intermediate- Adverbs of quantity 00:07:00 English Intermediate- Prepositions of place 00:07:00 English Intermediate- Prepositions of movement 00:06:00 English Intermediate- Verbs of the senses 00:08:00 English Intermediate- Have got 00:07:00 English Intermediate- Compound nouns 00:06:00 English Intermediate- Comparative and superlative adjectives 00:11:00 English Intermediate- Comparisons of equality 00:10:00 English Intermediate- Kinds of Adverbs 00:06:00 English Intermediate- So or such 00:07:00 English Intermediate- Question tags 00:09:00 English Intermediate- Enough 00:08:00 English Intermediate- Present perfect with since, for and just 00:05:00 English Intermediate- Already 00:05:00 English Intermediate- Ever and how long 00:04:00 English Intermediate- American and British English 00:08:00 English Intermediate- Past habit 00:04:00 English Intermediate- Recap of the Past Perfect 00:06:00 English Intermediate- Future Tense 00:06:00 English Intermediate- Past Tense 00:06:00 English Intermediate- Present Tense 00:07:00 Course Certification

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! "Prevention is better than cure." The key to preventing Legionnaires' disease is maintaining building water systems and deploying Legionella controls. Anyone can get Legionnaires' disease, but the elderly, smokers, drinkers, and those with cancer, diabetes, or chronic respiratory or kidney disease are at a higher risk. Enrol in our Legionella Management Course to learn more about this bacteria's spread and prevention. Legionnaires' disease is a rare but severe form of pneumonia caused by a Legionella bacterium infection. The germs create lung inflammation, leading to long-term health problems or even death. The Legionnaires' illness does not transfer from person to person. Instead, it spreads through inhaling contaminated water droplets containing Legionella bacteria. According to Public Health England, there were 503 confirmed cases of Legionnaires' disease in England and Wales in 2019. Therefore, you need to understand legionella management for yourself, your family, and others around you. You will learn about the conditions that cause Legionella bacteria to develop and enter the body in our expertly prepared Legionella Management course. You'll also learn easy but effective ways to avoid it in the future. Upon successful completion of this legionella management course, you will learn the following: The formation of Legionella bacteria and its consequences for health. The legal obligations for Legionella monitoring and prevention Concerning locations where Legionella bacteria are commonly seen How to conduct a risk assessment to identify, isolate, and control such dangers What precautions may be taken to limit the risk of legionella Legionella management procedures must be constantly monitored, reviewed, and updated. Legionella bacteria must be handled appropriately to avoid serious health consequences. This applies to both work and home environments. In addition, adequate measures must be put in place to limit the risks and prevent individuals from becoming unwell due to diseases caused by the Legionella bacterium. In the Legionella Management Course, you will learn about the health dangers of Legionella. As a result, you will be able to adopt suitable risk assessment procedures and control measures to prevent infection and contamination on the premises. *** Course Curriculum *** Module 01: What is Legionella? - In this module, you will learn how people get Legionella disease, who are at the most risk, symptoms and treatment of Legionella Module 02: Legal Responsibilities - In the second module, you will explore the laws and legislations associated with Legionellae, such as Health and Safety, RIDDOR, Landlord and Employee responsibilities. Module 03: Hazardous Environments - The module covers: Water System Cooling Systems, Risk Factors. Module 04: Legionella Risk Assessment - In this module, you will learn to assess risks, decide who may be harmed and review the risk assessment. Module 05: Controlling the Risks - The final module consists of duty holder responsibilities, employee responsibilities, operation of the water system, avoiding stagnation in residential settings, etc. Please note this course is not a regulated course, but it can help you to prepare for the future if you have any plans to study Level 2 Award in Legionella Awareness (RQF) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Employers who want to create a safe working environment Anyone who wants to keep themselves free from risk Individuals who want to develop a career as a Legionella Risk Assessor Anyone who wants to create awareness about Legionella Requirements There is no formal requirements to enrol in this Legionella Awareness for Legionella Management Course Career path A Legionella Risk Assessor in the UK earns around £20,000 to £35,000 annually. This Legionella Management course will open your horizons and help you secure jobs in the following areas: Legionella risk assessor Legionella risk assessor/Water treatment engineer Contracts manager legionella Lead health and safety manager - Legionella Mechanical surveyor - (Legionella) Certificates CPD Accredited Certificate Digital certificate - £10 Assessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.