NOTE: This course is not appropriate for Mac or iPad users as the functionality does not exist on those platforms.
Whilst Pivot Tables offer valuable data summarization features, they also have several limitations. They struggle with handling large datasets, they lack the ability to combine data from multiple datasets and the built-in calculation functionality is very simplistic.
This training focuses on the Data Model and Power Pivot, two of Excel’s hidden gems which help to overcome the built-in limitations. For example, using Power Pivot you can…
For anyone who is serious about taking their Pivot Tables to the next level, this course is a must!
In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence and reporting functionality within the familiar environment of Excel to provide you with better business insights and enable you to make more informed business decisions.
Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.
If you want to take your reporting capabilities to the next level by learning how to leverage the functionality of Power Pivot, this is a must-attend training session!
This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot & The Data Model. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.
IMPORTANT NOTE: This course is NOT suitable for Mac users or iPad users as the functionality does not exist on those platforms. On Windows, Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department or see this link: https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b
Date: 10/04/2024
Time: 1:00 pm - 2:30 pm (EDT)
Reg. deadline: 10/03/2024
Venue: Live Webinar
Turn bad data into great data in minutes! Do you spend more time than is necessary importing and updating data from external sources such as databases, CSV files and web pages? Does the phrase "it's taking too long" describe how you feel about the time it takes to get your data into the right format for your reports? Do you regularly perform repetitive time-consuming "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to numbers or dates, splitting or merging columns, removing "weird" characters or combining files together? Would you like to be able to do all the above with the click of a button? If the answer Is yes, you need Power Query (known as Get and Transform in Excel 2016 and later). This training will focus on two main topics…How to import data into Excel from a variety of sources and how to automate the data cleaning process. Why you should attend Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster and is repeatable with a couple of clicks. Topics covered Import data into Excel from sources such as text files, web pages and databases Avoid Excel’s "million-row limitation" Keep the imported data in sync with the source data using just two clicks Understanding and Managing Steps in the Power Query Editor Save a ton of time - automate the data cleaning process Who should attend? This training is classed as intermediate and is aimed at users of Excel who wish to learn about Power Query/Get and Transform to clean data (as both a one-off and a repeating process)
The Biden-Harris Administration, through the Office for Civil Rights (OCR) at the U.S. Department of Health & Human Services (HHS) has issued a Final Rule to modify the HIPAA Privacy Rule to support reproductive health care privacy. This Final Rule is one of many actions taken by HHS to protect access to and privacy of reproductive health care after the Supreme Court’s decision in Dobbs v. Jackson Women’s Health Organization that has led to extreme state abortion bans and other restrictions on reproductive freedom in 21 states. To better protect information related to reproductive health care and to bolster patient-provider confidentiality, organizations providing these services will need to implement required changes. This webinar will review those changes and provide guidance on new HIPAA Privacy Rule requirements. Webinar Objectives Definitions, Rules, CFR, & Acronyms What is Protected Health Information? Understand the Prohibitions Understand the Presumptions Understand Attestation Requirements Needed Changes to Your Notice of Privacy Practices Understand Disclosures to Law Enforcement The Complaint Process Q&A Webinar Highlights Learn from an expert who has served as a HIPAA Compliance Officer in a large organization. Learn how to understand the HIPAA Privacy Rule Final Rule to Support Reproductive Health Care Privacy. Learn what PHI can be disclosed to whom. Who Should Attend Compliance Officer HIPAA Privacy Officer HIPAA Security Officer Practice Managers Information Systems Manager Chief Information Officer General Counsel/lawyer Practice Management Consultants Reproductive Health Providers Women’s Healthcare Providers Vendor Business Associates supporting these providers
Confused about HIPAA compliance requirements and how it applies to your organization? HIPAA can be complicated!! Knowing what an organization must have in place to meet regulatory requirements can be challenging. For anyone tasked with managing a HIPAA compliance program, understanding the HIPAA security and privacy management process is critical to implementing and maintaining a comprehensive compliance program. The webinar will look at specific challenges organizations face in meeting HIPAA compliance requirements. This will include risk management plans; risk assessments; and program management. A growing concern with healthcare data is cybersecurity threats. The webinar will review critical HIPAA related information security topics. After completing this webinar, a Covered Entity or Business Associate will have a clear understanding for how to meet the growing demands of HIPAA compliance. Webinar Objectives Definitions, Rules, CFR, & Acronyms Who Must Comply with HIPAA Requirements? What are the HIPAA Security and Privacy Rules? Challenges of HIPAA Compliance What is a HIPAA Risk Management Plan? Upcoming changes to the HIPAA Privacy Rule How to prevent HIPAA data breaches from occurring Q&A Webinar Highlights Learn from an expert on the implementation of the HIPAA rules Learn what the HIPAA management process requires Learn how to uncomplicate and be able to evaluate your organization’s HIPAA compliance program Who Should Attend Compliance Officer HIPAA Privacy Officer HIPAA Security Officer Medical/Dental Office Managers Practice Managers Information Systems Manager Chief Information Officer General Counsel/lawyer Practice Management Consultants Any Business Associates that access protected health information
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 impoprtant 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 specfic 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