6290 Courses

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

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 Receptionist and Secretary Diploma 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 Medical Receptionist and Secretary Diploma course will teach you the critical concepts of patient confidentiality and other legal aspects of the healthcare industry. Learning Outcomes After completing thiscourse, 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 Receptionist Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. This 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 this course. **Courses are included in this Medical Receptionist and Secretary Diploma Course Course 01: Medical Receptionist and Secretary Diploma Course 02: Report Writing Course Course 03: Level 4 Time Management Course ***Others Included of Medical Receptionist and Secretary Diploma Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Detailed course curriculum of the Medical Receptionist and Secretary Diploma Course: 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 ------------------- ***GIFT Courses: ------------------- ***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 ------------------- ***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 ------------------ Assessment Method After completing each module of the Medical Receptionist and Secretary Diploma, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Medical Receptionist and Secretary Diploma course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Medical Receptionist and Secretary Diploma course is ideal for Health Care Professionals who work and will be working in healthcare settings such as hospitals, clinics, and healthcare facilities. Requirements There are no specific requirements for this Medical Receptionist and Secretary Diploma course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Medical Receptionist and Secretary Diploma 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 this Medical Receptionist and Secretary Diploma, you will have developed a set of skills necessary for career advancement and will be able to pursue a variety of job opportunities, including - Medical Receptionist Medical Secretary Healthcare Administrator GP Receptionist Patient Coordinator Certificates Certificate of completion Digital certificate - Included

Estate Agent and Property Management If you want to learn about Estate Agent and Property Management and become an expert in the field, you have arrived at the right place. Industry experts designed this Estate Agent and Property Management course to enable you to learn quickly and efficiently and at your own pace and convenience. If you're looking to start a career in estate agency and property management, or you're an experienced professional looking to enhance your skills, our "Estate Agent and Property Management" online course is the perfect solution. Our expert instructors will guide you through comprehensive training in property management, marketing and sales, customer service, and more. You'll learn how to effectively market and sell properties, manage and maintain properties, and provide outstanding customer service to clients. This course is delivered entirely online, allowing you to learn at your own pace and on your own schedule. Enroll now and take the first step towards a rewarding career in estate agency and property management! Learning Outcomes After completing this Estate Agent and Property Management course, learner will be able to: Understand the fundamental knowledge of estate agents Gain a thorough understanding of business planning Understand acquisition of ownership Understand other rights to property Gain a solid understanding of land use control, environmental liability and leases Understand how to make your first real estate investment Know how to determine a good deal Know how to write money-making contracts Understand negotiations Gain in-depth knowledge about tax and real estate finance Understand regulation of estate agents Why Choose this Estate Agent and Property Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. 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 this Estate Agent and Property Management course. Free Course Course 01: Property Management Others Benefits of this Estate Agent and Property Management Course: Free 2 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Estate Agent and Property Management course] Course Curriculum of This Course Module 1: Basic Knowledge of Estate Agents Estate Agent Start Thinking Decide to be an Estate Agent Laying It All Out Finding Value The Real Deal Module 2: Business Planning Writing Your Business Plan Experience Pays Figuring Your Commission Outlining Your Key Goals Outlining Your Business Plan Stoking Growth Module 3: Ownership of Real Estate Freehold Ownership Leasehold Ownership Other Interests In Land Restrictions on Ownership by Foreigners Module 4: Acquisition of Ownership Formal Requirements Registration Asset Deals Share Deals Public Auctions Module 5: Other Rights to Property Mortgages and Charges Easements Pre‑emption Rights Options Overage Module 6: Land Use Control The Process to Use Property Control Module 7: Environmental Liability Responsibility for the Environment Module 8: Leases Duration Rent Rent Review Operating Expenses Maintenance, Repair and Renovation at End of Lease Assignments/ Transfers Subleases Termination Sale of the Leased Property Module 9: Making Your First Real Estate Investment Use Positive Leverage to Maximise Your Return Remember That Location Is Paramount Buy the Least Expensive House on the Street Confirm Your Neighbourhood School with the Central Administration Consider Resale Value When You Buy Hire a Property Inspector Have a Buyer's Broker Represent You Use the Four Best Ways to Shop for a Mortgage Explore the Fixed-Rate Mortgage Save with a 15-Year Mortgage Concentrate on Resale Potential Rather Than Age of a Property Never Fall in Love with a Property Get a Second Opinion on Price Use a Lease Option Be Cautious When Buying a New Home from a Builder Read the Survey Carefully Have Your Title Company Delete Exceptions in Its Title Commitment Module 10: How to Determine a Good Deal? How Do You Determine a Good Deal? The Cost Approach The Market Approach The Income Approach The Enhanced Value Approach Module 11: How to Write Money-Making Contracts Learn the Rules of Contract Drafting Protect Your Purchases with a Financing Contingency Clause Diffuse Balloon Mortgages with Extension Options Avoid Personal Liability with an Escrow Deposit Create 'Outs' in Your Contracts Specify Time Limits in Contracts Add Performance Requirements to Your Contract Review All Leases on a Property Prior to Settlement Demand 'Guarantees' on Financial Representations Avoid Outstanding Lease Payments Employ Closing Extenders Keep Your Option to Sell Open Increase Deductions with Written Tax Allocations Use Outside Property Inspectors Ask for a Pre Executed Mortgage Satisfaction Itemise Personal Property That Is Part of Purchase Shift Cash Expenses to the Seller Generate Cash with Rebates for Repairs Get Pest Inspection on Improved Property Place the Burden of Title Insurance on the Seller Get the Property Surveyed Make Your Contract Clauses Survive Closings Use Default, Severability, and Binding-Agreement Clauses Use Penalty Provisions to Ensure Timely Property Possession Conduct a Final Inspection Insure against Property Damage Disclose Professional Relations Module 12: The Art of the Deal: Negotiations Understand That 'No' Doesn't Always Mean No Control the Playing Field Use the Power of Silence Employ Take-Away Options Use a Conversational Approach Use Your Star Negotiator Never Negotiate against Yourself Module 13: How to Sell Your Property Price It Right Use the Three Most Common Appraisal Methods Find the Right Buyer Pass the Two-Minute Test Module 14: Tax Stamp Duty Land Tax Value Added Tax Other Real Estate Taxes Taxation of Rental Income from Real Estate Taxation of Dividends from a Company Owning Real Estate Taxation of Capital Gains on Real Estate Taxation of Capital Gains from the Disposal of Shares in a Company Owning Real Estate Taxation of Gain on Disposal of a Partnership Interest in a Partnership Owning Real Estate Real Estate Investment Trusts Real Estate Funds Module 15: Real Estate Finance Interest Rate Risks Assets Held as Security Further Collateral Agreements Taxation on the Creation of Security Module 16: Regulation of Estate Agents Who Regulates Estate Agents? Estate Agents Act 1979 (EAA 1979) Consumer Protection from Unfair Trading Regulations 2008 (the 'CPRs') Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013 Consumers, Estate Agents and Redress Act 2007 Town and Country Planning (Control of Advertisements) Regulations 1992 Money Laundering Regulations 2007 Assessment Method After completing each module of the Estate Agent and Property Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Estate Agent and Property Management course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Estate Agent and Property Management This Estate Agent and Property Management course is suitable for anyone who aspires to work in or currently works in the health care sector. Requirements Estate Agent and Property Management There are no specific requirements for this Estate Agent and Property Management course because it does not require any advanced knowledge or skills. Career path Estate Agent and Property Management After completing this Estate Agent course, you will gain in-depth knowledge about real estate and you will be able to pursue a variety of rewarding career opportunities, such as- Real Estate Agent Real Estate Broker Real Estate Investor Property Developer Property Manager Certificates Certificate of completion Digital certificate - Included

Estate Agent and Property Management If you want to learn about Estate Agent and Property Management and become an expert in the field, you have arrived at the right place. Industry experts designed this Estate Agent and Property Management course to enable you to learn quickly and efficiently and at your own pace and convenience. If you're looking to start a career in estate agency and property management, or you're an experienced professional looking to enhance your skills, our "Estate Agent and Property Management" online course is the perfect solution. Our expert instructors will guide you through comprehensive training in property management, marketing and sales, customer service, and more. You'll learn how to effectively market and sell properties, manage and maintain properties, and provide outstanding customer service to clients. This course is delivered entirely online, allowing you to learn at your own pace and on your own schedule. Enroll now and take the first step towards a rewarding career in estate agency and property management! Learning Outcomes After completing this Estate Agent and Property Management course, learner will be able to: Understand the fundamental knowledge of estate agents Gain a thorough understanding of business planning Understand acquisition of ownership Understand other rights to property Gain a solid understanding of land use control, environmental liability and leases Understand how to make your first real estate investment Know how to determine a good deal Know how to write money-making contracts Understand negotiations Gain in-depth knowledge about tax and real estate finance Understand regulation of estate agents Why Choose this Estate Agent and Property Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. 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 this Estate Agent and Property Management course. Free Course Course 01: Property Management Others Benefits of this Estate Agent and Property Management Course: Free 2 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Estate Agent and Property Management course] Course Curriculum of This Course Module 1: Basic Knowledge of Estate Agents Estate Agent Start Thinking Decide to be an Estate Agent Laying It All Out Finding Value The Real Deal Module 2: Business Planning Writing Your Business Plan Experience Pays Figuring Your Commission Outlining Your Key Goals Outlining Your Business Plan Stoking Growth Module 3: Ownership of Real Estate Freehold Ownership Leasehold Ownership Other Interests In Land Restrictions on Ownership by Foreigners Module 4: Acquisition of Ownership Formal Requirements Registration Asset Deals Share Deals Public Auctions Module 5: Other Rights to Property Mortgages and Charges Easements Pre‑emption Rights Options Overage Module 6: Land Use Control The Process to Use Property Control Module 7: Environmental Liability Responsibility for the Environment Module 8: Leases Duration Rent Rent Review Operating Expenses Maintenance, Repair and Renovation at End of Lease Assignments/ Transfers Subleases Termination Sale of the Leased Property Module 9: Making Your First Real Estate Investment Use Positive Leverage to Maximise Your Return Remember That Location Is Paramount Buy the Least Expensive House on the Street Confirm Your Neighbourhood School with the Central Administration Consider Resale Value When You Buy Hire a Property Inspector Have a Buyer's Broker Represent You Use the Four Best Ways to Shop for a Mortgage Explore the Fixed-Rate Mortgage Save with a 15-Year Mortgage Concentrate on Resale Potential Rather Than Age of a Property Never Fall in Love with a Property Get a Second Opinion on Price Use a Lease Option Be Cautious When Buying a New Home from a Builder Read the Survey Carefully Have Your Title Company Delete Exceptions in Its Title Commitment Module 10: How to Determine a Good Deal? How Do You Determine a Good Deal? The Cost Approach The Market Approach The Income Approach The Enhanced Value Approach Module 11: How to Write Money-Making Contracts Learn the Rules of Contract Drafting Protect Your Purchases with a Financing Contingency Clause Diffuse Balloon Mortgages with Extension Options Avoid Personal Liability with an Escrow Deposit Create 'Outs' in Your Contracts Specify Time Limits in Contracts Add Performance Requirements to Your Contract Review All Leases on a Property Prior to Settlement Demand 'Guarantees' on Financial Representations Avoid Outstanding Lease Payments Employ Closing Extenders Keep Your Option to Sell Open Increase Deductions with Written Tax Allocations Use Outside Property Inspectors Ask for a Pre Executed Mortgage Satisfaction Itemise Personal Property That Is Part of Purchase Shift Cash Expenses to the Seller Generate Cash with Rebates for Repairs Get Pest Inspection on Improved Property Place the Burden of Title Insurance on the Seller Get the Property Surveyed Make Your Contract Clauses Survive Closings Use Default, Severability, and Binding-Agreement Clauses Use Penalty Provisions to Ensure Timely Property Possession Conduct a Final Inspection Insure against Property Damage Disclose Professional Relations Module 12: The Art of the Deal: Negotiations Understand That 'No' Doesn't Always Mean No Control the Playing Field Use the Power of Silence Employ Take-Away Options Use a Conversational Approach Use Your Star Negotiator Never Negotiate against Yourself Module 13: How to Sell Your Property Price It Right Use the Three Most Common Appraisal Methods Find the Right Buyer Pass the Two-Minute Test Module 14: Tax Stamp Duty Land Tax Value Added Tax Other Real Estate Taxes Taxation of Rental Income from Real Estate Taxation of Dividends from a Company Owning Real Estate Taxation of Capital Gains on Real Estate Taxation of Capital Gains from the Disposal of Shares in a Company Owning Real Estate Taxation of Gain on Disposal of a Partnership Interest in a Partnership Owning Real Estate Real Estate Investment Trusts Real Estate Funds Module 15: Real Estate Finance Interest Rate Risks Assets Held as Security Further Collateral Agreements Taxation on the Creation of Security Module 16: Regulation of Estate Agents Who Regulates Estate Agents? Estate Agents Act 1979 (EAA 1979) Consumer Protection from Unfair Trading Regulations 2008 (the 'CPRs') Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013 Consumers, Estate Agents and Redress Act 2007 Town and Country Planning (Control of Advertisements) Regulations 1992 Money Laundering Regulations 2007 Assessment Method After completing each module of the Estate Agent and Property Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Estate Agent and Property Management course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Estate Agent and Property Management This Estate Agent and Property Management course is suitable for anyone who aspires to work in or currently works in the health care sector. Requirements Estate Agent and Property Management There are no specific requirements for this Estate Agent and Property Management course because it does not require any advanced knowledge or skills. Career path Estate Agent and Property Management After completing this Estate Agent course, you will gain in-depth knowledge about real estate and you will be able to pursue a variety of rewarding career opportunities, such as- Real Estate Agent Real Estate Broker Real Estate Investor Property Developer Property Manager

In a world where longevity and retirement planning have become paramount, the role of Pension Consultants is undeniable. Dive into the universe of pension consultancy with the course - 'Pension Consultant Certification: Expertise in Retirement Planning.' This course doesn't merely present theories, but guides you through the intricate processes of pension schemes, their selection, and their management. As you traverse through its meticulously crafted modules, you'll gain insights into retirement planning, pension transfers, and the ever-crucial client relationship management. This is not just another certification; it's your ticket to becoming a sought-after expert in the realm of retirement planning. Learning Outcomes Understand the foundational principles of pension consulting and retirement planning. Gain the knowledge to assess, select, and implement suitable pension schemes. Acquire the capability to manage pension transfers and consolidations efficiently. Learn to develop effective pension investment strategies to maximise benefits. Familiarise with the compliance and regulatory framework governing pensions. Why buy this Pension Consultant Certification: Expertise in Retirement Planning? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Pension Consultant Certification: Expertise in Retirement Planning for? Individuals aiming to carve a niche in retirement planning. Financial planners keen to expand their service offering. Advisors wishing to enhance their pension-related knowledge. Recent graduates in finance looking to specialise in a lucrative domain. Any professional keen on understanding the nuances of pension schemes and their management. Career path Pension Consultant: £30,000 - £60,000 Retirement Planning Advisor: £35,000 - £65,000 Pension Scheme Manager: £40,000 - £70,000 Pension Investment Strategist: £45,000 - £75,000 Client Relationship Manager (Pensions): £32,000 - £67,000 Regulatory Compliance Officer (Pensions): £38,000 - £73,000. Prerequisites This Pension Consultant Certification: Expertise in Retirement Planning does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Pension Consultant Certification: Expertise in Retirement Planning was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Pension Consulting Introduction to Pension Consulting 00:24:00 Module 02: Retirement Planning and Pension Scheme Assessment Retirement Planning and Pension Scheme Assessment 00:16:00 Module 03: Pension Scheme Selection and Implementation Pension Scheme Selection and Implementation 00:18:00 Module 04: Pension Transfers and Consolidation Pension Transfers and Consolidation 00:17:00 Module 05: Pension Investment Strategies Pension Investment Strategies 00:17:00 Module 06: Maximising Pension Benefits Maximising Pension Benefits 00:16:00 Module 07: Compliance And Regulatory Framework Compliance And Regulatory Framework 00:17:00 Module 08: Communication and Client Relationship Management Communication and Client Relationship Management 00:15:00

Flash Sale! CPD Certified | Free Assessment | 24/7 Tutor Support | Lifetime Access

Fat Freezing Course About The procedure freezes and kills fat cells in the part of your body that you're having treated. Course Content What is Fat Freezing Anatomy and physiology Health & Safety Consultations and Aftercare How to provide Fat Freezing Certificate You will receive an end of course certificate which is accredited by the cpd group and allows you to work on public How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 3 months to complete the course before it expires Will I require a model? Yes, you will have to complete 1 case of studies for this course Are there video tutorials? Yes, you will have links to YouTube and training videos to watch the treatment being performed Do I Need Experience Before Booking a Course? We’re pleased to offer courses to people with lots of different experiences. However, previous experience nor qualifications are not necessary if you would like to enrol on our Course. Do you offer finance? http://www.kbhtrainingacademy.com/finance

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Overview Help your community by understanding the impact of severe mental conditions and be able to administer help and support. This course aims to educate you in the serious implications that Anxiety and Depression can have on an individual, and how to treat them. The Cognitive behavioural therapy course provides essential information for diagnosing the associated disorders and describes how Cognitive Behavioural Therapy (CBT) can reliably treat them. It will also help you distinguish the conditions from inaccurate media representation and differentiate them from other minor issues. The necessity of maintaining Mental wellbeing in the nation can be supported with your knowledge from this course. Please Note: Occupational Therapists and Clinical Psychologists must be registered with the Health and Care Professions Council (HCPC), which is the statutory regulator of the professions. Please note, that completion of the course does not entitle a person to join the HCPC Register or use the protected titles of Occupational Therapist or Clinical Psychologist. 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 Cognitive behavioural therapy. It is available to all students, of all academic backgrounds. Requirements Our Cognitive behavioural therapy 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 8 sections • 29 lectures • 03:35:00 total length •What is 'Stress'?: 00:09:00 •How does 'stress' affect us?: 00:09:00 •Why do we experience 'stress' differently?: 00:10:00 •'Good stress' (Eustress) Vs 'Bad stress' (Distress): 00:09:00 •'Stress' and 'Burnout': 00:09:00 •Coping with stress as an individual: 00:09:00 •Low ability (inability) to cope with stressors: 00:07:00 •What do people use to cope with stress?: 00:10:00 •'Addictions' and Coping with 'Stress': 00:09:00 •'Breathing' in Stress Management: 00:08:00 •Stress-Reducing Techniques: 00:10:00 •Medication Treatments (Pharmacology) - Part 1: 00:06:00 •Medication Treatments (Pharmacology) - Part 2: 00:04:00 •Nutrition and 'Stress' - Part 1: 00:04:00 •Nutrition and 'Stress' - Part 2: 00:06:00 •What do we call 'anxiety'?: 00:06:00 •What is the difference between 'stress' and 'anxiety'?: 00:07:00 •When does 'anxiety' become an 'anxiety disorder'?: 00:05:00 •Generalised Anxiety Disorder (GAD): 00:08:00 •Social Anxiety Disorder (Social Phobia): 00:08:00 •Panic Disorder: 00:07:00 •'Addictions' and Anxiety Disorders: 00:10:00 •Psychotherapy for Anxiety Disorders: 00:08:00 •Cognitive Behavioural Therapy (CBT) for Anxiety Disorders: 00:09:00 •Mindfulness & Mindfulness Based Therapy (MBT): 00:11:00 •Medial Treatments (Pharmacology): 00:05:00 •Anxiety-Reducing Techniques: 00:10:00 •Good Bye and Thank You!: 00:02:00 •Assignment - Cognitive behavioural therapy: 00:00:00