- Call Us: +1 833 990 1500 (Toll Free) (Mon - Fri, 7am - 3pm EST)
- Email Us: info@medical-webinars.com
Menu
Already Thousands Strong and Expanding
Medical Webinar is an international community of healthcare professionals engaged in medical coding, billing, auditing, compliance, clinical documentation improvement, revenue cycle management, and practice management. We offer various possibilities for experts in the sector to further their education and progress their careers through our webinars, which are a handy approach to increase your business knowledge rapidly.
Are you new to Excel and struggling to understand formulas? Are you tired of manually calculating data in Excel spreadsheets? Do you want to learn how to use Excel formulas to streamline your work and save time? If so, this online training session is the perfect solution for you. Think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula. Once you’ve mastered formulas, you’ll be introduced to functions which are built-in formulas that have been programmed to perform a specific calculation. They can often be used to shorten and simplify what would otherwise be a long-winded manually-entered formula. Why you should attend Excel is an essential tool for anyone who works with data, from entry-level employees to professionals. Knowing how to use Excel formulas can help you streamline your work, increase accuracy, and save time. This training is designed for beginners, so you don't need any prior experience with Excel or formulas to attend. You will leave the session with a solid understanding of the fundamentals of Excel formulas and the confidence to use them in your work. Topics covered Creating basic formulas: addition, subtraction, division, multiplication Using parentheses in formulas - the what and why Copying a formula - the gotchas you need to know about Make formulas logical and understandable by assigning names to your important cells An introduction to functions: SUM, AVERAGE, COUNT and SUBTOTAL The SUMIF and COUNTIF function: Add up and count based on criteria Use TODAY, DATEDIF and NETWORKDAYS to calculate and manipulate dates Use CONCATENATE and TEXTJOIN to combine text from multiple cells Who should attend This training is perfect for beginners who are new to Excel or have limited experience with formulas. Whether you are a student, professional, or simply looking to improve your Excel skills, this training is for you. The training will be delivered using the latest version of Excel for Windows however all of the functionality is also available to users of earlier versions of Excel.
President Trump will appoint a Secretary of the Department of Health and Human Services and Director of the Office for Civil Rights (OCR) with missions to make significant modifications to the HIPAA Rules. Roger Severino, OCR Director in the first Trump administration, described proposed HIPAA modifications in the 2025 Presidential Transition Project. A particular focus will be the 2024 HIPAA Privacy Rule to Support Reproductive Health Care Privacy. The new HIPAA Privacy landscape will confuse and worry Health Care Providers, Business Associates and patients. You must know what to expect and thoughtfully plan how you will respond to protect your organization, staff and the people you serve. Areas Covered Expected HIPAA Modifications OCR strategies to make modifications effective quickly Constraints to quick HIPAA modifications Compliance options for HIPAA-regulated entities Strategies to delay or defeat HIPAA modifications Why You Should Attend This Webinar Attend this webinar to begin planning how you will respond to the Trump administration’s attempt to make significant modifications to the HIPAA Rules. Who Will Benefit Health Care Covered Entities Health Care Providers Health Care Providers of all types and sizes Hospitals Health Care Practices of all types and sizes Urgent Care Clinics Behavioral Therapist Health Plans Group Health Plan Administrators Third Party Group Health Plan Administrators Health Plan Administrators Personnel Executive Management – all Covered Entities Compliance Committee – Covered Entity Board of Trustees Practice Managers – Covered Entities Chief Compliance Officer – all Covered Entities HIPAA Compliance Officials – Privacy and Security Covered Entity Owners and Senior Management Attorneys for Covered Entities – In-house and Outside Counsel Vendors and Business Associates Practice Management Companies Medical Record storage and retrieval vendors Coding, billing and payment vendors Health Care Compliance Consultants Information Technology vendors Law Firms
Critical Access Hospitals (CAHs) must comply with the Centers for Medicare & Medicaid Services’ Conditions of Participation located in Appendix W in the manual. This eight-part webinar series will cover the CAH CoP manual. There were changes and new regulations for CAHs in 2020, including a change to all the tag numbers, some which do not include Interpretive Guidelines or Survey Procedures. Changes include infection prevention and control and antibiotic stewardship, QAPI and Swing Bed changes. This seminar will help CAHs comply with specific CoP problem areas, such as nursing care plans, necessary policies and procedures, medication administration and drug storage, and informed consent to name a few. Part Two of Eight: Emergency Services, Staffing and Responsibilities, Provision of Services, Emergency Procedures and EMTALA Objectives Describe staffing requirements and supervision Recall the required14 emergency department written policies that must be present Describe that CMS has a list of emergency drugs and equipment every CAH must have Recall that a CAH must comply with EMTALA requirements Emergency Services 14 Emergency department policies ED staffing Equipment, Supplies, and Medication Blood and Blood Products Staffing/Personnel Coordination with Emergency Response Systems Staffing and Responsibilities Staffing and responsibilities Physician supervision Transfer of patient Patient admissions Provision of Services Patient care policies Scope of services Emergency medical services Medical management Diagnostic and therapeutic services Supplies Outpatient services Outpatient director Inpatient services Census and Ensuring compliance EMTALA Physician lists Central log Medical Screening examination Admit or transfer Appendix and Resources
In today’s fast-paced and data-driven world, efficiency, accuracy, and innovation are more critical than ever. This 60-minute session will introduce you to the seamless integration of ChatGPT with Excel, showing how AI can dramatically boost your spreadsheet capabilities. Learn how to speed up data analysis, automate tedious tasks, and uncover deeper insights—all with the help of AI. Whether you’re building complex formulas or running data analysis, integrating ChatGPT into your workflow allows you to bypass manual processes, generate powerful insights faster, and make smarter business decisions. This course is designed to meet the needs of both seasoned Excel pros and beginners looking to enhance their skills with the power of artificial intelligence. Why You Should Attend This session is a must-attend for anyone looking to optimize their use of Excel by incorporating cutting-edge AI technology. Whether you're a data analyst, business professional, or anyone who regularly works with spreadsheets, this training will equip you with practical skills to enhance your efficiency and make more informed decisions. Don't miss out on the opportunity to stay ahead of the curve and learn how to harness the power of ChatGPT to simplify complex tasks and boost your productivity. Topics Covered Introduction to ChatGPT and its integration with Excel Automating repetitive tasks in Excel with AI Generating complex formulas and functions using ChatGPT Enhancing data analysis and visualization with AI-driven insights Best practices for maximizing the synergy between Excel and ChatGPT Real-world applications and case studies Who should attend This training is ideal for Excel users of all levels, including data analysts, financial professionals, business managers, and anyone interested in leveraging AI to improve their productivity in Excel. Whether you're looking to automate tedious tasks or gain deeper insights from your data, this session will provide you with the knowledge and tools to elevate your Excel skills with ChatGPT.
GET EXPERIENCE
Medical webinars provide you with the best way to learn about medical coding, billing, auditing, compliance, Nursing, hipaa and more that can help you to earn and make you learn about more hot & emerging topics.
