This event is open to MPCA member organizations only.

Overview

This is a follow-along session, so plan to have Excel open. Using sample worksheets we will provide, you will practice time-saving shortcuts, data cleaning, sorting and filtering, everyday formulas such as IF and XLOOKUP, and pivot-table analysis. Real-world examples will show how these tools can help you look at prescribing patterns, pharmacy activity, 340B savings, contract pharmacy opportunities, and other operational trends. You will leave with practical techniques you can put to work right away to make reporting easier and support better-informed decisions at your health center.

Who Should Attend

This session is designed for pharmacy and 340B staff at all experience levels, and finance team members who work with 340B reports are warmly welcome too. If you have ever wished you could pull answers out of your data faster, this one is for you.

Registration

There is no cost to attend but you are required to register. To register and receive your Zoom link to participate, click here.

Per MPCA’s updated security policies, a Zoom account is required to register for and attend all MPCA virtual events. Please use this link as a resource to assist with creating your own Zoom account if you currently don’t have one. Thank you.

Questions?

Reach out to Lindsay Sailor at [email protected]. We hope to see you there!