Description: This workshop will focus on techniques that HIM Professionals can use to analyze complex healthcare data sets: Microsoft Power Pivot and Power Query.  These tools are built-in to Excel and are important components of Microsoft’s Business Intelligence (BI) suite. They enable HIM Professionals to integrate data from multiple software products into one spreadsheet.  If you’ve ever had to analyze data held in different files and formats, then Power Pivot and Power Query can address this situation. These tools increase your data analysis efficiency while minimizing redundant data entry. By the time you’ve completed this workshop, you’ll be in a position to analyze complex administrative, clinical and financial data sets without having to involve external consultants or IT staff.  The demands on HIM Professionals to conduct complex data analysis are increasing exponentially. Power Pivot and Power Query can help you to address this critical need. No previous knowledge of Microsoft Excel is required, although some exposure to the concept of Pivot Tables is helpful.

Live Webinar Date: Tuesday, August 18, 2020 
Duration: 1 hour

Speaker:  Michael Gera is with the Healthcare Computer Training Group, based in New York City.  He worked in a number of IT related administrative and technical capacities for hospitals in New Jersey, New York and Florida for over twenty years.  His focus is the development and delivery of customized computer training in hospitals, long term care facilities, rehabilitation centers, behavioral health organizations and fiscal intermediaries.  He is a graduate of Montclair State University (BA) and Florida State University (MS).  He has served on the adjunct faculty of the City University of New York (CUNY), Rutgers University and Essex County (NJ) Community College.  He is a long time and regular presenter at various AHIMA events and has worked with HIM Professionals since the earliest days of the “DRG” movement.  He has presented at OHIMA on several occasions in the past and he is looking forward to seeing you in this new virtual environment that we find ourselves in.

Best Practices for Virtual Learning

- Consider having two screens if you wish your learning experience to be interactive. The first will be your computer with Excel up so you can follow along with the presenter. The other can be a tablet or second computer where you can pull up the Webex session and watch what the speaker is demonstrating.

- Note that the session will be recorded; registered attendees can return to the recording for reference for up to 6 months after the live event.

- Data will be provided prior to the live session. They should be downloaded and opened in Excel prior to the start of the webinar.

Click here to register for this webinar!

Cost: $25 Members / $35 Non-Members
1 AHIMA CEU*
Domain: Informatics, Analytics and Data Use

*Save $10 by purchasing all 4 parts! Simply select the "Excel Webinar Series - All" package at checkout.

*AHIMA CEUs are also accepted by the AAPC! Check eligibility on the AAPC website.