Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Learning English Language Level 2 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Are you finding it difficult to pass an English literature exam or master it as a second language? We can help you overcome all the obstacles in your way. This course delivers an expertly written masterclass on the standard contents of a UK GCSE curriculum and will help you embed that knowledge. The Learning English Language Level 2 course provides comprehensive overviews of all the learning required to pass this essential exam and secure good educational standards. You will be taught how to appreciate and analyse the works of Shakespeare and English novels, alongside poetry, drama, and the basic structure of essays, documents and letters for everyday use. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Learning English Language Level 2 will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Learning English Language Level 2 has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Learning English Language Level 2 is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Learning English Language Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home What other courses are included with this Learning English Language Level 2? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Curriculum Module: 01 English Language Learning English Punctuation in English Capitalisation Sentence Structure Spelling Module: 02 Verbs Verb tenses and aspects The future Be, have and do Modal verbs English Writing And Much More..... How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Learning English Language Level 2. It is available to all students, of all academic backgrounds. Requirements Our Learning English Language Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included
With a single payment you will gain access to HR Advisor and Recruitment Training Diploma including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Learn how to advise about HR policies and help enhance HR processes by enrolling in our exclusively designed HR Advisor and Recruitment Training Diploma course. This course is packed with all the knowledge and skills required to encourage staff development and play an important role in a reputed organisation's human resource department. The course navigates your HR career path. After successful completion, you will be more than capable of weighing in on recruitment decisions, overseeing the performance management cycle, dealing with underperformers, ensuring health and safety in the workplace, and more. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. HR Advisor and Recruitment Training Diploma will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. HR Advisor and Recruitment Training Diploma has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take HR Advisor and Recruitment Training Diploma is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Training Diploma: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home What other courses are included with this Training? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Curriculum ***HR Advisor and Recruitment Training Diploma*** Module 01: Introduction to Human Resource Module 02: Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Performance Appraisal Management Module 05: Employee Relations Module 06: Motivation and Counselling Module 07: Ensuring Health and safety at the Workplace Module 08: Employee Termination Module 09: Employer Record and Statistics Module 10: Essential UK Employment Law How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Training . It is available to all students, of all academic backgrounds. Requirements Our HR Advisor and Recruitment Training Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Domestic Violence and Abuse Awareness - Level 2 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Ensure a healthy domestic environment,deepening your knowledge of violence and abuse, by taking the advanced Domestic Violence and Abuse Awareness - Level 2 course. The comprehensive Domestic Violence and Abuse Awareness - Level 2 course covers the types, impacts and assessment of domestic violence and abuse. You'll learn how to support victims and report incidents,as well as how to impose and maintain a healthy environmental framework in a domestic context. Kickstart a career in social care and raise awareness of domestic violence by enrolling today! Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Domestic Violence and Abuse Awareness - Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home What other courses are included with this Domestic Violence and Abuse Awareness - Level 2? Office 365 Course - 7 CPD Points Microsoft Teams - 2 CPD Points Coronavirus (COVID-19) Awareness - 2 CPD Points Working from Home Essentials - 5 CPD Points Mental Health and Working from Home - 5 CPD Points Online Meeting Management - 3 CPD Points Effective Communication Skills - 2 CPD Points Time Management - 2 CPD Points Leadership and Influencing Skills - 2 CPD Points Emotional Intelligence and Human Behaviour - 5 CPD Points Course Curriculum of Domestic Violence and Abuse Awareness - Level 2 Domestic Violence and Abuse Awareness - Level 2 Module 01: Introduction Module 02: The Components of Domestic Violence Module 03: The Impact of Domestic Violence on Victims Module 04: The Impact of Domestic Violence and Abuse on Children Module 05: Assessing the Risks of Domestic Violence and Abuses on Children Module 06: Supporting the Victim and Reporting Incidents Module 07: Record Keeping How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Domestic Violence and Abuse Awareness - Level 2. It is available to all students, of all academic backgrounds. Requirements Our Domestic Violence and Abuse Awareness - Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Domestic Violence and Abuse Awareness - Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Bread Making including 10 additional premium courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Bread Making Complete Bundle: Course 01: Bread Making Course 02: Sourdough Breads & Pastries Mastery Course 03: Artisan Pastry & Desserts Course 04: 7 Traditional Swedish Cookies Course 05: Bake a Layer Cake Course 06: Baking and Cake Decorating Level 2 Course 07: Learning Cooking Course 08: Italian Cooking Course 09:Juices, Smoothies, Healthy Eating, Vegan, Nutrition with Certificate Course 10: Nutrition and Diet Awareness Course 11: Food Safety and Hygiene Management If you want to gain a solid understanding of Bread Making and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Bread Making course designed by expert instructors. The Bread Making will cover a comprehensive range of 7, you'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Bread Making will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Bread Making has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Bread Making is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online Bread Making course is perfect! Why choose Bread Making Count the ways that it can help you⦠One payment, but lifetime access to 11 CPD courses Certificate, Transcript, student ID everything included in a one-time fee No need to worry about hidden charges CPD certificate will be sent directly to you Practical and honest assessments performed immediately Personal PDF certificate awarded on passing Original copies of your exam certificate and transcript sent the next working day Gain valuable and in-demand skills without leaving your home. Curriculum Module 1: Introduction to Bread Making Module 2: Equipment Module 3: Basics of Baking Module 4: Basic Techniques Module 5: Make Your Own Sourdough Module 6: Making Bread Using Straight Dough Module 7: More Recipes How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous certifications required for enrolment on this Bread Making. It is available to all students, of all academic backgrounds. Requirements Our Bread Making is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various certifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Bread Making) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment, you will gain access to Functional English including 10 Career development courses, an original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Challenge your language limit and grow your English language skills to the ultimate extent by enrolling in the comprehensive Functional English course. This expert outlined diploma course covers all the key fundamentals of English learning, from the grammar basics to resolving common mistakes and ways to improve. You will learn multilateral uses of the same words in a different setting and become confident in applying the newly learned concepts in any context you want. Throughout the Functional English course, your grammar will improve, and you will enrich your vocabulary, gaining more acceptance in both personal and professional areas. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Functional English will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Functional English has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Functional English is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Functional English: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home What other courses are included with this Functional Skills: English? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Course Curriculum ***Functional English*** Module 01 Introduction to the Course Module 02 Basics of Grammar Module 03 The Basics of Sentence Module 04 Structure of Sentence Module 05 Question Module 06 Punctuation & Capitalisation Module 07 Spelling Module 08 Common Mistakes & Ways to Improve How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 45 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment in this course. It is available to all students, of all academic backgrounds. Requirements This training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. Career path Having this CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Certificates Certificate of completion Digital certificate - Included
A medical secretary is responsible for ensuring that a doctor's office runs smoothly so that patients receive the best possible care. A medical secretary must understand office organisation and standard procedures to provide this secretarial support. They should also be able to use medical terminologies fluently. This Medical Secretary & Receptionist course will teach you about the medical secretarial profession and the skills needed to do the job successfully. This course will teach you about the roles and responsibilities of a medical secretary. You will also learn various medical secretary skills, including an effective filing system, medical transcription, medical writing, maintaining medical records, an appointment system, and more. Furthermore, this comprehensive this course will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing this Medical Secretary & Receptionistcourse, learner will be able to: Understand the fundamentals of the National Health Service. Understand the roles and responsibilities of a medical secretary. Know how to organise schedules and manage appointment systems. Gain a clear understanding of the Law, Ethics and Medicine. Gain a thorough understanding of the effective filing system in medical offices. Familiarise yourself with the concept of patient confidentiality and its dos and don'ts. Become skilled at controlling and ordering stocks and supplies. Gain in-depth knowledge of Medical Terminology and Clinical Aspects. Know the importance of health and safety in the healthcare sector. Have a solid understanding of Complementary Medicine Why Choose Medical Secretary & Receptionist Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Medical Secretary & Receptionist 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 Medical Secretary & Receptionist course. Assessment Method After completing each module of the Medical Secretary & Receptionist, 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 Medical Secretary & Receptionist 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. [Bundle Course 1] Detailed course curriculum of the Medical Secretary & Receptionist Module 1: The National Health Service History Structure of the NHS The NHS Plan Resource Allocation Delivering Care Mental Health Services Public Health The NHS, the Regions and Devolution Module 2: Patient (Customer) Care The Medical Receptionist Putting Patient First Complaints Within the Health Service The Complaints Procedure Patient and Public Involvement Patient's Rights Access to Health Care Total Quality in Medical Practice Customer Care: Involving Patients and the Public Module 3: Communication Report Writing Electronic Mail & Mobile Phones: Text Messages Telephone Skills People Skills - Face to Face Meeting Performance Review & Counselling The Practice Leaflet & Hospital Information Leaflets Networking Module 4: Law, Ethics and Medicine Medical Ethics and Etiquette Doctor's Duties Patient's Right The Regulatory Bodies and Their Role Legal Aspects Certification Health and Safety at Work Module 5: Health & Safety in a Clinical Environment First Aid at Work Hazardous Substances The NHS National Patient Safety Agency (NPSA) Hepatitis & AIDS Fire Precautions Clinical Risk Management Coping With Aggression & Violence Module 6: Practical Reception Skills in General Practice Record Keeping and General Administration Information Technology Module 7: The Hospital Service The Patient's Route Through the Hospital Outpatient Appointments Admissions from the Waiting List Accident and Emergency Admissions Home From Hospital Support Day Cases and Ward Attendees Hospital Team Clinical Audit Star Ratings What is a Medical Record? Cases Notes Master Index Filing Room or Records Library Medical Records Procedure for Departments Retention of Records Destruction of Medical Records The Role of the Secretary in the Hospital Module 8: Private Medicine Private Clinic or Hospital The Secretary In Private Practice Module 9: Forms, Fees and Finances in General Practises Contracting Finance Practice Income Scotland Wales Northern Ireland Module 10: Using Information Technology Computers in General Practice Electronic Medicine Computers in Hospitals Maintaining Security Module 11: Medical Terminology and Clinical Aspects Pathology and X-ray Examinations Prescribing and Drugs Nurse Prescribing New Developments in Pharmacy Module 12: Audit, Health Economics and Ensuring Quality for the Medical Receptionist and Secretary Audit Health Economics and Cost-effective Medicine Private Finance Initiative Clinical Governance National Institute for Clinical Excellence (NICE) National Clinical Assessment Service (NCAS) National Service Framework (NSF) Patient Surveys Module 13: Complementary Medicine Acupuncture Alexander Technique Aromatherapy Chiropractic Homoeopathy Hydrotherapy Hypnotherapy Osteopathy Reflexology [Bundle Course 2] Dealing With Difficult People Module 01: Difficult People and Their Difficult Behaviour Module 02: Communicating With Difficult People Module 03: Standing Up to Difficult People Module 04: A Quick Guide to the Seven Classically Difficult Types Module 05: Dealing with Bosses Who Drive You Barmy Module 06: Colleagues to Throttle Module 07: Dealing With Impossible People Module 08: The Temper Tantrum Type [Bundle Course 3] Communication Skills Course Module 01: Introduction to Communication Module 02: The Communication Skills Module 03: Different Types of Communication Module 04: Different Methods of Communication Module 05: Styles of Communication Module 06: Barriers to Communication Module 07: Assessing Communication Competence: Relevant Criteria Module 08: Seven Actions for Effective Communication Module 09: Do's and Don'ts of Effective Communication [Bundle Course 4] Level 4 Time Management Course Module 1: Basics of Time Management Module 2: Prioritise Your Time Module 3: Organise Your Time Module 4: Using Your Time Efficiently Module 5: Time Management in the Workplace Module 6: Time Management For Students Module 7: Time Management Software Module 8: Create a Value-Based Time Management Plan [Bundle Course 5] Level 5 Negotiation Skills Course Module 01: An Overview of Negotiation Module 02: How to Prepare For Negotiations Module 03: The Process of Negotiation Module 04: Ways of Developing Persuasion & Influencing Skills Module 05: Ways of Developing Communication Skills Module 06: How to Develop Active Listening Skills Module 07: Comprehending Body Language Module 08: Assertiveness and Self Confidence Module 09: Managing Anger Module 10: Managing Stress Module 11: Negotiation Tactics to Closing a Better Deal Module 12: Ways of Overcoming Sales Objections [Bundle Course 6] Level 5 Report Writing Course Module 01: Introduction to Report Writing Module 02: The Basics of Business Report Writing Module 03: The Practical Side of Report Writing (Part-1): Preparation & Planning Module 04: The Practical Side of Report Writing (Part-2): Collecting and Handling Information Module 05: The Practical Side of Report Writing (Part-3): Writing and Revising Report Module 06: The Creative Side of Report Writing (Part -1): A Style Guide to Good Report Writing Module 07: The Creative Side of Report Writing (Part -2): Improving the Presentation of Your Report Module 08: Developing Research Skills Module 09: Developing Creativity & Innovation Module 10: Develop Critical Thinking Skills Module 11: Interpersonal Skill Development [Bundle Course 7] Level 5 Proofreading & Copy Editing Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 07: Copy Editing - the Use of Language Module 08: Copy Editing - Checking Accuracy and Facts Module 09: Copy Editing - Legal Checks Module 10: Career Development [Bundle Course 8] Level 2 Customer Service Module 1: Introduction to Customer Service Module 2: Understanding the Organisation Module 3: Prepare to Deliver Excellent Customer Service Module 4: Communication in the Customer Service Role Module 5: Understand Customers [Bundle Course 9] Level 1 Certificate in Well-being Module 01: Introduction to Stress and Stress Management Module 02: Develop an Awareness of Mental Health Module 03: Develop an Awareness of Substance Misuse Module 04: Introductory Awareness of the Importance of Healthy Eating and Drinking for Adults Module 05: Dementia Awareness [Bundle Course 10] Level 3 Diploma in Healthcare Support Module 01: Promote Personal Development in Care Settings Module 02: Promote Safeguarding and Protection in Care Settings Module 03: Promote Health, Safety and Wellbeing in Care Settings Module 04: Understand Mental Well-Being and Mental Health Promotion Module 05: Causes and Spread of Infection Module 06: Promote Communication in Care Settings Module 07: Responsibilities of a Care Worker Module 08: Promote Effective Handling of Information in Care Settings Module 09: Understand Mental Health Problems Module 10: The Principles of Infection Prevention and Control And More... [Bundle Course 11] **Workplace Stress Management** [Bundle Course 12] **Anger Management** Who is this course for? This Medical Secretary & Receptionist course is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing Medical Secretary & Receptionist, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities- Medical Receptionist & Secretary Healthcare Administrator GP Receptionist Patient Coordinator In the United Kingdom, these job opportunities pay between £10,000 and £30,000 per year.
Overview Become an expert in the maintenance of water and heating systems and learn how to be a professional in a thriving industry. This comprehensive course will swiftly train you to become a Domestic Plumbing specialist and could help you start a lucrative new career. The Domestic Plumbing and Repair Training Diploma course is designed to make you fully proficient with the installation and upkeep of all major water supplies to a home or building. Alongside the fundamental training designed to transform you into an approved Plumber, you will gain comprehensive knowledge about the components, tools, systems, and fixtures you will use. UK laws and regulations are also covered. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Domestic Plumbing and Repair Training Diploma. It is available to all students, of all academic backgrounds. Requirements Our Domestic Plumbing and Repair Training Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 12 lectures • 03:00:00 total length •Module 01: Basic Components of Plumbing: 00:15:00 •Module 02: Principles of Effective Plumbing Systems: 00:15:00 •Module 03: The Plumbing Tools: 00:15:00 •Module 04: The Plumbing Process: 00:15:00 •Module 05: Central Heating Systems: 00:15:00 •Module 06: Domestic Cold Water System: 00:15:00 •Module 07: Domestic Hot Water System - Part 1: 00:15:00 •Module 08: Domestic Hot Water System - Part 2: 00:15:00 •Module 09: The Sanitation System and Repairs: 00:15:00 •Module 10: Domestic Rainwater System Installation: 00:15:00 •Module 11: Plumbing Projects: Case Study: 00:15:00 •Module 12: UK Standards for Plumbing: 00:15:00
Overview Boost your career opportunities within the IT industry and learn new abilities with the latest technology and software. Today's businesses rely on IT systems to support them, so this course will quickly upgrade your skills and allow you to apply for the latest roles. The Essential IT Skills Level 3 course provides you with all the knowledge needed to master every primary IT process. You will be explicitly taught how to produce professional spreadsheets and presentations with the standard Microsoft software. All this will be accompanied by varied tips and recommendations on approaching IT assignments and how to make the best impressions at work. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Essential IT Skills Level 3. It is available to all students, of all academic backgrounds. Requirements Our Essential IT Skills Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 12 lectures • 04:00:00 total length •Module 01: Introduction: A Transforming Technology: 00:30:00 •Module 02: Importance of Information Technology: 00:10:00 •Module 03: Communication and Network: 00:30:00 •Module 04: Future Skills Required in Information Technology: 00:15:00 •Module 05: Technology as a Foundation Skill Area: 00:10:00 •Module 06: Word Processing Software: 00:30:00 •Module 07: Presentation Software: 00:30:00 •Module 08: Creating and Editing Spreadsheet (Part 1: The Basics of Spreadsheets): 00:15:00 •Module 09: Creating and Editing Spreadsheet (Part 2: Navigation and Edit): 00:25:00 •Module 10: Storing Database: 00:25:00 •Module 11: Information Technology Project Management: 00:20:00 •Assignment - Essential IT Skills Level 3: 00:00:00