Elevate your Excel prowess with this training. Aimed at users already versed in Excel’s core functions (SUM, X/VLOOKUP, COUNTIF etc), this course introduces users to some of the new innovative functions added since 2020, exclusively available to Microsoft 365 and Excel 2021 users.
These cutting-edge tools are designed to streamline your formula creation process, enhance your data interaction, and expand your analytical capabilities. Embrace the simplicity of extracting unique values, sorting and filtering datasets, creating dynamic, self-updating lists and much more!
Whether you’re looking to improve efficiency, accuracy, or both, these features will set you on a path to becoming an Excel ninja. Ensure your skill set remains at the forefront of technological advancements with these essential, transformative functions that redefine what’s possible in Excel.
This intermediate-level training is tailored for Excel users eager to learn the cutting-edge functions exclusive to Microsoft 365 subscribers and Excel 2021 users. Prior to attending, confirm with your IT department whether your subscription includes these features.
Venue: Recorded Webinar
ICD-10-CM updates for 2025 will become effective on October 1, 2024. These updates will include several guideline changes as well as multiple updates & additions to the specific chapters. This webinar will discuss the new guidelines as well as specific code categories in which you need to be alert to changes that may impact your code selection. All chapters will be included to ensure your specialty is covered. It is important that you be proactive and prepared when submitting your claims with discharge dates of October 1. Missed update information may cause a processing & reimbursement delay. Webinar’s Goals Be aware of guideline changes Learn about chapter specific additions & updates Ensure you are prepared with new code information Align with your software vendors to implement any necessary changes Target Audience Revenue Cycle Managers & staff Billers Coders Clinical Documentation Staff Finance Managers Denial Management Staff Physicians Mid Level Providers Claims Follow Up Staff
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 Four of Eight: Governing Board, Agreements and Contracted Services, QAPI, Discharge Planning Objectives Describe that CMS requires the Board enter into a written agreement for telemedicine services Describe requirements for contract management for a CAH Describe the essential elements of a QAPI program and Board responsibilities Recall the requirement for when a discharge evaluation must be completed Organizational Structure and Governing Body/Individual Governing body/Individual’s responsibilities Appointment to medical staff Telemedicine services and requirements Required disclosures Agreements and Contracted Services Agreement with providers or suppliers Lab and diagnostic services Food services Quality Assurance Performance Improvement - QAPI Changes to the QAPI program Requirements of a QAPI program QAPI standards Data collection and analysis Reference: Standards and guidelines for Acute hospitals Discharge Planning Need for effective discharge planning process Discharge evaluation and plan Review of discharge planning process Requirement to assist in PAC selection Appendix and Resources
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 Three of Eight: Physical Plant & Environment, Emergency Preparedness Objectives Describe expectations for a safe environment for patient care Recall the requirements for equipment maintenance and an alternative management program Explain the importance of maintaining ventilation, temperature, and lighting within a CAH Describe the mandatory training and exercises for an emergency preparedness plan Physical Plant and Environment Construction and maintenance Equipment, preventive maintenance and AEM Physical environment Disposal of trash Storage of drugs Life Safety from Fire LSC waivers Fire inspections Emergency Preparedness Emergency Plan Policies and procedures Communication Plan Training and testing Power systems Appendix and Resources
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